Open navigation

Pinterest Ads and Pinterest Organic: Query setup guide

This guide will walk you through how to authenticate or reauthenticate Pinterest Ads and Pinterest Organic with Google Sheets, Data Studio, and Microsoft Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API. 


Before you begin

To connect Supermetrics to Pinterest Organic, you need: 

  • A user logged in as the Owner account of the profile (access to an Ad account won't allow access to organic data of the profile). 
  • The profile queried must be a business profile

Here’s an example of sufficient user permissions:


To connect Supermetrics to Pinterest Ads, you need:

Here’s an example of sufficient user permissions:


Available fields

Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source. You can find the full list of data sources on the left side of the page.

  • 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.