Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | user_analytics_year | dim | |
| Year of week (Sun-Sat) | user_analytics_year_of_week | dim | ||
| Year of week (Mon-Sun) | user_analytics_year_of_week_iso | dim | ||
| Year & month | user_analytics_year_month | dim | ||
| Month | user_analytics_month | dim | ||
| Year & week (Sun-Sat) | user_analytics_year_week | dim | ||
| Year & week (Mon-Sun) | user_analytics_year_week_iso | dim | ||
| Week (Sun-Sat) | user_analytics_week | dim | ||
| Week (Mon-Sun) | user_analytics_week_iso | dim | ||
| Day of month | user_analytics_day_of_month | dim | ||
| Day of week (Sun-Sat) | user_analytics_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | user_analytics_day_of_week_name_iso | dim | ||
| Date | user_analytics_date | dim | ||
| Datetime | user_analytics_atom | dim | ||
| Ad account | Ad account name | user_analytics_ad_account_name | dim | Ad account name. |
| Ad account ID | user_analytics_ad_account_id | dim | Ad account ID. | |
| Ad account country | user_analytics_ad_account_country | dim | Country of the ad account. | |
| Profile | Username | user_analytics_user__username | dim | Username of the Pinterest account. |
| User account type | user_analytics_user__account_type | dim | User account type. | |
| Business name | user_analytics_user__business_name | dim | The name of the business. | |
| Profile image | user_analytics_user__profile_image_gs | dim | URL to the profile image. | |
| Profile image | user_analytics_user__profile_image | dim | URL to the profile image. | |
| Website URL | user_analytics_user__website_url | dim | URL to the website. | |
| Impressions | user_analytics_impressions | met | The number of times your Pins were on screen. | |
| Engagements | user_analytics_engagements | met | The total number of engagements on your Pins. This includes saves, Pin clicks, outbound clicks, carousel card swipes, secondary creative (collections) clicks and Idea Pin forward/backward swipes. | |
| Engagement rate | user_analytics_engagement_rate | met | The ratio of engagements on a Pin to the number of times it was shown. (engagements/impressions) | |
| Pin clicks | user_analytics_pin_clicks | met | The total number of clicks on your Pin so it opens in closeup. | |
| Pin click rate | user_analytics_pin_click_rate | met | The total number of clicks from your Pin or ad to content on or off Pinterest, divided by the total number of times your Pins or ads were on screen. (pin_clicks/impressions) | |
| Outbound clicks | user_analytics_outbound_clicks | met | The number of times people perform actions that lead them to a destination off Pinterest. | |
| Outbound click rate | user_analytics_outbound_click_rate | met | The total number of clicks to the destination URL associated with your Pin divided by the total number of times your Pins were on screen. (outbound_clicks/impressions) | |
| Saves | user_analytics_saves | met | The number of times people saved your Pin to a board. | |
| Save rate | user_analytics_save_rate | met | The total saves of your Pins divided by the total number of times your Pins were on screen. (saves/impressions) | |
| Followers | user_analytics_user__follower_count | met | The number of followers. | |
| Following | user_analytics_user__following_count | met | The number of accounts following. | |
| Pins | user_analytics_user__pin_count | met | The number of Pins owned. | |
| Boards | user_analytics_user__board_count | met | The number of boards owned. | |
| Pin | Pin ID (all sources) | top_pins_pin_id | dim | The unique identifier of a Pin including Other pins from e.g. claimed content. |
| Pin ID | top_pins_pin__pin_id | dim | Unique identifier of a Pin. Includes only Your (owned) pins. | |
| Pin title | top_pins_pin__title | dim | Title of the Pin. | |
| Pin description | top_pins_pin__description | dim | Description of the Pin. | |
| Pin link | top_pins_pin__link | dim | The URL associated with the Pin. | |
| Pin media type | top_pins_pin__media_type | dim | The type of media associated with the Pin (e.g. image, video). | |
| Pin media image URL | top_pins_pin__url_media_image | dim | The URL of the image associated with the Pin. | |
| Pin media image | top_pins_pin__media_image_url | dim | The media image displayed inside a cell in Google Sheets. | |
| Pin alt text | top_pins_pin__alt_text | dim | Alternative text for the image on the Pin. | |
| Pin created at datetime | top_pins_pin__created_at | dim | Date and time when the Pin was created. | |
| Pin created at date | top_pins_pin__created_at_date | dim | Date when the Pin was created. | |
| Pin dominant color | top_pins_pin__dominant_color | dim | The dominant color of the Pin's image. | |
| Is owner | top_pins_pin__is_owner | dim | Is owner of the Pin. [True, False] | |
| Ad account | Ad account name | top_pins_pin__ad_account_name | dim | Ad account name. |
| Ad account ID | top_pins_pin__ad_account_id | dim | Ad account ID. | |
| Ad account country | top_pins_pin__ad_account_country | dim | Country of the ad account. | |
| Impressions | top_pins_impressions | met | The number of times your Pins were on screen. | |
| Engagements | top_pins_engagements | met | The number of engagements on a Pin, including closeups, saves, and outbound clicks. | |
| Engagement rate | top_pins_engagement_rate | met | The ratio of engagements on a Pin to the number of times it was shown. (engagements/impressions) | |
| Pin clicks | top_pins_pin_clicks | met | The total number of clicks on your Pin so it opens in closeup. | |
| Pin click rate | top_pins_pin_click_rate | met | The total number of clicks from your Pin or ad to content on or off Pinterest, divided by the total number of times your Pins or ads were on screen. (pin_clicks/impressions) | |
| Close ups | top_pins_closeups | met | The number of times a Pin was clicked to view it in a larger size. | |
| Closeup rate | top_pins_closeup_rate | met | The ratio of closeups on a Pin to the number of times it was shown. (closeups/impressions) | |
| Outbound clicks | top_pins_outbound_clicks | met | The number of times people perform actions that lead them to a destination off Pinterest. | |
| Outbound click rate | top_pins_outbound_click_rate | met | The total number of clicks to the destination URL associated with your Pin divided by the total number of times your Pins were on screen. (outbound_clicks/impressions) | |
| Saves | top_pins_saves | met | The number of times people saved your Pin to a board. | |
| Save rate | top_pins_save_rate | met | The total saves of your Pins divided by the total number of times your Pins were on screen. (saves/impressions) | |
| Video views | top_pins_video_mrc_view | met | The amount of views for at least 2 seconds with 50% of video in view. | |
| 10-second plays | top_pins_video_10s_view | met | The number of times your video was viewed for at least 10 seconds. | |
| Played to 95% | top_pins_video_quartile_95_percent_view | met | The number of times your video was viewed to 95% of its length. | |
| Average video play time (ms) | top_pins_video_avg_watch_time | met | The average time (ms) someone spent playing the video and static image cards included in your Pin. | |
| Total play time (ms) | top_pins_video_v50_watch_time | met | The total play time for your video in milliseconds. | |
| Video starts | top_pins_video_start | met | The total number of video starts. | |
| Full screen play | top_pins_full_screen_play | met | The number of times a video Pin was played in full screen mode. | |
| Full screen playtime (ms) | top_pins_full_screen_playtime | met | The total amount of time (ms) a video Pin was played in full screen mode. | |
| Ad account name | pin_ad_account_name | dim | Ad account name. | |
| Ad account ID | pin_ad_account_id | dim | Ad account ID. | |
| Ad account country | pin_ad_account_country | dim | Country of the ad account. | |
| Pin | Pin ID | pin_pin_id | dim | Unique identifier of a Pin. Includes only Your (owned) pins. |
| Pin title | pin_title | dim | Title of the Pin. | |
| Pin description | pin_description | dim | Description of the Pin. | |
| Pin link | pin_link | dim | The URL associated with the Pin. | |
| Pin media type | pin_media_type | dim | The type of media associated with the Pin (e.g. image, video). | |
| Pin media image URL | pin_url_media_image | dim | The URL of the image associated with the Pin. | |
| Pin media image | pin_media_image_url | dim | The media image displayed inside a cell in Google Sheets. | |
| Pin alt text | pin_alt_text | dim | Alternative text for the image on the Pin. | |
| Pin created at datetime | pin_created_at | dim | Date and time when the Pin was created. | |
| Pin created at date | pin_created_at_date | dim | Date when the Pin was created. | |
| Pin dominant color | pin_dominant_color | dim | The dominant color of the Pin's image. | |
| Is owner | pin_is_owner | dim | Is owner of the Pin. [True, False] | |
| Time | Year | pin_pin_analytics__year | dim | |
| Year of week (Sun-Sat) | pin_pin_analytics__year_of_week | dim | ||
| Year of week (Mon-Sun) | pin_pin_analytics__year_of_week_iso | dim | ||
| Year & month | pin_pin_analytics__year_month | dim | ||
| Month | pin_pin_analytics__month | dim | ||
| Year & week (Sun-Sat) | pin_pin_analytics__year_week | dim | ||
| Year & week (Mon-Sun) | pin_pin_analytics__year_week_iso | dim | ||
| Week (Sun-Sat) | pin_pin_analytics__week | dim | ||
| Week (Mon-Sun) | pin_pin_analytics__week_iso | dim | ||
| Day of month | pin_pin_analytics__day_of_month | dim | ||
| Day of week (Sun-Sat) | pin_pin_analytics__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | pin_pin_analytics__day_of_week_name_iso | dim | ||
| Date | pin_pin_analytics__date | dim | ||
| Datetime | pin_pin_analytics__atom | dim | ||
| Date | Impressions | pin_pin_analytics__impressions | met | The number of times your Pins were on screen. |
| Pin clicks | pin_pin_analytics__pin_clicks | met | The total number of clicks on your Pin so it opens in closeup. | |
| Pin click rate | pin_pin_analytics__pin_click_rate | met | The total number of clicks from your Pin or ad to content on or off Pinterest, divided by the total number of times your Pins or ads were on screen. (pin_clicks/impressions) | |
| Outbound clicks | pin_pin_analytics__outbound_clicks | met | The number of times people perform actions that lead them to a destination off Pinterest. | |
| Outbound click rate | pin_pin_analytics__outbound_click_rate | met | The total number of clicks to the destination URL associated with your Pin divided by the total number of times your Pins were on screen. (outbound_clicks/impressions) | |
| Saves | pin_pin_analytics__saves | met | The number of times people saved your Pin to a board. | |
| Save rate | pin_pin_analytics__save_rate | met | The total saves of your Pins divided by the total number of times your Pins were on screen. (saves/impressions) | |
| Video views | pin_pin_analytics__video_mrc_view | met | The amount of views for at least 2 seconds with 50% of video in view. | |
| 10-second plays | pin_pin_analytics__video_10s_view | met | The number of times your video was viewed for at least 10 seconds. | |
| Played to 95% | pin_pin_analytics__video_quartile_95_percent_view | met | The number of times your video was viewed to 95% of its length. | |
| Average video play time | pin_pin_analytics__video_avg_watch_time | met | The average time someone spent playing the video and static image cards included in your Pin. | |
| Total play time (minutes) | pin_pin_analytics__video_v50_watch_time | met | The total play time for your video in minutes. | |
| Video starts | pin_pin_analytics__video_start | met | The total number of video starts. |