I need export the KPI data to Excel

(0) Share

Report

Posted on by Jone

Hello,

I need export to Excel all the information by a customer journey:

- Overview

- Delivery

- Links

etc.

Is It posible?

I need export to any platform (Excel, Word, , etc.)

Thanks in advance

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

d_radulova 2 User Group Leader on at

Like (0)

Report

Hi @Jone,

sorry, at the moment you can't export this data from the Marketing app.

I believe an idea with this functionality already exists, so what you can do is, find it and up-vote it here

experience.dynamics.com/.../

The more votes it has, the more likely it is to go on the road map and be incorporated in the product.

Thanks,

-DD

Was this reply helpful? Yes No
Suggested answer

ashish12 3,079 on at

Like (0)

Report

experience.dynamics.com/.../

Was this reply helpful? Yes No
Verified answer

cloflyMao 25,210 on at

Like (1)

Report
Hi Jone,

Do your KPI data means Insights data for a delivered marketing email in a custom journey like screenshot below?

If so, as many people asked, those data could be only accessed with PowerBi.

But there is an unsupported way to get these data and export as a csv.

Disclaimer: APIs provided in the anwser are not officially supported so that they might be changed without prior notice. Please use them on your own risk.

From this original article: https://pkoval.com/2019/08/25/programmatically-accessing-data-from-dynamics-marketing-insights/,

even though we couldn't access them directly, but these data are rendered inside widget grid,

so we could call msdyncrm_ListWidgetData organizational request to fetch them.

Please create a html web resource for customer journey form and copy code below:

Page Title

Overall data

Delivery data

Link data

This web resource will query a marketing email overall, delivery and link insights data from 11/20 to 11/30,

and will create a csv file from retrieved overall data table.

Remember to change value property to your own marketing email id to test,

and click table header to see result.

Some test result:

Original overview data:

result in web resource:

Generated csv file after click Test Download button:

Extend your logic with existing code.

However, as I said at beginning, powerBi is still the recommended and supported way to export them:

https://docs.microsoft.com/en-us/dynamics365/marketing/custom-analytics

Regards,

Clofly

Was this reply helpful? Yes No