Facebook Page Insights (Meta) Connector Reference

203 metrics115 dimensions

Here is a sample URL for the Facebook Page Insights Connector which fetches Facebook Page Insights on page, post and media level

https://connectors.windsor.ai/facebook_organic?api_key=[your API key]&date_preset=last_7d&fields=date,page_impressions_unique,page_engaged_users

The Facebook Page Insights (Meta) connector exposes 318 fields (203 metrics, 115 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Available actions


Create Photo Post Publish a single image post to a connected Facebook Page. Provide a publicly accessible image URL and an optional caption. For a text/link-only post use create_post instead.

Publish a single image post to a connected Facebook Page. Provide a publicly accessible image URL and an optional caption. For a text/link-only post use create_post instead.

Parameters
image_urlstringRequiredcaptionstring
Create Post Publish a post to a connected Facebook Page's feed. Provide a message (post text), a link (shared URL), or both - at least one is required. For an image post use create_photo_post instead.

Publish a post to a connected Facebook Page's feed. Provide a message (post text), a link (shared URL), or both - at least one is required. For an image post use create_photo_post instead.

Parameters
messagestringlinkstring

Facebook Page Insights (Meta) Fields

Facebook Page Insights (Meta) Comments fields

The Comments report of the Facebook Page Insights (Meta) connector includes 11 fields.

ID Type Name Description
comment_attachment_description TEXT Comment Link Attachment Description The description of the attachment included in the Facebook comment.
comment_attachment_title TEXT Comment Attachment Title Title of the attachment included in the Facebook comment.
comment_attachment_type TEXT Comment Attachment Type Type of the attachment included in the Facebook comment. Possible types include: album, animated_image_autoplay, checkin, cover_photo, event, link, multiple, music, note, offer, photo, profile_media, status, video, video_autoplay, etc.
comment_attachment_url TEXT Comment Attachment URL URL of the attachment included in the Facebook comment.
comment_id TEXT Comment ID Unique ID linked to a Facebook comment.
comment_is_hidden BOOLEAN Comment Is Hidden Whether the comment is hidden from the Page's public timeline. True if hidden, False if visible.
comment_like_count NUMERIC Comment Like Count The number of like reactions on the comment.
comment_parent_id TEXT Comment Parent ID For comment replies, this the comment that this is a reply to.
comment_reply_count NUMERIC Comment Reply Count The total number of all replies to a comment.
comment_text TEXT Comment Text The text of the Facebook comment. Tags are excluded.
comment_timestamp TIMESTAMP Comment Timestamp The time the Facebook comment was created.

Facebook Page Insights (Meta) Deprecated fields

The Deprecated report of the Facebook Page Insights (Meta) connector includes 66 fields.

Facebook Page Insights (Meta) Deprecated fields (page_call_phone_clicks_by_age_gender_logged_in_unique to page_negative_feedback_by_type_hide_clicks)

ID Type Name Description
page_call_phone_clicks_by_age_gender_logged_in_unique TEXT (Deprecated) Page Call Phone Clicks By Age Gender Logged In Unique Number of people who logged in to Facebook and clicked the Call Now button, broken down by age and gender group.
page_call_phone_clicks_by_site_logged_in_unique TEXT (Deprecated) Page Call Phone Clicks By Site Logged In Unique The number of people who clicked your Page's phone number or Call Now button while they were logged into Facebook, broken down by the type of device they used.
page_call_phone_clicks_logged_in_by_city_unique TEXT (Deprecated) Page Call Phone Clicks Logged In By City Unique Number of people who logged in to Facebook and clicked the Call Now button, broken down by city.
page_call_phone_clicks_logged_in_by_country_unique TEXT (Deprecated) Page Call Phone Clicks Logged In By Country Unique Number of people who logged in to Facebook and clicked the Call Now button, broken down by countries.
page_call_phone_clicks_logged_in_unique TEXT (Deprecated) Page Call Phone Clicks Logged In Unique Number of people who logged in to Facebook and clicked the Call Now button.
page_consumptions NUMERIC (Deprecated) Page Consumptions The number of times people clicked on any of your content.
page_consumptions_by_consumption_type OBJECT (Deprecated) Page Consumptions By Consumption Type The number of times people clicked on any of your content, by type. Types include link_click, other_click, photo_view, and video_view.
NUMERIC (Deprecated) Page Consumptions By Link Click Type The number of times people clicked on any of your content, by link_click type.
page_consumptions_by_consumption_type_other_clicks NUMERIC (Deprecated) Page Consumptions By Other Click Type The number of times people clicked on any of your content, by other_click type.
page_consumptions_by_consumption_type_photo_view NUMERIC (Deprecated) Page Consumptions By Photo View Type The number of times people clicked on any of your content, by photo_view type.
page_consumptions_by_consumption_type_unique OBJECT (Deprecated) Page Consumptions By Consumption Type Unique The number of people who clicked on any of your content, by type. Types include link_click, other_click, photo_view, and video_view.
NUMERIC (Deprecated) Page Consumptions By Link Click Type Unique The number of people who clicked on any of your content, by link_click type.
page_consumptions_by_consumption_type_unique_other_clicks NUMERIC (Deprecated) Page Consumptions By Other Click Type Unique The number of people who clicked on any of your content, by other_click type.
page_consumptions_by_consumption_type_unique_photo_view NUMERIC (Deprecated) Page Consumptions By Photo View Type Unique The number of people who clicked on any of your content, by photo_view type.
page_consumptions_by_consumption_type_unique_video_view NUMERIC (Deprecated) Page Consumptions By Video View Type Unique The number of people who clicked on any of your content, by video_view type.
page_consumptions_by_consumption_type_video_view NUMERIC (Deprecated) Page Consumptions By Video View Type The number of times people clicked on any of your content, by video_view type.
page_consumptions_unique NUMERIC (Deprecated) Page Consumptions Unique The number of people who clicked on any of your content.
page_cta_clicks_by_age_gender_logged_in_unique TEXT (Deprecated) Page CTA Clicks By Age Gender Logged In Unique Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and gender group.
page_cta_clicks_by_site_logged_in_unique TEXT (Deprecated) Page CTA Clicks By Site Logged In Unique Number of people who are logged in to Facebook and clicked on the CTA button, broken down by www, mobile, api or other.
page_cta_clicks_logged_in_by_city_unique TEXT (Deprecated) Page CTA Clicks Logged In By City Unique Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by city.
page_cta_clicks_logged_in_by_country_unique TEXT (Deprecated) Page CTA Clicks Logged In By Country Unique Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by country.
page_cta_clicks_logged_in_total NUMERIC (Deprecated) Page CTA Clicks Logged In Total Total number of clicks on the Page CTA button by people who are logged in to Facebook.
page_cta_clicks_logged_in_unique NUMERIC (Deprecated) Page CTA Clicks Logged In Unique Unique number of clicks on the Page CTA button by people who are logged in to Facebook.
page_engaged_users NUMERIC (Deprecated) Page Engaged Users The number of people who engaged with your Page. Engagement includes any click.
page_fans_age TEXT (Deprecated) Page Fans Age The number of people who have liked your Page, broken down by age (should be used with 'page_fans_likes' and 'date' fields together)
page_fans_gender TEXT (Deprecated) Page Fans Gender The number of people who have liked your Page, broken down by gender (should be used with 'page_fans_likes' and 'date' fields together)
page_fans_gender_age TEXT (Deprecated) Page Fans Gender and Age The number of people who have liked your Page, broken down by gender and age (should be used with 'page_fans_likes' and 'date' fields together)
page_fans_online TEXT (Deprecated) Page Fans Online The number of your fans who saw any posts on Facebook on a given day, broken down by hour of day in PST/PDT.
page_fans_online_per_day NUMERIC (Deprecated) Page Fans Online Per Day The number of your fans who saw any posts on Facebook on a given day.
page_get_directions_clicks_by_age_gender_logged_in_unique TEXT (Deprecated) Page Get Directions Clicks By Age Gender Logged In Unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by age and gender group.
page_get_directions_clicks_by_site_logged_in_unique TEXT (Deprecated) Page Get Directions Clicks By Site Logged In Unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by www, mobile, api or other.
page_get_directions_clicks_logged_in_by_city_unique TEXT (Deprecated) Page Get Directions Clicks Logged In By City Unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by city.
page_get_directions_clicks_logged_in_by_country_unique TEXT (Deprecated) Page Get Directions Clicks Logged In By Country Unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by country.
page_get_directions_clicks_logged_in_unique NUMERIC (Deprecated) Page Get Directions Clicks Logged In Unique Number of people who logged in to Facebook and clicked the Get Directions button.
page_impressions_organic_unique_v2 NUMERIC (Deprecated) Page Impressions Organic Unique This metric counts reach from the organic distribution of your Facebook Page and Page content. This metric is estimated.
page_impressions_organic_v2 NUMERIC (Deprecated) Page Impressions Organic The number of times any post or story content from your Page or about your Page entered a person's screen through unpaid distribution.
page_negative_feedback NUMERIC (Deprecated) Page Negative Feedback The number of times people took a negative action (e.g., un-liked or hid a post).
page_negative_feedback_by_type OBJECT (Deprecated) Page Negative Fedback By Type The number of times people took a negative action broken down by type.
page_negative_feedback_by_type_hide_all_clicks NUMERIC (Deprecated) Page Negative Feedback By Hide All Clicks Type Number of hide_all_clicks actions.
page_negative_feedback_by_type_hide_clicks NUMERIC (Deprecated) Page Negative Feedback By Hide Clicks Type Number of hide_clicks actions.

Facebook Page Insights (Meta) Deprecated fields (page_negative_feedback_by_type_report_spam_clicks to post_negative_feedback_by_type_unique_hide_all_clicks)

ID Type Name Description
page_negative_feedback_by_type_report_spam_clicks NUMERIC (Deprecated) Page Negative Feedback By Report Spam Clicks Type Number of report_spam_clicks actions.
page_negative_feedback_by_type_unique OBJECT (Deprecated) Page Negative Fedback By Type Unique The number of people who took a negative action broken down by type.
page_negative_feedback_by_type_unique_hide_all_clicks NUMERIC (Deprecated) Page Negative Feedback By Hide All Clicks Type Unique The number of people who took hide_all_clicks actions.
page_negative_feedback_by_type_unique_hide_clicks NUMERIC (Deprecated) Page Negative Feedback By Hide Clicks Type Unique The number of people who took hide_clicks actions.
page_negative_feedback_by_type_unique_report_spam_clicks NUMERIC (Deprecated) Page Negative Feedback By Report Spam Type Unique The number of people who took report_spam_clicks actions.
page_negative_feedback_by_type_unique_unlike_page_clicks NUMERIC (Deprecated) Page Negative Feedback By Unlike Page Clicks Type Unique The number of people who took unlike_page_clicks actions.
page_negative_feedback_by_type_unlike_page_clicks NUMERIC (Deprecated) Page Negative Feedback By Unlike Page Clicks Type Number of unlike_page_clicks actions.
page_negative_feedback_unique NUMERIC (Deprecated) Page Negative Feedback Unique The number of people who took a negative action (e.g., un-liked or hid a post).
page_places_checkin_mobile NUMERIC (Deprecated) Page Places Checkin Mobile The number of times people checked into a place using mobile phones.
page_places_checkin_mobile_unique NUMERIC (Deprecated) Page Places Checkin Mobile Unique The number of people who checked into a place using mobile phones.
page_places_checkin_total NUMERIC (Deprecated) Page Places Checkin Total The number of times people checked into a place.
page_places_checkin_total_unique NUMERIC (Deprecated) Page Places Checkin Total Unique The number of people who checked into a place.
page_places_checkins_by_age_gender NUMERIC (Deprecated) Page Places Checkin By Age Gender gender and age of people who checked in at your Place.
page_places_checkins_by_country NUMERIC (Deprecated) Page Places Checkins By Country top countries of people who checked into your Place.
page_places_checkins_by_locale NUMERIC (Deprecated) Page Places Checkin By Locale top locales of people who checked into your Place.
page_positive_feedback_by_type TEXT (Deprecated) Page Positive Feedback By Type The number of times people took a positive action broken down by type.
page_positive_feedback_by_type_unique TEXT (Deprecated) Page Positive Feedback By Type Unique The number of people who took a positive action broken down by type.
page_website_clicks_by_age_gender_logged_in_unique TEXT (Deprecated) Page Website Clicks By Age Gender Logged In Unique Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by age and gender group.
page_website_clicks_by_site_logged_in_unique TEXT (Deprecated) Page Website Clicks By Site Logged In Unique Number of people who logged in to Facebook and clicked the Page CTA button, broken down by www, mobile, api and other.
page_website_clicks_logged_in_by_city_unique TEXT (Deprecated) Page Website Clicks Logged In By City Unique Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by city.
page_website_clicks_logged_in_by_country_unique TEXT (Deprecated) Page Website Clicks Logged In By Country Unique Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by country.
page_website_clicks_logged_in_unique NUMERIC (Deprecated) Page Website Clicks Logged In Unique Number of people who logged in to Facebook and clicked the goto website CTA button.
post_clicks_unique NUMERIC (Deprecated) Post Clicks Unique The number of people who clicked anywhere in your post without generating a story.
post_negative_feedback_by_type_hide_all_clicks NUMERIC (Deprecated) Post Negative Feedback By Type Hide All Clicks Number of negative actions taken on your post (hide all clicks).
post_negative_feedback_by_type_hide_clicks NUMERIC (Deprecated) Post Negative Feedback By Type Hide Clicks Number of negative actions taken on your post (hide all clicks).
post_negative_feedback_by_type_unique_hide_all_clicks NUMERIC (Deprecated) Post Negative Feedback By Type Unique Hide All Clicks The number of people who performed a negative action in your post (hide all clicks).

Facebook Page Insights (Meta) Page fields

The Page report of the Facebook Page Insights (Meta) connector includes 46 fields.

Facebook Page Insights (Meta) Page fields (current_location to page_video_views_by_paid_non_paid_unpaid)

ID Type Name Description
current_location TEXT Current Location The current location of the Page.
name_with_location_descriptor TEXT Name With Location Descriptor The name of the Page with its location and/or global brand descriptor. Only visible to a Page admin.
page_actions_post_reactions_anger_total NUMERIC Page Actions Post Reactions Anger Total Daily total post anger reactions of a page.
page_actions_post_reactions_haha_total NUMERIC Page Actions Post Reactions Haha Total Daily total post haha reactions of a page.
page_actions_post_reactions_like_total NUMERIC Page Actions Post Reactions Like Total Daily total post like reactions of a page.
page_actions_post_reactions_love_total NUMERIC Page Actions Post Reactions Love Total Daily total post love reactions of a page.
page_actions_post_reactions_sorry_total NUMERIC Page Actions Post Reactions Sorry Total Daily total post sad reactions of a page.
page_actions_post_reactions_total NUMERIC Page Reactions Total Daily total post reactions of a page (like + love + wow + haha + sorry + anger).
page_actions_post_reactions_wow_total NUMERIC Page Actions Post Reactions Wow Total Daily total post wow reactions of a page.
page_daily_follows NUMERIC Daily Follows The number of people who have followed your Page daily.
page_daily_follows_unique NUMERIC Daily Follows Unique The number of people who have followed your Page daily. (Unique Users)
page_daily_unfollows NUMERIC Daily Unfollows The number of people who have unfollowed your Page daily.
page_daily_unfollows_unique NUMERIC Daily Unfollows Unique The number of people who have unfollowed your Page daily. (Unique Users)
page_fan_adds NUMERIC (Deprecated) New likes (Deprecated) The number of new people who have liked your Page
page_fan_adds_unique NUMERIC (Deprecated) New likes (unique users) (Deprecated) The number of new people who have liked your Page (Unique users)
page_fan_removes NUMERIC (Deprecated) New unlikes (Deprecated) The number of new people who have unliked your Page
page_fan_removes_unique NUMERIC (Deprecated) Unlikes (unique users) (Deprecated) The number of Unlikes of your Page (Unique users)
page_fans NUMERIC Page Fans total page likes The total number of people who have liked your Page
page_fans_daily NUMERIC Page Fans total page likes (daily) The total number of people who have liked your Page (daily)
page_fans_likes NUMERIC Page Fans Likes (for dimensions) The number of people who have liked your Page broken down by dimensions (page_fans_gender_age, page_fans_locale, page_fans_city, page_fans_country, page_fans_gender, page_fans_age fields)
page_fans_likes_daily NUMERIC Page Fans Likes (for dimensions - daily) The number of people who have liked your Page broken down by dimensions (page_fans_gender_age, page_fans_locale, page_fans_city, page_fans_country, page_fans_gender, page_fans_age fields) (daily)
page_follows NUMERIC Lifetime Total Follows Lifetime - The total number of people who have followed your Page. (Unique Users)
page_follows_daily NUMERIC Lifetime Total Follows daily Lifetime - The total number of people who have followed your Page daily. (Unique Users)
page_id TEXT Page Id Page id
page_impressions NUMERIC Page Impressions The number of times any content from your Page or about your Page entered a person's screen. This includes posts, stories, ads, as well other content or information on your Page.
page_impressions_organic NUMERIC Page Impressions Organic The number of times any post or story content from your Page or about your Page entered a person's screen through organic distribution.
page_impressions_organic_unique NUMERIC (Deprecated) Page Impressions Organic Unique (Deprecated) The number of people who had any content from your Page or about your Page enter their screen through organic distribution. This includes posts, stories, check-ins, ads, social information from people who interact with your Page and more. This metric is estimated.
page_impressions_paid NUMERIC Page Impressions Paid The number of times any post or story content from your Page or about your Page entered a person's screen through paid distribution such as an ad.
page_impressions_paid_unique NUMERIC (Deprecated) Page Impressions Paid Unique (Deprecated) The number of Accounts Center accounts that saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same Accounts Center accounts. This metric is estimated.
page_impressions_unique NUMERIC Page Impressions Unique The number of people who had any content from your Page or about your Page enter their screen. This includes posts, stories, check-ins, ads, social information from people who interact with your Page and more.
page_name TEXT Page Name The name of the Page
page_post_engagements NUMERIC Page Post Engagements The number of times people have engaged with your posts through reactions, comments, shares and more.
page_total_actions NUMERIC Page Total Actions The number of clicks on your Page's contact info and call-to-action button.
page_total_media_view_unique NUMERIC Page Total Media View Unique The number of total unique media viewers for your Facebook Page. This metric is estimated.
page_video_view_time NUMERIC Page Video View Time The total time (in milliseconds) spent by users watching videos on your Page.
page_video_views NUMERIC Page Video Views The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds. During separate playback, videos are treated separately, replay time is excluded.
page_video_views_autoplayed NUMERIC Page Video Views Autoplayed The number of times your autoplay videos have been viewed for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account.
page_video_views_by_paid_non_paid_paid NUMERIC Paid Page Video Views By Paid Non Paid The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by paid views. During a separate playback event, video views are counted separately, repeat times are excluded.
page_video_views_by_paid_non_paid_total NUMERIC Total Page Video Views By Paid Non Paid The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by total views. During a separate playback event, video views are counted separately, repeat times are excluded.
page_video_views_by_paid_non_paid_unpaid NUMERIC Unpaid Page Video Views By Paid Non Paid The number of times your Page video has been viewed for at least 3 seconds, or nearly all if it is shorter than 3 seconds, broken down by unpaid views. During a separate playback event, video views are counted separately, repeat times are excluded.

Facebook Page Insights (Meta) Page fields (page_video_views_click_to_play to store_location_descriptor)

ID Type Name Description
page_video_views_click_to_play NUMERIC Page Video Views Click To Play The number of views of your Page video, initiated by pressing the "Play" button, for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account.
page_video_views_organic NUMERIC Page Video Views Organic Your Page's video has been viewed for at least 3 seconds, or nearly all if shorter than 3 seconds, within organic reach. When analyzing a single case of video playback, the time spent on repetitions is not taken into account.
page_video_views_paid NUMERIC Page Video Views Paid The number of views of your Page's promoted videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. For each video impression, views are counted separately, the time spent on replays is not counted.
page_video_views_unique NUMERIC Page Video Views Unique The number of people who viewed your Page's video for at least 3 seconds, or almost all of them if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account.
page_views_total NUMERIC Total Page Views The number of times a Page's profile has been viewed by logged in and logged out people.
store_location_descriptor TEXT Store Location Descriptor The Page's store location descriptor, e.g. the name of the mall the store is located in.

Facebook Page Insights (Meta) Post fields

The Post report of the Facebook Page Insights (Meta) connector includes 67 fields.

Facebook Page Insights (Meta) Post fields (clicks to post_reactions_love_total)

ID Type Name Description
clicks NUMERIC Post Clicks (duplicate) The number of times people clicked on anywhere in your posts without generating a story.
full_picture IMAGE_URL Post full picture If the photo's largest dimension exceeds 720 pixels, it is resized, with the largest dimension set to 720.
is_eligible_for_promotion BOOLEAN Post is Eligible For Promotion Whether the post is eligible for promotion.
is_expired BOOLEAN Post is Expired Whether the post has expiration time that has passed.
is_inline_created BOOLEAN Post is Inline Created Returns True if the post was created inline when creating ads.
BOOLEAN Post is Popular Whether the post is currently popular. Based on whether the total actions as a percentage of reach exceeds a certain threshold.
is_published BOOLEAN Post is Published Indicates whether a scheduled post was published (applies to scheduled Page Post only, for users post and instanlty published posts this value is always true)
media_type TEXT (Deprecated) Post media Type [deprecated] A string indicating the object type of this post.
TEXT Post permalink URL The permanent static URL to the post/video on www.facebook.com. Example https://www.facebook.com/FacebookforDevelopers/posts/10153449196353553
post_activity_by_action_type TEXT (Deprecated) Post Activity Use Post Activity (number of likes), Post Activity (number of comments), Post Activity (times stories have been shared) instead.
post_activity_by_action_type_comment NUMERIC Post Activity (number of comments). The number of comments on a Post.
post_activity_by_action_type_like NUMERIC Post Activity (number of likes) The number of likes on a Post.
post_activity_by_action_type_share NUMERIC Post Activity (times stories have been shared). The number of shares on a Post.
post_clicks NUMERIC Post Clicks The number of times people clicked on anywhere in your posts without generating a story.
post_clicks_by_type_link_clicks NUMERIC Post Clicks By Type Link Clicks The number of clicks on any places in your publications without creating news (link clicks).
post_clicks_by_type_other_clicks NUMERIC Post Clicks By Type Other clicks The number of clicks on any places in your publications without creating news (other clicks).
post_clicks_by_type_photo_view NUMERIC Post Clicks By Type Photo View The number of clicks on any places in your publications without creating news (photo clicks).
post_clicks_by_type_video_play NUMERIC Post Clicks By Type Video Play The number of clicks on any places in your publications without creating news (video plays).
post_comments_total NUMERIC Post Total Comments Total comments count of the post.
post_comments_with_reply NUMERIC Post Total Comments With Replies Total comments on the post including replies, matching the count shown in the Facebook UI. Read from the comments edge with filter=stream, unlike post_comments_total which counts only top-level comments.
post_created_time TIMESTAMP Post Created Time Post created time
post_description TEXT Post Description The description of the link (appears beneath the link caption). If not specified, this field is automatically populated by information scraped from the link, typically the title of the page.
post_engagements NUMERIC Post Engagements Total engagements on a post: all reactions (like, love, wow, haha, sad, anger) plus comments and shares.
post_id TEXT Post Id Post id
post_impressions NUMERIC Post Impressions The number of times your Page's post entered a person's screen. Posts include statuses, photos, links, videos and more.
post_impressions_fan NUMERIC Post Impressions Fan The number of times your Page content was on screen for accounts that followed or liked your Page.
post_impressions_fan_unique NUMERIC (Deprecated) Post Impressions Fan Unique (Deprecated) The number of Accounts Center accounts that followed or liked your Page. This metric is estimated.
post_impressions_organic NUMERIC Post impressions Organic The number of times your Page posts are displayed on the user's screen as a result of unpaid distribution.
post_impressions_organic_unique NUMERIC (Deprecated) Post impressions Organic Unique (Deprecated) The number of people who displayed your Page post as a result of an unpaid distribution (Post Reach - Organic).
post_impressions_paid NUMERIC Post Impressions Paid The number of times your Page post appears on the screen of any user as a result of paid distribution - for example, advertising.
post_impressions_paid_unique NUMERIC (Deprecated) Post Impressions Paid Unique (Deprecated) The number of people on whose screen the publication of your Page was displayed as a result of paid distribution - for example, advertising.
post_impressions_unique NUMERIC Post Impressions Unique The number of people on the page displayed the publication of your information. Publications are considered statuses, photos, links, videos, etc.
post_message TEXT Post Message Post message
post_message_oneline TEXT Post Message Oneline Post message in one line
post_picture IMAGE_URL Post Picture The picture scraped from any link included with the post.
post_reactions_anger_total NUMERIC Post Reactions Anger Total Total "anger" reactions of a post. Includes "anger" in the original post and its shares.
post_reactions_by_type_total NUMERIC Post Reactions By Type Total Total post reactions by type. Includes reactions in the original post and its shares.
post_reactions_haha_total NUMERIC Post Reactions Haha Total Total "haha" reactions of a post. Includes "haha" in the original post and its shares.
post_reactions_like_total NUMERIC Post Reactions Like Total Total "like" reactions of a post. Includes "like" in the original post and its shares.
post_reactions_love_total NUMERIC Post Reactions Love Total Total "love" reactions of a post. Includes "love" in the original post and its shares.

Facebook Page Insights (Meta) Post fields (post_reactions_no_shares to url)

ID Type Name Description
post_reactions_no_shares NUMERIC Post Reactions No Shares Total Total reactions on the post/reel itself, excluding reshares. Read from the post object's reactions edge, so it matches the count shown in the Facebook UI (unlike post_reactions_* and post_video_* which aggregate reshares).
post_reactions_sorry_total NUMERIC Post Reactions Sorry Total Total "sad" reactions of a post. Includes "sad" in the original post and its shares.
post_reactions_total NUMERIC Post Reactions Total Total reactions of a post.
post_reactions_wow_total NUMERIC Post Reactions Wow Total Total "wow" reactions of a post. Includes "wow" in the original post and its shares.
post_title TEXT Post title The title of the post.
post_total_media_view_unique NUMERIC Post Total Media View Unique The number of total unique media viewers for a Facebook post.
post_video_complete_views_organic NUMERIC Post Video Complete Views Organic Your videos have been viewed up to 95% or more of their organic reach. During a separate playback case, video views are counted separately, video replay time is excluded. Returns 0 for video reposts.
post_video_complete_views_organic_unique NUMERIC Post Video Complete Views Organic Unique The number of people who viewed your videos up to 95% or more of their organic reach. During a single playback event, views are counted separately, repeat times are excluded. Returns 0 for video reposts.
post_video_views NUMERIC Post Video Views The number of times your videos have been viewed for at least 3 seconds, or nearly all if they are shorter than 3 seconds. During a separate case of playback, video views are counted separately, video replay time is excluded.
post_video_views_autoplayed NUMERIC Post Video Views Autoplayed The number of times your autoplay videos have been viewed for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account.
post_video_views_clicked_to_play NUMERIC Post Video Views Clicked To Play The number of views of your videos initiated by pressing the Play button for at least 3 seconds, or almost completely if they are shorter than 3 seconds. When analyzing a single case of video playback, the time spent on replays is not taken into account.
post_video_views_organic NUMERIC Post Vide Views Organic The number of views of your videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds, within organic reach. During a separate playback case, video views are counted separately, video replay time is excluded.
post_video_views_organic_unique NUMERIC Post Video Views Organic Unique The number of people who watched your videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds, within organic reach. During a single playback event, views are counted separately, repeat times are excluded.
post_video_views_paid NUMERIC Post Video Views Paid The number of views of your promoted videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. For each video display, video views are counted separately, video repeat times are excluded.
post_video_views_paid_unique NUMERIC Post Video Views Paid Unique The number of people who watched your promoted videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. For each video show, views are counted separately, repeat times are excluded.
post_video_views_unique NUMERIC Post Video Views Unique The number of people who watched your videos for at least 3 seconds, or almost completely if they are shorter than 3 seconds. During a separate playback event, video views are counted separately, repeat times are excluded.
targeting TEXT Post targeting Object that limited the audience for this content. Anyone not in these demographics will not be able to view this content. This will not override any Page-level demographic restrictions that may be in place.
total_video_15s_views NUMERIC Lifetime Total 15-Second Views Lifetime: Total number of times your video was viewed for at least 15 seconds.
total_video_30s_views NUMERIC Lifetime Total 30-Second Views Lifetime: Total number of times your video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds. (Total Count)
total_video_60s_excludes_shorter_views NUMERIC Lifetime Total 60-Second Views for videos 60 seconds or longer Lifetime: Total number of times your video was viewed for 60 seconds only if the video is 60 seconds or longer. Returns 0 for video reposts: Facebook's post-level insights return 0 for reposted videos.
total_video_complete_views NUMERIC Lifetime Total Video Watches at 95% Lifetime: Total number of times your video was watched at 95% of its length, including watches that skipped to this point. (Total Count). May read 0 for video reposts: derived from post-level organic + paid insights, which Facebook returns as 0 for reposted videos.
total_video_complete_views_organic NUMERIC Lifetime Organic Watches at 95% Lifetime: Number of times your video was watches at 95% of its length without any paid promotion, including watches that skipped to this point. (Total Count). Returns 0 for video reposts: Facebook's post-level insights return 0 for reposted videos.
total_video_complete_views_organic_unique NUMERIC Lifetime Organic Unique Watches at 95% Lifetime: The number of unique people who watched your video at 95% of its length without any paid promotion, including people that skipped to this point. (Unique Users). Returns 0 for video reposts: Facebook's post-level insights return 0 for reposted videos.
total_video_complete_views_paid NUMERIC Lifetime Paid Watches at 95% Lifetime: Number of times your video was watched at 95% of its length after paid promotion, including watches that skipped to this point. (Total Count). Returns 0 for video reposts: Facebook's post-level insights return 0 for reposted videos.
total_video_complete_views_paid_unique NUMERIC Lifetime Paid Unique Watches at 95% Lifetime: The number of unique people who watched your video at 95% of its length after paid promotion, including people that skipped to this point. (Unique Users)
type TEXT Post type A string indicating the object type of this post.
url TEXT Post URL URL of the attachment.

Facebook Page Insights (Meta) Reels fields

The Reels report of the Facebook Page Insights (Meta) connector includes 23 fields.

ID Type Name Description
blue_reels_play_count NUMERIC Reels Lifetime Play Count Lifetime: The number of times your reel starts to play after an impression is already counted. This is defined as reels sessions with 1ms or more of playback and excludes replays.
fb_reels_replay_count NUMERIC Reels Replay Count The number of times your reel starts to play again after an initial play of your reel by the same account for at least 1ms in the same session.
fb_reels_total_plays NUMERIC Reels Total Plays The number of times your reel starts to play after an impression is already counted. This is defined as reel sessions with 1ms or more and includes replays. Replays are counted after the initial play of the reel in the same session.
post_video_avg_time_watched NUMERIC Reels Avg Time watched Lifetime: the average time (in ms) your reel was played, including any time spent replaying the reel during a single instance of it playing. Because this metric includes replays, this number could be greater than the total length of the reel
post_video_followers NUMERIC Reels Followers Lifetime: The number of people who followed your Page or profile within 24 hours of watching this reel. This metric is estimated.
post_video_likes_by_reaction_type_reaction_angry NUMERIC Reels Likes By Reaction Type Angry Lifetime loves of a video broken down by reaction type.
post_video_likes_by_reaction_type_reaction_care NUMERIC Reels Likes By Reaction Type Care Lifetime loves of a video broken down by reaction type.
post_video_likes_by_reaction_type_reaction_haha NUMERIC Reels Likes By Reaction Type Haha Lifetime loves of a video broken down by reaction type.
post_video_likes_by_reaction_type_reaction_like NUMERIC Reels Likes By Reaction Type Like Lifetime likes of a video broken down by reaction type.
post_video_likes_by_reaction_type_reaction_love NUMERIC Reels Likes By Reaction Type Love Lifetime loves of a video broken down by reaction type.
post_video_likes_by_reaction_type_reaction_sad NUMERIC Reels Likes By Reaction Type Sad Lifetime loves of a video broken down by reaction type.
post_video_likes_by_reaction_type_reaction_wow NUMERIC Reels Likes By Reaction Type WOW Lifetime loves of a video broken down by reaction type.
post_video_social_actions_comment NUMERIC Reels Social Actions Comment Lifetime comments of a video.
post_video_social_actions_share NUMERIC Reels Social Actions Share Lifetime shares of a video.
post_video_total_reactions NUMERIC Reels Total Reactions Total reels reactions.
post_video_view_time NUMERIC Reels View Time The total number of milliseconds your reel played, including time spent replaying your reel.
reel_picture_url IMAGE_URL Reel Picture URL The URL for the thumbnail picture of the reel.
reel_thumbnails TEXT Reel Thumbnails Thumbnails for the reel.
reels_description TEXT Reel Description The description of the reel.
TEXT Reel Permalink URL The permanent static URL to the reel on www.facebook.com. Example https://www.facebook.com/reel/1234567890
reels_post_impressions_unique NUMERIC Reels Post Impressions Unique The number of people who saw your reel at least once, whether or not the person played your reel. This metric is different from impressions, which includes multiple views of your reel by the same person. This metric is estimated.
reels_post_type TEXT Reels Post Type Indicates whether the content is a 'video' or 'reel'.
video_post_impressions_unique NUMERIC (Deprecated) Video Post Impressions Unique The number of people who saw your reel at least once, whether or not the person played your reel. This metric is different from impressions, which includes multiple views of your reel by the same person. This metric is estimated.

Facebook Page Insights (Meta) Video fields

The Video report of the Facebook Page Insights (Meta) connector includes 81 fields.

Facebook Page Insights (Meta) Video fields (backdated_time to total_video_30s_views_auto_played)

ID Type Name Description
backdated_time TIMESTAMP Video Backdated Time A user-specified time for when this object was created.
backdated_time_granularity TEXT Video Backdated Time Granularity The granularity of the backdated time. How accurate the backdated time is.
captions TEXT Video Captions Captions for the video.
content_category TEXT Video Content Category The content category of the video.
created_time TIMESTAMP Created Time The time the video was initially published.
description TEXT Video Description The description of the video.
embed_html TEXT Video Embed HTML The embed HTML of the video.
embeddable BOOLEAN Video Embeddable Whether the video is embeddable.
event TEXT Video Event Event info.
icon TEXT Video Icon The icon that Facebook displays when videos are published to the Feed.
id TEXT Video ID The ID of the video.
is_crosspost_video BOOLEAN Video Is Crosspost Video Whether the video is a crosspost from other page.
is_crossposting_eligible BOOLEAN Video Is Crossposting Eligible Whether the video is eligible for crossposting.
is_episode BOOLEAN Video Is Episode Whether the video is an episode in a series.
is_instagram_eligible BOOLEAN Video Is Instagram Eligible Whether the video is eligible for Instagram promotion.
length TEXT Video Length Duration of this video in seconds.
live_status TEXT Video Live Status Status of the video.
picture IMAGE_URL Video Thumbnail Picture The URL for the thumbnail picture of the video.
place TEXT Video Place Place info.
poll_settings TEXT (Deprecated) Video Poll Settings Settings for polls on the video.
polls TEXT (Deprecated) Video Polls (Deprecated) Video polls attached to this video.
post_views NUMERIC Video Post Views The number of times the video has been viewed.
premiere_living_room_status TEXT Video Premiere Living Room Status The status of the Premiere Watch Party, if any.
privacy TEXT Video Privacy The privacy setting for the video.
published BOOLEAN Video Published Whether the video is published.
scheduled_publish_time TIMESTAMP Video Scheduled Publish Time The time that the video is scheduled to publish.
source TEXT Video Source A URL to the raw, playable video file.
TEXT Video Sponsor Tags Sponsor pages tagged in the video.
status TEXT Video Status Status of the video.
tags OBJECT (Deprecated) Video Tags (Deprecated) Users tagged in the video.
thumbnails TEXT Video Thumbnails Thumbnails for the video.
title TEXT Video Title The title of the video.
total_video_10s_views NUMERIC Lifetime Total 10-Second Views Lifetime: Total number of times your video was viewed for 10 seconds or viewed to the end, whichever came first. (Total Count)
total_video_10s_views_auto_played NUMERIC Lifetime Auto-Played 10-Second Views Lifetime: Number of times your video started automatically playing and people viewed it for 10 seconds, or viewed it to the end, whichever came first. (Total Count)
total_video_10s_views_clicked_to_play NUMERIC Lifetime Clicked-to-Play 10-Second Views Lifetime: Number of times people clicked to play your video and viewed it for 10 seconds or viewed it to the end, whichever came first. (Total Count)
total_video_10s_views_organic NUMERIC Lifetime Organic 10-Second Views Lifetime: Number of times your video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. (Total Count)
total_video_10s_views_paid NUMERIC Lifetime Paid 10-Second Views Lifetime: Number of times your video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. (Total Count)
total_video_10s_views_sound_on NUMERIC Lifetime 10-Second Views with sound on Lifetime: Number of times your video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. (Total Count)
total_video_10s_views_unique NUMERIC Lifetime Unique 10-Second Views Lifetime: Number of unique people who viewed your video for 10 seconds or viewed to the end, whichever came first. (Unique Users)
total_video_30s_views_auto_played NUMERIC Lifetime Auto-Played 30-Second Views Lifetime: Number of times your video started automatically playing and people viewed it for 30 seconds or 97% of the video if video is less than 30 seconds. (Total Count)

Facebook Page Insights (Meta) Video fields (total_video_30s_views_clicked_to_play to video_total_reactions)

ID Type Name Description
total_video_30s_views_clicked_to_play NUMERIC Lifetime Clicked-to-Play 30-Second Views Lifetime: Number of times people clicked to play your video and viewed it for 30 seconds or 97% of the video if video is less than 30 seconds. (Total Count)
total_video_30s_views_organic NUMERIC Lifetime Organic 30-Second Views Lifetime: Number of times your video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds without a paid promotion. (Total Count)
total_video_30s_views_paid NUMERIC Lifetime Paid 30-Second Views Lifetime: Number of times your video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds after a paid promotion. (Total Count)
total_video_30s_views_unique NUMERIC Lifetime Unique 30-Second Views Lifetime: Number of unique people who viewed your video for 30 seconds or 97% of the video if video is less than 30 seconds. (Unique Users)
total_video_avg_time_watched NUMERIC Lifetime Average time video viewed Lifetime: Average time video viewed (Total Count)
total_video_complete_views_auto_played NUMERIC Lifetime Auto-Played Video Watches at 95% Lifetime: Number of times your video started automatically playing and people watched it at 95% of its length, including watches that skipped to this point. (Total Count)
total_video_complete_views_clicked_to_play NUMERIC Lifetime Clicked-to-Play Video Watches at 95% Lifetime: Number of times people clicked to play your video and watched it at 95% of its length, including watches that skipped to this point. (Total Count)
total_video_complete_views_unique NUMERIC Lifetime Unique Video Watches at 95% Lifetime: Total number of unique people who watched your video at 95% of its length or more, including people that skipped to this point. (Unique Users)
total_video_consumption_rate NUMERIC Lifetime Video Consumption Rate The ratio of unique video views to total unique impressions.
total_video_impressions NUMERIC Lifetime Video Total Impressions Lifetime: The number of impressions of the video. (Total Count)
total_video_impressions_fan NUMERIC Lifetime Video Impressions by people who have liked your Page Lifetime: Number of impressions of your Page Video to people who have liked your Page. (Total Count)
total_video_impressions_fan_paid NUMERIC Lifetime Video Paid Impressions by people who have liked your Page Lifetime: Number of paid impressions of your Page Video Asset to people who have liked your Page. (Total Count)
total_video_impressions_fan_paid_unique NUMERIC Lifetime Paid reach of a Video by people who like your Page Lifetime: Number of people who like your Page and who saw your Page Video in an ad or sponsored story. (Unique Users)
total_video_impressions_fan_unique NUMERIC Lifetime Video reach by people who like your Page Lifetime: Number of people who saw your Page video because they've liked your Page (Unique Users)
total_video_impressions_organic NUMERIC Lifetime Video Organic Impressions Lifetime: The number of impressions of your Video in Feed or ticker or on your Page's Timeline. (Total Count)
total_video_impressions_organic_unique NUMERIC Lifetime Video organic reach Lifetime: Number of people who saw your Page Video in Feed or ticker, or on your Page's timeline. (Unique Users)
total_video_impressions_paid NUMERIC Lifetime Video Paid Impressions Lifetime: Number of impressions of your Page Video in an Ad or Sponsored Story. (Total Count)
total_video_impressions_paid_unique NUMERIC Lifetime Video Paid Reach Lifetime: Number of people your advertised Page Video was served to. (Unique Users)
total_video_impressions_unique NUMERIC Lifetime Video Total Reach Lifetime: The total number of people your video was served to. (Unique Users)
total_video_impressions_viral NUMERIC Lifetime Video Viral Impressions Lifetime: The number of impressions of your Page Video in a story generated by a friend. (Total Count)
total_video_impressions_viral_unique NUMERIC Lifetime Video viral reach Lifetime: Number of people who saw your Page Video in a story from a friend. (Unique Users)
total_video_play_count NUMERIC Lifetime Video Play Count Lifetime Video Play Count.
total_video_view_total_time NUMERIC Lifetime Total Video View Time (in ms) Lifetime: Total time (in ms) video has been viewed. (Total Count)
total_video_view_total_time_organic NUMERIC Lifetime Total Organic Video View Time (in ms) Lifetime: Total time (in ms) video has been viewed in Feed or ticker or on your Page's Timeline. (Total Count)
total_video_view_total_time_paid NUMERIC Lifetime Total Paid Video View Time (in ms) Lifetime: Total time (in ms) video has been viewed after paid promotion. (Total Count)
total_video_views NUMERIC Total Video Views Lifetime: Total number of times your video was viewed for 3 seconds or viewed to the end, whichever came first. (Total Count)
total_video_views_autoplayed NUMERIC Lifetime Auto-Played Video Views Lifetime: Number of times your video started automatically playing and people viewed it for 3 seconds or viewed it to the end, whichever came first. (Total Count)
total_video_views_clicked_to_play NUMERIC Lifetime Clicked-to-Play Video Views Lifetime: Number of times people clicked to play your video and viewed it for 3 seconds or viewed it to the end, whichever came first. (Total Count)
total_video_views_organic NUMERIC Lifetime Organic Video Views Lifetime: Number of times your video was viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. (Total Count)
total_video_views_organic_unique NUMERIC Lifetime Unique Organic Video Views Lifetime: Number unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. (Unique Users)
total_video_views_paid NUMERIC Lifetime Paid Video Views Lifetime: Number of times your video was viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. (Total Count)
total_video_views_paid_unique NUMERIC Lifetime Unique Paid Video Views Lifetime: Number of unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. (Unique Users)
total_video_views_sound_on NUMERIC Lifetime Video Views with sound on Lifetime: Number of times your video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. (Total Count)
total_video_views_unique NUMERIC Lifetime Unique Video Views Lifetime: Number of unique people who viewed your video for 3 seconds or viewed to the end, whichever came first. (Unique Users)
universal_video_id TEXT Video Universal Video ID The publishers asset management code for this video.
updated_time TIMESTAMP Video Updated Time The last time the video or its caption was updated.
TEXT Video Permalink URL The permanent static URL to the video on www.facebook.com. Example https://www.facebook.com/FacebookforDevelopers/posts/10153449196353553
video_post_id TEXT Video Post Id Video Post id
video_post_type TEXT Video Post Type Indicates whether the content is a 'video' or 'reel'.
video_total_reactions NUMERIC Video Total Reactions The total number of reactions on the video, across all types.

Facebook Page Insights (Meta) Video fields (views to views)

ID Type Name Description
views NUMERIC Views (video) The number of times the video has been viewed.

Facebook Page Insights (Meta) other fields

The Facebook Page Insights (Meta) connector has 29 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID The Page ID of the Facebook Page
account_name TEXT Account Name The Page Name of the Facebook Page
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date The dimension that determines how date-based data in a chart is handled (the time dimension).
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
page_fan_adds_by_paid_non_paid_unique TEXT Page Fans Adds By Paid Non Paid Unique The number of new people who have liked your Page broken down by paid and non-paid.
page_fans_city CITY Page Fans City The number of people who have liked your Page, broken down by city (should be used with 'page_fans_likes' and 'date' fields together)
page_fans_city_name CITY Page Fans City Name Specific city name from page_fans_city field(should be used with 'page_fans_likes' and 'date' fields together)
page_fans_city_value NUMERIC Page Fans City Value Specific city likes value from page_fans_city field(should be used with 'page_fans_likes' and 'date' fields together)
page_fans_country COUNTRY Page Fans Country The number of people who have liked your Page, broken down by country (should be used with 'page_fans_likes' and 'date' fields together)
page_fans_country_name COUNTRY Page Fans Country Name Specific country name from page_fans_country field(should be used with 'page_fans_likes' and 'date' fields together)
page_fans_country_value NUMERIC Page Fans Country Value Specific country likes value from page_fans_country field(should be used with 'page_fans_likes' and 'date' fields together)
page_fans_locale TEXT (Deprecated) Page Fans Locale (Deprecated) The number of people who have liked your Page, broken down by locale (should be used with page_fans_likes and date fields together).
period TEXT Period Aggregation window applied to the metrics in the row: 'day', 'week', 'month' or 'total_over_range'. Set from the requested date fields (e.g. requesting week_iso or month yields one row per ISO week / calendar month, deduplicated by Facebook); defaults to 'day'.
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20