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

What sentiment, topics, or authors are driving brand mentions? — use sentiment, topic, author_username

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

Use Social Media Posts table when you need posts published on your own connected pages. The Social Media Brand Mentions table is for public posts by other accounts mentioning your brand.

Use Social Media Comments table when you need comments made directly on your posts. The Social Media Brand Mentions table is for public brand mentions on other accounts' posts.

Use AI Visibility table when you need brand mentions inside LLM prompt results or AI answers. The Social Media Brand Mentions table is for public social posts by other accounts mentioning your brand.

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 11 days ago