5.3.5.3 Enhanced Delivery Data Mapping (Google Ad Manager)


Version 2.87 and up
Supported Adservers

Google Ad Manager

Mapping Table 

FIELD LABELFIELD NAMEDATA TYPEGoogle Ad Manager fieldGoogle Ad Manager ServiceBeginning with Version
AdServer IDADvendio_AdServerID_cLookup(AdServer ID)

2.87
AdServer-ID CategoryADvendio_AdServerIdCategory_cFormula (Text)

2.87
AdServer-ID TypeADvendio_AdServerIDType_cFormula (Text)
only Device Category & Country as filter2.87
AdServer-ID NameADvendio_AdServerIDName_cFormula (Text)

2.87
Advertiser View-Through Sales (Deprecated)ADvendio_AdvertiserViewThroughSales__cCurrency
Deprecated.2.97
Advertiser View-Through SalesADvendio__AdvertiserViewThroughSalesRev__cNumber (12,6)VIEW_THROUGH_REVENUE
2.102
Advertiser Click Through SalesADvendio__AdvertiserClickThroughSalesRev__cNumber (12,6)CLICK_THROUGH_REVENUE
2.102
Campaign ItemADvendio_CampaignItem_cMaster-Detail(Campaign Item)

2.87
Clicks totalADvendio_ClicksTotal_cNumber(18, 0)AD_SERVER_CLICKS
2.87
Click-Through ConversionsADvendio_ClickThroughConversions__ cNumber(18,0)CLICK_THROUGH_CONVERSIONS
2.97
Conversions per ClickADvendio_ConversionsPerClick__ cNumber(18,0)CONVERSIONS_PER_CLICK
2.97
Conversions per Thousand ImpressionsADvendio_ConversionsPerThousandImpressions__ cNumber(4,14)CONVERSIONS_PER_THOUSAND_IMPRESSIONS
2.97
Created ByCreatedByIdLookup(User)

2.87
CurrencyCurrencyIsoCodePicklist

2.87
DateADvendio_Date_cDate

2.87
Enhanced Delivery Data NameNameAuto Number

2.87
Impressions totalADvendio_ImpressionsTotal_cNumber(18, 0)AD_SERVER_IMPRESSIONShttps://developers.google.com/doubleclick-publishers/docs/reference/v201705/ReportService.Column2.87
Impressions total viewedADvendio_ImpressionsTotalViewed_cNumber(18, 0)TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
2.87
Last Modified ByLastModifiedByIdLookup(User)

2.87
MonthADvendio_Month_cFormula (Date)

2.87
Total CTRADvendio_TotalCtr__ cPercentAD_SERVER_CTR
2.97
Video viewed 100%ADvendio_VideoViewed100_cNumber(18, 0)VIDEO_VIEWERSHIP_COMPLETE
2.87
Video viewed 25%ADvendio_VideoViewed25_cNumber(18, 0)VIDEO_VIEWERSHIP_FIRST_QUARTILE
2.87
Video viewed 50%ADvendio_VideoViewed50_cNumber(18, 0)VIDEO_VIEWERSHIP_MIDPOINT
2.87
Video viewed 75%ADvendio_VideoViewed75_cNumber(18, 0)VIDEO_VIEWERSHIP_THIRD_QUARTILE
2.87
View-Through ConversionsADvendio_ViewThroughConversions__ cNumber(18,0)VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE
2.97
AdvertiserViewThroughSales__cADvendio__AdvertiserViewThroughSales__cCurrency(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__cADvendio__ClickThroughConversions__cNumber(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__cADvendio__ConversionsPerClick__cNumber(18,0)
Number of click-through conversions divided by the number of clicks.2.98
ConversionsPerThousandImpressions__cADvendio__ConversionsPerThousandImpression__cNumber(4, 14)
(View-through conversions for control group ÷ Impressions for control group) × 10002.98
TotalCtr__cADvendio__TotalCtr__cPercent(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__cADvendio__ViewThroughConversions__cNumber(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.