This guide covers the basic functionality of the Supermetrics Pinterest connector for Sheets and Data Studio, and gives examples of how to set up a query in both products.
Quick links to the sections below:
- Query Types
- Example Query Setup in Google Sheets Add-on (and Excel)
- Example Query Setup in Data Studio
- Common Issues
The Pinterest connector is a "simple connector" which does not require you to log in to a specific account. It allows you to then collect publicly available data about pins and Pinterest users. It uses a query selection system for the type of data you would like to collect, which limits which metrics can be used, but prevents user errors from combining invalid field combinations.
The Pinterest connector supports 3 type of queries:
- Pinterest pins for URLs - gathers count of times a specific URL was pinned
- Pinterest user data - gathers data about the user, such as account name, link to profile, follower count, etc.
- Pinterest pins for users - gathers data about user pins, such as Pin URL, image, description, etc.
Query type selection in Google Sheets:
Query type selection in Data Studio:
Query type selection in Excel:
Example Query Setup in Google Sheets
Here is a walk-through for setting up a "Pinterest pins for user" query using the Google Sheets Add-on. Though the sidebar UI is slightly different, the same basic method also works for Supermetrics for Excel. (The example for Data Studio is below this section.)
- With an empty cell selected, launch the sidebar in Google Sheets.
- In the Data Source section, select the connector "Pinterest Public Data".
- This connector does not require you to log on. It should immediately open the Query Type section.
- In the Select query type: drop-down, select "Pinterest pins for user".
- In the Pinterest usernames box, add the usernames you wish to search for. You can add expand the box and add more than one name, one each on a new line.
- In the # of rows per item drop-down, select "10". This will pull the most recent 10 pins for each username you added. For better performance, avoid higher row values.
- Open the Select metrics section. Click in the box to see a drop-down of the available metrics for this query type. Note that as this is a simple connector using a public API, it's field options are more limited.
- Open the Split by dimension section. Click in the box under Split to rows to see a drop-down of the available dimension for this query type. (You can also split by column using the second section - this is optional.)
- You can also apply filters to some fields under Filter, or set "no headers" in the advanced settings under the Options. These are optional though, and not required to make the query work.
- At the top of the sidebar, click Get Data to Table to run the query and see the results. In this example, this is the most recent 10 posts made to the Supermetrics page.
If further adjustments need to be made, click Modify. Note that due to the nature of the "Query type" system, you cannot combine user data with user's pin data in a single query. If you get errors, see the "Common Issues" section in this article at the bottom.
Example Query Setup in Data Studio
Here is a walk-through for setting up a "Pinterest pins for user" query using the Data Studio connector.
- In Data Studio, add a new data source and search for "Pinterest" in the Partner Connectors section. Click SELECTto add it.
- Click AUTHORIZE to start the authorization process for Data Studio. In the resulting pop-up, click your Google account you are using for Data Studio access. Click Allow to continue (else the connector won't function).
- Click AUTHORIZEfor Pinterest. You do not need to log in to use this connector, it will open a pop-up that closes automatically, and then should go to the next part of the configuration.
- In the Query typedrop-down, select "Pinterest pins for user".
- Go down to the ***************** SETTINGS FOR QUERY TYPE: Pinterest pins for user ***************** section.
- In the Pinterest usernames box, add one or more page names, comma separated.
- In the # of pins per userdrop-down, select "10". This will pull the most recent 10 pins for each username you added. Data Studio is hard-coded to a 500 row maximum, by design. For better performance, avoid higher row values.
- The other check boxes next to the settings allow you to edit the settings directly in the report. These are optional and not required to make the query work.
- You do not need to fill out any other query section as it will not be used. Note that you can only set one query type at a time with this connector. If you need other query types, repeat this process to create a new data source with the different query type selected.
- Give the Data Source a meaningful name.
- Click CONNECT in the upper right-hand corner to create the data source.
- It will take you to a page with all the connector's fields that are available for the "Pinterest pins for user" query type. Click ADD TO REPORT to continue.
- Create a report element on the report page, selecting your new source as the Data Source. Add the metrics and dimensions available to create your query. In this example, a table is used to show the last 10 pins made to the Pinterest account and their repin counts.
- If you need to modify the query, you can do so from the Data bar in the Data Studio UI and it will update automatically to reflect your changes.
"No account objects selected" Errors
More often affects Data Studio. Check that you filled out the proper query section and that there's a valid page name given.
Query Runs Very Slowly
More commonly affects Sheets, as it allows for a larger row limit. The API being used is not that efficient, so the more user accounts you try pull or the more rows, the slower it gets. Try reducing the number of rows to something below 300 or limit the number of usernames listed.
No Data over Time is Available/I Can't Report Over Time?
Sadly, 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 Sheets and run this every day to collect your own historical data (this feature is not available at all in Data Studio).
I'm Only Getting 50 Pins/Discrepancies in Board Counts
The version of the API we are using currently only allows us to fetch up to 50 pins per user, and the board data is derived from the pin data. So this may be why you only get 50 pins even with a higher setting, or that board data seems to be missing. This will be corrected in future when we upgrade to v4 of the API.
Getting 'No Data' for Username
The "display name" on their 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: