Use a CSV file to make multiple changes to your account's mediation and network instance settings at one time.
You can manage CSV files on either the SDK Networks page or the Mediation Management page.
SDK Networks page
Upload a CSV file on the SDK Networks page to update your mediated network settings and perform the following actions:
- Activate and deactivate instances
- Connect an instance to a mediation group
- Create instances
- Delete non-bidding instances
- Set instance rates
- Update existing instances
Import CSV
To upload a CSV from the SDK Networks page, complete the following steps:
- Go to the SDK Networks page.
- Select the app to update.
- Select the CSV icon.
- Select Import CSV.
- Upload your CSV.
Your CSV file must use the .csv file format and be structured by using the format detailed in the following section.
CSV structure
Ensure that you structure the CSV file by using the exact column names in the order listed in the following table.
| Column name | Guidance | Mandatory/optional |
|---|---|---|
| Network | Enter 1 network per row. Use network names as they appear here. Note that settings for ironSource Network non-bidding instances and Amazon Publisher Services must be configured on the platform. | Mandatory |
| Ad unit | Enter 1 ad unit per row. Supported ad units: rewarded video, interstitial, banner. Refer to the list in Mediation Networks for Unity to find the ad units supported by each network | Mandatory |
| Instance name | Enter 1 instance name per row. | Only mandatory for non-bidding instances |
| Rate | Enter a value between 0 and 3000. | Mandatory |
| Status | Enter Active or Inactive. | Optional |
| Mediation group A | Enter the name of a mediation group to connect it to the instance. To add this instance to multiple mediation groups, list them here and separate using pipes ( | ). If you're running an A/B test, connect configuration A to this group. | Optional |
| Mediation group B | Enter the name of a mediation group to connect it to the instance. To add multiple values, separate them using pipes ( | ). If you're running an A/B test, connect configuration B to this group. | Optional |
| App config 1 | Enter the relevant AppConfig value from this table. | Mandatory |
| App config 2 | If the network includes a second appConfig value in this table, enter it here. | Mandatory for networks that list 2 appConfig values |
| Instance config 1 | Enter 1 value per row Use the instanceConfig column from this table. | Mandatory, except for ironSource Network bidder |
| Instance config 2 | If the network includes a second instance config Use the instanceConfig column from this table | Mandatory for networks that list 2 instanceConfig values |
| Delete instance | Enter True for instances you want to delete. Only non-bidding instances can be deleted by using CSV. | Optional |
The following list details additional guidelines for your CSV file:
- The file can contain up to 10,000 rows
- Each file can contain only one of the following combinations per row:
- For bidding networks: network and ad unit
- For traditional networks: network, ad unit, and instance name
- If an existing instance is connected to a mediation group, include that mediation group in your CSV to ensure they stay connected
- Changes to mediation groups can only be made to active instances
You can also configure these settings directly on the platform. For more information, refer to Mediation networks setup.
Export to CSV
You can export mediated network instance settings to a CSV file and then use the file as a template to import bulk changes to the platform.
The CSV will include all instances that you've configured and will be structured similar to the table in the preceding section.
If you haven't configured any instances, the file will include sample data. Replace the sample data with your own instance preferences and import it to update your settings.
Mediation Management page
Upload a CSV file on the Mediation Management page to perform the following actions for your app's mediation settings:
- Change the optimization type for each tier
- Change the order of instances
- Update instance rates
Import CSV
To upload a CSV from the Mediation Management page, complete the following steps:
- Go to the Mediation Management page.
- Select the app, ad unit, and mediation group to update.
- Select the CSV icon.
- Select Import CSV.
- Upload your CSV.
Your CSV file must use the .csv file format and be structured by using the format detailed in the following section.
CSV structure
Ensure that you structure the CSV file by using the exact column names in the order listed in the following table.
| Column name | Guidance | Mandatory/optional |
|---|---|---|
| Waterfall tier | Enter one of the following values: ‘Tier 1', ‘Tier 2', ‘Tier 3', ‘Backfill', 'Bidding' | Mandatory |
| Tier Type | Enter one of the following values: ‘Manual', ‘Sort by CPM', ‘Optimized' | Mandatory |
| Ad Source | From provider table | Mandatory |
| Instance | Instance name | Mandatory |
| Rate | Enter a value between 0 and 1000 to set your instance price. For more information, refer to Instance rate. | Optional |
The following list details additional guidelines for your CSV file:
- The CSV will only update the selected ad unit and mediation group
- If an A/B test is running in the selected app, the CSV will only update the group that the toggle is set to
You can also configure these settings directly on the platform. For more information, refer to Mediation management.
Export to CSV
You can export your mediation group settings to a CSV file to make bulk updates and then import them to the platform.
The CSV will include all instances on the mediation group and will be structured similar to the table in the preceding section.
Set up network settings for an app by using CSV
You can use the CSV tool to configure network instances in bulk after duplicating setup from another app. By using this process, you don't need to access each network's modal on the platform to update the settings manually.
- In the left navigation menu, select Dashboard.
- In the upper right corner, select New App.
- Enter your app's details and then select Duplicate setup from another application.
- Select the app to duplicate from the dropdown menu and then select Add App.
- In the confirmation window that displays, select Got it.
- On the SDK Networks Setup page, in the upper right corner, select the CSV button to export the app's mediated network instance configurations.
- Adjust the settings per network in the CSV file according to the guidelines in the appropriate CSV structure section earlier in this topic.
- After you've made your adjustments, select the CSV button again to import your updated CSV file.
Next steps
Test that your ads are being delivered to specific devices by using the integration testing tool.
For more information, refer to Integration testing.