Email Performance Report showing different results when grouping by segmentation | Community
Skip to main content
A
ailsadempsey
Level 2
November 24, 2023
Question

Email Performance Report showing different results when grouping by segmentation

  • November 24, 2023
  • 1 reply
  • 1687 views

Hello,

I am looking at an email performance report that is collating all emails within an engagement program. If I create a report specifying just the email/program in the setup, it brings back a sent volume of 6,735.

However when I group the report by one of our segmentations (market), the sent volume changes to 6,088. 

This segmentation is fully approved and has 0 leads in the default segment. If I remove the grouping from the report and try to choose Market Segment is default in the smart list instead, it brings back no results. Similarly, if in the smart list I choose Market Segment is not any of the defined segments, it brings back no results.

Does anyone know why I'm seeing these discrepancies? Not sure if I am missing something obvious!

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Darshil_Shah1
Community Advisor and Adobe Champion
Darshil_Shah1Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 26, 2023

Well, since you have no people in the default segment, the report returning 0 entries when the default Market segment is selected seems expected. However, ideally, you should not be seeing missing email rows with or without segment grouping selected. Are you able to reproduce the results? It could have been the case that the segment might be getting refreshed at the time you pulled or refreshed the report. Also, did you add any email activity-related filters in the smart list  (e.g., Was Sent Email, Delivered Email, etc.?) as those are kept in the Activity log for only up to a period of 90 days from the date of activity.

SanfordWhiteman
SanfordWhiteman
Level 10
November 26, 2023

This actually is a thing (different totals with different groupings). IIRC it has to do with the way the statistics are memoized (persisted) even when people are deleted. I’ll try to get more info on the why(s), but it def happens.

A
ailsadempseyAuthor
Level 2
November 28, 2023

@sanfordwhiteman think this is it.

Would an email performance report without filters/group by segmentation show all stats for email sends within the program, but if I group by segmentation it would only pull in results for leads who still exist within the database (and therefore would not show the results for any leads who have since been deleted).

We do have deletion/anonymisation processes in place in our CRM for leads who have unsubscribed etc. so this could be playing a role.

Terms & ConditionsAccessibility statement

Loading footer...