Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Version 2.87 and up
Supported Adservers

DFPGoogle Ad Manager

Mapping Table 

FIELD LABELFIELD NAMEDATA TYPEDFP fieldDFP ServiceGoogle 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


Note
titleAttention:

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.