Social
Pinterest Organic schema
SightShark syncs Pinterest Organic into a data warehouse you own. It creates 5 tables holding 55 fields, refreshed daily. Profile and pin data for a business account, with daily analytics per pin and for the account as a whole.
5 tables / 55 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
pin_analytics
14 fields
- id
- ad_account_id
- pin_id
- date
- data_status
- impression
- outbound_click
- pin_click
- quartile_95_percent_view
- save
- video_10s_view
- video_avg_watch_time
- total_comments
- total_reactions
pin
14 fields
- pin_id
- ad_account_id
- created_at
- link
- title
- description
- alt_text
- creative_type
- board_id
- media_type
- images
- parent_pin_id
- has_been_promoted
- bookmark
user_account_analytics
8 fields
- date
- ad_account_id
- data_status
- engagement
- save
- pin_click
- outbound_click
- impression
ad_accounts
6 fields
- id
- name
- country
- permissions
- created_time
- updated_time
user_account
13 fields
- id
- ad_account_id
- account_type
- profile_image
- website_url
- username
- about
- business_name
- board_count
- pin_count
- follower_count
- following_count
- monthly_views
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Organic numbers live behind a different login from paid, so the two halves of the same channel are usually reported separately and never add up.
Questions people ask
What tables does SightShark create from Pinterest Organic?
5 tables, including pin_analytics, pin, user_account_analytics. pin_analytics is one row per pin, per day. Every one is listed on this page, with its fields.
Which Pinterest Organic fields can I get?
All 55 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does Pinterest Organic data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Pinterest Organic data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Pinterest Organic and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
What happens when a platform changes its API.
A pipeline that stops gets fixed today. A pipeline that keeps returning rows can be wrong for a month.
Read it - 6 min read
How to write metric definitions that hold across clients.
Most arguments about a number are arguments about what the number means. Write it down once.
Read it - 7 min read
How far back a new client's marketing data goes.
Further than you expect in places, and gone for good in others. Worth knowing before the day you need it.
Read it
Get started
Want Pinterest Organic in your own warehouse?
A call with someone who can answer the schema questions.