Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Description |
|---|---|---|---|
| TIME | Year | Year | Year, e.g. 2017 |
| Year & month | Yearmonth | Year and month, e.g. 2017|06 | |
| Year & week (Mon-Sun) | Yearweek | Year and week for ISO weeks, e.g. 2017|08 | |
| Quarter | Quarter | Quarter, e.g. 1 | |
| Month | Month | Month, e.g. 6 | |
| Week (Mon-Sun) | WeekISO | ISO week number, e.g. 51 | |
| Date | Date | Date, e.g. 2017-01-31 | |
| PAGE | Page name | profile | |
| Page ID | profileid | ||
| POST | Post ID | post_ID | |
| Post name | post_name | ||
| Post creator | post_creator | Name of post creator | |
| Link to post | post_linkto | ||
| Post type | post_type | ||
| Post message | post_message | ||
| Post story | post_story | ||
| Post description | post_description | ||
| Post status type | post_status_type | ||
| Post privacy | post_privacy | ||
| Post shared link | post_link | ||
| Post object ID | post_object_id | ||
| Post thumbnail URL | post_picture | ||
| Post image URL | post_full_picture | ||
| Post caption | post_caption | ||
| Post story tags | post_story_tags | The list of tags in the post description | |
| Post video length (s) | post_video_length | ||
| Post creation time of day | post_created_time_of_day | ||
| POST COMMENT | Post comment text | post_comment_text | The comment text |
| Post comment author | post_comment_author | Author of the comment | |
| Post comment date | post_comment_date | Date of the comment | |
| Post comment time | post_comment_time | Time of the comment | |
| VIDEO | Video ID | video_id | |
| Universal video identifier | video_universal_id | ||
| Video title | video_title | ||
| Video description | video_description | ||
| Video content category | video_content_category | ||
| Video live status | video_live_status | ||
| Video post publish status | video_published | ||
| Video image URL | video_picture | ||
| Video source URL | video_source | ||
| Video permalink URL | video_permalink_url | ||
| Video embeddable | video_embeddable | ||
| Video embed HTML | video_embed_html | ||
| Video crossposting eligibility | video_is_crossposting_eligible | ||
| Video Instagram eligibility | video_is_instagram_eligible | ||
| Video length (s) | video_length | ||
| Video creation time of day | video_created_time_of_day | ||
| Video backdated time | video_backdated_time | ||
| Video backdated time granularity | video_backdated_time_granularity | ||
| LOCATION | Country | country | |
| City | city | ||
| Language | locale | ||
| DEMOGRAPHICS | Gender | gender | |
| Age | age | ||
| Gender & age | genderage | ||
| FEED TARGETING | Feed targeting age min | feed_targeting_age_min | Minimum age. Default is 0 |
| Feed targeting age max | feed_targeting_age_max | Maximum age | |
| Feed targeting cities | feed_targeting_cities | Targeting cities | |
| Feed targeting collage years | feed_targeting_college_years | Targeting graduation year from college | |
| Feed targeting countries | feed_targeting_countries | Targeting countries | |
| Feed targeting education statuses | feed_targeting_education_statuses | Targeting based on education levels | |
| Feed targeting genders | feed_targeting_genders | Targeting genders | |
| Feed targeting interests | feed_targeting_interests | Targeting fans interests | |
| Feed targeting locales | feed_targeting_locales | Targeted locales | |
| Feed targeting regions | feed_targeting_regions | Targeting regions | |
| Feed targeting relation statuses | feed_targeting_relationship_statuses | Targeting relationship statuses | |
| REVIEWS/RECOMMENDATIONS | Review creation date | review_created_date | Date then review was created |
| Reviewer ID | reviewer_id | The author ID of a recommendation/review | |
| Reviewer | reviewer_name | The author name of a recommendation/review | |
| Has rating | has_review_rating | Was a rating included in the recommendation/review (1-5 stars) | |
| Has review | has_review | Was there text in the rating in the recommendation/review | |
| Recommendation type | review_recommendation_type | Whether or not this recommendation was "positive" or "negative" | |
| Review text | review_text | Review text included in the review | |
| OTHER | Content click type | consumption_type | |
| Action type | feedback_type | ||
| Story type | story_type | ||
| DEPRECATED | Page tab | tab | Please note that this field will be removed on 2024-03-14 |
| Page like source | like_source | Please note that this field will be removed on 2024-03-14 |