ChannelMix | Paid Search Ad OneView Performance and Conversion
Below are the fields for the Paid Search Ad Performance and Conversion OneView dataset. Please note that the sources that populate this OneView may provide data for channels other than Paid Search. Data for irrelevant channels are removed from this OneView. The sources that populate a OneView can be customized to your data specifications, however, the datasets that are available in the standard Paid Search Ad Performance and Conversion OneView configuration are:
- Apple Search Ads (v_apple_search_ads_ad)
- Bing Ads (v_bing_ad_performance)
- Bing Ads (v_bing_ad_performance_conversion)
- Google Ads (v_google_ads_api_ad_performance)
- Google Ads (v_google_ads_api_ad_performance_conversion)
- 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 Ads (v_google_ads_api_campaign_conversion) - This is included just to provide insights to data that is only available at the campaign level (like "Performance Max Campaigns").
- Google Search Ads 360 (v_search_ads_360_reporting_ad)
- Google Search Ads 360 (v_search_ads_360_reporting_ad_conversion)
| 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 |
| Account ID | Integer | The account ID |
| Campaign | String | The campaign name |
| Ad Group | String | The Ad Group or Placement name |
| Ad ID | Integer | The ad ID |
| Ad Type | String | The ad type |
| Channel | String | A description of the marketing channel |
| Device | String | The device where the ad was viewed |
| Description | String | The ad description that appears below the path in your ad |
| Description Line 1 | String | Line 1 description of the Ad |
| Description Line 2 | String | Line 2 description of the Ad |
| Title | String | The ad title |
| Headline 1 | String | The first part of an expanded text ad headline |
| Headline 2 | String | The second part of an expanded text ad headline |
| URL | String | The ad display URL |
| Conversion Category | String | Category that describes the action taken |
| Conversion Name | String | A description of the conversion |
| Impressions | Integer | Total times the ads were served |
| Clicks | Integer | Total times the ads were clicked |
| Cost | Decimal | Total cost of ads |
| Conversions | Decimal |
Total conversions based on data source conversion tracking
|
| Conversion value | Decimal |
Total conversion value based on data source conversion tracking
|
| View Through Conversions | Decimal |
The total number of view-through conversions. These happen when a customer sees an image or rich media ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
|
| 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
|