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:
- Record Type "RUBICON".
- User Name: Enter your Rubicon API Key provided by Rubicon.
- Password: Enter your Rubicon API Secret.
- Network ID: Enter your Account-Id.
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.2 Schedule Delivery Data Reports. 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:
| Feature | Source | Target Object | Target |
|---|---|---|---|
| RubiconProgrammaticAccountUpload | Id | ADvendio__ProgrammaticAccount__c | ADvendio__ExternalID__c |
| RubiconProgrammaticAccountUpload | Login | ADvendio__ProgrammaticAccount__c | ADvendio__AdServerLogin__c |
| RubiconProgrammaticAccountUpload | Name | ADvendio__ProgrammaticAccount__c | ADvendio__AccountName__c |
| RubiconProgrammaticAccountUpload | Type | ADvendio__ProgrammaticAccount__c | ADvendio__AccountType__c |
| RubiconProgrammaticAccountUpload | UniqueKey | ADvendio__ProgrammaticAccount__c | ADvendio__UniqueKey__c |
| RubiconProgrammaticDataUpload | AdServer Login | ADvendio__ProgrammaticData__c | ADvendio__AdServerLogin__c |
| RubiconProgrammaticDataUpload | Size | ADvendio__ProgrammaticData__c | ADvendio__AdSlot__c |
| RubiconProgrammaticDataUpload | Size ID | ADvendio__ProgrammaticData__c | ADvendio__AdSlotID__c |
| RubiconProgrammaticDataUpload | Advertiser Unique Key | ADvendio__ProgrammaticData__c | ADvendio__Advertiser__r.ADvendio__UniqueKey__c |
| RubiconProgrammaticDataUpload | Advertiser ID | ADvendio__ProgrammaticData__c | ADvendio__AdvertiserId__c |
| RubiconProgrammaticDataUpload | Agency Unique Key | ADvendio__ProgrammaticData__c | ADvendio__Agency__r.ADvendio__UniqueKey__c |
| RubiconProgrammaticDataUpload | Buyer ID | ADvendio__ProgrammaticData__c | ADvendio__AgencyID__c |
| RubiconProgrammaticDataUpload | Country | ADvendio__ProgrammaticData__c | ADvendio__Country__c |
| RubiconProgrammaticDataUpload | Currency ISO Code | ADvendio__ProgrammaticData__c | CurrencyISOCode |
| RubiconProgrammaticDataUpload | Date | ADvendio__ProgrammaticData__c | ADvendio__Date__c |
| RubiconProgrammaticDataUpload | Deal | ADvendio__ProgrammaticData__c | ADvendio__DealName__c |
| RubiconProgrammaticDataUpload | Deal ID | ADvendio__ProgrammaticData__c | ADvendio__DealID__c |
| RubiconProgrammaticDataUpload | Demaind Partner Unique Key | ADvendio__ProgrammaticData__c | ADvendio__DSP__r.ADvendio__UniqueKey__c |
| RubiconProgrammaticDataUpload | Partner | ADvendio__ProgrammaticData__c | ADvendio__DSPText__c |
| RubiconProgrammaticDataUpload | eCPM | ADvendio__ProgrammaticData__c | ADvendio__eCPM__c |
| RubiconProgrammaticDataUpload | Impressions | ADvendio__ProgrammaticData__c | ADvendio__Impressions__c |
| RubiconProgrammaticDataUpload | Record Type | ADvendio__ProgrammaticData__c | RecordTypeId |
| RubiconProgrammaticDataUpload | Revenue | ADvendio__ProgrammaticData__c | ADvendio__Revenue__c |
| RubiconProgrammaticDataUpload | Unique Key | ADvendio__ProgrammaticData__c | ADvendio__UniqueKey__c |
| RubiconProgrammaticDataUpload | Zone | ADvendio__ProgrammaticData__c | ADvendio__AdUnit__c |
| RubiconProgrammaticDataUpload | Zone ID | ADvendio__ProgrammaticData__c | ADvendio__AdUnitID__c |