Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| ACCOUNT | Profile ID | profile_id | dim | The unique identifier of the profile |
| Username | username | dim | The username of the profile | |
| First name | first_name | dim | The first name of the profile | |
| Last name | last_name | dim | The last name of the profile | |
| Full name | full_name | dim | The full name of the profile | |
| Profile description | description | dim | The description of the profile | |
| Profile location | location | dim | The location of the profile | |
| Gender | gender | dim | The gender of the profile | |
| Profile website URL | website_url | dim | The URL of the website of the profile | |
| Profile image URL | profile_image_url | dim | The URL of the profile image | |
| Profile type | profile_type | dim | The profile type | |
| Profile creation date | profile_created_at | dim | The date the profile was created | |
| Last pin save date | profile_last_pin_save_time | dim | The date of the latest pin save | |
| Link to profile | link_to_profile | dim | URL to the profile | |
| PROFILE LIFETIME | Pins | total_pins | met | The pin count of the account |
| Followers | followers | met | The amount of followers the account has | |
| Following | following | met | The amount of users followed by the account | |
| Reach | profile_reach | met | The amount of reach the account has, matches "monthly unique viewers" in the Pinterest UI | |
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| ACCOUNT | Profile ID | profile_id | dim | The unique identifier of the profile |
| Username | username | dim | The username of the profile | |
| First name | first_name | dim | The first name of the profile | |
| Last name | last_name | dim | The last name of the profile | |
| Full name | full_name | dim | The full name of the profile | |
| Profile description | description | dim | The description of the profile | |
| Profile location | location | dim | The location of the profile | |
| Gender | gender | dim | The gender of the profile | |
| Profile website URL | website_url | dim | The URL of the website of the profile | |
| Profile image URL | profile_image_url | dim | The URL of the profile image | |
| Profile type | profile_type | dim | The profile type | |
| Profile creation date | profile_created_at | dim | The date the profile was created | |
| Last pin save date | profile_last_pin_save_time | dim | The date of the latest pin save | |
| Link to profile | link_to_profile | dim | URL to the profile | |
| COMMON METRICS | Impressions | impressions | met | The total amount of impressions |
| Engagements | engagements | met | The total amount of engagements | |
| Engagement rate | engagement_rate | met | The engagement rate | |
| Outbound clicks | outbound_clicks | met | The number of clicks on links that take people off Pinterest-owned properties | |
| Outbound click rate | outbound_click_rate | met | Total outbound clicks divided by the total number of times your Pins were seen | |
| Saves | saves | met | The total amount of saves | |
| Save rate | save_rate | met | The save rate | |
| Pin clicks | pin_clicks | met | The number of clicks on your Pins | |
| Pin click rate | pin_click_rate | met | Total clicks to your Pins divided by the total number of times your Pins were seen | |
| DEPRECATED | Close-ups | closeups | met | The total amount of close-ups. Please note that this field will be removed on 2021-02-20 |
| CTR | ctr | met | The click-through rate. Please note that this field will be removed on 2021-02-20 | |
| Clicks | clickthroughs | met | The total amount of clicks. Please note that this field will be removed on 2021-02-20 | |
| Close-up rate | closeup_rate | met | Total clicks to a close-up view of your Pins divided by the total number of times your Pins were seen. Please note that this field will be removed on 2021-02-20 | |
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| ACCOUNT | Profile ID | profile_id | dim | The unique identifier of the profile |
| Username | username | dim | The username of the profile | |
| First name | first_name | dim | The first name of the profile | |
| Last name | last_name | dim | The last name of the profile | |
| Full name | full_name | dim | The full name of the profile | |
| Profile description | description | dim | The description of the profile | |
| Profile location | location | dim | The location of the profile | |
| Gender | gender | dim | The gender of the profile | |
| Profile website URL | website_url | dim | The URL of the website of the profile | |
| Profile image URL | profile_image_url | dim | The URL of the profile image | |
| Profile type | profile_type | dim | The profile type | |
| Profile creation date | profile_created_at | dim | The date the profile was created | |
| Last pin save date | profile_last_pin_save_time | dim | The date of the latest pin save | |
| Link to profile | link_to_profile | dim | URL to the profile | |
| PIN | Pin ID | pin_id | dim | The unique identifier of a Pin |
| Pin title | pin_title | dim | The title of the Pin | |
| Pin description | pin_description | dim | The description of the Pin | |
| Link to pin | pin_permalink_url | dim | URL of the pin on Pinterest | |
| Pin image URL | pin_image_large_url | dim | The URL of the image of the Pin | |
| Pin link | pin_link | dim | The link to the Pin | |
| Pin tracked link | pin_tracked_link | dim | The tracked link to the Pin | |
| Pin creative type | pin_creative_type | dim | The creative type of the Pin | |
| Pin type | pin_type | dim | Describes if the pin is organic, paid or both | |
| Pin price currency | pin_price_currency | dim | The currency of the Pin price | |
| Pin is repin | pin_is_repin | dim | Whether or not the Pin is a repin | |
| Pin is uploaded | pin_is_uploaded | dim | Whether or not the Pin has been uploaded | |
| Pin is playable | pin_is_playable | dim | Whether or not the Pin is playable | |
| Pin is video | pin_is_video | dim | Whether or not the Pin is a video | |
| Pin is promotable | pin_is_promotable | dim | Whether or not the Pin is promotable | |
| Pin is downstream promotion | pin_is_downstream_promotion | dim | Whether or not the Pin is a downstream promotion | |
| Pin source | pin_source | dim | Describes if the pin source is Your pin, Other pins or both | |
| Pin not promotable reason | pin_not_promotable_reason | dim | The reason why the Pin is not promotable | |
| Pin created | pin_created_at | dim | The time and date the Pin was created | |
| Pin created date | pin_created_date | dim | The date the Pin was created | |
| Pin format | pin_format | dim | Format of the pin | |
| COMMON METRICS | Impressions | impressions | met | The total amount of impressions |
| Engagements | engagements | met | The total amount of engagements | |
| Engagement rate | engagement_rate | met | The engagement rate | |
| Outbound clicks | outbound_clicks | met | The number of clicks on links that take people off Pinterest-owned properties | |
| Outbound click rate | outbound_click_rate | met | Total outbound clicks divided by the total number of times your Pins were seen | |
| Saves | saves | met | The total amount of saves | |
| Save rate | save_rate | met | The save rate | |
| Pin clicks | pin_clicks | met | The number of clicks on your Pins | |
| Pin click rate | pin_click_rate | met | Total clicks to your Pins divided by the total number of times your Pins were seen | |
| PIN | Comments | comments | met | The amount of comments on the Pin |
| Repins | repins | met | The amount of times the Pin has been repinned | |
| DEPRECATED | Close-ups | closeups | met | The total amount of close-ups. Please note that this field will be removed on 2021-02-20 |
| CTR | ctr | met | The click-through rate. Please note that this field will be removed on 2021-02-20 | |
| Clicks | clickthroughs | met | The total amount of clicks. Please note that this field will be removed on 2021-02-20 | |
| Close-up rate | closeup_rate | met | Total clicks to a close-up view of your Pins divided by the total number of times your Pins were seen. Please note that this field will be removed on 2021-02-20 | |
| ACCOUNT | Profile ID | profile_id | dim | The unique identifier of the profile |
| Username | username | dim | The username of the profile | |
| First name | first_name | dim | The first name of the profile | |
| Last name | last_name | dim | The last name of the profile | |
| Full name | full_name | dim | The full name of the profile | |
| Profile description | description | dim | The description of the profile | |
| Profile location | location | dim | The location of the profile | |
| Gender | gender | dim | The gender of the profile | |
| Profile website URL | website_url | dim | The URL of the website of the profile | |
| Profile image URL | profile_image_url | dim | The URL of the profile image | |
| Profile type | profile_type | dim | The profile type | |
| Profile creation date | profile_created_at | dim | The date the profile was created | |
| Last pin save date | profile_last_pin_save_time | dim | The date of the latest pin save | |
| Link to profile | link_to_profile | dim | URL to the profile | |
| PIN | Pin ID | pin_id | dim | The unique identifier of a Pin |
| Pin title | pin_title | dim | The title of the Pin | |
| Pin description | pin_description | dim | The description of the Pin | |
| Pin image URL | pin_image_large_url | dim | The URL of the image of the Pin | |
| Pin tracked link | pin_tracked_link | dim | The tracked link to the Pin | |
| Pin created | pin_created_at | dim | The time and date the Pin was created | |
| Pin created date | pin_created_date | dim | The date the Pin was created | |
| Hashtags | pin_hashtags | dim | Hashtags used in the Pin description | |
| Pin CTA text | pin_cta_text | dim | CTA text of the Pin | |
| Has been promoted | pin_has_been_promoted | dim | Has the Pin been promoted | |
| Pin category | pin_category | dim | Category of the Pin | |
| Comments | comments | met | The amount of comments on the Pin | |
| Repins | repins | met | The amount of times the Pin has been repinned | |
| Likes | likes | met | The amount of likes the Pin has | |
| ACCOUNT | Profile ID | profile_id | dim | The unique identifier of the profile |
| Username | username | dim | The username of the profile | |
| First name | first_name | dim | The first name of the profile | |
| Last name | last_name | dim | The last name of the profile | |
| Full name | full_name | dim | The full name of the profile | |
| Profile description | description | dim | The description of the profile | |
| Profile location | location | dim | The location of the profile | |
| Gender | gender | dim | The gender of the profile | |
| Profile website URL | website_url | dim | The URL of the website of the profile | |
| Profile image URL | profile_image_url | dim | The URL of the profile image | |
| Profile type | profile_type | dim | The profile type | |
| Profile creation date | profile_created_at | dim | The date the profile was created | |
| Last pin save date | profile_last_pin_save_time | dim | The date of the latest pin save | |
| Link to profile | link_to_profile | dim | URL to the profile | |
| PROFILE BOARDS | Board ID | board_id | dim | ID of the board |
| Created at | board_created_at | dim | The date the board was created | |
| Category | board_category | dim | Category of the board | |
| Name | board_name | dim | Name of the board | |
| Description | board_description | dim | Description of the board | |
| Cover image URL | board_image_cover_url | dim | Cover image URL of the board | |
| Thumbnail image URL | board_thumbnail_image_url | dim | Thumbnail image URL of the board | |
| Privacy | board_privacy | dim | Privacy of the board | |
| Follower count | board_followers | met | Follower count of the board | |
| Pin count | board_pins | met | Pin count of the board | |
| Collaborator count | board_collaborators | met | Collaborator count of the board |