Add net clicks on campaign statistics

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rorosa
    Member
    • Feb 2017
    • 69

    Add net clicks on campaign statistics

    Add net clicks on campaign statistics group by email
  • rorosa
    Member
    • Feb 2017
    • 69

    #2
    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); 
    
    This query return the "Image 1" picture.

    The query should be like "Image 2" picture.

    Comment

    Working...