Once you've authenticated your connection to Pinterest Public Data, you're ready to create your first query.
This guide will walk you through Pinterest Public Data query setup for Google Sheets, Looker Studio (formerly Data Studio), and Microsoft Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.
Before you begin
Pinterest Public Data doesn't require you to log into a specific account. It allows you to collect publicly available data about pages and posts.
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 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 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 Supermetrics API
Troubleshooting
Query runs very slowly
This error more commonly affects Sheets, as it allows for a larger row limit. Try reducing the number of rows to something below 300, or limit the number of usernames listed, to speed the query up.
No data overtime is available
This version of the API only shows lifetime totals for most metrics and you won't be able to report changes over time unless you use the "Combine new with old" feature in Google Sheets and run this every day to collect your own historical data.
Discrepancies in board counts
The API allows a fetch of up to 50 pins per user — board data is derived from the pin data. This can mean that queries only return 50 pins even when more are requested, or why board data seems to be missing. We're working on updating the API to fix this.
Getting "no data" for username
The "display name" on a page may not be the correct one to use with their API. Make sure that you are using the true username as seen in the URL to their page on Pinterest:
Incompatible fields or quotas
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.