AI Visibility Table

ai_visibility_table

The AI Visibility table captures the results of LLM prompt executions for a shop, including the prompt, a preview of the response, whether the shop was mentioned, and any cited sources. Querying this table helps you track brand/merchant visibility in AI answers over time and analyze which topics, prompts, and citations appear in those responses.

📘
Note
event_date is a required field for queries on this table.

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`.
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`
LLM	`llm`	string	The LLM that was used for the prompt execution. Example values: `chatgpt`, `gemini`
Is Mentioned	`is_mentioned`	boolean	Whether the shop was mentioned in the response. Possible values: `true`, `false`
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	`visibility_percentage`	formula	Percentage of prompt executions where the shop was mentioned in the LLM response. Visibility % = Number of Mentions / Number of Prompt Executions

Title

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

Updated 18 days ago