How to connect external systems to the ADvendio Programmatic Import (DSP, SSP, Exchange)

Version 2.120 and up
Supported Adservers

Appnexus (SSP)

Ad Exchange

1.) Create connection records in ADvendio

To start your journey into Programmatic Analytics, you will first need to save your credentials to the DSPs / SSPs / Exchanges in ADvendio. To do so you will need to create so called AdServer Logins. Open the app launcher and search for AdServer Login.

Then proceed to create new records for the services you'd like to connect.

For our new Programmatic Revenue Import, we natively support Google Ad Manager, Xandr (SSP) & Google Display & Video 360. Please see the following pages for more details, about the credentials needed for the connection. Setup Xandr SSP and AdServer Connection Setup DoubleClick AdExchange Setup Google Display&Video 360 connection

2.1) Use Salesforce Big Objects

There are two possibilities for the storage of the programmatic data you import from the different SSPs / Exchanges / DSPs. You can either use Big Objects or use a separate storage provided by ADvendio.

To use our import into Big Objects there are no more steps needed to be done. As soon as your connection login records are configured, you can schedule the programmatic import and the data will be imported into Big Objects. Please be aware that you are not able to view Big Object records like regular Salesforce records. You are required to use the Salesforce Anayltics cloud, or use third party app from the Salesforce App Exchange, to access the 'raw' data imported into Salesforce.

For testing purposes, each Salesforce Org has a storage of 1.000.000 rows for Big Objects. To use our features properly, you will need to purchase additional storage space. Please contact your technical account manager so we can support you with that.

2.2) Configure Database connection

To use the ADvendio Storage a separate license, please contact your technical account manager for more information!

If you are not using Big Objects for the storage of your programmatic data, you need to also configure a connection to ADvendios database. You will receive the login credentials, as well as the database endpoint directly from ADvendio. If you have purchased the analytics license and haven't yet received your database login, please contact support@advendio.com

Once you have these information, you will need to connect them to your AdServer Login, which will be used for the programmatic import. Go to the related tab and see  a list called additional logins. If you can't see this related list, please modify the page layout for AdServer Login under Setup→Object Manager → AdServer Login

Pay attention to change the layout for the correct record type.

Click the new button to create a new additional login information.

You will need to set the following information:

  • Record Type = Programmatic Data
  • Username = the username you received from ADvendio
  • Endpoint = the name of you enpoint, you will also receive this information from ADvendio, usually it's identical to the username
  • Password = the password

If you're importing data from multiple SSPs / Exchanges, please repeat this step for each AdServer Login record in your org, which will be used for programmatic revenue data.

Attention: Please use one Username/Endpoint per org! If you want to test in Sandboxes please use a different username and endpoint from your productive environment. If you use the import with the same endpoint in different orgs, this may lead to inconsistencies in your data!

3.) Required Objects, Fields, Record Types