Marketo

Marketo is a marketing automation software that provides email marketing, lead management and revenue attribution services.

Sync Marketo data to Sourcetable

Build reports once. Connect to Marketo and start modeling from live data.

Popular Use Cases

Marketo connector Sourcetable connector
Create automated reports from Marketo
Marketo + Sourcetable
Marketo connector Salesforce connector
Merge Marketo and Salesforce databases
Marketo + Salesforce
Marketo connector MySQL connector
Create reports using Marketo and MySQL database data
Marketo + MySQL
Marketo connector Facebook Ads Manager connector
Analyze Marketo and Facebook Ads data
Marketo + Facebook Ads Manager
Marketo connector Mailchimp connector
Analyze Marketo and Mailchimp data
Marketo + Mailchimp
Here's a sample of the Marketo data that will be available in your Sourcetable spreadsheets:
ACTIVITY_[TYPE_NAME]

Any change or action which gets recorded is an activity, it varies from subscription to subscription and they are linked to lead id for tracking

ACTIVITY_ADD_TO_NURTURE

No schema present only table name is there in ER Diagram

ACTIVITY_ADD_TO_OPPORTUNITY

No schema present only table name is there in ER Diagram

ACTIVITY_CHANGE_DATA_VALUE

No schema present only table name is there in ER Diagram

ACTIVITY_CHANGE_STATUS_IN_PROGRESSION

No schema present only table name is there in ER Diagram

ACTIVITY_CLICK_EMAIL

Tracks an activity where a user clicked on an email

ACTIVITY_DELETE_LEAD

Tracks an activity in case a lead is deleted

ACTIVITY_EMAIL_BOUNCED

Tracks an activity in case email got bounced and did not received by the receipient

ACTIVITY_EMAIL_BOUNCED_SOFT

No schema present only table name is there in ER Diagram

ACTIVITY_EMAIL_DELIVERED

Tracks an activity when an email is delivered to the intended receipient

ACTIVITY_MERGE_LEADS

Tracks an activity when the 2 leads are merged

ACTIVITY_NEW_LEAD

Contains the associations of activity type, campaign and lead data along with the activity date

ACTIVITY_OPEN_EMAIL

Tracks an activity where the receipient opened the email which was sent to him

ACTIVITY_RECIEVED_FORWARD_TO_FRIEND_EMAIL

Tracks an activity where the receipient has forwarded the email to another email address and other user has received it

ACTIVITY_REMOVE_FROM_LIST

No schema present only table name is there in ER Diagram

ACTIVITY_REMOVE_FROM_OPPORTUNITY

No schema present only table name is there in ER Diagram

ACTIVITY_SEND_ALERT

Tracks an alert when an email is send successfully

ACTIVITY_SEND_EMAIL

Tracks an activity when an email is send to the desired receipient

ACTIVITY_SEND_EMAIL

Tracks an activity when an email is send to the desired receipient

ACTIVITY_SENT_FORWARD_TO_FRIEND_EMAIL

Tracks an activity where the receipient has forwarded the email to another email address

ACTIVITY_TYPE

Contains the name and description of an activity

ACTIVITY_UNSUBSCRIBE_EMAIL

Tracks an activity when a user unsubscibes himself from the mailing list

CAMPAIGN

A campaign contains the program details, campaign's name and description along with name of workspace

COMPANY

A company is an organisation to which a lead record belongs to

EMAIL_TEMPLATE_HISTORY

Contains the program information, template details like name, description, status, url along with the details who is sending the email

LEAD

A lead is a prospective user which a company wishes to target

LEAD_COMPANY

A lead company has an association of lead id and company id

LEAD_JOIN_MERGES

Contains the id's of lead which got merged, whom the lead was merged into and the date on which merging happened

LIST

Contains the name, description, program name and workspace name

LIST_MEMBERSHIP

Contains the lead information and list information

OPPORTUNITY_MEMBERSHIP

Contains the lead information and opportunity information

PROGRAM

Contains the name, description, timestamp details of creation and modification, status and sdfc name and id

PROGRAM_COST

Contains the program information, cost, note and start date

PROGRAM_MEMBERSHIP

Contains the program information, lead information, membership date, flag to tell whether it reached successfully and acquired by

PROGRAM_TAG

Contains the information of program, program tag type and value

PROGRAM_TAG _TYPE

Contains the tag type, applicable program types and whether it is required or not