7.7.10.3 Generate Media Campaigns from your Programmatic Data

Owned by Former user (Deleted)
Last updated: 2024-04-17 by Daniel Yañez
3 min read

Challenge:

Now that my programmatic data is available in ADvendio storage, and programmatic prices, advertisers, and partners are mapped accordingly, I need to have the data organized per Media Campaigns and/or Campaign Items.

 

Solution:

Programmatic Media Campaign Generation feature

In order to generate the Media Campaigns from your BURT reporting data, we have a dedicated process. This can be started by using the ‘Programmatic Media Campaign Generation’ button on your Connection record or by scheduling an automated process, for example every day!

The automatic Media Campaign Generation is a great solution to get the most up to date Revenue Media Campaigns without having to push the button each time.

Please note our automatic Media Campaign Generation will always generate Campaigns for the current / running month. Except for the first 10 days of a month. During this time, the process will update Campaigns from the past month, as well as for the running month, so that we can make sure all data arrived in ADvendio, while already giving you the new Campaigns for your reporting needs!

To find out more information about the Media Campaign generation process, please check the following wiki section: https://advendio.atlassian.net/wiki/spaces/SO/pages/983564300

Burt specific settings

In Burt, the Media Campaign generation process has been slightly adjusted to better emphasize the data that will be received from various Adservers. Let’s start with the default scenario (any other integration but Burt):

  • If multiple Programmatic Prices are assigned to one Ad Price, one Campaign Item will be created

  • For each Connection, Account, Currency, and Month, a Media Campaign will be created.

  • The name of the Programmatic Media Campaign contains: Year-Month Programmatic Revenue PLATFORM - Advertiser/Buyer

However, with the Burt integration, you bring data from multiple third-party sources. Therefore, how is data from different AdServers being differentiated from each other? If Burt integration is being used, then the above scenario becomes the following one:

  • If multiple Programmatic Prices are assigned to one Ad Price, one Campaign Item will be created.

  • For each Connection, Account, Currency, Partner Account, Deal Type, and Month, a Media Campaign will be created.
    In that way, each Media Campaign result will correspond to the associated Programmatic Partner.

  • The Programmatic Partner Account information will be stored at the level of Media Campaign in the Programmatic Partner field.

  • The name of the Programmatic Media Campaign contains: Year-Month Programmatic Revenue PROGRAMMATIC PARTNER ACCOUNT - Advertiser/Buyer

 

Example:

Step 1: Confirm that all programmatic relevant data has been imported. For that, you can check the following objects: Programmatic Advertisers, Programmatic Price, and Programmatic Partner

Step 2: Assign (Partner) Accounts to the relevant Programmatic Partners

Step 3: Assign Ad Prices to the relevant Programmatic Prices

Step 4: Assign (Advertiser) Accounts to the relevant Programmatic Accounts

Step 5: Generate Programmatic Media Campaigns

 

Why no Programmatic Media Campaign is being generated?

  1. To have programmatic media campaigns generated, confirm that the imported programmatic partners, prices, and advertisers have been correctly assigned (see Example section).

  2. The Media Campaign Name field supports maximum 80 characters. If it contains more than 80 characters, no programmatic media campaign will be created.

 

Useful links: