Social Media Brand Mentions Table

social_media_brand_mentions_table

The Social Media Brand Mentions table captures public posts referencing your brand via tracked keywords, hashtags, or direct mentions, including author metadata and conversation context. One row per mention.

📋
Table Guide
What You Can Answer With This Table

How many brand mentions am I getting, and by which keyword or hashtag? — use matched_keyword, mention_type, group by matched_keyword or mention_type

What's the sentiment of brand mentions over time? — use sentiment, event_date, group by event_date and sentiment

Which topics are driving mentions? — use topic, mention_text, group by topic

Who is mentioning my brand, and how often? — use author_username, author_name, group by author_username

Which mentions start a thread vs. reply to an existing one? — use is_thread_starter, reply_to_post_id, conversation_id

Before You Query

This table is not time-series. No event_date filter is required. Use event_date or created_at if you want to narrow to when the mentioning post was created.

post_id and reply_to_post_id refer to posts by other accounts (the ones mentioning your brand). They do not join to the Social Media Posts table, which only contains posts on your own connected pages.

When to Use a Different Table

For posts you published on your own connected pages → use Social Media Posts. This table only contains public posts by other accounts mentioning your brand.

For comments made directly on your posts → use Social Media Comments.

For page-level reach and engagement on your own pages → use Social Media Pages.

View the full Triple Whale Data Ontology →

Dimensions

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

Title	ID	Type	Description
Event Date	`event_date`	date	The date the post containing the mention was created. 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 made the mention. 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 post containing the mention 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	The time the post containing the mention was created. Formatted according to the ISO 8601 international standard. Example value: `2025-07-16 04:32:29`
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 1 day ago