BI analytics on email/push - Export delivery log? | Community
Skip to main content
Level 4
February 1, 2023
Solved

BI analytics on email/push - Export delivery log?

  • February 1, 2023
  • 1 reply
  • 861 views

Hi community! 

We are in the process of migrating from ACC to AJO. In that context we are investigating the best way for us to perform BI analysis on email/push delivery. In ACC we have had a daily export of email and push delivery logs that allowed us to analyse deeper (with different bussiness KPI's) in Power BI. 

So I am wondering how we can accomplish the same level of analytics from AJO. I don't see an OOB solution to export delivery logs from AJO (Maybe I am missing something) 


We have query service as a part of our solution as well, so wondering if that is the way to go? 

Interested in hearing you guys what your experience is and how you have achieved similar cases 🙂 Thanks a bunch!

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 Anuhya-Y

@sorendp 

interaction data (opens/clicks) available in Email Tracking Experience Event Dataset and Push Tracking Experience Event Dataset, sent and bounce data available in Message Feedback Event Dataset.

checkout https://experienceleague.adobe.com/docs/journey-optimizer/using/data-management/datasets/datasets-query-examples.html?lang=en

 

once required data available in data sets, Connect Power BI to Query Service and generate reports

check out https://experienceleague.adobe.com/docs/experience-platform/query/clients/power-bi.html

1 reply

Anuhya-Y
Community Advisor
Anuhya-YCommunity AdvisorAccepted solution
Community Advisor
February 1, 2023

@sorendp 

interaction data (opens/clicks) available in Email Tracking Experience Event Dataset and Push Tracking Experience Event Dataset, sent and bounce data available in Message Feedback Event Dataset.

checkout https://experienceleague.adobe.com/docs/journey-optimizer/using/data-management/datasets/datasets-query-examples.html?lang=en

 

once required data available in data sets, Connect Power BI to Query Service and generate reports

check out https://experienceleague.adobe.com/docs/experience-platform/query/clients/power-bi.html

SorenDPAuthor
Level 4
February 6, 2023

Thanks @anuhya-y ! We will look into said solution. Seems like the way to go!