Open navigation

Pinterest Ads and Pinterest Organic: Authentication and reauthentication 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:

  • User must be logged in as 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:



Pinterest Organic - Query types


Profile lifetime metrics

- Profile lifetime metrics provide a snapshot view of your profile’s current data: followers, the number of pins, reach.


- Unfortunately, historical follower data cannot be queried with Pinterest Organic connector.


- If you want to track the development of your follower and pin amount, you can use “Append new results to old” feature in report configuration, and schedule a periodic refresh of your query. This way, previous query results are stored and new results are fetched automatically.


- “Append new results to old” works only with Google Sheets. If you want to track the development of your metrics in Data Studio, you can schedule query in Google Sheets, and import that data to Data Studio using Google Sheets connector for Data Studio.


Profile data

- Profile data report type allows you to fetch and investigate key impressions and engagement metrics for your Pinterest profile over time. This data includes metrics of all pins, not just the top 100. 


- You can select a date range for which time period you want the data to be returned. Please note that the time range in Top pins report type defines the time range of when metrics have been accumulated (impressions, clicks, saves, close-ups) and not when the pin has been created.


- The report allows you to select if you want to see organic, paid or both metrics for pins, and if you want to inspect pins created by you, pins that you re-pinned or both.


Top pins

- Top pins report type returns data for 100 best-performing pins in your profile based on the metric you select. You can define the sorting basis in report configuration.


- You can select a date range for which time period you want the data to be returned. Please note that the time range in Top pins report type defines the time range of when metrics have been accumulated (impressions, clicks, saves, close-ups) and not when the pin has been created.


- The report allows you to select if you want to see organic, paid or both metrics for pins, and if you want to inspect pins created by you, pins that you re-pinned or both.


Data protection agreement 

If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.


Instructions


Google Sheets Data Studio  Excel Data integrations
Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.
  1. Open a new Google Sheets file. 
  2. Click Add-ons → Supermetrics → Launch to open the sidebar.
  3. Under Data source, select the data source.
  4. Click Start.
  5. Enter your email address and password, and click Log in
  6. Click Give access.
    For Pinterest Ads, under Select accounts, select the accounts.
    For Pinterest Organic, under Select accounts, select your accounts.
    Navigate to Report configuration.
    Under Query type, select the query type.

Reauthenticate 
Learn how to reauthenticate the data source with Supermetrics Google Sheets.

Next steps
Learn how to create your first Supermetrics query with Pinterest Ads and Pinterest Organic.


Troubleshooting

  • If you encounter an authentication error such as “authentication failed”, “you need to reauthenticate” or similar, see this guide
  • If you're missing an account from the drop-down list, follow these steps.
  • If you encounter a permission error such as “user permission denied” or similar, follow this guide.

Did you find it helpful? Yes No

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