Add net clicks on campaign statistics group by email
Announcement
Collapse
No announcement yet.
Add net clicks on campaign statistics
Collapse
X
-
I was investigating, in fact it is a bug:
PHP Code:$clickedCount = $this->getEntityManager()->getRepository('CampaignLogRecord')->where(array(
'campaignId' => $entity->id,
'action' => 'Clicked',
'isTest' => false,
'groupBy' => ['queueItemId']
))->count();
$entity->set('clickedCount', $clickedCount);
The query should be like "Image 2" picture.
2 Photos
Comment