I would like to create an email campaign report in Google Data Studio which shows the most important KPIs
As far as I know, the direct integration between Marketo and Data Studio is not possible (tell me if I am wrong), so I should solve it via Google sheet. There are some solution like zapier, but as I see, you can sync only static list, not reports
Do you have any idea how can I show the email campaign report on Data Studio?
Thanks in advance
Solved! Go to Solution.
Thanks a lot! Is it possible to push campaign report data as well, not just field value? Sorry, but I am pretty beginner in this topic
It will send the data from user activity for email sent, open, clicked etc.
And also the campaign information, and programs.
I do join those data in BigQuery before pushing them to Datastudio. (SQL is required.)
Once you have the FiveTran setup, this is going to be the data thats' available!