Question
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?