5.3.2 How to schedule and manage Delivery Reports / Programmatic Data Imports from AdServers, SSPs, DSPs (new interface)

Version2.130 and higher
IntegrationsGoogle AdManager, Adswizz, Freewheel, Google Display&Video 360, Datorama, SMART, Xandr

Challenge

You successfully connected your external systems to ADvendio and now you want to do one of the following:

  • Get in delivery data for running and finished Campaign Items, to see their performance and start invoicing based on actuals
  • Set up detailed breakdowns for your Delivery Reports, so you can see delivery by site/medium or even more details
  • Plan a quick update of your Items data, so that your Sales Reps can see at a glance if Campaign Items perform according to the defined goals
  • Check when the next delivery import is due
  • Change the time for your planned imports or who will receive an email with the results
  • Bring in your programmatic data from SSPs or DSPs to start reporting or using those information in our accounting interface
  • If there was a problem with your last import, you can check if all settings are configured correct and reschedule the import if needed



Solution

For all these things, we can offer you a single interface. So you will have all relevant information and settings in one place and can quickly change everything to your desire.

This is our Delivery Report Center. To enter it go to the App Launcher and type in "Delivery Report Center"


Once opened you will see the following overview

You can see all delivery reports and imports that are currently planned for your Org.

1. Use the buttons on the top right to plan a new import or quickly delete all settings for your Org

2. Additional Settings: This column shows, if any additional features have been activated for your Import. For example a status sync or enhanced delivery data

3. - 5. The next three columns show, when the next import is due, when the last one ran and the status of the import. You can see if an import is currently running or waiting for the next import.

6. You can use these two buttons to either edit or delete a single report of the list


Planning new Imports

However, if you are relatively new and currently in the setup of your ADvendio instance, the screen you will see looks like this:

Looks a bit empty, because there are no Delivery or Programmatic Imports planned yet. Click the button "Plan delivery report" to continue.

First step will be to choose what you want to plan. You have the following options:

  • Lifetime Delivery Report: Updates the overall Impressions, Clicks and Status of your Campaign Items, can be used to synch your items performance, to see if they deliver according to the Campaign Item goals.
  • Monthly / Daily delivery Report: Updates your Campaign Items with detailed delivery information, either on a monthly or daily basis. This will also be needed, in order to invoice your items based on actuals.
  • Programmatic Revenue Import: The import of programmatic revenue data from a DSP / SSP / Exchange as used in our programmatic reporting features


Which Salesforce User is used to actually import the data?

Generally, ADvendio is using the Salesforce User, who is planning the delivery reports as also the user who will then be used to import and update the actual delivery information into Salesforce. This is mainly relevant, that you will need to make sure that the user planning the reports has access to all needed objects and records. We generally recommend to use a System Administrator profile for this. If you want to use a specific user for the import, for example to better track which data has been updated by the delivery reports, you will need to log into the Salesforce UI with that specific user and plan the delivery reports.

If you're updating from an existing version to 2.130 it depends on your current configuration what step you will need to take. We're switching from the user that is entered in the settings, to the one who has planned the configuration as user we take to perform the import actions. It is important, that the user which performs the import, has authorized ADvendio to use OAuth to manage the data and that the user has enough access right to all relevant ADvendio objects and records. We recommend to use a System Administrator profile for this.

  1. You used your System Administrator User to plan the delivery report settings and have also entered his login credentials in the login settings section. Then everything is working like before for you. 
  2. You entered a different user into the login settings section of your Delivery Reports. In this case you will need to follow these steps:
    1. Log into Salesforce as this specific user, you want to use for your Delivery Imports
    2. go to the Delivery Report Settings / Delivery Report Center, click edit and save the settings again without changing anything
    3. Make sure the user has authorized ADvendio to use OAuth. If not, you can do this be performing any ADvendio Connect related action, like going to a connection record and click the check login button.


Lifetime Delivery Reports

Lifetime Delivery Import are a quick way to update your overall performance of your Campaign Items. It will update how many impressions, clicks ect. an item has achieved within it's overall runtime. You can use this data to get a quick update on your items performance, so your sales reps can see if their Campaign Items meet the desired goals, or if they need to make some adjustments.

The lifetime import offers the following settings:

  1. Select the starting time. You can select as many time slots as you like, the lifetime import will always run for all applicable connections in your system. Attention: You can only plan one import/delivery job for each time slot. This applies to all different types of imports. E.g. you can'T plan a lifetime delivery report and a programmatic import to both start at 12:00 
  2. The setting Site-Based Delivery Data, shows if your import delivery information grouped by Top Level Domains or Sites. This is a general setting for your ADvendio Org and can be changed in the Administration Settings (see setup section below). The Checkbox here only shows you if this setting is activated or not
  3. Update Ad Status: Once activated, you will automatically synch back status information for your line items from the external, connected systems
  4. You can also set one or more recipients for results emails. Please be aware that your are required to set at least a Failure Note Recipient in order to save these delivery settings.

Monthly / Daily delivery Report

The monthly or daily delivery imports will import delivery information for your Campaign Items on a monthly and daily breakdown, so you can see exactly how many Impressions were there for each month. This is required for an invoicing based on actuals.

  1. Select the starting time. You can only select a single timeslot here, due to the amount of data that could be imported during this process. Attention: You can only plan one import/delivery job for each time slot. This applies to all different types of imports. E.g. you can't plan a lifetime delivery report and a programmatic import to both start at 12:00 
  2. Select on which days of the month these imports will be running. If you are using them only for invoicing purposes, it might make sense to plan imports on towards the end of a month / beginning of the next month. 
  3. Daily delivery reports can be additionally activated in your Administration Settings (see also setup section below). These will then be automatically planned with your monthly imports (starting 30 minutes after your monthly import)
  4. The setting Site-Based Delivery Data, shows if your import delivery information grouped by Top Level Domains or Sites. This is a general setting for your ADvendio Org and can be changed in the Administration Settings (see setup section below). The Checkbox here only shows you if this setting is activated or not
  5. Enhanced Delivery Data: Once activated you can import enhanced delivery data for your Campaign Items, those are used for a more detailed breakdown of your delivery information (e.g. Impressions per Device or Audience Targeting). These will require to set an additional breakdown and filter. You can see our wiki on Enhanced Delivery Data for more information.
  6. You can also set one or more recipients for results emails. Please be aware that your are required to set at least a Failure Note Recipient in order to save these delivery settings.


Programmatic Revenue Import

The Programmatic Imports will help you bring data from your SSPs / DSPs / Exchanges / Datorama into ADvendio, enabling a unified reporting and also reusing those information for example in Publisher Payout or our Accounting Interface.

  1. Select the starting time. You can only select a single timeslot here, due to the amount of data that could be imported during this process. Attention: You can only plan one import/delivery job for each time slot. This applies to all different types of imports. E.g. you can't plan a lifetime delivery report and a programmatic import to both start at 12:00 
  2. Select on which days of the month these imports will be running. If you are not planning to use the data in day to day reporting, it can be enough to plan the imports at the beginning of a month for the previous month. Attention: at the moment our imports are structured in a way, that for the first 10 days of a month, we import data for the previous month, in order to make sure we can grab any missed data and prevent gabs in the reporting
  3. You can also set one or more recipients for results emails. Please be aware that your are required to set at least a Failure Note Recipient in order to save these delivery settings.



Setup

To access this feature, you will need to have at least one active connection configured to an AdServer, SSP, DSP or similar external system. To find out more about how to do this, you can take a look at the following pages:

7.3.1 Create an Ad Server Login

7.7.1 Connect a Supply Side Platform (SSP)

7.7.2 Connect a Demand Side Platform (DSP)

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

Moat - Delivery Report Settings

Once you have configured your Moat AdServer connection in ADvendio (see: 7.7.6 Setup Moat (Media Analytics)), the third party data will be transferred automatically with the monthly delivery reports for the connected 'main' AdServer Login. There is no separate report to schedule.

Activate Site Base Delivery Data or Daily Delivery Data (optional)

Use the App Launcher to navigate to the Administration Settings or

  1. Navigate to Overview.
  2. Scroll down and open the section Setup & Settings.
  3. Click the button Administration Settings.

Additional Delivery Report Relevant Settings


Here you can activate site-based delivery data or Revenue Schedules Daily for daily delivery data (default is deactivated). If you make changes, click Save


System specific setting and features

Freewheel Enhanced Delivery Data


Xandr time zone settings

For Xandr reporting, it is required to set a specific time zone, you can change which time zone is used for reporting in the ADvendio user settings:

7.3.8.4 How to configure the time zone used for Xandr Delivery Reports / Why are my Xandr monthly delivery data not matching the overall item performance?