Skip to main content
Megan_Koelemay
Level 4
February 19, 2020
Solved

Google Data Studio

Has anyone out there connected their Marketo instance to Google Data Studio?  What are you using for the integration?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
JDNelson1Accepted solution
Community Advisor
March 2, 2021

I've had some good success using Zapier to do this. Ultimately I setup all the reports I want to run in Marketo and have them emailed to me on a set cadence. Then I have Zapier watch my inbox for those emails and save the attachments to a folder in GDrive. Now, the tricky part for me was I wanted to have a running log of these reports, so I actually created a Google Script that will convert all the .csv files to Sheets and combine them into one master doc that also gets time-stamped. The only issue I've run into with it was that I have to clear out the old files every 2-3 months otherwise the script times out. This was definitely a poor mans solution and any integration would probably be better.

View in thread

13 replies

Grace_Brebner3
Grace_Brebner3
Level 10
February 24, 2020

May as well jump in seeing as no-one's come in with magic solutions here yet... We do a lot of business reporting with Data Studio. I'm not aware of any tool that integrates between Marketo & GDS.

 

Unexciting as it may be, we just have a bunch of smart list/report subscriptions set up and then push that data into google sheets, where some transformations happen, and the dashboard connects to that instead. 

Translate
    Levi_Halvorsen
    Levi_Halvorsen
    Level 2
    October 8, 2020

    What tools or services or.... do you use to push the smart list/report subscriptions into google sheets?

    Translate
    Grace_Brebner3
    Grace_Brebner3
    Level 10
    October 12, 2020

    No tool/service, i'm afraid - just copy paste.

    Translate
    Danielle_Wong
    Community Advisor
    Danielle_WongCommunity Advisor
    Community Advisor
    February 25, 2020

    I'm actually trying to use Stitch Data to integrate Marketo data into Google Data Studio. It does not seem as straight forward as I had hoped. If I get it up and running, I'll try to remember to update here.

    Translate
    Danielle W.
      Megan_KoelemayAuthor
      Level 4
      April 1, 2020

      Good to hear your experience, Danielle.  Thanks for the reply!

      Translate
      Vinay_Kumar
      Community Advisor and User Group Leader
      Vinay_KumarCommunity Advisor and User Group Leader
      Community Advisor and User Group Leader
      March 2, 2021

      @megan_koelemay, I didn't integrated Marketo with Google Data Studio. But, I have researched for the some tools and here are the names of a few: Stitch, owoxBI, Cdata, Skyvia, Panoply

      Translate
        Community Advisor
        JDNelson1Community AdvisorAccepted solution
        Community Advisor
        March 2, 2021

        I've had some good success using Zapier to do this. Ultimately I setup all the reports I want to run in Marketo and have them emailed to me on a set cadence. Then I have Zapier watch my inbox for those emails and save the attachments to a folder in GDrive. Now, the tricky part for me was I wanted to have a running log of these reports, so I actually created a Google Script that will convert all the .csv files to Sheets and combine them into one master doc that also gets time-stamped. The only issue I've run into with it was that I have to clear out the old files every 2-3 months otherwise the script times out. This was definitely a poor mans solution and any integration would probably be better.

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...