BI analytics on email/push - Export delivery log?

[SorenDP]

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!

[Anuhya-Y · Accepted solution]

@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-qu...

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

[SorenDP]

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