Developer forum

Forum » Integration » Export of email marketing statistics

Export of email marketing statistics

E-mail notifications
Thomas Schroll
Thomas Schroll
Reply
Posted on 14/10/2019 14:40:46

Hi

I am setting up a report in Google Data Studio with a page with email marketing statistics. The manual export has the highlights in columns instead of rows, which makes the import into data studio impossible without manual editing of the excel file.

Instead I tried to setup an export via Data Integration but I can't find the tables with the email marketing statistics. Does anybody know which table I should use?

Regards Thomas


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 15/10/2019 09:41:19
Reply
This post has been marked as an answer

Hi Thomas,
you can export data from that tables:


As an alternative you can try to use the CRM Provider for the email statistics export. Try to create the Data integration job with CRM Provider as a source and XML/CSV/Excel provider as destination.

Best regards, Dmitrij

Votes for this answer: 1
 
Thomas Schroll
Thomas Schroll
Posted on 15/10/2019 10:34:24
Reply

Thanks, Dmitrij

The data is unfortunately not in one table. It would be nice if the Email table could have the information from 'Highlights' (eg. Sent, Opened, Clicks, Orders, Unsubscribes). Then it would be easy to export the data to Data Studio ;)

Regards Thomas

 

You must be logged in to post in the forum