Solved

marketo email reports to Data Studio

Forum|Forum|4 years ago
October 1, 2021
1 reply
3588 views

Hi Everyone,

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

Kata

Marketo

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 yukotakagi1

Not a free solution but I do this exact thing using FiveTran and Google BigQuery and works great.

FiveTran can take the Marketo data and push them into BigQuery, then you can pull data from BigQuery to DataStudio.

yukotakagi1Accepted solution

Not a free solution but I do this exact thing using FiveTran and Google BigQuery and works great.

FiveTran can take the Marketo data and push them into BigQuery, then you can pull data from BigQuery to DataStudio.

Györke_-_Szasz_Author

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

yukotakagi1

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded