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:
- A valid Pinterest user account with at least Admin or Campaign access to an ad account. Read Pinterest’s documentation for instructions on how to grant access to Pinterest Ad account.
Here’s an example of sufficient user permissions:
Pinterest Organic - Query types
- 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 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 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
- Open a new Google Sheets file.
- Click Add-ons → Supermetrics → Launch to open the sidebar.
- Under Data source, select the data source.
- Click Start.
- Enter your email address and password, and click Log in.
- 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.
- Open the Supermetrics data source gallery.
- Navigate to the data source and click Try.
- Click Authorize to authorize Supermetrics in Data Studio.
*If you're authenticating the data source for the first time, log in with the Google account you use with Supermetrics. Click Allow.* - Click Authorize to log in to your data source.
- Enter your email address and password, and click Log in.
- 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. - Scroll down to the bottom of the page.
To create a report with our template, select Use report template for new reports.
To create a blank report, deselect this option. - Click Connect on the top right-hand side.
- This will open a full list of fields available in this connector. You can skip this list.
- Click Create report.
- Click Add to report to complete the authentication steps.
Add or remove a user account
- To add or remove a user account go back to the data source settings. Click on the link at the end of the sentence that starts with “To add more/manage user accounts…”
- Click +Add new account to add a new user account.
- Click the Trash icon to remove that specific user account.
- Click Continue to proceed with that user account.
Reauthenticate
Learn how to reauthenticate the data source with Supermetrics Data Studio.
Next steps
Learn how to create your first Supermetrics query with Pinterest Ads and Pinterest Organic.
Before you can authenticate the data source in Excel, you need to
install the Supermetrics add-on.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select the data source.
- Click Start.
- Enter your email address and password, and click Log in.
- 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. - Under Select accounts, select the accounts.
Reauthenticate
Learn how to reauthenticate the data source with Supermetrics Excel.
Next steps
Learn how to create your first Supermetrics query with Pinterest Ads and Pinterest Organic.
Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up Data warehouse and cloud storage (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up Supermetrics API
Reauthenticate the data source
Learn how to reauthenticate the data source with Supermetrics API, data warehouse and cloud storage integrations:
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.