Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | clicks_posts__year | dim | |
| Year of week (Sun-Sat) | clicks_posts__year_of_week | dim | ||
| Year of week (Mon-Sun) | clicks_posts__year_of_week_iso | dim | ||
| Year & month | clicks_posts__year_month | dim | ||
| Month | clicks_posts__month | dim | ||
| Year & week (Sun-Sat) | clicks_posts__year_week | dim | ||
| Year & week (Mon-Sun) | clicks_posts__year_week_iso | dim | ||
| Week (Sun-Sat) | clicks_posts__week | dim | ||
| Week (Mon-Sun) | clicks_posts__week_iso | dim | ||
| Day of month | clicks_posts__day_of_month | dim | ||
| Day of week (Sun-Sat) | clicks_posts__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | clicks_posts__day_of_week_name_iso | dim | ||
| Date | clicks_posts__date | dim | ||
| Datetime | clicks_posts__atom | dim | ||
| Click | Click ID | clicks_id | dim | |
| Click created at | clicks_created_at | dim | Date and time when the click was performed. | |
| Click created at date | clicks_created_date | dim | Date when the click was performed. | |
| Sharer ID | clicks_sharer_id | dim | ID of the sharer. | |
| Post ID | clicks_post_id | dim | ID of the post. | |
| Social network | clicks_social_network | dim | Social network where the click was performed. | |
| Post | Post ID | clicks_posts__id | dim | |
| Post published at | clicks_posts__published_at | dim | Date and time when the post was published. | |
| Post published at date | clicks_posts__published_date | dim | Date when the post was published. | |
| Post title | clicks_posts__title | dim | Title of the post. | |
| Post url | clicks_posts__url | dim | URL of the post. | |
| Post type | clicks_posts__type | dim | Type shows whether the post is e.g. link, article, image or video post. | |
| Campaign | Campaign ID | clicks_posts__campaigns__id | dim | |
| Campaign name | clicks_posts__campaigns__name | dim | Name of the campaign | |
| User | User ID | clicks_users__id | dim | |
| User first name | clicks_users__first_name | dim | First name of the user. | |
| User last name | clicks_users__last_name | dim | Last name of the user. | |
| User phone number | clicks_users__phone_number | dim | Phone number of the user. | |
| User group ID | clicks_users__group_id | dim | ID of the group to which the user belongs to. | |
| Group | Group ID | clicks_users__groups__id | dim | |
| Group name | clicks_users__groups__name | dim | Name of the group, e.g. based on geography or departments. | |
| Click count | clicks_count | met | Number of times the shared post was clicked. Note that Smarp only counts unique clicks. | |
| Time | Year | posts_year | dim | |
| Year of week (Sun-Sat) | posts_year_of_week | dim | ||
| Year of week (Mon-Sun) | posts_year_of_week_iso | dim | ||
| Year & month | posts_year_month | dim | ||
| Month | posts_month | dim | ||
| Year & week (Sun-Sat) | posts_year_week | dim | ||
| Year & week (Mon-Sun) | posts_year_week_iso | dim | ||
| Week (Sun-Sat) | posts_week | dim | ||
| Week (Mon-Sun) | posts_week_iso | dim | ||
| Day of month | posts_day_of_month | dim | ||
| Day of week (Sun-Sat) | posts_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | posts_day_of_week_name_iso | dim | ||
| Date | posts_date | dim | ||
| Datetime | posts_atom | dim | ||
| Post | Post ID | posts_id | dim | |
| Post published at | posts_published_at | dim | Date and time when the post was published. | |
| Post published at date | posts_published_date | dim | Date when the post was published. | |
| Post title | posts_title | dim | Title of the post. | |
| Post url | posts_url | dim | URL of the post. | |
| Post type | posts_type | dim | Type shows whether the post is e.g. link, article, image or video post. | |
| Campaign | Campaign ID | posts_campaigns__id | dim | |
| Campaign name | posts_campaigns__name | dim | Name of the campaign | |
| Post count | posts_count | met | Number of posts. Note that posts that were published in private channels are not counted. | |
| Time | Year | shares_posts__year | dim | |
| Year of week (Sun-Sat) | shares_posts__year_of_week | dim | ||
| Year of week (Mon-Sun) | shares_posts__year_of_week_iso | dim | ||
| Year & month | shares_posts__year_month | dim | ||
| Month | shares_posts__month | dim | ||
| Year & week (Sun-Sat) | shares_posts__year_week | dim | ||
| Year & week (Mon-Sun) | shares_posts__year_week_iso | dim | ||
| Week (Sun-Sat) | shares_posts__week | dim | ||
| Week (Mon-Sun) | shares_posts__week_iso | dim | ||
| Day of month | shares_posts__day_of_month | dim | ||
| Day of week (Sun-Sat) | shares_posts__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | shares_posts__day_of_week_name_iso | dim | ||
| Date | shares_posts__date | dim | ||
| Datetime | shares_posts__atom | dim | ||
| Share | Share ID | shares_id | dim | |
| Shared at | shares_shared_at | dim | Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z. | |
| Shared at date | shares_shared_date | dim | Date when post was shared, e.g. 2019-08-24 | |
| Sharer ID | shares_sharer_id | dim | ID of the user who shared the post. | |
| Post ID | shares_post_id | dim | ID of the post. | |
| Share social network | shares_social_network | dim | Name of the social network where the post was shared, e.g. LinkedIn or Facebook. | |
| Post | Post ID | shares_posts__id | dim | |
| Post published at | shares_posts__published_at | dim | Date and time when the post was published. | |
| Post published at date | shares_posts__published_date | dim | Date when the post was published. | |
| Post title | shares_posts__title | dim | Title of the post. | |
| Post url | shares_posts__url | dim | URL of the post. | |
| Post type | shares_posts__type | dim | Type shows whether the post is e.g. link, article, image or video post. | |
| Campaign | Campaign ID | shares_posts__campaigns__id | dim | |
| Campaign name | shares_posts__campaigns__name | dim | Name of the campaign | |
| User | User ID | shares_users__id | dim | |
| User first name | shares_users__first_name | dim | First name of the user. | |
| User last name | shares_users__last_name | dim | Last name of the user. | |
| User phone number | shares_users__phone_number | dim | Phone number of the user. | |
| User group ID | shares_users__group_id | dim | ID of the group to which the user belongs to. | |
| Group | Group ID | shares_users__groups__id | dim | |
| Group name | shares_users__groups__name | dim | Name of the group, e.g. based on geography or departments. | |
| Share count | shares_count | met | Number of unique times the post has been shared in social media. | |
| Share unique click count | shares_unique_click_count | met | Number of unique clicks on the shared post. No clicks are recorded for image posts. | |
| Share like count | shares_like_count | met | Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared. | |
| Share comment count | shares_comment_count | met | Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared. | |
| Resharer count | shares_resharer_count | met | Number of times the shared post was retweeted or otherwise reshared. | |
| User | User ID | users_id | dim | |
| User first name | users_first_name | dim | First name of the user. | |
| User last name | users_last_name | dim | Last name of the user. | |
| User phone number | users_phone_number | dim | Phone number of the user. | |
| User group ID | users_group_id | dim | ID of the group to which the user belongs to. | |
| Group | Group ID | users_groups__id | dim | |
| Group name | users_groups__name | dim | Name of the group, e.g. based on geography or departments. | |
| User count | users_count | met | Number of Smarp users. | |
| LinkedIn connections | users_linkedin_connections | met | The amount of LinkedIn connections user has. | |
| Twitter connections | users_twitter_connections | met | The amount of Twitter connections user has. | |
| Total connections | users_total_connections | met | The total amount of connections user has. This includes Twitter and LinkedIn. | |
| Group ID | groups_id | dim | ||
| Group name | groups_name | dim | Name of the group, e.g. based on geography or departments. | |
| Team | Team ID | teams_id | dim | |
| Team name | teams_name | dim | Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users. | |
| Team group ID | teams_group_id | dim | ID of the team. | |
| Campaign | Campaign ID | campaigns_id | dim | |
| Campaign name | campaigns_name | dim | Name of the campaign |