Documentation Index

Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt

Use this file to discover all available pages before exploring further.

Pinterest Organic

  • 4 minute(s) read
Prev Next

The Pinterest Organic connector lets you extract data from Pinterest into Dataddo and sync it to any dashboard, database, or data warehouse. It covers the organic (non-paid) performance of your account and your Pins: daily account metrics, top Pins, per-Pin analytics, and follower counts.

Refer to our website for the list of available metrics and attributes you can extract from Pinterest Organic.

If you have multiple Pinterest Organic accounts and would like to extract the same data from all of them, it's possible through multi-account extraction. Contact our Solutions team to enable this feature.

Authentication Methods

You can connect to Pinterest in two ways:

  • Sign in with Pinterest and approve access (recommended).
  • Use your own Pinterest app (for advanced setups). Connect with the credentials of your own Pinterest developer app.

Authorize Connection to Pinterest

  1. In Dataddo, go to Authorizers and click Authorize New Service.
  2. Select Pinterest, or Pinterest Custom to use your own app.
  3. Sign in with your Pinterest account and approve the access.

Data Coverage

The connector offers the datasets below. The example fields are a representative sample. Each dataset has more fields, and you choose which ones to extract when you create the source.

Dataset Description Example fields Date range
Account Daily Metrics Organic performance metrics for the authenticated Pinterest account, segmented by calendar day. Date, Engagements, Engagement Rate, Impressions, Outbound Clicks, Outbound Click Rate (+4 more) Yes
Top Pins Rolling Metrics Organic engagement summary for the highest-ranked Pins in the selected period, sorted by a chosen metric. Pin ID, Engagements, Engagement Rate, Impressions, Outbound Clicks, Outbound Click Rate (+4 more) Yes
Top Video Pins Rolling Metrics Organic video engagement summary for the highest-ranked video Pins in the selected period, sorted by a chosen video metric. Pin ID, Impressions, Outbound Clicks, Video 95% Quartile Views, Saves, Video 10s Views (+4 more) Yes
Pin Daily Metrics Daily organic performance metrics for a single Pin identified by its ID. Pin ID, Date, Engagements, Engagement Rate, Impressions, Outbound Clicks (+5 more) Yes
Pins Rolling and Lifetime Metrics All Pins owned by the account, combining Pin metadata with 90-day rolling window and lifetime performance summaries. Pin ID, Board ID, Board Section ID, Outbound Clicks (90d), Outbound Clicks (Lifetime), Comments (Lifetime) (+12 more) No
Top Pins Analytics Pin-level performance data for the account's top-ranked Pins over a selected date range, enriched with Pin metadata. Pin ID, Board ID, Board Owner Username, Board Section ID, Created At, Creative Type (+11 more) Yes
Daily Follower Snapshot Follower and content counts for the authenticated Pinterest account, with one row recorded per extraction run. User Account ID, Account Type, Board Count, Business Name, Followers, Following (+4 more) No

Some datasets need an extra pick during setup:

  • Pin Daily Metrics asks for the ID of the Pin you want to track.
  • Top Pins Rolling Metrics and Top Video Pins Rolling Metrics ask for the sort metric (such as Engagement, Impressions, or Saves) and the number of top Pins. Default: 25.
  • Top Pins Analytics first finds your top Pins for the selected period. It then reads each Pin's details and combines them with the period's metrics: impressions, engagement, Pin clicks, saves, and outbound clicks.

How Data Extraction Works

Most datasets use a relative date range, for example "last 7 days". The range sets the start and end date of the Pinterest analytics query. Every run re-reads that window against the current date, so the window slides forward over time. Each run replaces the window's data, it does not accumulate older history. To load data from before the window, run a full data re-sync with a wider range. See Data Backfilling.

Two datasets work differently:

  • Pins Rolling and Lifetime Metrics has no date range. Every run pulls all your Pins with their current 90-day and lifetime metrics. Use the upsert write mode to keep your destination current.
  • Daily Follower Snapshot records one row per run with the current follower and content counts. Schedule the source daily and use the append write mode to build a follower time series over time.

Metadata Columns

The datasets with a date range can add optional Dataddo metadata columns:

  • dataddo_extraction_timestamp is the time the record was extracted. Use it to track slowly changing dimensions.
  • dataddo_date_start and dataddo_date_stop mark the start and end of the time period the run covered.

How to Create a Pinterest Organic Data Source

  1. In Dataddo, go to Sources and click Create Source.
  2. Search for Pinterest Organic and select it.
  3. Pick the dataset you want to extract.
  4. Choose your Pinterest authorizer.
  5. Name the data source and select the fields to extract. Fill in the Pin ID or the top Pins settings where asked.
  6. Set the date range where the dataset offers one.
  7. Click Test Data to preview the data.
  8. Click Save.

Troubleshooting

No Data Preview

If Test Data shows no preview:

  • Try a smaller or different date range. The selected period may have no activity.
  • For Pin Daily Metrics, check that the Pin ID is correct and the Pin belongs to your account.
  • For the top Pins datasets, your account may have no Pins with activity in the period.

Note that the preview reads only a small sample. The full extraction after saving covers everything.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources