Understanding Marketo Data

[Ketki_Sharma]

We have all these marketo tables in our data-warehouse:

• activity_add_to_account_contact_relationship
• activity_add_to_contact_account_relationship
• activity_add_to_nurture
• activity_add_to_onboard_account_id_c_
• activity_add_to_opportunity
• activity_add_to_quote
• activity_add_to_sfdc_campaign
• activity_call_webhook
• activity_change_data_value
• activity_change_nurture_cadence
• activity_change_nurture_track
• activity_change_owner
• activity_change_score
• activity_change_segment
• activity_change_status_in_progression
• activity_change_status_in_sfdc_campaign
• activity_click_email
• activity_click_link
• activity_convert_lead
• activity_delete_lead
• activity_email_bounced
• activity_email_bounced_soft
• activity_email_delivered
• activity_fill_out_form
• activity_interesting_moment
• activity_merge_leads
• activity_new_lead
• activity_open_email
• activity_remove_from_opportunity
• activity_remove_from_sfdc_campaign
• activity_request_campaign
• activity_send_alert
• activity_send_email
• activity_sfdc_activity
• activity_sfdc_activity_updated
• activity_sync_lead_to_sfdc
• activity_type
• activity_unsubscribe_email
• activity_update_opportunity
• activity_visit_webpage
• campaign
• fivetran_audit
• lead
• lead_describe
• lead_join_merges
• list
• opportunity_membership
• program
• program_cost
• program_membership

I understand some of the main tables such activity_open_email, activity_send_email etc. but not other tables. Is there some documentation around what information each activity table captures?

[SanfordWhiteman]

Your integration app created those as individual tables, not Marketo. They originated as Marketo API responses. You don't download SQL tables.

Presumably the activity_* comes from an activity extract downloaded in full and then split on the Activity ID. Or possibly downloaded separately by Activity ID, same result.

Everything here should be self-explanatory, they relate to the same filters and triggers you see in Marketo Smart Lists.