Open navigation

Yahoo DSP: Query setup guide

Once you’ve authenticated your connection to Yahoo DSP, you’re ready to create your first query. 


This guide will walk you through Yahoo DSP query setup for Google Sheets, Looker Studio (formerly Data Studio), and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.


Before you begin

To connect Supermetrics to Yahoo DSP, you need:

  • API access and a Client ID and Client secret. To enable the API, please follow the One-time setup steps. 


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 Looker Studio Excel Data Integrations
  1. Authenticate the data source in Google Sheets. 
  2. Select Metrics
  3. 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.
  4. 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.
  • 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.



Troubleshooting


Did you find it helpful? Yes No

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