Hi there!
Due to the limitation of not being able to export the reports in Journey Analytics as a CSV (only an image), I’m trying to replicate the dashboard in Report Builder but for the life of me I’m not able to replicate the results from Journey Analytics in a report. Part of it appears to be that we cannot create Formula Fields. For example, I have I’m trying to display Send, Opens and Clicks for JO Programs in a single report. I’m using the following:
Email Log V2 → Show Me:
- Count of Sent
- Count of Number of Opens
- Count Distinct of Link Clicked
Group by → Source Name.
From what I can discern, the primary issues I have are that Opens and Clicks are numeral values for the number of times in which either action was completed by a recipient (ie, opened an email five times, clicked the link twice).
It looks like that I can create a Formula Field for each one of these sets to get the value I need if I show by email id or Yes/No Opened, but I’d have to create three individual reports for each in my dashboard. Whereas, ideally, I’d be able to have the CTR info in a single report similarly to how its presented in Journey Analytics.
Does anybody have any suggestions for recreating that?
Lastly: it appears that the values for total Open and Link Clicked are always a few short of the amount listed in Journey Analytics. Is there are reason for this?
