Solved

Is it possible to export a delivery summary report to CSV automatically?

Forum|Forum|2 years ago
June 13, 2023
1 reply
1241 views

I know it's possible to set up a scheduled report that sends a PDF to selected email addresses on a weekly/daily basis but would like to do the same in a CSV format so that I can use powerBI to create a dashboard

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 aggabhi

Hi @lg23 ,

Automatic scheduling of report is only possible in PDF format. That is predefined by Adobe and we can't change the functionality from backend. You can manually export the report in CSV format if needed as below :-

Hope it helps. Ref :- https://experienceleague.adobe.com/docs/campaign-standard/using/reporting/about-reporting/reporting-interface.html?lang=en

A

aggabhiAccepted solution

Level 5

Hi @lg23 ,

Automatic scheduling of report is only possible in PDF format. That is predefined by Adobe and we can't change the functionality from backend. You can manually export the report in CSV format if needed as below :-

Hope it helps. Ref :- https://experienceleague.adobe.com/docs/campaign-standard/using/reporting/about-reporting/reporting-interface.html?lang=en

L

LG23Author

Thanks for the explanation Aggabhi.

Do you if it's possible to use a workflow to export deliverability metrics to CSV?

I will do some investigating myself also.

All the best

Lewis

A

aggabhi

Level 5

Hi @lg23 ,

Ok here, you have to define a simple export workflow which will pick data from your targetting tables and once you have all the attributes defined, you simply use a Transfer file activity to export a csv file from adobe campaign to any external SFTP.

Workflow Model :- Query Activity > Deduplication(if required) -> enrichmnent activity > Transfer file activity

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded