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.
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!