Reporting # of sends do not match Marketo records for recurring campaign? | Community
Skip to main content
L
lindas
New Participant
January 11, 2023
Solved

Reporting # of sends do not match Marketo records for recurring campaign?

  • January 11, 2023
  • 1 reply
  • 2824 views

We have a weekly reminder campaign we send using the same program (different database table).

 

For example, week 1 = 100 people are overdue for timecard submission and get a reminder

Week 2 = 90 people are overdue and get a reminder. 30 of these 90 people, also received a reminder in Week 1

 

The Smart campaign is set to:

Each person can run through the flow every time
If person has reached the communication limits
Ignore limit
 
If I create a smart list campaign of who was sent the campaign in the past week (ensuring not to include Week 1), it says 90 unique records/people. However when we create a report it says only 60 people received it. 
 
We are baffled on why it says 60 on the reports when the smart list query shows 90 (which is correct on who should have gotten it).
 
Can someone help explain and also advice on correcting the report if 90 is the true number?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

I’m sorry but just to be clear (as it’s confusing in the question), are you comparing the number of people who were sent the email on week 2 in the SL with the number of deliveries (aka email delivered/people received it) number in the report? 

Assuming that you’re comparing email send counts in the SL and EPR, unlike the SL that solely looks at the lead activity log, in the email performance report, multiple sends from the same campaign to the same person are counted only once (the first email send activity is only counted). Given that background, I think the numbers do add up, as of the 90 people who were sent email on week 2, 30 people were sent again. The Email Performance report isn’t  including the repeat email sends for those 30 people, and hence showing email sends as 60.

1 reply

Darshil_Shah1
Darshil_Shah1Accepted solution
Community Manager
January 11, 2023

I’m sorry but just to be clear (as it’s confusing in the question), are you comparing the number of people who were sent the email on week 2 in the SL with the number of deliveries (aka email delivered/people received it) number in the report? 

Assuming that you’re comparing email send counts in the SL and EPR, unlike the SL that solely looks at the lead activity log, in the email performance report, multiple sends from the same campaign to the same person are counted only once (the first email send activity is only counted). Given that background, I think the numbers do add up, as of the 90 people who were sent email on week 2, 30 people were sent again. The Email Performance report isn’t  including the repeat email sends for those 30 people, and hence showing email sends as 60.

    L
    lindasAuthor
    New Participant
    January 13, 2023

    Sorry for the confusion. To clarify, say we send the same campaign 2 weeks in a row.

     

    Week 1: John, Tom, and Mike sent/received the campaign

    Week 2: Only John and Tom sent/received the campaign

     

    We would like our reports to look like:

     

    Week 1: Sent = 3 people

    Week 2: Sent = 2 people

     

    Is there a report that would show quantities of the above even if the same people receive it 2 week in a row? We do not want to include new recipients only.

     

    Thank you!

    Darshil_Shah1
    Darshil_Shah1
    Community Manager
    January 13, 2023

    You could setup a smart list with Was Sent Email filter and include email name and date of activity filters in it to get the required counts of people who were sent email on a particular day based on the campaign run schedule. A SL query data from the activity log and does not do any filtering to exclude multiple email send activities from the same campaign unlike email performance report.

     

      Terms & ConditionsAccessibility statement

      Loading footer...