How to import Programmatic Data

Once the basic configuration is done, importing the data into Salesforce is simple. You just need to schedule delivery reports for the exchange or SSP your want to use. To do so, simply open the Delivery Report Settings via the App Launcher. Scroll down to the section PA-Delivery Report Settings, and select the timing for your report to run. Depending on the license model you're using the data will be imported into either big objects or aggregated via Amazon Web Service. For both solutions you will need to schedule a delivery report.

Open

More information on Delivery Report Settings can be found here: 5.3.2 How to schedule and manage Delivery Reports / Programmatic Data Imports from AdServers, SSPs, DSPs (New interface)

ADvendio does not import single Auctions / Deals, but will already aggregate the data to a certain extent. We will summarize the data by the following:

• The Advertiser / Buyer

• The part of the Inventory, which has been sold

• The type of Deal and how it has been charged (for example: Direct Deals with CPM)

• Data will always be aggregated for full months
  
  

Results of the import

Once an import has run successfully, you will receive an email with the results.

Here you can see what kind of data has been imported into your Org. Depending on your used licensing model. Depending on your license model, the programmatic revenue data will be imported either into Big Objects or the ADvendio database. While programmatic prices and programmatic advertisers will be created directly into your Salesforce Org, so you can start configuring the mapping.

Once the import is done, there are two ways you can continue to work with your data and visualize them in ADvendio:

1. Directly use the data in Analytics Cloud:

2. Generate Media Campaigns, to further aggregate the data and simplify reporting for you and use it in further ADvendio features, like the Accounting Interface: 

Mapping

Here is an overview of the data mapping from the different exchanges and SSPs to ADvendio. Keep in mind that we will always aggregate the number of sold impressions and revenue by month.