I’m trying to calculate the number of unique users that recieved at least one automated email from a specific campaign within a specific week. What is the best way to do that?
I have 20+ automated campaigns with 3+ emails each that I’d like to get this data for each week, so I’m hoping to find an easier way than doing this manually.
I believe the manual way would be: for each campaign,
1) download the individual lists of recipients for each email in that campaign within a specific week
2) combine all recipients into one list, and delete duplicate contacts to account for any recipients that received multiple emails, for example – Email 1 and Email #2 from the same campaign, within a specific week
3) sum the number of recipients for that campaign
(Then repeat for each campaign.)
The end goal for this week-over-week count of the number of users that were emailed as part of a specific campaign: use this data to more accurately track conversion rates across campaigns.
