Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version 6

changes.mady.by.user Pascal Clausen

Saved on

Key

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

Version 2.107.1 and up

To store your Enhanced Delivery Data from AppNexus split by Adserver ID schedule the Delivery Reports as described in 5.3.5 Enhanced Delivery Data and define by which criteria you want to split by using the field "Enhanced Delivery Report Filter".

...

CategoryStringAdditional Information
Country{
"splitBy":["Country"]
}
Inventory{
"splitBy":["Inventory"]
}
Key Values

With filter:

{
"splitBy":["Key Values"],
"filterByKeys":["a092K00000q14e5","a092K00000q24e8"]
}


Without filter:

{
"splitBy":["Key Values"],
"filterByKeys":[]
}

You can filter for certain Keys to reduce the loaded data by entering the Salesforce IDs of the relevant Keys in the "filterByKeys" section as shown on the left. If you don't enter IDs for filtering all Keys will be used.


Mapping - Enhanced Delivery Data to ADvendio

The Object Enhanced Delivery Data is able to store the following data. These are pulled from the ADserver and pushed into Advendio per Campaign Item for the following dimension and metrics:

FIELD LABELFIELD NAMEDATA TYPEAppNexus field
AdServer IDADvendio_AdServerID_cLookup(AdServer ID)
AdServer-ID CategoryADvendio_AdServerIdCategory_cFormula (Text)
AdServer-ID TypeADvendio_AdServerIDType_cFormula (Text)
AdServer-ID NameADvendio_AdServerIDName_cFormula (Text)
Advertiser View-Through SalesADvendio__AdvertiserViewThroughSalesRev__cNumber (12,6)
Advertiser Click Through SalesADvendio__AdvertiserClickThroughSalesRev__cNumber (12,6)
Campaign ItemADvendio_CampaignItem_cMaster-Detail(Campaign Item)
Clicks totalADvendio_ClicksTotal_cNumber(18, 0)clicks
Click-Through ConversionsADvendio_ClickThroughConversions__ cNumber(18,0)
Conversions per ClickADvendio_ConversionsPerClick__ cNumber(18,0)
Conversions per Thousand ImpressionsADvendio_ConversionsPerThousandImpressions__ cNumber(4,14)
Created ByCreatedByIdLookup(User)
CurrencyCurrencyIsoCodePicklist
DateADvendio_Date_cDate
Enhanced Delivery Data NameNameAuto Number
Impressions totalADvendio_ImpressionsTotal_cNumber(18, 0)imps
Impressions total downloadedADvendio_ImpressionsTotalDownloaded_cNumber(18, 0)
Impressions total viewedADvendio_ImpressionsTotalViewed_cNumber(18, 0)
Last Modified ByLastModifiedByIdLookup(User)
MonthADvendio_Month_cFormula (Date)
Total CTRADvendio_TotalCtr__ cPercent
Video viewed 100%ADvendio_VideoViewed100_cNumber(18, 0)imps_viewed
Video viewed 25%ADvendio_VideoViewed25_cNumber(18, 0)
Video viewed 50%ADvendio_VideoViewed50_cNumber(18, 0)
Video viewed 75%ADvendio_VideoViewed75_cNumber(18, 0)
View-Through ConversionsADvendio_ViewThroughConversions__ cNumber(18,0)
AdvertiserViewThroughSales__cADvendio__AdvertiserViewThroughSales__cCurrency(16, 2)
ClickThroughConversions__cADvendio__ClickThroughConversions__cNumber(18,0)
ConversionsPerClick__cADvendio__ConversionsPerClick__cNumber(18,0)
ConversionsPerThousandImpressions__cADvendio__ConversionsPerThousandImpression__cNumber(4, 14)
TotalCtr__cADvendio__TotalCtr__cPercent(16, 2)
ViewThroughConversions__cADvendio__ViewThroughConversions__cNumber(18, 0)