Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Type | Description |
---|---|---|---|---|
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 | ||
PAGE/GROUP | Account | profile | dim | |
Account ID | profileID | dim | ||
UPDATE DETAILS | Update owner ID | update_owner_id | dim | ID of the update owner |
Update ID | update_id | dim | ID of the update | |
Update title | update_title | dim | Title of the update | |
Update content text | update_share_comment | dim | Text of the update | |
Update share media category | update_share_media_category | dim | The type of media represented in update | |
Update description | update_description | dim | Update content description. This field is displayed to a small percentage of members on the mobile web version of the site. It is not displayed on the desktop site or native mobile apps | |
Update URL | update_url | dim | URL of the update | |
Update outbound URL | update_eyebrow_url | dim | URL of the content being shared | |
Update submitted image URL | update_image_url | dim | URL of the image | |
Update source share ID | update_source_share_id | dim | Unique ID for the update | |
Update visibility | update_visibility | dim | Visibility of the update | |
UGC DETAILS | Content ID | ugc_id | dim | User generated content (UGC) ID |
Content text | ugc_text | dim | User generated content (UGC) text | |
Content URL | ugc_url | dim | User generated content (UGC) URL | |
VIDEO ANALYTICS | Video created date | ugc_video_created | dim | Date when content was created |
SHARE COMMENTS DETAIL | Share ID | share_id | dim | Id of the share |
Share title | share_title | dim | Title of the share on which the comment was posted | |
Share comment | share_comment | dim | Content of the posted comment | |
Share comment date | share_comment_date | dim | Date on which comment was posted | |
FOLLOWER DETAILS | Follower country | follower_country | dim | Follower country name |
Follower job function | follower_function | dim | Follower job function | |
Follower region | follower_region | dim | Follower region | |
Follower industry | follower_industry | dim | Follower industry | |
Follower company size | follower_company_size | dim | Follower company size | |
Follower seniority | follower_seniority | dim | Follower seniority | |
Follower association | follower_association | dim | Follower association, with values of Employee or Non-employee | |
TOTAL PAGE STATISTICS BREAKDOWNS | Country | page_views_by_country | dim | |
Function | page_views_by_function | dim | ||
Industry | page_views_by_industry | dim | ||
Region | page_views_by_region | dim | ||
Seniority | page_views_by_seniority | dim | ||
Staff count | page_views_by_staff_count | dim | ||
DEPRECATED | Update commentable (deprecated) | update_is_commentable | dim | Please note that this field will be removed on 2020-02-01 |
Update type code (deprecated) | update_type | dim | Please note that this field will be removed on 2020-02-01 | |
Comment date (deprecated) | update_comment_date | dim | Please note that this field will be removed on 2023-02-21 | |
Update likable (deprecated) | update_is_likable | dim | Please note that this field will be removed on 2020-02-01 | |
Update type (deprecated) | updates_all | dim | Please note that this field will be removed on 2020-02-01 | |
Job commentable (deprecated) | update_job_is_commentable | dim | Please note that this field will be removed on 2019-02-27 | |
Job description (deprecated) | update_job_description | dim | Please note that this field will be removed on 2019-02-27 | |
Update thumbnail URL (deprecated) | update_thumbnail_url | dim | Please note that this field will be removed on 2020-02-01 | |
Job position (deprecated) | update_job_position | dim | Please note that this field will be removed on 2019-02-27 | |
Job location (deprecated) | update_job_location | dim | Please note that this field will be removed on 2019-02-27 | |
Job URL (deprecated) | update_job_url | dim | Please note that this field will be removed on 2019-02-27 | |
Job ID (deprecated) | update_job_id | dim | Please note that this field will be removed on 2019-02-27 | |
Job type code (deprecated) | update_job_type | dim | Please note that this field will be removed on 2019-02-27 | |
Update key | update_key | dim | The combination of Owner ID and Update activity ID in the format UPDATE-c3335913-6589480136654057472. Please note that this field will be removed on 2023-02-21 | |
Job action (deprecated) | update_job_action | dim | Please note that this field will be removed on 2019-02-27 | |
Update source name | update_source_name | dim | Please note that this field will be removed on 2020-01-10 | |
Comment content (deprecated) | update_comment_content | dim | Please note that this field will be removed on 2023-02-21 | |
Update activity ID | activity_id | dim | ID of the update activity. Activity act as a wrapper around updates and articles to represent content in the LinkedIn feed. Please note that this field will be removed on 2023-02-21 | |
Comment timestamp (deprecated) | update_comment_timestamp | dim | Please note that this field will be removed on 2023-02-21 | |
Job key (deprecated) | update_job_key | dim | Please note that this field will be removed on 2019-02-27 | |
Job likable (deprecated) | update_job_is_likable | dim | Please note that this field will be removed on 2019-02-27 | |
UPDATE/UGC STATISTICS | Content first level comments | ugc_first_level_comments | met | Number of first level comments on user generated content (UGC) posts |
Content comments | ugc_comments | met | Number of all comments on user generated content (UGC) posts | |
Content likes | ugc_likes | met | Number of likes on user generated content (UGC) posts | |
Updates | update_count | met | Number of updates | |
Update first level comments | update_first_comment_count | met | Number of first level comments on updates | |
VIDEO ANALYTICS | Video views | ugc_video_views | met | Video views with play-pause cycles for at least 3 seconds |
Video time watched for views | ugc_video_time_watched_for_views | met | The time watched in milliseconds for video play-pause cycles that are at least 3 seconds | |
PAGE STATISTICS | Careers page banner promo clicks | careers_page_banner_promo_clicks | met | |
Desktop careers page banner promo clicks | desktop_careers_page_banner_promo_clicks | met | ||
Mobile careers page banner promo clicks | mobile_careers_page_banner_promo_clicks | met | ||
Careers page promo links clicks | careers_page_promo_links_clicks | met | ||
Desktop careers page promo links clicks | desktop_careers_page_promo_links_clicks | met | ||
Mobile careers page promo links clicks | mobile_careers_page_promo_links_clicks | met | ||
Careers page employees clicks | careers_page_employees_clicks | met | ||
Desktop careers page employees clicks | desktop_careers_page_employees_clicks | met | ||
Mobile careers page employees clicks | mobile_careers_page_employees_clicks | met | ||
Careers page jobs clicks | careers_page_jobs_clicks | met | ||
Desktop careers page jobs clicks | desktop_careers_page_jobs_clicks | met | ||
Mobile careers page jobs clicks | mobile_careers_page_jobs_clicks | met | ||
Page views | page_views | met | ||
Desktop page views | desktop_page_views | met | ||
Mobile page views | mobile_page_views | met | ||
Careers page views | careers_page_views | met | ||
Desktop careers page views | desktop_careers_page_views | met | ||
Mobile careers page views | mobile_careers_page_views | met | ||
Jobs page views | jobs_page_views | met | ||
Desktop jobs page views | desktop_jobs_page_views | met | ||
Mobile jobs page views | mobile_jobs_page_views | met | ||
Life at page views | life_at_page_views | met | ||
Desktop life at page views | desktop_life_at_page_views | met | ||
Mobile life at page views | mobile_life_at_page_views | met | ||
Overview page views | overview_page_views | met | ||
Desktop overview page views | desktop_overview_page_views | met | ||
Mobile overview page views | mobile_overview_page_views | met | ||
UNIQUE PAGE STATISTICS | Unique page views | unique_page_views | met | |
Unique desktop page views | unique_desktop_page_views | met | ||
Unique mobile page views | unique_mobile_page_views | met | ||
Unique careers page views | unique_careers_page_views | met | ||
Unique desktop careers page views | unique_desktop_careers_page_views | met | ||
Unique mobile careers page views | unique_mobile_careers_page_views | met | ||
Unique jobs page views | unique_jobs_page_views | met | ||
Unique desktop jobs page views | unique_desktop_jobs_page_views | met | ||
Unique mobile jobs page views | unique_mobile_jobs_page_views | met | ||
Unique life at page views | unique_life_at_page_views | met | ||
Unique desktop life at page views | unique_desktop_life_at_page_views | met | ||
Unique mobile life at page views | unique_mobile_life_at_page_views | met | ||
Unique overview page views | unique_overview_page_views | met | ||
Unique desktop overview page views | unique_desktop_overview_page_views | met | ||
Unique mobile overview page views | unique_mobile_overview_page_views | met | ||
TOTAL PAGE STATISTICS | Total page views | total_page_views | met | |
Total desktop page views | total_desktop_page_views | met | ||
Total mobile page views | total_mobile_page_views | met | ||
Total careers page views | total_careers_page_views | met | ||
Total desktop careers page views | total_desktop_careers_page_views | met | ||
Total mobile careers page views | total_mobile_careers_page_views | met | ||
Total jobs page views | total_jobs_page_views | met | ||
Total desktop jobs page views | total_desktop_jobs_page_views | met | ||
Total mobile jobs page views | total_mobile_jobs_page_views | met | ||
Total life at page views | total_life_at_page_views | met | ||
Total desktop life at page views | total_desktop_life_at_page_views | met | ||
Total mobile life at page views | total_mobile_life_at_page_views | met | ||
Total overview page views | total_overview_page_views | met | ||
Total desktop overview page views | total_desktop_overview_page_views | met | ||
Total mobile overview page views | total_mobile_overview_page_views | met | ||
SHARE STATISTICS | Impressions | page_impressions | met | |
Clicks | page_clicks | met | ||
Likes | page_likes | met | ||
Comments | page_comments | met | ||
Shares | page_shares | met | ||
Engagements | page_engagements | met | ||
Engagement rate (%) | page_engagement_rate | met | ||
SHARE TOTALS | Total impressions | total_share_impressions | met | |
Total unique impressions | total_share_impressions_unique | met | ||
Total clicks | total_share_clicks | met | ||
Total likes | total_share_likes | met | ||
Total comments | total_share_comments | met | ||
Total shares | total_shares | met | ||
Total engagements | total_share_engagements | met | ||
Total engagement rate (%) | total_share_engagement_rate | met | ||
FOLLOWER STATISTICS | New followers | followers_gain_total | met | |
New organic followers | followers_gain_organic | met | ||
New sponsored followers | followers_gain_paid | met | ||
FOLLOWER DETAILS | Followers | follower_count | met | |
Organic followers | follower_count_organic | met | ||
DEPRECATED | Jobs (deprecated) | update_job_count | met | Please note that this field will be removed on 2019-02-27 |
Update comments | update_comment_count | met | Please note that this field will be removed on 2020-02-01 | |
Follower trend (deprecated) | followers_total | met | Please note that this field will be removed on 2019-02-27 | |
Update likes | update_like_count | met | Please note that this field will be removed on 2020-02-01 | |
Non-employee followers | follower_non_employee_count | met | Please note that this field will be removed on 2012-10-27 | |
Employee followers | follower_employee_count | met | Please note that this field will be removed on 2021-10-27 | |
Sponsored followers | follower_count_paid | met | Please note that this field will be removed on 2021-10-27 | |
Sponsored followers (deprecated) | followers_paid | met | Please note that this field will be removed on 2019-02-27 | |
Organic followers (deprecated) | followers_organic | met | Please note that this field will be removed on 2019-02-27 |