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 Connection / 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.

Please note that we only import open auctions, impressions/ clicks for deals can be imported by our regular Delivery data import see chapter 3 here or 5.3 Revenue Schedule, Delivery Data, and Status Updates directly from your DFP Adserver.

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:



Target Object


AdxProgrammaticDataUploadAdServer LoginADvendio__ProgrammaticData__cADvendio__AdServerLogin__c
AdxProgrammaticDataUploadAdvertiser Unique KeyADvendio__ProgrammaticData__cADvendio__Advertiser__r.ADvendio__UniqueKey__c
AdxProgrammaticDataUploadAgency Unique KeyADvendio__ProgrammaticData__cADvendio__Agency__r.ADvendio__UniqueKey__c
AdxProgrammaticDataUploadCurrency ISO CodeADvendio__ProgrammaticData__cCurrencyISOCode
AdxProgrammaticDataUploadDemaind Partner Unique KeyADvendio__ProgrammaticData__cADvendio__DSP__r.ADvendio__UniqueKey__c
AdxProgrammaticDataUploadRecord TypeADvendio__ProgrammaticData__cRecordTypeId
AdxProgrammaticDataUploadUnique KeyADvendio__ProgrammaticData__cADvendio__UniqueKey__c