5.3.5.3 Enhanced Delivery Data Mapping (Google Ad Manager)
Version | 2.87 and up |
---|---|
Supported Adservers | Google Ad Manager |
Mapping Table
FIELD LABEL | FIELD NAME | DATA TYPE | Google Ad Manager field | Google Ad Manager Service | Beginning with Version |
---|---|---|---|---|---|
AdServer ID | ADvendio_AdServerID_c | Lookup(AdServer ID) | 2.87 | ||
AdServer-ID Category | ADvendio_AdServerIdCategory_c | Formula (Text) | 2.87 | ||
AdServer-ID Type | ADvendio_AdServerIDType_c | Formula (Text) | only Device Category & Country as filter | 2.87 | |
AdServer-ID Name | ADvendio_AdServerIDName_c | Formula (Text) | 2.87 | ||
Advertiser View-Through Sales (Deprecated) | ADvendio_AdvertiserViewThroughSales__c | Currency | Deprecated. | 2.97 | |
Advertiser View-Through Sales | ADvendio__AdvertiserViewThroughSalesRev__c | Number (12,6) | VIEW_THROUGH_REVENUE | 2.102 | |
Advertiser Click Through Sales | ADvendio__AdvertiserClickThroughSalesRev__c | Number (12,6) | CLICK_THROUGH_REVENUE | 2.102 | |
Campaign Item | ADvendio_CampaignItem_c | Master-Detail(Campaign Item) | 2.87 | ||
Clicks total | ADvendio_ClicksTotal_c | Number(18, 0) | AD_SERVER_CLICKS | 2.87 | |
Click-Through Conversions | ADvendio_ClickThroughConversions__ c | Number(18,0) | CLICK_THROUGH_CONVERSIONS | 2.97 | |
Conversions per Click | ADvendio_ConversionsPerClick__ c | Number(18,0) | CONVERSIONS_PER_CLICK | 2.97 | |
Conversions per Thousand Impressions | ADvendio_ConversionsPerThousandImpressions__ c | Number(4,14) | CONVERSIONS_PER_THOUSAND_IMPRESSIONS | 2.97 | |
Created By | CreatedById | Lookup(User) | 2.87 | ||
Currency | CurrencyIsoCode | Picklist | 2.87 | ||
Date | ADvendio_Date_c | Date | 2.87 | ||
Enhanced Delivery Data Name | Name | Auto Number | 2.87 | ||
Impressions total | ADvendio_ImpressionsTotal_c | Number(18, 0) | AD_SERVER_IMPRESSIONS | https://developers.google.com/doubleclick-publishers/docs/reference/v201705/ReportService.Column | 2.87 |
Impressions total viewed | ADvendio_ImpressionsTotalViewed_c | Number(18, 0) | TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS | 2.87 | |
Last Modified By | LastModifiedById | Lookup(User) | 2.87 | ||
Month | ADvendio_Month_c | Formula (Date) | 2.87 | ||
Total CTR | ADvendio_TotalCtr__ c | Percent | AD_SERVER_CTR | 2.97 | |
Video viewed 100% | ADvendio_VideoViewed100_c | Number(18, 0) | VIDEO_VIEWERSHIP_COMPLETE | 2.87 | |
Video viewed 25% | ADvendio_VideoViewed25_c | Number(18, 0) | VIDEO_VIEWERSHIP_FIRST_QUARTILE | 2.87 | |
Video viewed 50% | ADvendio_VideoViewed50_c | Number(18, 0) | VIDEO_VIEWERSHIP_MIDPOINT | 2.87 | |
Video viewed 75% | ADvendio_VideoViewed75_c | Number(18, 0) | VIDEO_VIEWERSHIP_THIRD_QUARTILE | 2.87 | |
View-Through Conversions | ADvendio_ViewThroughConversions__ c | Number(18,0) | VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE | 2.97 | |
AdvertiserViewThroughSales__c | ADvendio__AdvertiserViewThroughSales__c | Currency(16, 2) | Amount of sales revenue generated for the advertiser because a user performed an action, such as completing a purchase, after viewing an ad. | 2.98 | |
ClickThroughConversions__c | ADvendio__ClickThroughConversions__c | Number(18,0) | Number of actions, such as visiting the advertiser's webpage or completing a purchase, taken by a user who has clicked on an ad. | 2.98 | |
ConversionsPerClick__c | ADvendio__ConversionsPerClick__c | Number(18,0) | Number of click-through conversions divided by the number of clicks. | 2.98 | |
ConversionsPerThousandImpressions__c | ADvendio__ConversionsPerThousandImpression__c | Number(4, 14) | (View-through conversions for control group ÷ Impressions for control group) × 1000 | 2.98 | |
TotalCtr__c | ADvendio__TotalCtr__c | Percent(16, 2) | Percentage of impressions served by the DoubleClick ad server, AdSense and Ad Exchange that resulted in users clicking on an ad. | 2.98 | |
ViewThroughConversions__c | ADvendio__ViewThroughConversions__c | Number(18, 0) | Number of actions, such as visiting the advertiser's webpage or completing a purchase, taken by a user who has viewed an ad. | 2.98 |
Attention:
Starting with ADvendio Version 2.102 the field
ADvendio_AdvertiserViewThroughSales__c got changed to
ADvendio__AdvertiserViewThroughSalesRev__c.
If you are planning to use view through sales make sure to display the correct field in page layouts, reports, profiles, etc.