CSV Export Schema

This page documents the columns of the main CSV exports. CSV export is available on paid plans, including the trial; on other plans each page's export stays in its menu with a lock and opens the plan picker. Column sets can change as the product changes, so read columns by header name rather than by position. Cells that hold a status or category carry the same label the dashboard shows.

File names and header lines

Every export filename follows the shape surfacedby-{workspace_slug}-{section}-{domain}-{YYYY-MM-DD}.csv, so a downloaded file is self-describing when you belong to several workspaces. On the Agency plan, which includes white-label exports, the surfacedby- prefix is dropped and the title line of a multi-table export starts with your workspace name instead of SurfacedBy.

Single-table exports start with three comment lines before the column headers, so you can skip them when you import the data:

# Workspace,Acme Marketing (acme-marketing)
# Domain,yourbrand.com
# Section,tracked-prompts

The Plans export uses a longer comment block that also carries the export date and, when you export a single plan, the plan name, followed by a blank line.

The Overview, AI Visibility, and Trends exports hold several tables in one file: a short header block (title, workspace, domain, export date), then each table under its own title, separated by blank lines.

Measurement scope

The Tracked prompts and AI responses exports (Measurement Scope) and the Plans export (Source Scope) fill a scope column with one of two values:

Daily Check: the focused daily review that picks up recent movement quickly.
Full Check: the complete tracked Prompt and platform set, used for rank, reports, and durable competitor comparisons.

The values match the scope labels on the dashboard, so a spreadsheet filter lines up with what you see on screen. See Measurement scope.

The Your pages and Sources exports carry Sparkline Scope Coverage instead: how many days of the row's trend line came from each scope, for example Full:5 Daily:2. Competitor rows combine answers from both scopes, so the Competitors export has no scope column.

Your pages

Exported from Citations & Sources > Your pages (section citations-urls). One row per page on your site that AI platforms cited in the selected period.

Column	Meaning
`URL`	Full URL of the cited page.
`Page Type`	The kind of page, for example `Product`, `Pricing`, `Features`, or `Other`.
`Current Citations`	Citations in the selected period.
`Lifetime Citations`	Citations since the domain was first checked, or `N/A`.
`Citation Rate`	Share of AI answers that cite this page, for example `12.5%`, or `N/A`.
`Trend`	`Improving`, `Declining`, `Stable`, or `New` compared with the previous check of the same scope, or `N/A`.
`Platforms`	The AI platforms that cited the page, by name, separated by `\|`.
`Opportunity Score`	`Missed Prompts` as a percentage of `Cited Prompts` plus `Missed Prompts`, or `N/A`.
`Cited Prompts`	Number of Prompts where this page was cited in the last 90 days and the latest check of the Prompt still cites it.
`Missed Prompts`	Number of Prompts where this page was cited in the last 90 days, but the latest check of the Prompt cited a competitor and not this page.
`Co-Mentioned Brands`	Other brands cited alongside the page, as `domain(count)` pairs separated by `\|`.
`First Cited`	When the page was first cited, or `N/A`.
`Last Cited`	When the page was most recently cited, or `N/A`.
`Sparkline Scope Coverage`	Days of the trend line from each scope, for example `Full:5 Daily:2`.

Sources

Exported from Citations & Sources > Sources (section citations-domains). One row per third-party site AI platforms cited for your Prompts.

Column	Meaning
`Source Domain`	The cited site.
`Display Name`	The site's display name.
`Source Type`	Source category, for example `Editorial`, `Community`, `Competitor`.
`Source Format`	Kind of page, for example `Review site`, `Forum`, `Best-of list`, or empty.
`Total Mentions`	AI answers in the period that cited this site.
`Included Mentions`	Of those, answers that also mentioned you.
`Co-Appearance Rate`	`Included Mentions` as a percentage of `Total Mentions`.
`Status`	`Cited with you` if the site appeared in at least one answer that mentioned you, otherwise `Cited without you`.
`Influence`	`Deciding`, `Supporting`, or empty.
`Top Platform`	The AI platform that cites this site most, or `N/A`.
`Opportunity Score`	How much there is to gain from being present on this site.
`Citing Prompts`	Number of tracked Prompts whose answers cite this site.
`Is New`	`Yes` if the site is newly cited, otherwise `No`.
`Rate Delta`	Change in `Co-Appearance Rate`, or `N/A`.
`Sparkline Scope Coverage`	Days of the trend line from each scope, for example `Full:5 Daily:2`.

Tracked prompts

Exported from the Active tab of Tracked Prompts (section tracked-prompts). One row per Prompt and AI platform that was actually checked. Prompts that have not been checked yet, and platforms a Prompt was not checked on, have no row.

Column	Meaning
`Prompt`	The Prompt text.
`Country`	Country code the Prompt is checked in.
`Platform`	The AI platform, for example `ChatGPT`.
`Country Confidence`	`Country verified` or `Country approximate`: how reliably the answer reflects the chosen country.
`Presence`	Your presence in that platform's answer: `Cited`, `Named`, `Considered`, or `Missing`. See Brand presence.
`Position`	Your position in the answer, prefixed with `#`, or `N/A`.
`Citation URL`	Your page the platform cited, or `N/A`.
`Platform coverage %`	Share of the checked platforms that mention you for this Prompt.
`Status`	`Surfaced`, `Partially surfaced`, `Not surfaced`, or `Awaiting check`.
`Priority Score`	How much attention the Prompt needs, from 0 to 100; higher needs more. It rises when fewer platforms mention you, when competitors appear in its answers where you do not, and when the tone of its answers about you is weak.
`Priority Level`	`High priority`, `Medium priority`, or `Low priority`, grouped from `Priority Score`.
`Relevance`	`High`, `Medium`, `Low`, or `N/A`.
`Historical Brand Coverage`	The Prompt's long-run rate of answers that mention you, or `N/A`.
`Pinned`	`Yes` if you pinned the Prompt, otherwise `No`.
`CPC (USD)`	Cost per click for the matching search term, where known.
`Est. traffic value (USD)`	Estimated traffic value, where known.
`Monthly Value (USD)`	Estimated monthly value, where known.
`Sentiment Score`	0 to 100, where higher is more positive.
`Sentiment Label`	`Positive`, `Neutral`, `Negative`, or `Mixed`.
`Measurement Scope`	`Daily Check` or `Full Check`: the check the table on screen shows.

The Inactive tab exports as section inactive-prompts, with the columns Prompt, Country, Status (Paused or Archived), Last Coverage (or Not recorded), and Inactive Since.

Competitors

Exported from Competitors (section competitors). One row per competitor you track.

Column	Meaning
`Competitor Domain`	The competitor's domain.
`Display Name`	Human-readable name, or the domain when none is set.
`Market Position`	Rank among the brands you track, prefixed with `#` (for example `#3`), or `N/A`.
`Market Position Change`	Change versus the previous comparable check, or `N/A`.
`Citation position`	0 to 100 strength of where the competitor appears in answers, or `N/A`.
`Trend`	`Rising`, `Stable`, `Declining`, or `N/A`.
`AI Mentions`	AI answers that mention the competitor.
`Mentions Change`	Change versus the previous comparable check, or `N/A`.
`Share of Voice (%)`	The competitor's share of mentions across the brands you track.
`Share Change`	Change in Share of Voice, or `N/A`.
`Prompt Coverage (%)`	Share of your tracked Prompts whose AI answers mention the competitor.
`{Platform} Citations`	One column per AI platform your workspace tracks, for example `ChatGPT Citations`.
`Source`	How the competitor was added: `Added by you`, `Confirmed during onboarding`, `Auto-discovered`, `AI-cited`, `From SEO data`, or `AI-discovered`.

AI responses

Exported from AI Responses (section ai-responses). One row per AI answer that matches the current filters, up to 3,000 answers.

Column	Meaning
`Platform`	The AI platform.
`Prompt`	The Prompt sent to the platform.
`Country`	Country code.
`Country confidence`	`Country verified` or `Country approximate`.
`Presence`	`Cited`, `Named`, `Considered`, or `Missing`.
`Cited`	`Yes` when `Presence` is Cited, otherwise `No`.
`Source only`	`Yes` when the answer cites your page as a source but its text neither names you nor links you, otherwise empty.
`Named`	`Yes` when `Presence` is Named, otherwise `No`.
`Considered`	`Yes` when `Presence` is Considered, otherwise `No`.
`Position`	Your position in the answer, prefixed with `#`, or empty.
`Sentiment`	`Positive`, `Neutral`, `Negative`, `Mixed`, or empty.
`Score`	Sentiment score (0 to 100).
`Tone`	Tone of the answer.
`Hedging`	`Hedged` if the answer hedged, otherwise empty.
`Answer Preview`	First 200 characters of the answer.
`Sources`	Number of sources the answer cited.
`Top co-mention`	The domain most often mentioned alongside you in the answer.
`Competitors Mentioned`	Competitors named in the answer, separated by commas.
`Measurement Scope`	`Daily Check` or `Full Check`.
`Date`	When the answer was captured (ISO 8601).

Plans

Exported from Plans (section plans). One row per plan item on the domain.

Column	Meaning
`Title`	Item title.
`Plan`	The plan the item belongs to.
`Section`	Section label.
`Priority`	Impact label.
`Effort`	Effort label.
`Effort Hours`	Estimated hours, when set.
`Status`	Status label.
`Source`	Where the item came from.
`Source Scope`	`Daily Check`, `Full Check`, or empty.
`Owner`	Owner email.
`Country`	Country from the item's evidence.
`Step Progress`	Completed steps out of recommended steps, for example `2/5`.
`Due Date`	Due date, or empty.
`Notes`	Your notes.
`Started`	When work started (ISO 8601), or empty.
`Completed`	When the item was completed (ISO 8601), or empty.
`Reason`	Why the item was recommended.
`Action`	The kind of action, for example `Create content` or `Improve source presence`.
`Failure Mode`	The diagnosis, for example `Source coverage`.
`Source Mix`	Source categories behind the item, for example `Editorial x3, Community x1`.
`AI Cites`	The competitor AI platforms cite for the item's Prompt, when there is one.
`Topics`	Topics the item's Prompt belongs to.

Other exports

These pages also export CSV: Overview (headline numbers, platform breakdown, top competitors, top cited pages, recommendations), AI Visibility, Trends (Visibility Score, AI Mentions, average position, and Brand Coverage over time, each with its scope, plus sentiment by Brand Theme when available), Citations & Sources > Communities, Opportunities and dismissed opportunities, Tracking, the page checks in Tools, and the brand list on the workspace home.

Encoding

Exports are UTF-8 text with comma separators. Values containing commas, quotes, or line breaks are quoted, with inner quotes doubled. Values that begin with =, +, -, @, a tab, or a carriage return are prefixed with a single quote so spreadsheet apps do not run them as formulas.

On this page