Ad spend third-party storage exports

Ad spend third-party storage exports let you export aggregated ad spend data to your own storage for analysis.

Use this solution if you want to customize your reports and the frequency at which you receive them. You can use these reports to optimize your campaigns.

Before you begin

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

Requirements

• You need to be on the SpendWorks Custom package to get the ad spend third-party storage exports solution on your account.

How it works

1. Connect your account in DataWorks > Connections.
2. Set up the report in Datascape with your Technical Account Manager.
3. Share the report URL with your Technical Account Manager. They verify the configuration with you and complete the export setup.
4. Provide your Technical Account Manager with:
   • Path template, which determines how exported files are organized in your storage destination. It can use a subset of the dimensions included in your report.
   • Number of days to export
   • Export schedule
5. Adjust sends the exported files or data to your configured destination on the selected schedule.

Connect your storage

You can export data to the following destinations:

• Amazon S3
• AWS Redshift
• BigQuery
• Google Cloud Storage
• Snowflake

Select the section below for the connection details required for each destination.

Report configuration

Work with your Technical Account Manager to create a Datascape report containing the data you want to export.

You can customize:

• Dimensions
• Metrics
• Date range
• Export frequency

App token and Day are always included in the report. You can also include additional Datascape dimensions in the report, for example:

• Partner
• Store type
• Month

The dimensions and metrics you select determine the contents of the exported data.

Your Technical Account Manager can also configure a path template to determine how exported files are organized in your storage destination. The dimensions used in the path template do not have to match all of the dimensions included in the report.

Export schedule

You can choose how often your export runs and how much historical data each export contains.

For example, you can configure an export to contain the previous 7 days of data and run it every day, or export a longer period on a less frequent schedule.

Your Technical Account Manager will configure the schedule based on your reporting requirements.

Exported files

The available export format depends on the storage destination:

• Amazon S3: CSV or Apache Parquet
• AWS Redshift: DataFrame
• BigQuery: DataFrame
• Google Cloud Storage: CSV or Apache Parquet
• Snowflake: DataFrame

Adjust generates one file for each unique combination of values for the dimensions included in the path template. For example: bucket_name/{day}_{app_token}_{store_type}_{partner}

The path template can include a subset of the dimensions in your report. Dimensions included in the report but not used in the path template do not determine how many files are generated.

For example, if your path template is bucket_name/{day}_{app_token}_{store_type}_{partner} and you export data for two days and two app tokens, while store_type and partner remain the same, Adjust generates the following files:

• A file with day 1, app token 1, store type A, and partner A.
• A file with day 2, app token 1, store type A, and partner A.
• A file with day 1, app token 2, store type A, and partner A.
• A file with day 2, app token 2, store type A, and partner A.

Troubleshooting

If you are not receiving exports, check the following with your Technical Account Manager:

• The storage connection is valid.
• The destination configuration is correct.
• The report URL is valid.
• The selected dimensions and metrics are supported.
• The export schedule is active.
• Your storage destination has the required permissions and available capacity.

Your Technical Account Manager can also check the export run status and investigate failed export jobs.