Import/export ad unit and mediation details using CSV (Beta)

This feature is currently in beta release to a select group of publishers.

This article explains how you can import data from a .CSV file to create and update ad unit mappings and ad source instances in mediation groups. You can also use export to create a .CSV file to review the data, troubleshoot any issues, and then import updates to your mediation setup.

In addition, this article provides a breakdown of the structure of your .CSV file and provides a table to help you correctly map your data to app and ad unit configurations during import.

On this page

• Before you get started importing your ad unit mappings and mediation groups
• Export a CSV file of your ad unit mappings and mediation groups
• Import a CSV file of your ad unit mappings and mediation groups
• Understand the columns in your CSV file
• Third-party ad source names, app, and ad unit credentials

Before you get started importing your ad unit mappings and mediation groups

Importing a .CSV file allows you to efficiently create and update ad unit mappings and ad source instances. Before you get started, we recommend you follow these best practices:

• Start by exporting a .CSV file to understand the file format, and all of the ad unit mappings and mediation groups in your app. Once you’ve familiarized yourself with the .CSV file, you can start to edit and add ad unit mappings and line items.
• Work with a single app at a timeto avoid making bulk changes across multiple apps.
• Create ad units and mediation groups in advance.Importing a .CSV file does not create ad units or mediation groups. First, you’ll need to create them in AdMob and then copy those IDs into your .CSV file to use them for new mappings and ad source instances.
• Set up your waterfall and bidding ad sources beforehand.You’ll need to set up ad sources in AdMob, before you can import a .CSV file of the mappings for those ad sources. Once you’ve set up the ad source, you can use the table below to know what mapping details to use in which columns (App Config 1, App Config 2, Ad Unit Config 1, Ad Unit Config 2).

Export a CSV file of your ad unit mappings and mediation groups

You can export a .CSV file to download mapping and ad source details. Use export to create a .CSV file to review the data, troubleshoot any issues, and then import updates to your mediation setup. You can choose to download mappings for a specific app or all the apps in your account.

To export a .CSV file:

1. Sign in to your AdMob account at https://admob.google.com .
2. Click  Mediation in the sidebar.
3. Click Export to CSV.
4. Check the checkbox next to the apps you want to include in the .CSV file download. You can use the Searchbox to find a specific app.
5. Click Confirm.
6. Save the .CSV file to your device.

The downloaded .CSV file includes your selected ad unit mappings, third-party network ad unit identifiers, AdMob ad unit details, and the list of the mediation groups where the mappings are being used. For more information about the different columns in a .CSV file and what they mean, refer to the table below .

Import a CSV file of your ad unit mappings and mediation groups

You can import a .CSV file to create and update ad unit mappings and add ad source instances to mediation groups.

To import a .CSV file:

1. Sign in to your AdMob account at https://admob.google.com .
2. Click  Mediation in the sidebar.
3. Click Import CSV.
   Note: The upload limit is 1000 rows
4. Select the .CSV file you want to import from your device.
5. Click Nextto generate a preview.
6. Review the updates you want to make to your mediation setup, click Apply changes.

   Each row in the generated preview corresponds to a row in your file and shows its change status:

   • No change: This means the ad unit mapping already exists in your account, and it’s usage in mediation groups also has no change.
   • Update:This means the ad unit mapping already exists, but updates have been made to the fields in the ad unit mapping (name, IDs, eCPM, etc.) or to the list of mediation groups where the mapping is used.
   • Create:This means a new ad unit mapping will be created and ad source instances will be added to the specified mediation groups.
   • Error:This means something is wrong with the row you are attempting to import. Review the error details to resolve the issue.

7. Click Yes, apply changesto confirm your updates.

   Changes you make via upload will modify serving behavior if you’re making updates to mediation groups.

8. A message indicates the import was successfully applied. Click Done.

Understand the columns in your CSV file

The table below details the columns and their meanings within the .CSV file.

Third-party ad source names, app, and ad unit credentials

To import your .CSV file, consult the table below to determine the appropriate app and ad unit configuration values for each relevant column.