ChannelMix | Lead Generation Geography Oneview

Below are the fields for the Lead Generation Geography OneView dataset. The sources that populate a OneView can be customized to your data specifications and CRM, however, the datasets that are available in the standard Lead Generation Geography OneView configuration are:

  • SalesForce (v_salesforce_lead)*
  • HubSpot (v_hubspot_contact)*
  • Bing Ads (v_bing_geo_performance)*
  • Twitter Ads (v_twitter_ads_line_item)
  • Facebook Ads (v_facebook_ad_region)*
  • Google Ads (v_google_ads_geo_performance)*
  • Google Campaign Manager (v_gcm_geo)*
  • LinkedIn Ads (v_linkedin_ads_creative)
  • Google Search Ads 360 (v_google_search_ads_ad_group)
  • Snapchat Ads (v_snapchat_ads)
  • Yahoo Gemini (v_yahoo_gemini_performance_stats)
  • Traditional Media via Google Sheet (v_gs_traditional_media)
  • Digital Media via Google Sheet (v_gs_digital_media_performance)
  • Lead Gen Data via Google Sheet (v_gs_lead_gen_data_row_level OR v_gs_lead_gen_data_aggregate)

*Can obtain geography-level data.

Field Field Type Description
Report Date Date The date activity occurred
Data Source String The data source from where the record originated
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
Channel String A description of the marketing channel
Region String Region of Lead as defined by the Data Source
Country String Country of Lead as defined by the Data Source
ChannelMix Region String ChannelMix standardization of the Region
ChannelMix Country String ChannelMix standardization of the Country
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
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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.