Getting Started - Pinterest Organic

This guide covers the basic functionality of the Supermetrics Pinterest Organic connector, and gives examples of how to set up a query for Google Sheets, Google Data Studio, and Microsoft Excel. 


Quick links to the sections below:

Google Sheets

Google Data Studio

Microsoft Excel

"If everything fails..." 

Data Source Access Requirements:

To enable Supermetrics for Pinterest Organic: 

  • User must be logged in as Owner account of the profile.
  • The profile queried must be a business profile.

Documentation:

The complete list of available fields (metrics and dimensions) for Pinterest Organic, can be found here.


Query types:

The data source offers three report types:

  • Profile lifetime metrics
  • Profile data
  • Top pins


Query type: 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.


Query type: Profile data


  • Profile data report type allows you to fetch and investigate key impressions and engagement metrics of your Pinterest profile over time.


Query type: 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.
    • NOTE: currently we return only top 10, but that will be changed in the soon future.
  • 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.
  • Currently, the report type returns all organic and paid data for shown pins, and data that is generated from pins of others on your profile and your own pins. However, we will soon add additional configuration allowing you to select if you want to get organic, paid, or all data, and if you want to inspect your pins, others’ pins or both.


Google Sheets - Query Setup Example:

1. To authenticate the data source, please see:

How to Authenticate/Re-authenticate Pinterest Organic in Google Sheets, Google Data Studio & Microsoft Excel

2. Select account/s. To select a specific account, search with the account name.

3. Under report configuration, select query type.

4. Select metrics. To see all metrics that can be fetched, please see Pinterest Organic documentation. To deselect a metric click on the X next to the metric's name.

- When searching for a metric in the documentation, please see "Type met"

Field label is the metric name that appears in the sidebar.

5. Split by dimensions. You can choose dimensions in rows and/or columns. To see all dimensions that can be fetched, please see the documentation. To deselect a dimension click on the X next to the dimension's name. 

- If you wish to split dimensions to rows, select number of rows and how to sort them (automatic, month, year & month, etc.)

- If you wish to split dimensions to columns. Select number of columns and how to sort them (descending, alphabetical, reverse alphabetical, etc.). To deselect a dimension click on the X next to the dimension's name.

- When searching for a dimension in the documentation, please see "Type dim"

Field label is the metric name that appears in the sidebar.

6. As a last step, click on Get Data To Table.

You have completed all the steps to setup a query.


Further Reading

1. As optional, click on filter to filter your data. Select field, operator and insert the value to filter by.

2. Select options to add additional features to your query.

- Highlight values with colours (green, red, etc.).

- Advanced settings: please see Advanced Settings for Google Sheets.

Google Data Studio - Query Setup Example:

1. To authenticate the data source, please see:

How to Authenticate/Re-authenticate Pinterest Organic in Google Sheets, Google Data Studio & Microsoft Excel

2. Select dimensions. To see all dimensions that can be fetched, please see the documentation. To deselect a dimension click on the X next to the dimension's name. 

- When searching for a dimension in the documentation, please see "Type dim"

Field label is the metric name that appears in the sidebar.

3. Select metrics. To see all metrics that can be fetched, please see the documentation. To deselect a metric click on the X next to the metric's name.


- When searching for a metric in the documentation, please see "Type met"

Field label is the metric name that appears in the sidebar.

4. Sort how the data is shown. Choose the field you wish to sort wish and the order you want to use (ascending/descending).


5.Select default date range on auto or custom.

- To select a custom date, click on last 28 days. An automatic calendar bar will open, select a date on start date and end date and click apply.


To select a specific period (fixed, previoud period, previous year, none, advanced), click on the arrow on the right top corner.

You have completed all the steps to setup a query.


Further Reading

1. As optional, click on add a filter to filter your data.

If you encounter a discrepancy when using a filter, please see Discrepancies in Data Studio When Using a Filter.

Microsoft Excel - Query Setup Example:

1. To authenticate the data source, please see:

How to Authenticate/Re-authenticate Pinterest Organic in Google Sheets, Google Data Studio & Microsoft Excel

2. Select account/s. To select a specific account, search with the account name.

3. Select query type.



4. Select dates. Choose one date range (today, yesterday, last week, etc.).


- To select a custom date, you can either insert the date manually on start and end or select it from the calendar bar.

4. Select metrics. To see all metrics that can be fetched, please see the documentation. To deselect a metric click on the X next to the metric's name.

- When searching for a metric in the documentation, please see "Type met"

Field label is the metric name that appears in the sidebar.

5. Split dimensions by rows and/or columns.

- When searching for a dimension in the documentation, please see "Type dim"

Field label is the name that appears in the sidebar.


- If you wish to split dimensions by rows, select number of rows and how to sort them (ascending/descending).

- If you wish to split dimensions by columns, select number of categories and how to sort them (descending/alphabetical).

6. As a last step, click on Get data.

You have completed all the steps to setup a query.


Further Reading

1. As optional, click on add filter to filter your data.

2. Select options to add additional features to your query.

- Replace blank metric values with zeroes.

- No header row.

- Show all time value values: please see What does the "Show all time values" do

- Custom, advanced settings: please see Advanced Settings for Excel.

Common errors:

- These metrics and dimensions can't be fetched together / Incompatible fields, please see this guide.
- For daily query quotas, please see this guide.

- Not All Accounts/Segments/Custom Fields/Labels Are Showing in the Product, please see this guide.

- For authentication/re-authentication common errors, please see this guide.

- Error:" Unsupported Get Request. Object With ID 'act_XXXX' Does Not Exist", please see this guide

- Error validating access token: The user is enrolled in a blocking, logged-in checkpoint, please see this guide

- Getting "null" or "No Data" With Reach and Other Unique Metrics With Filters, please see this guide.


Further assistance 

If you followed all the above steps and you still encounter an error, please create a new support request with the details of the issue and we will assist you.

Did you find it helpful? Yes No

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