Windsor brings all your Pinterest Organic data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Pinterest Organic Field Reference
Sample
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
Available Options
| ID | Type | Name | Description | Options |
|---|---|---|---|---|
| pin__pin_filter | SELECT_SINGLE | Pins - Pin Filter | Pin filter to use when requesting pin data. Default - None | ; exclude_native; exclude_repins; has_been_promoted; |
| pin__include_protected_pins | CHECKBOX | Pins - Include Protected Pins | Specify if return pins from protected boards. Default - false | |
| pin__creative_types | SELECT_MULTI | Pins - Creative Types | Pin creative types filter. By default returns all pin types | ALL; REGULAR; VIDEO; SHOPPING; CAROUSEL; MAX_VIDEO; COLLECTION; IDEA; |
| board__privacy | SELECT_SINGLE | Boards - Privacy Types | Privacy setting for a board to return. By default returns all boards. | ALL; PROTECTED; PUBLIC; SECRET; PUBLIC_AND_SECRET; |
| account__from_claimed_content | SELECT_SINGLE | Account Analytics - From Claimed Content | Filter on Pins that match your claimed domain. Default: BOTH | BOTH; OTHER; CLAIMED; |
| account__pin_format | SELECT_SINGLE | Account Analytics - Pin Format | Pin format to get data for. Default: ALL | ALL; ORGANIC_IMAGE; ORGANIC_PRODUCT; ORGANIC_VIDEO; ADS_STANDARD; ADS_PRODUCT; ADS_VIDEO; ADS_IDEA; PRODUCT; REGULAR; VIDEO; |
| account__app_types | SELECT_SINGLE | Account Analytics - App Types | Apps or devices to get data for. Default: ALL | ALL; MOBILE; TABLET; WEB; |
| account__content_type | SELECT_SINGLE | Account Analytics - Content Type | Filter to paid or organic data. Default: ALL | ALL; PAID; ORGANIC; |
| account__source | SELECT_SINGLE | 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 | ALL; YOUR_PINS; OTHER_PINS; |
| pin_analytics__app_types | SELECT_SINGLE | Pin Analytics - App Types | Apps or devices to get data for. Default: ALL | ALL; MOBILE; TABLET; WEB; |
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_about | TEXT | Account about | User profile about description. | Account |
| account_account_type | TEXT | Account type | Type of account. Enum: 'PINNER', 'BUSINESS'. | Account |
| 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 |
| account_business_name | TEXT | Account business name | Account business name | Account |
| account_follower_count | NUMERIC | Account follower count | User account follower count. | Account |
| account_following_count | NUMERIC | Account following count | User account following count. | Account |
| account_id | TEXT | Account id | Account id | Account |
| account_monthly_views | NUMERIC | Account monthly views | User account monthly views | Account |
| account_name | TEXT | Account name | Account name | Account |
| account_pin_count | NUMERIC | Account pin count | User account pin count. This includes both created and saved pins. | Account |
| account_profile_image | IMAGE_URL | Account profile image URL | Account profile image URL | Account |
| account_website_url | TEXT | Account website url | Account website url | Account |
| board_board_pins_modified_at | TIMESTAMP | Board pins modified at | Board pins modified at | Board |
| board_collaborator_count | NUMERIC | Board collaborator count | Board collaborator count | Board |
| board_created_at | TIMESTAMP | Board created date | Board created date | Board |
| board_description | TEXT | Board description | Board description | Board |
| board_follower_count | NUMERIC | Board follower count | Board follower count | Board |
| board_id | TEXT | Board ID | Board ID | Board |
| board_image_cover_url | IMAGE_URL | Board image cover url | Board image cover url | Board |
| board_media_image_cover_url | IMAGE_URL | Board media image cover url | Board media image cover url | Board |
| board_name | TEXT | Board name | Board name | Board |
| board_owner | TEXT | Board owner | Board owner username | Board |
| board_owner_username | TEXT | Board owner username | Board owner username | Board |
| board_pin_count | NUMERIC | Board pin count | Board pin count | Board |
| board_privacy | TEXT | Board privacy | Board privacy | Board |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Pin analytics date | pin_analytics |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| pin_alt_text | TEXT | Pin alt_text | Pin alt_text | Pin |
| pin_board_section_id | IMAGE_URL | Pin board section ID | Pin board section ID | Pin |
| pin_click | NUMERIC | Pin pin_click | Pin analytics pin_click | pin_analytics |
| pin_created_at | TIMESTAMP | Pin created date | Pin created date | Pin |
| pin_creative_type | TIMESTAMP | Pin creative type | Pin creative type. Enum: 'REGULAR' 'VIDEO' 'SHOPPING' 'CAROUSEL' 'MAX_VIDEO' 'COLLECTION' 'IDEA' 'SHOWCASE' 'QUIZ' | Pin |
| pin_description | TEXT | Pin description | Pin description | Pin |
| pin_dominant_color | TEXT | Pin dominant color | Dominant pin color. Hex number, e.g. '#6E7874'. | Pin |
| pin_has_been_promoted | BOOLEAN | Pin has been promoted | Whether the Pin has been promoted or not. | Pin |
| pin_id | TEXT | Pin id | Pin id | Pin |
| pin_image_url | IMAGE_URL | Pin image url | Pin image url | Pin |
| pin_impression | NUMERIC | Pin impression | Pin analytics impression | pin_analytics |
| pin_is_owner | BOOLEAN | Pin is owner | Whether the 'operation user_account' is the Pin owner. | Pin |
| 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 |
| pin_link | TEXT | Pin link | Pin link | Pin |
| pin_media_cover_image_url | IMAGE_URL | Pin media cover image url | Pin media cover image url | Pin |
| pin_media_duration | NUMERIC | Pin media duration (video) | Pin media duration (in milliseconds) | Pin |
| pin_media_height | NUMERIC | Pin media height (video) | Pin media height (in pixels) | Pin |
| pin_media_images_1200x_url | IMAGE_URL | Pin image 1200px url | Pin image 1200px url | Pin |
| pin_media_images_150x150_url | IMAGE_URL | Pin image 150px url | Pin image 150px url | Pin |
| pin_media_images_400x300_url | IMAGE_URL | Pin image 400px url | Pin image 400px url | Pin |
| pin_media_media_type | TEXT | Pin media type | Pin media type | Pin |
| pin_media_video_url | TEXT | Pin media video url | Video url (720p). Note: This field is limited and not available to all apps. | Pin |
| pin_media_width | NUMERIC | Pin media width (video) | Pin media width (in pixels) | Pin |
| pin_note | TEXT | Pin private note | Private note for this Pin. | Pin |
| pin_outbound_click | NUMERIC | Pin outbound_click | Pin analytics outbound_click | pin_analytics |
| pin_permalink | TEXT | Pin permalink | Pin permalink | Pin |
| pin_quartile_95_percent_view | NUMERIC | Pin quartile_95_percent_view | Pin analytics quartile_95_percent_view | pin_analytics |
| pin_save | NUMERIC | Pin save | Pin analytics save | pin_analytics |
| pin_save_rate | PERCENT | Pin save rate | Pin analytics save rate | pin_analytics |
| pin_title | TEXT | Pin title | Pin title | Pin |
| pin_total_comments | NUMERIC | Pin total comments | Pin analytics total comments | pin_analytics |
| pin_total_reactions | NUMERIC | Pin total reactions | Pin analytics total reactions | pin_analytics |
| pin_video_10s_view | NUMERIC | Pin video_10s_view | Pin analytics video_10s_view | pin_analytics |
| pin_video_avg_watch_time | NUMERIC | Pin video_avg_watch_time | Pin analytics video_avg_watch_time | pin_analytics |
| pin_video_mrc_view | NUMERIC | Pin video_mrc_view | Pin analytics video_mrc_view | pin_analytics |
| pin_video_start | NUMERIC | Pin video_start | Pin analytics video_start | pin_analytics |
| pin_video_v50_watch_time | NUMERIC | Pin video_v50_watch_time | Pin analytics video_v50_watch_time | pin_analytics |
| 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_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 |