Marketo Automated Bulk Extraction process Getting Ready for Data Retention ? | Community
Skip to main content
A
ajaymamgain1
Level 3
July 2, 2020
Question

Marketo Automated Bulk Extraction process Getting Ready for Data Retention ?

  • July 2, 2020
  • 1 reply
  • 2966 views

Business Issue: Do a bulk extract of the Marketo data using minimum IT resources and finances. ?

Solution: Marketo we will start archiving Email send and delivered data prior to 90 days, so it becomes important we take regular back up of Marketo data using Marketo Bulk Activity Extract (which will save APIs calls). In the below example, I have used App Script and Google Sheet to do the extraction and copy of the data. You can also notify the user when the job is started and completed.

 

The flow looks like below:

 

You can create triggers to run the job on hourly, daily basis as well. 

 

Finally, you can link the Google Sheet with PowerBI which is a one time sync to get the insights automatically in PowerBI.

let me know in case if you want to start archiving your data in Google Sheet and before Marketo retention policy kicks in.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    July 2, 2020

    D'you have the code for this in a public repo?

    A
    ajaymamgain1Author
    Level 3
    July 4, 2020

    Hi Sanford, 

    Not yet, I'm focusing on developing my own skills which would include Marketo API Work, Webhooks, and other Marketo services to find freelance work related to Marketo. It would be great if you can guide me on how to get started.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    July 4, 2020

    OK, I'm concerned then about the content of your post. If you're not willing to present a code/recipe that someone could follow to build the same solution, then it sounds like you're trying to get freelance work from the incomplete post... which would be a violation of Community rules against promo'ing one's own services or products.

     

    If you want me to privately review your code that might be possible, send me an email.

    Terms & ConditionsAccessibility statement

    Loading footer...