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.

TitleIDTypeDescription
Event Dateevent_datedateThe 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 Dayevent_date.daydateThe day the event occurred. Derived from event_date.
Event Weekevent_date.weekdateThe Sunday of the week during which the event occurred. Derived from event_date.
Event Monthevent_date.monthdateThe month during which the event occurred. Derived from event_date.
Event Quarterevent_date.quarterdateThe first month of the quarter during which the event occurred. Derived from event_date.
Event Yearevent_date.yeardateThe year during which the event occurred. Derived from event_date.
Author IDauthor_idstringThe ID of the user that made the mention.Example value: 987654321098735
Author Nameauthor_namestringThe name of the user that made the mention.Example value: John Smith
Author Usernameauthor_usernamestringThe username of the user that made the mention.Example value: example_username
ChannelchannelstringThe channel where the post containing the mention was published.Example values: meta-analytics, twitter-social
Conversation IDconversation_idstringThe ID of the conversation that the mention is in.Example value: 123456789012345
Created Datecreated_attimestampThe 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 IDin_reply_to_user_idstringThe ID of the user that the mention is replying to.Example value: 123456789012345
Is Thread Starteris_thread_starterbooleanIndicates whether the post that the mention is in is the first in a thread.Possible values: true, false
Matched Keywordmatched_keywordstringThe keyword that was matched in the mention.Example values: running shoes, cheap flights, best coffee
Mention Textmention_textstringThe text content of the mention.Example value: @example_user thanks for the shoutout!
Mention Typemention_typestringThe type of mention.Example values: keyword, user, hashtag
Mentioned Post IDpost_idstringThe ID of the post that the mention is in.Example value: 123456789012345_987654321098765
Mentioned Post Permalinkpost_permalinkstringThe permanent link to the post containing the mention on the social platform.Example value: https://www.facebook.com/123456789/posts/987654321
Reply to Post IDreply_to_post_idstringThe ID of the post that the mention is replying to.Example value: 123456789012345
SentimentsentimentstringThe sentiment of the mention.Example values: positive, negative, neutral
TopictopicstringThe topic of the mention.Example value: custom t-shirt
Mentioned User IDuser_idstringThe ID of the user who was mentioned.Example value: 123456789012345