Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Pinterest Organic data to
Pinterest Organic Connector Reference
24 metrics57 dimensions
The Pinterest Organic connector retrieves Pinterest organic data on an account, board and pin level.
https://connectors.windsor.ai/pinterest_organic?api_key=[your API key]&date_preset=last_7d&fields=date,pin_id,pin_impression,pin_click,pin_outbound_click
The Pinterest Organic connector exposes 81 fields (24 metrics, 57 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
pin__pin_filter Pins - Pin Filter
Pin filter to use when requesting pin data. Default - None
Possible values (4)
defaultexclude_nativeexclude_repinshas_been_promoted
pin__include_protected_pins Pins - Include Protected Pins
Specify if return pins from protected boards. Default - false
pin__creative_types Pins - Creative Types
Pin creative types filter. By default returns all pin types
Possible values (8)
ALLdefaultREGULARVIDEOSHOPPINGCAROUSELMAX_VIDEOCOLLECTIONIDEA
board__privacy Boards - Privacy Types
Privacy setting for a board to return. By default returns all boards.
Possible values (5)
ALLdefaultPROTECTEDPUBLICSECRETPUBLIC_AND_SECRET
account__from_claimed_content Account Analytics - From Claimed Content
Filter on Pins that match your claimed domain. Default: BOTH
Possible values (3)
BOTHdefaultOTHERCLAIMED
account__pin_format Account Analytics - Pin Format
Pin format to get data for. Default: ALL
Possible values (11)
ALLdefaultORGANIC_IMAGEORGANIC_PRODUCTORGANIC_VIDEOADS_STANDARDADS_PRODUCTADS_VIDEOADS_IDEAPRODUCTREGULARVIDEO
account__app_types Account Analytics - App Types
Apps or devices to get data for. Default: ALL
Possible values (4)
ALLdefaultMOBILETABLETWEB
account__content_type Account Analytics - Content Type
Filter to paid or organic data. Default: ALL
Possible values (3)
ALLdefaultPAIDORGANIC
account__source Account Analytics - Source
Filter to activity from Pins created and saved by your, or activity created and saved by others from your claimed accounts. Default: ALL
Possible values (3)
ALLdefaultYOUR_PINSOTHER_PINS
pin_analytics__app_types Pin Analytics - App Types
Apps or devices to get data for. Default: ALL
Possible values (4)
ALLdefaultMOBILETABLETWEB
Pinterest Organic Fields
Pinterest Organic Account fields
The Account report of the Pinterest Organic connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_about | TEXT | Account about | User profile about description. |
| account_account_type | TEXT | Account type | Type of account. Enum: 'PINNER', 'BUSINESS'. |
| account_board_count | NUMERIC | Account board count | User account board count. Note: Board count on user account level may differ from counts found elsewhere due to attribution of collaborative Boards. |
| account_business_name | TEXT | Account business name | Account business name |
| account_follower_count | NUMERIC | Account follower count | User account follower count. |
| account_following_count | NUMERIC | Account following count | User account following count. |
| account_id | TEXT | Account id | Account id |
| account_monthly_views | NUMERIC | Account monthly views | User account monthly views |
| account_name | TEXT | Account name | Account name |
| account_pin_count | NUMERIC | Account pin count | User account pin count. This includes both created and saved pins. |
| account_profile_image | IMAGE_URL | Account profile image URL | Account profile image URL |
| account_website_url | TEXT | Account website url | Account website url |
Pinterest Organic Board fields
The Board report of the Pinterest Organic connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| board_board_pins_modified_at | Board pins modified at | Board pins modified at | |
| board_collaborator_count | NUMERIC | Board collaborator count | Board collaborator count |
| board_created_at | Board created date | Board created date | |
| board_description | TEXT | Board description | Board description |
| board_follower_count | NUMERIC | Board follower count | Board follower count |
| board_id | TEXT | Board ID | Board ID |
| board_image_cover_url | IMAGE_URL | Board image cover url | Board image cover url |
| board_media_image_cover_url | IMAGE_URL | Board media image cover url | Board media image cover url |
| board_name | TEXT | Board name | Board name |
| board_owner | TEXT | Board owner | Board owner username |
| board_owner_username | TEXT | Board owner username | Board owner username |
| board_pin_count | NUMERIC | Board pin count | Board pin count |
| board_privacy | TEXT | Board privacy | Board privacy |
Pinterest Organic Pin fields
The Pin report of the Pinterest Organic connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| pin_alt_text | TEXT | Pin alt_text | Pin alt_text |
| pin_board_section_id | IMAGE_URL | Pin board section ID | Pin board section ID |
| pin_created_at | Pin created date | Pin created date | |
| pin_creative_type | Pin creative type | Pin creative type. Enum: 'REGULAR' 'VIDEO' 'SHOPPING' 'CAROUSEL' 'MAX_VIDEO' 'COLLECTION' 'IDEA' 'SHOWCASE' 'QUIZ' | |
| pin_description | TEXT | Pin description | Pin description |
| pin_dominant_color | TEXT | Pin dominant color | Dominant pin color. Hex number, e.g. '#6E7874'. |
| pin_has_been_promoted | BOOLEAN | Pin has been promoted | Whether the Pin has been promoted or not. |
| pin_id | TEXT | Pin id | Pin id |
| pin_image_url | IMAGE_URL | Pin image url | Pin image url |
| pin_is_owner | BOOLEAN | Pin is owner | Whether the 'operation user_account' is the Pin owner. |
| pin_is_standard | BOOLEAN | Pin is standard | Whether the Pin is standard or not. See documentation on https://developers.pinterest.com/docs/content/update/ for more information. |
| pin_link | TEXT | Pin link | Pin link |
| pin_media_cover_image_url | IMAGE_URL | Pin media cover image url | Pin media cover image url |
| pin_media_duration | NUMERIC | Pin media duration (video) | Pin media duration (in milliseconds) |
| pin_media_height | NUMERIC | Pin media height (video) | Pin media height (in pixels) |
| pin_media_images_1200x_url | IMAGE_URL | Pin image 1200px url | Pin image 1200px url |
| pin_media_images_150x150_url | IMAGE_URL | Pin image 150px url | Pin image 150px url |
| pin_media_images_400x300_url | IMAGE_URL | Pin image 400px url | Pin image 400px url |
| pin_media_media_type | TEXT | Pin media type | Pin media type |
| pin_media_video_url | TEXT | Pin media video url | Video url (720p). Note: This field is limited and not available to all apps. |
| pin_media_width | NUMERIC | Pin media width (video) | Pin media width (in pixels) |
| pin_note | TEXT | Pin private note | Private note for this Pin. |
| pin_permalink | TEXT | Pin permalink | Pin permalink |
| pin_title | TEXT | Pin title | Pin title |
Pinterest Organic pin_analytics fields
The pin_analytics report of the Pinterest Organic connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| date | DATE | Date | Pin analytics date |
| pin_click | NUMERIC | Pin pin_click | Pin analytics pin_click |
| pin_impression | NUMERIC | Pin impression | Pin analytics impression |
| pin_outbound_click | NUMERIC | Pin outbound_click | Pin analytics outbound_click |
| pin_quartile_95_percent_view | NUMERIC | Pin quartile_95_percent_view | Pin analytics quartile_95_percent_view |
| pin_save | NUMERIC | Pin save | Pin analytics save |
| pin_save_rate | PERCENT | Pin save rate | Pin analytics save rate |
| pin_total_comments | NUMERIC | Pin total comments | Pin analytics total comments |
| pin_total_reactions | NUMERIC | Pin total reactions | Pin analytics total reactions |
| pin_video_10s_view | NUMERIC | Pin video_10s_view | Pin analytics video_10s_view |
| pin_video_avg_watch_time | NUMERIC | Pin video_avg_watch_time | Pin analytics video_avg_watch_time |
| pin_video_mrc_view | NUMERIC | Pin video_mrc_view | Pin analytics video_mrc_view |
| pin_video_start | NUMERIC | Pin video_start | Pin analytics video_start |
| pin_video_v50_watch_time | NUMERIC | Pin video_v50_watch_time | Pin analytics video_v50_watch_time |
Pinterest Organic other fields
The Pinterest Organic connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |