Open navigation

The Trade Desk: Query setup guide

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, Data Studio, and Excel. 


Main features

Below is a list of main features of The Trade Desk connector:

  • 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


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 must pay to The Trade Desk.


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

Google Sheets Data Studio Excel Data Integrations
  1. Authenticate the data source in Google Sheets. 
  2. 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.

  3. Select Metrics
  4. 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.
  5. Click Get Data to Table to create your query and pull your data.

Advanced options for Google Sheets

  1. You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
  2. Under Options, you can add additional features to your query.



Troubleshooting


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.