Social Media Pages Table (BETA)

social_media_pages_table

The Social Media Pages table stores daily performance and engagement metrics for connected social media pages, including impressions, likes, views, and page-level metadata. Querying this table lets you analyze page reach, paid vs. organic performance, audience engagement, and visibility trends over time.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title

ID

Type

Description

Event Date

event_date

date

The date the event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).

Event Day

event_date.day

date

The day the event occurred. Derived from event_date.

Event Week

event_date.week

date

The Sunday of the week during which the event occurred. Derived from event_date.

Event Month

event_date.month

date

The month during which the event occurred. Derived from event_date.

Event Quarter

event_date.quarter

date

The first month of the quarter during which the event occurred. Derived from event_date.

Event Year

event_date.year

date

The year during which the event occurred. Derived from event_date.

About

about

string

A short description of the page, often provided by the business or creator.

Example value: Custom apparel designed to stand out

Category

category

string

The business category assigned to the page.

Example values: Marketing Agency, Business service

Channel

channel

string

The channel where the page was published.

Example value: meta-analytics

Cover URL

cover_url

string

The URL of the page's cover image.

Example value: https://scontent-example.fbcdn.net/v/t39.30808-6/cover_image.jpg

Image URL

image_url

string

The URL of the page's profile image.

Example value: https://scontent-example.fbcdn.net/v/t39.30808-1/profile_image.jpg

Page ID

page_id

string

The unique identifier assigned to the page by the platform.

Example value: 123456789012345

Page Name

page_name

string

The name of the social media page.

Example values: Acme Apparel, Horizon Handcrafted Soaps

Permalink

page_permalink

string

The permanent link to the social media page.

Example value: https://www.facebook.com/123456789

Website

website

string

The website URL associated with the page.

Example values: https://example.com/products/sample-product, https://www.example.com/

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

TitleIDTypeDescription
Fan Addsfan_addsnumericThe number of new fans (followers) who followed the page during the selected period.
Fan Removesfan_removesnumericThe number of fans (followers) who unfollowed the page during the selected period.
ImpressionsimpressionsnumericThe total number of times any content from or about the page was shown on a user's screen, including posts, ads, stories, mentions, and shares. Includes repeat exposures.
Paid Impressionsimpressions_paidnumericThe total number of times paid content from the page, such as ads or boosted posts, was shown on a user's screen. Includes repeat exposures.
Unique Impressionsimpressions_uniquenumericThe number of unique users who saw any content from or about the page during the selected period.
Viral Impressionsimpressions_viralnumericThe number of times content from the page was displayed to users through social interactions, such as shares, mentions, or recommendations.
Likes AddedlikesnumericThe number of likes added to the page during the selected period.
Likes RemovedunlikesnumericThe number of likes removed from the page during the selected period.
Video Viewsvideo_viewsnumericThe number of times videos were viewed on the page during the selected period.
Total Viewsviews_totalnumericThe total number of times users visited the page itself during the selected period, including repeat visits.