The Trade Desk Data Connector User Guide

The Trade Desk Data Connector User Guide

Are you looking to streamline your programmatic advertising data analysis? This guide will walk you through the process of integrating The Trade Desk with Power My Analytics, enabling you to automate data collection, centralize your metrics, and create powerful reports. By the end of this guide, you'll be able to effortlessly connect The Trade Desk to your Power My Analytics account and start leveraging your data for actionable insights.

Prerequisites

Before you begin, ensure you have the following:
  1. An active account with The Trade Desk
  2. The account manager must grant your account access to the following APIs:
    1. MyReports API
    2. Scheduling API
  3. Permission to create reports in your The Trade Desk account
  4. An API token generated by your client account manager in The Trade Desk with appropriate permissions

Adding The Trade Desk as a Data Source

  1. Log in to your Power My Analytics account.
  2. Navigate to the Sources section from the main menu.
  3. Click on the + New Data Source button.
  4. Locate and select The Trade Desk from the gallery of available data sources.
  5. Enter your The Trade Desk username and password to authenticate your account.

Creating a Looker Studio Report

To create a Looker Studio report using your The Trade Desk data:
  1. In the Power My Analytics hub, go to Reports > Looker Studio
  2. Select The Trade Desk under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "The Trade Desk - Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your The Trade Desk account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Click Connect (top right) to complete the data source configuration
    4. Step 4:
      1. Click Create Report (top right)

Key Reports and Fields

The Trade Desk data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  • Campaign Metrics: Advertiser Cost, Start Date, End Date
  • Ad Group Metrics: Budget Amount, Pacing Mode, Spend, Ad Group Base Bid CPM, Total Bid Amount, Frequency, Impressions
  • Creative Metrics: Ad Format, Start Date, End Date
  • Advertiser Metrics: Clicks, Impressions, Click Conversion, Conversion Touch, Spend
  • Performance Insight Metrics: Bids, Impressions, Advertiser Cost, Advertiser CPM, Clicks, Click Conversion, View Through Conversion
  • Conversion Performance Metrics: Bids, Impressions, Spend, Clicks, Click Conversion, View Through Conversion
For a comprehensive list of available The Trade Desk fields in Power My Analytics, visit the Schema Explorer.

Limitations and Important Considerations

  • Backfilling: Limited to 2 years, with an initial backfill of 13 months when you first connect your The Trade Desk account as a data source.
  • Reach and frequency reports are coming soon.

Troubleshooting

If you encounter issues:

  1. Verify your The Trade Desk account has the correct permissions
  2. See the article Basic Troubleshooting for instructions on issues that may affect The Trade Desk connector
  3. Contact our support team if problems persist


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • Criteo Data Connector User Guide

        This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...

      • PayPal Data Connector User Guide

        PayPal is a widely used payment processing platform, and integrating its data into your analytics workflow can provide valuable insights into your business performance. This guide will walk you through the process of setting up PayPal as a data ...

      • Stripe Data Connector User Guide

        Stripe is a powerful payment processing platform that enables businesses to accept online payments, manage subscriptions, and handle invoicing. This guide will walk you through the process of connecting Stripe to Power My Analytics, creating reports, ...

      • CartStack Data Connector User Guide

        Are you looking to streamline your e-commerce analytics and improve your cart abandonment recovery efforts? This guide will walk you through setting up and using the CartStack data source in Power My Analytics. By integrating CartStack with our ...