ChannelMix | Marketing to Sales Pipeline OneView
Below are the fields for the Marketing to Sales Pipeline OneView dataset. The sources that populate a OneView can be customized to your data specifications and CRM.
- Act-On (v_act_on_message_statistics)
- Adobe Analytics (v_adobe_analytics_event)
- AdRoll (v_adroll_ad_performance)
- AdRoll (v_adroll_ad_geo_conversion)
- Amazon Ads (v_amazon_ads_all_ads)
- Amazon DSP (v_amazon_dsp_creative_activity)
- Apple Search Ads (v_apple_search_ads_ad_group)
- Bing Ads (v_bing_ad_group)
- Campaign Monitor (v_campaign_monitor_summary)
- Constant Contact (v_constant_contact_campaign_performance)
- Digital Media via Google Sheet (v_gs_digital_media_performance_and_conversion)
- El Toro (v_el_toro_creative_performance)
- Emfluence (v_emfluence_email)
- Exact Target (v_exact_target_send)
- Facebook Ads (v_facebook_ads_standard)
- Facebook Social (v_facebook_post)
- Facebook Social (v_facebook_page)
- Google Ads (v_google_ads_api_ad_group)
- Google Ads (v_google_ads_api_campaign) - This is included just to provide insights to data that is only available at the campaign level (like "Performance Max Campaigns").
- Google Analytics (v_ga_event)
- Google Analytics 4 (v_ga4_event)
- Google Campaign Manager (v_gcm_standard)
- Google Search Ads 360 (v_search_ads_360_reporting_ad)
- Google Search Console (v_google_search_console_top_queries)
- Hubspot (v_hubspot_contact)
- Hubspot (v_hubspot_event)
- IBM Watson (v_ibm_watson_email_mailing)
- Instagram Social (v_instagram_media)
- Lead Gen Data via Google Sheet (v_gs_lead_gen_data_row_level OR v_gs_lead_gen_data_aggregate)
- LinkedIn Ads (v_linkedin_ad_creative)
- LinkedIn Social (v_linkedin_update)
- Mailchimp (v_mailchimp)
- MNTN (formerly known as SteelHouse) (v_mntn_creative_group)
- ON24 (v_on24_event_registrants)
- Pardot (v_pardot_email)
- Pinterest Ads (v_pinterest_ad_group)
- Reddit Ads (v_reddit_ad_standard)
- SalesForce (v_salesforce_lead)
- Snapchat Ads (v_snapchat_ads)
- Snappy Kraken (v_snappy_kraken_activity)
- Spotify Ads (v_spotify_ads_ad_performance)
- StackAdapt (v_stackadapt_ad)
- The Trade Desk (v_ttd_basic_performance_stats)
- TikTok (v_tiktok_organic)
- TikTok Ads (v_tiktok_ad_geo_region_standard)
- Traditional Media via Google Sheet (v_gs_traditional_media_and_conversion)
- Twitter Ads (v_twitter_ads_line_item)
- Twitter Social (v_upload_twitter_organic_tweets / v_twitter_tweet (if available))
- YouTube Analytics (v_youtube_video_analytics)
| Field | Field Type | Description |
| Report Date | Date | The date activity occurred |
| Data Source | String | The data source from where the record originated |
| ChannelMix Type | String | A description of the marketing channel strategy e.g. Paid, Owned, or Earned |
| Platform | String | The platform from where the data originated |
| Account | String | The account name from the platform the data was pulled |
| Campaign | String | The campaign name |
| Ad Group | String | The Ad Group or Placement name |
| ChannelMix Channel | String | A description of the marketing channel unified for consistency |
| GA Event Category | String | Event category designated to track ChannelMix Events on your website e.g. "ChannelMix" |
| GA Event Action | String | Event action designated to describe the action the user is completing on the website e.g. "Conversion" |
| GA Event Label | String | A custom description of the event |
| Lead Status | String | Status of the Lead |
| Impressions | Integer | Total times the ads were served |
| Interactions | Integer | Total times the ads were clicked |
| Cost | Decimal | Total cost of ads |
| Stage 1 | Integer | First Stage of the Lead as defined by the client |
| Stage 2 | Integer |
Second Stage of the Lead as defined by the client
|
| Stage 3 | Integer |
Third Stage of the Lead as defined by the client
|
| Stage 4 | Integer |
Fourth Stage of the Lead as defined by the client
|
| Stage 5 | Integer |
Fifth Stage of the Lead as defined by the client (if necessary)
|
| Stage 6 | Integer |
Sixth Stage of the Lead as defined by the client (if necessary)
|
| Stage 7 | Integer |
Seventh Stage of the Lead as defined by the client (if necessary)
|
| Stage 8 | Integer |
Eighth Stage of the Lead as defined by the client (if necessary)
|
| Stage 9 | Integer |
Ninth Stage of the Lead as defined by the client (if necessary)
|
| Stage 10 | Integer |
Tenth Stage of the Lead as defined by the client (if necessary)
|
| Lead Value | Decimal | Total value of leads generated |
| ChannelMix Key | String | The ChannelMix Key associated with the campaign metadata |
| Insert Date | Timestamp |
The time in which the record was inserted into ChannelMix - Data freshness indicator
|
| ChannelMix Profile | String |
A descriptive name for the segment of data from each data source
|