Hello
We want to report interactions across a number of different emails.
I see that I'll need to use PowerBI for this.
Is there a way to group these emails so that they can be reported on together?
E.g
Email 1
Email 2
Email 3
are labelled as group1
Email 4
Email 5
Email 6
are labelled as group2
Then we can run reports on group1 to see interactions etc.
Pete
So, I've decided to use the existing Campaigns table to groups these Marketing Emails. I created a relationship between Campaigns and Marketing Emails which works fine.
I've not run any reports yet, but hopefully I can report on (for example) all opens in campaign x.
Pete
Hi Amanda, thanks for your help. I don't know much about PowerBI, but what you're suggesting seems like something PowerBI could do.
Pete
We are also attempting to create marketing email insights reports across multiple emails. Do you have some good documentation on how to set this up using Power BI?
For our emails, we've created a 'Category' field. I imagine you could set up a similar Choice column that includes the groups you're looking for, then update your emails to assign them into the right group.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156