This guide covers the basic functionality of the Supermetrics The Trade Desk connector, and gives examples of how to set up a query for Google Sheets, Looker Studio (formerly Data Studio), and Excel.
Before you begin
To connect Supermetrics to The Trade Desk, you need:
- Partner-level reporting user role level and access to partner cost metrics. There might be fees associated with API access that you'll pay to The Trade Desk.
- Please note that you will need to sign a form with The Trade Desk to give your data access. Supermetrics or any other third party is not involved in the legal process of this contract.
Main features
- Fetches main advertising metrics: impressions, clicks, CTR data for all different conversion pixels, conversion revenue, and cost.
- Fetches detailed data and metrics for video ads such as views, completes, starts, pauses, resumes, and skips.
- Fetches metrics on the level you want: by advertiser, campaign, ad group, or creative.
- Inspects detailed campaign performance by digging into metrics by:
- Target audience, category, vendor, site or app
- Device, operating system, browser
Available fields
Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source.
- Field label is the name that appears in the sidebar.
- Metrics can be found under type - “met”.
- Dimensions can be found under type - “dim” .
Instructions
- Authenticate the data source in Google Sheets.
- Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
- Select Metrics.
- Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
- Click Get Data to Table to create your query and pull your data.
Advanced options for Google Sheets
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query.
- Replace blank metric values with zeros.
- Combine new results with old.
- Format results for Looker Studio (to import data from Google Sheets to Looker Studio).
- No header row.
- Highlight values with colours (green, red, etc.).
- Advanced settings.
- Authenticate the data source in Looker Studio.
- Under Dimension, select Dimensions.
- Under Metric, select Metrics.
- Select how to sort the data.
- Select the Date range from the auto or custom options. If you choose a custom date range, click the arrow on the top-right hand side. Under a specific period, select a Start Date and End Date.
Advanced options for Looker Studio
You can filter your data by selecting the field, condition, and value to filter by. Learn more about using filters.
- Authenticate the data source in Excel.
- Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
- Select Metrics.
- Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
- Click Get data to create your query and pull your data.
Advanced options for Excel
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query. Learn more about Supermetrics advanced settings in Excel.
Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up data warehouse and cloud storage products (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up the Supermetrics API
Troubleshooting
- If you see an error about metrics and dimensions not fetching together, or fields being incompatible, follow these steps to fix the issue.
- If you see errors relating to quotas, or “daily query quotas”, read this guide.