Below are the fields for the Lead Generation Pipeline 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 Pipeline 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)
- Reddit Ads (v_reddit_ad_standard)
- TikTok Ads (v_tiktok_ad_standard)
*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 |
| 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
|
Comments
Please sign in to leave a comment.