AI Visibility Table

The AI Visibility table captures LLM prompt execution results for a shop. One row per prompt execution, including the prompt, response preview, shop mention flag, competitor visibility, and cited sources.

📋
Table Guide
What You Can Answer With This Table

How often is my shop mentioned in AI answers? — use visibility_percentage, is_mentioned

Which topics or prompts are driving AI visibility? — group by topic_name, prompt_text

Which sources are cited in AI responses? — use sources.source_domain, sources.source_url

Before You Query

Required field: event_date

When to Use a Different Table

Use Social Media Brand Mentions table when you need public social posts that mention your brand. The AI Visibility table is for brand mentions inside LLM prompt results and AI answer visibility.

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 AI visibility prompt execution ran. 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`.
Competitors Visibility	`competitors_visibility`	record repeated	Competitor visibility data for the prompt execution. Each record represents a competitor and whether they were mentioned in the LLM response.
Competitor ID	`competitors_visibility.competitor_id`	string	Unique identifier for the competitor. Example value: `6801a2f3c9e7b54d1023ef89`
Competitor Name	`competitors_visibility.competitor_name`	string	Display name of the competitor. Example value: `Acme Co`
Competitor URL	`competitors_visibility.competitor_url`	string	URL of the competitor. Example value: `https://acmeco.com`
Competitor Is Mentioned	`competitors_visibility.is_mentioned`	boolean	Whether this competitor was mentioned in the LLM response. Possible values: `true`, `false`
Prompt Execution Timestamp	`event_timestamp`	timestamp	Timestamp of when the prompt execution ran (UTC). Example value: `2026-01-10 10:04:06`
Prompt Execution ID	`execution_id`	string	Unique identifier for a single prompt execution. Example value: `985c7f1d-0f6e-4ae5-bbbc-50f5b3c8353e`
Is Mentioned	`is_mentioned`	boolean	Whether the shop was mentioned in the response. Possible values: `true`, `false`
LLM	`llm`	string	The LLM that was used for the prompt execution. Example values: `chatgpt`, `gemini`
Prompt ID	`prompt_id`	string	The prompt identifier associated with the execution. Example value: `29431f0b8fb1900972f8f121`
Prompt Text	`prompt_text`	string	The prompt text used for the execution. Example values: `What’s the best heritage flour for everyday baking?`, `What makes seed oil free bars better?`, `What features should I look for in skis for moderate skill level?`
Response Preview	`response_preview`	string	Preview of the LLM response (first 200 characters). Example value: `Here are some of the best heritage flours you can use for everyday baking…`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
Cited Sources	`sources`	record repeated	Citations/sources returned by the LLM for the prompt execution. Each record represents one cited source.
Cited Source Domain	`sources.source_domain`	string	Domain of a cited source. Example value: `exampleshop.com`
Cited Source URL	`sources.source_url`	string	URL of a cited source. Example value: `https://exampleshop.com/products/heritage-bread-blend-flour?utm_source=chatgpt.com`
Citation Order	`sources.citation_order`	numeric	Order of the citation in the response (lower numbers appear earlier). Example value: `2`
Topic ID	`topic_id`	string	The topic identifier associated with the prompt execution. Example value: `495be1b1787a86e9ae3dadd3`
Topic Name	`topic_name`	string	The topic name associated with the prompt execution. Example value: `Flour`, `Seed Oil Free`, `Skis`

Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

Title ID Type Description

Visibility Percentage

Title	ID	Type	Description
Visibility Percentage	`visibility_percentage`	formula	Percentage of prompt executions where the shop was mentioned in the LLM response. Visibility % = Number of Mentions / Number of Prompt Executions

visibility_percentage

formula

Percentage of prompt executions where the shop was mentioned in the LLM response.

Visibility % = Number of Mentions / Number of Prompt Executions

Updated 7 days ago