Ad spend third-party storage exports

Ad spend third-party storage exports give you the flexibility to export aggregated data to a storage for your own data 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.

1. Set up the report in Datascape with your Technical Account Manager.
2. Share the report URL with your Technical Account Manager. The Technical Account Manager verifies the information with you and completes the export configuration.
3. Provide the following details to your Technical Account Manager:
   • Dimensions
     • The exported files are always split by the App token and Day dimensions. Choose any additional dimensions available in Datascape by which you want to split up your report.
   • Metrics
   • Custom metrics
   • How many days' worth of data you want to receive
   • Schedule on which exports should run
4. You start receiving exported files in your storage.

Exported files

Adjust exports files containing all information for the selected criteria in the CSV, Apache Parquet, or DataFrame format.

The default path template for the files in the selected storage is bucket_name-folder_name/{day}{app_token}{selected_dimension_1}_{selected_dimension_2}. The Day and App token dimensions are mandatory.

You receive one file per unique combination of metrics. For example: if you want to see two days' worth of information for two app tokens, you receive the following files:

• A file with day 1 data for app token 1.
• A file with day 2 data for app token 1.
• A file with day 1 data for app token 2.
• A file with day 2 data for app token 2.