Social Media Mentions Table

social_media_mentions_table

The Social Media Mentions table captures public posts that reference your brand through tracked keywords, hashtags, or direct user mentions, and includes author metadata, conversation context, and post text and metadata. Querying this table allows you to monitor brand visibility, analyze conversation patterns, and investigate individual mentions across channels.

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`.
Author ID	`author_id`	string	The ID of the user that made the mention. Example value: `987654321098735`
Author Name	`author_name`	string	The name of the user that published the post. Example value: `John Smith`
Author Username	`author_username`	string	The username of the user that made the mention. Example value: `example_username`
Channel	`channel`	string	The channel where the page was published. Example values: `meta-analytics`, `twitter-social`
Conversation ID	`conversation_id`	string	The ID of the conversation that the mention is in. Example value: `123456789012345`
Created Date	`created_at`	timestamp
In Reply to User ID	`in_reply_to_user_id`	string	The ID of the user that the mention is replying to. Example value: `123456789012345`
Is Thread Starter	`is_thread_starter`	boolean	Indicates whether the post that the mention is in is the first in a thread. Possible values: `true`, `false`
Matched Keyword	`matched_keyword`	string	The keyword that was matched in the mention. Example values: `running shoes`, `cheap flights`, `best coffee`
Mention Text	`mention_text`	string	The text content of the mention. Example value: `@example_user thanks for the shoutout!`
Mention Type	`mention_type`	string	The type of mention. Example values: `keyword`, `user`, `hashtag`
Mentioned Post ID	`post_id`	string	The ID of the post that the mention is in. Example value: `123456789012345_987654321098765`
Mentioned Post Permalink	`post_permalink`	string	The permanent link to the post containing the mention on the social platform. Example value: `https://www.facebook.com/123456789/posts/987654321`
Reply to Post ID	`reply_to_post_id`	string	The ID of the post that the mention is replying to. Example value: `123456789012345`
Sentiment	`sentiment`	string	The sentiment of the mention. Example values: `positive`>, `negative`, `neutral`
Topic	`topic`	string	The topic of the mention. Example value: `custom t-shirt`
Mentioned User ID	`user_id`	string	The ID of the user who was mentioned. Example value: `123456789012345`

Updated about 5 hours ago