Understanding Marketo Data

Highlighted
Level 1

Understanding Marketo Data

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?

1 REPLY 1
Level 10 - Community Moderator

Re: Understanding Marketo Data

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.