Ad revenue data import

With Adjust’s Data imports solution, you can upload your aggregated ad revenue data directly to Adjust. This is helpful if you work with partners that don’t have a direct integration with Adjust.

When you import your ad revenue data to our system, it brings it together with Adjust-measured data for more powerful insights and actionable reporting.

Before you begin

Here's what you need to know before getting started.

Requirements

• Admin or Editor permissions in Adjust.
• A Google Sheets link with View permissions.

Availability

Prepare your Google Sheets file

To accurately import your ad revenue data to Adjust, you need to set up your Google Sheets file in a specific format and include key information.

1. Create a Google Sheets file titled: [YourCompany]_[Network being integrated]_[Data type] data import.
   • Example: companyname_networkname_adrevenue_data_import
2. Modify the Share settings to:
   • Share with View permissions to the automate.import@adjust.com email address.
3. Use the Ad revenue Data Imports template to build your CSV report in the correct format.
   • Ensure there are no commas (,) or dollar signs ($) in the document, as this will cause errors during the import.
   • Do not leave any empty rows between the rows of data.
   • Make sure there are no random cells filled outside the rows of data.
4. Set up ad revenue data import in Adjust.

Column formatting

Ensure that your CSV file contains the following parameters:

• Required parameters - date, revenue
• At least one of these parameters - app_name, bundle_id, channel_app_id, store_id
• All other fields can be left empty if you don't receive them from the network.

Set up ad revenue data import

To set up your ad revenue data import, follow these steps.

1. Under DataWorks, select Data imports.
2. Select New data import.
3. Under Data type, select Ad Revenue.
4. Select a partner from the list.
   • If you do not see your partner in the list, reach out to your Account Manager to get this partner added.
5. In the Google Sheets link field, paste the correct Google Sheets link that you set up.
6. Now, select Check table to validate your Google Sheets file. Any errors in your file would be displayed here, and you need to correct them, before you can go to the next step.
7. Under Frequency, choose how often should the data import process run automatically.
   • Select Daily, and choose a time in UTC. When you choose to run a daily import, data is checked daily at the selected time. The import process runs only if 24 hours have passed since the last import.
   • Select Weekly, and choose a day and then time in UTC. When you choose to run a weekly import, data is checked weekly at the selected time. The import process runs only if a week has passed since the last import.
8. Select Create data import.

You're all set! Now, Adjust pulls data for the last 7 days automatically. If you want to modify this lookback window, reach out to support@adjust.com.

View and manage your data import setup

1. Go to DataWorks > Data imports. This page displays a list of all data imports that you've set up. This page gives you an overview of the following:

   • ID - The identifier of the data import. Always share the ID with your Technical Account Manager if you have questions or need to discuss issues.
   • Partner - The name of the advertising network for which you're importing ad revenue data.
   • Ad account - The ad account of the partner.
   • Frequency - The frequency at which the data import process is run automatically.
   • Data type - The type of data. In this case, ad revenue data.
   • Source type - The source of ad revenue data. Example: Google Sheets
   • Last import - The last time when the data import process ran successfully.
   • Failed imports - The number of the times the data import process failed to complete.
     • None - Denotes that the data import process has never failed.
     • Failed - Denotes the number of times that the data import process failed. Under Actions, select (more icon) > Open to view the reasons for a failed import.

2. On the Data imports page, under Actions, select (more icon) > Open to view a specific data import. You can perform the following tasks for this data import:

   • Select (delete icon) to delete the data import setup.
   • Select Edit import to edit the import setup configuration.
   • Under the Import settings section, you can:
     • View your import settings, and turn on or turn off the automatic data import process.
       
     • View the import log with details of all import processes run till date. This section displays the time at which the import process was run, and the period for which data was imported. For all successful imports, select View imported data to view imported data in reports in Datascape. For all failed imports, select Check error details to view and resolve errors in the data import process.

3. On the Data imports page, under Actions, select (more icon) and then:

   • Select Edit to edit an existing import setup configuration.
   • Select Delete to delete the data import setup.