Setting Up a New SSP Connection Through a Scheduled Daily CSV File

Set up an SSP mail import with scheduled daily CSV reports when API access is not available.

If the SSP does not provide an API, follow this documentation to set up a mail import SSP through CSV imports in Yield.

It is always better to utilise the API first, but CSVs can be used as well. Read more about how to set up an API connection: Setting Up a New SSP Connection with API

Setting Up the CSV Report

You need to ask the partner company to generate automatic daily reports in .CSV format. The daily email must contain exactly one .CSV file. In some systems, you are allowed to do this yourself as well.

Before you start, make sure the report meets these requirements:

1. The report needs to be in CSV format. Excel files don't work.

2. Only Gmail is supported as the mailbox.

3. The subject line of the report should be unique. This is especially important if you work with multiple email import SSPs coming from the same sender address.

They should send the email reports to: dev_[customer]@relevant-digital.com. You should have already been given a similar email, but if you're unsure, feel free to reach out to your Technical Account Manager or our support team, and they can provide you with the correct email.

The report should include the following columns. Required fields are marked with *.

Required:

• Date column*

• Placement ID column*

• Placement name column*

• Revenue column*

• Sold Impressions column*

Optional but recommended:

• Deal

• Deal ID

• Advertiser

• Ad Requests

In Yield, you will need to set up both access to the mailbox and configure the column names in the report.

To see your Relevant email address (dev_[customer]@relevant-digital.com), you need help from Relevant Support because credentials are required. Contact your TAM or our support team to complete this step.

Setting Up the Integration in Yield

1

Create the integration

Go to Configuration → Integrations and add a new SSP integration.

Set the SSP type to Mail Import SSP and give the integration a name. This name appears as the SSP name in reporting.

2

Map the CSV columns

Fill in the required fields * and as many additional fields as possible.

Make sure the column names in Relevant Yield match the column names in the CSV file.

3

Configure import settings

Complete any additional settings needed for your report:

• Add how the data should be handled and add revenue shares if needed.

• If the report currency is not EUR, enable Use Default Report Currency and select the value in Default Report Currency.

• Fill in the fields based on the column names used in the .CSV report file.

• Check the date format in the date column. If it is not a standard JavaScript date format, enter it in Date Format.

4

Add Gmail credentials

To add the credentials for the Gmail account at the bottom of the page, follow the same procedure as Google Ad Manager.

Using Scheduled Reports with Rubicon/Magnite

By default, we use Magnite's preferred partner connection. If, for any reason, there's a need to set up a Magnite connection as a mail import SSP, here are the step-by-step instructions.

1

Create the saved report

Create a saved report with these settings:

• Time Period: Yesterday

• Columns:

  • Date

  • Advertiser

  • Zone

  • Zone ID

  • Ad Requests

  • Paid Impressions

  • Gross Revenue

  • Deal

  • Deal ID

  • Buyer

  • DSP

  • Creative Size

2

Add the filter

Add this filter: Paid Impressions >= 1.

This removes unnecessary rows for advertisers with bid requests but no impressions.

3

Check the row count

Run the report manually and check the row count.

Rubicon has a 50,000-row report limit.

4

Reduce columns if needed

If the report is close to or above that limit, remove the Advertiser column.

This avoids losing data, but advertiser reporting in Yield for Rubicon will not be available.

5

Schedule the report

Schedule the report to send daily to dev_[customer]@relevant-digital.com.