Export Data and Analytics to Mysql

Forum|Forum|9 years ago
June 30, 2016
2 replies
2574 views

Hi,

We want to export marketo lead data and analytics including email opens, clicks and delivers to a MySQL database. We can host the database on our server.

I have researched and found some solutions like Zapier and cloudpipes, but they only sync the Lead data and NOT the analytics data.

Do you guys know anyother service that we can use or point to a webhook doc that will provide us with data analytics support.

Thanks,

Farhan

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

SanfordWhiteman

Level 10

You want the Get Lead Activities REST API method and related endpoints.

It's definitely true that there is no commercial product that does all of this right. Which is not to say it will be easy to build by any means, but you will be more satisfied over time.

A

Anonymous

Thanks for your response, This API will give me lead's activity details and to keep my database sync with marketo I will be constantly pinging marketo which is neither a viable solution nor they will allow me to.

What I am looking for is a webhook, that will send a request with all the information to my endpoint, when an activity occurs.

SanfordWhiteman

Level 10

What you're describing is not a practical application for webhooks. Webhooks execute synchronously in Marketo Flows, and executing a webhook for "uninteresting moments" like Email Delivered will kill instance performance. I generally keep webhook executions to ~ 5000 per day, i.e. for specific interesting moments and not for high-traffic activities.

At any rate the webhook guide in the docs is straightforward: define in Admin, add to Flow.

Josh_Hill13

Level 10

What do you mean by Analytics data? You should be able to pull all lead and log activities using the API.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded