AnsweredAssumed Answered

Understanding Marketo Data

Question asked by Ketki Sharma on Oct 23, 2019
Latest reply on Oct 23, 2019 by Sanford Whiteman

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?

Outcomes