7.7.1.2 Setup DoubleClick AdExchange

Currently ADvendio can only import action data from AdExchange (version 2.89 and up).


Here are the steps how to set up your AdExchange AdServer in ADvendio:

1. Set up your AdServer Login

Follow the steps in the instructions 7.3.1 Create an Ad Server Login but make sure to use the ADX record type to specify that this is an AdExchange login record. 

You have successfully created the Google DoubleClick Ad Exchange integration.

Note: You can validate the Google DoubleClick Ad Exchange integration by clicking the link Check Login at the AdServer Login detail page.

Please take care of the permission settings for the user that generates the OAuth Token.

To import the full set of data please ensure that the role permissions for reporting like "Create and view reports" and "Create and view Ad Exchange reports" are enabled in the DFP UI. Here is a documentation on how to create/edit a user role in the UI. Also, you can check this guide for the complete list of user role permissions.


2. Schedule your Delivery Data

Add the configuration for AdExchange on the 5.3.3 Schedule Delivery Data Reports (Legacy Feature).

Enter all relevant data:

  1. Enter the Salesforce Username as well as Password and Security Token.
  2. Select Time and Day information.
  3. Enter an email address for the fields Failure Note Recipient and Success Note Recipient, if needed.
  4. Activate the checkbox Send Success Note, if needed.
  5. Click the button Submit.


3. Update your Ad Ids

The easiest process is probably to have a monthly data loader import. Here we explain the manual steps:

4. Validate Revenue Schedule Data

After your import has been run make sure the data has been imported correctly. When importing delivery data we use Adserver data (AD_SERVER_IMPRESSIONS). Starting with version 2.87 and up we alternatively import ADX numbers for clicks/impression (AD_EXCHANGE_IMPRESSIONS etc.).


5. Mapping

We have implemented the Mapping with the Generic Dataloader (GDL) so you are free to map to your requirements. If you need help please contact your technical account manager for support.

Following fields are mapped by default:

Feature

Source

Target Object

Target

AdxProgrammaticAccountUploadIdADvendio__ProgrammaticAccount__cADvendio__ExternalID__c
AdxProgrammaticAccountUploadLoginADvendio__ProgrammaticAccount__cADvendio__AdServerLogin__c
AdxProgrammaticAccountUploadNameADvendio__ProgrammaticAccount__cADvendio__AccountName__c
AdxProgrammaticAccountUploadTypeADvendio__ProgrammaticAccount__cADvendio__AccountType__c
AdxProgrammaticAccountUploadUniqueKeyADvendio__ProgrammaticAccount__cADvendio__UniqueKey__c
AdxProgrammaticDataUploadAdServer LoginADvendio__ProgrammaticData__cADvendio__AdServerLogin__c
AdxProgrammaticDataUploadCREATIVE_SIZEADvendio__ProgrammaticData__cADvendio__AdSlot__c
AdxProgrammaticDataUploadDFP_AD_UNIT_IDADvendio__ProgrammaticData__cADvendio__AdUnitID__c
AdxProgrammaticDataUploadAdvertiser Unique KeyADvendio__ProgrammaticData__cADvendio__Advertiser__r.ADvendio__UniqueKey__c
AdxProgrammaticDataUploadAgency Unique KeyADvendio__ProgrammaticData__cADvendio__Agency__r.ADvendio__UniqueKey__c
AdxProgrammaticDataUploadCLICKSADvendio__ProgrammaticData__cADvendio__Clicks__c
AdxProgrammaticDataUploadCOUNTRY_CODEADvendio__ProgrammaticData__cADvendio__Country__c
AdxProgrammaticDataUploadCurrency ISO CodeADvendio__ProgrammaticData__cCurrencyISOCode
AdxProgrammaticDataUploadDemaind Partner Unique KeyADvendio__ProgrammaticData__cADvendio__DSP__r.ADvendio__UniqueKey__c
AdxProgrammaticDataUploadMONTHADvendio__ProgrammaticData__cADvendio__Date__c
AdxProgrammaticDataUploadDEAL_IDADvendio__ProgrammaticData__cADvendio__DealID__c
AdxProgrammaticDataUploadCOST_PER_CLICKADvendio__ProgrammaticData__cADvendio__eCPC__c
AdxProgrammaticDataUploadAD_IMPRESSIONS_RPMADvendio__ProgrammaticData__cADvendio__eCPM__c
AdxProgrammaticDataUploadAD_IMPRESSIONSADvendio__ProgrammaticData__cADvendio__Impressions__c
AdxProgrammaticDataUploadRecord TypeADvendio__ProgrammaticData__cRecordTypeId
AdxProgrammaticDataUploadEARNINGSADvendio__ProgrammaticData__cADvendio__Revenue__c
AdxProgrammaticDataUploadTRANSACTION_TYPE_NAMEADvendio__ProgrammaticData__cADvendio__TransactionType__c
AdxProgrammaticDataUploadUnique KeyADvendio__ProgrammaticData__cADvendio__UniqueKey__c