7.7.1.4 Setup Rubicon Project SSP Connection

To connect Rubicon Project SSP with ADvendio please follow these steps:

1. Configure the ADServer Login

Navigate to Overview - AdServer Interface - ADServer Logins. Create a new login record and fill in the following fields:


2. Schedule Delivery Data Imports

Go to the Delivery Data Settings page and schedule the job to your needs. Read here how to: 5.3.3 Schedule Delivery Data Reports (Legacy Feature). Starting with version 2.90 the import will get delivery data for the last month plus the current month-to-date data (until the 7th day of the current). After this cut-off date we only import data for the actual month/month-to-date. 

3. 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:

FeatureSourceTarget ObjectTarget
RubiconProgrammaticAccountUploadIdADvendio__ProgrammaticAccount__cADvendio__ExternalID__c
RubiconProgrammaticAccountUploadLoginADvendio__ProgrammaticAccount__cADvendio__AdServerLogin__c
RubiconProgrammaticAccountUploadNameADvendio__ProgrammaticAccount__cADvendio__AccountName__c
RubiconProgrammaticAccountUploadTypeADvendio__ProgrammaticAccount__cADvendio__AccountType__c
RubiconProgrammaticAccountUploadUniqueKeyADvendio__ProgrammaticAccount__cADvendio__UniqueKey__c
RubiconProgrammaticDataUploadAdServer LoginADvendio__ProgrammaticData__cADvendio__AdServerLogin__c
RubiconProgrammaticDataUploadSizeADvendio__ProgrammaticData__cADvendio__AdSlot__c
RubiconProgrammaticDataUploadSize IDADvendio__ProgrammaticData__cADvendio__AdSlotID__c
RubiconProgrammaticDataUploadAdvertiser Unique KeyADvendio__ProgrammaticData__cADvendio__Advertiser__r.ADvendio__UniqueKey__c
RubiconProgrammaticDataUploadAdvertiser IDADvendio__ProgrammaticData__cADvendio__AdvertiserId__c
RubiconProgrammaticDataUploadAgency Unique KeyADvendio__ProgrammaticData__cADvendio__Agency__r.ADvendio__UniqueKey__c
RubiconProgrammaticDataUploadBuyer IDADvendio__ProgrammaticData__cADvendio__AgencyID__c
RubiconProgrammaticDataUploadCountryADvendio__ProgrammaticData__cADvendio__Country__c
RubiconProgrammaticDataUploadCurrency ISO CodeADvendio__ProgrammaticData__cCurrencyISOCode
RubiconProgrammaticDataUploadDateADvendio__ProgrammaticData__cADvendio__Date__c
RubiconProgrammaticDataUploadDealADvendio__ProgrammaticData__cADvendio__DealName__c
RubiconProgrammaticDataUploadDeal IDADvendio__ProgrammaticData__cADvendio__DealID__c
RubiconProgrammaticDataUploadDemaind Partner Unique KeyADvendio__ProgrammaticData__cADvendio__DSP__r.ADvendio__UniqueKey__c
RubiconProgrammaticDataUploadPartnerADvendio__ProgrammaticData__cADvendio__DSPText__c
RubiconProgrammaticDataUploadeCPMADvendio__ProgrammaticData__cADvendio__eCPM__c
RubiconProgrammaticDataUploadImpressionsADvendio__ProgrammaticData__cADvendio__Impressions__c
RubiconProgrammaticDataUploadRecord TypeADvendio__ProgrammaticData__cRecordTypeId
RubiconProgrammaticDataUploadRevenueADvendio__ProgrammaticData__cADvendio__Revenue__c
RubiconProgrammaticDataUploadUnique KeyADvendio__ProgrammaticData__cADvendio__UniqueKey__c
RubiconProgrammaticDataUploadZoneADvendio__ProgrammaticData__cADvendio__AdUnit__c
RubiconProgrammaticDataUploadZone IDADvendio__ProgrammaticData__cADvendio__AdUnitID__c
RubiconProgrammaticDataUploadRevenue SourceADvendio__ProgrammaticData__cTransactionType__c