Sync Marketo data to Sourcetable
Marketo
All your business data, synced in a spreadsheet.
Find out how to make the most of your Marketo marketing automation data with Sourcetable
Sourcetable Benefits
Query marketing automation data quickly & easily
Marketo’s focus is on attracting and engaging leads, and moving them through the sales funnel so B2B companies can grow. By syncing Marketo data to Sourcetable, and combining it with inputs from other platforms and databases, businesses can keep track of audience engagement and other important metrics quickly and easily.
Automation
Use Sourcetable to compile key data from Marketo and other platforms quickly and intuitively, automate processes in one easy-to-use spreadsheet, and free up time to focus on other important aspects of your business.
Accessibility
Query inputs and data from Marketo and multiple other databases and platforms in Sourcetable, without having to learn SQL. Make your marketing automation campaign data readily available to everyone on your team, all in one place.
Visualizations
Sourcetable comes with a full suite of visualization tools for all your reporting needs, from charts, graphs, conditional formatting, pivot tables and more. Create visually appealing live dashboards to share with your team and identify the metrics that matter.
How to get the most of Marketo with Sourcetable
Smart Templates
Use out of the box tried and tested templates in order to cross-reference Marketo data and enable data collaboration across your entire organisation
Quick Analysis
Analyse your marketing automation campaign data quickly and easily in intuitive cross-channel reports
Ease Of use
Compile all your Marketo data into a single spreadsheet, identifying key business insights behind the numbers in order to confidently assess and improve your campaigns.
Who uses Marketo data in Sourcetable
📈 Marketing and Advertising professionals
👷🏿 Sales and Sales Ops folk
🚀 Founders
🏢 Ecommerce businesses
Here's a sample of 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
Sample companies
Online businesses integrating Marketo with Sourcetable have access to all relevant data on audiences, users, leads, revenues and email marketing.
-
Retail online stores
(eCommerce) -
Retail offline stores
-
B2B Platforms
-
Software as a Service
(SaaS) companies -
B2C Marketplaces
Popular Use Reports & Use Cases
Create automated reports from Marketo
Marketo + Sourcetable
Merge Marketo and Salesforce databases
Marketo + Salesforce
Create reports using Marketo and MySQL database data
Marketo + MySQL
Analyze Marketo and Facebook Ads data
Marketo + Facebook Ads
Analyze Marketo and Mailchimp data
Marketo + Mailchimp
What makes Sourcetable special?
Interconnectivity
Collate and analyse your Marketo marketing automation data side by side with findings from 30+ other sources, to drive decisions and improve your campaigns
Collaboration
Automate your Marketo data so you can free up time to focus on what matters most: selling your product
Automation
Create workflow templates based on key data from Marketo and other platforms, and share among team members quickly and easily
Frequently Asked Questions
How do I sync my Marketo data to Sourcetable?
Which marketing automation platform works best with Sourcetable – Mailchimp or Marketo?