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 |
| 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 |
| date | The day the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
About |
| string | A short description of the page, often provided by the business or creator. Example value: |
Category |
| string | The business category assigned to the page. Example values: |
Channel |
| string | The channel where the page was published. Example value: |
Cover URL |
| string | The URL of the page's cover image. Example value: |
Image URL |
| string | The URL of the page's profile image. Example value: |
Page ID |
| string | The unique identifier assigned to the page by the platform. Example value: |
Page Name |
| string | The name of the social media page. Example values: |
Permalink |
| string | The permanent link to the social media page. Example value: |
Website |
| string | The website URL associated with the page. Example values: |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
Title | ID | Type | Description |
---|---|---|---|
Fan Adds | fan_adds | numeric | The number of new fans (followers) who followed the page during the selected period. |
Fan Removes | fan_removes | numeric | The number of fans (followers) who unfollowed the page during the selected period. |
Impressions | impressions | numeric | The 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 Impressions | impressions_paid | numeric | The 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 Impressions | impressions_unique | numeric | The number of unique users who saw any content from or about the page during the selected period. |
Viral Impressions | impressions_viral | numeric | The number of times content from the page was displayed to users through social interactions, such as shares, mentions, or recommendations. |
Likes Added | likes | numeric | The number of likes added to the page during the selected period. |
Likes Removed | unlikes | numeric | The number of likes removed from the page during the selected period. |
Video Views | video_views | numeric | The number of times videos were viewed on the page during the selected period. |
Total Views | views_total | numeric | The total number of times users visited the page itself during the selected period, including repeat visits. |
Updated about 21 hours ago