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 GuideWhat 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_usernameBefore You Query
- This table is not time-series. No
event_datefilter is required. Useevent_dateorcreated_atif you want to narrow to when the mentioning post was created.post_idandreply_to_post_idrefer 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.
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 4 days ago