Rank Tracking
Keywords and Prompt Files
Upload the keywords and AI prompts Prism tracks, using Excel files with the exact column headers Prism expects.
3 min read Updated
What is it?
Prism tracks the keywords and prompts you give it in an Excel file.
- Keywords are used by rank tracking: Google SERP, Bing, Play Store, App Store and YouTube.
- Prompts are used by AI Visibility, the LLM Tool in your Prism sidebar. A prompt is a question Prism asks AI platforms.
You upload these files in two places in the Client panel:
- Keyword Setting — in the sidebar group Keyword Setting.
- The project form in Project settings, when you create or edit a tracking project.
Why use it?
- To start tracking a new project.
- To add, remove or change keywords and prompts.
- To group them by brand, category and sub-category, so you can filter your reports.
Before you start
You need admin or owner access to open the Client panel. See Roles and permissions. If you do not have access, you see You need admin or owner access on at least one project to open this panel.
How to use it
Open the Client panel
In the Prism top bar, open the Current Project switcher and click + New project. This opens the Client panel.
Open Keyword Setting
In the Client panel sidebar, click Keyword Setting. Or open Project settings and edit a project.
Get the sample file
Click Download sample file. You get
sample-keywords.xlsxorsample-prompts.xlsx.Fill in your rows
Keep the header row exactly as it is. Add one keyword or prompt per row.
Upload the file
Upload your .xlsx or .xls file. On the project form, click Save changes.
Understanding the screen
File headers
The header row must match exactly. The columns can be in any order, but nothing can be missing and nothing extra can be added.
| File | Headers |
|---|---|
| Keywords | Keywords, Brand, Category, SubCategory |
| LLM prompts | Prompts, Category, SubCategory |
The Category and SubCategory values are what you later filter by, for example with Category and Sub Category on rank tracking screens, or All Categories and All SubCategories on AI Visibility screens.
Download links and export
- Download sample file — a sample file with the right headers.
- Download current file — the file Prism is using now. Start from this one to make changes.
- Export Keywords — on Keyword Setting, downloads your keywords, for example
google-keywords.xlsx.
Understanding the data
Category
A group of your website's pages, such as Blog or Products. You define categories in Category Builder, with regex rules or an Excel upload.
Appears in: Advanced Analytics
Prompt
A question you track in the LLM Tool, such as “best SEO agency in Delhi”. Prism checks how each AI platform answers it.
Appears in: LLM Tool
Example
For example, a keywords file for a shoe shop might look like this:
| Keywords | Brand | Category | SubCategory |
|---|---|---|---|
| running shoes for men | ShoeCo | Running | Men |
| trail running shoes | ShoeCo | Running | Trail |
| leather office shoes | ShoeCo | Formal | Office |
A prompts file for the same shop:
| Prompts | Category | SubCategory |
|---|---|---|
| What are the best running shoes for flat feet? | Running | Advice |
| Which brands make comfortable office shoes? | Formal | Brands |
Tips
- Always start from Download current file when you edit. That way you do not lose rows.
- Keep category names short and spelled the same way every time.
- Write prompts the way a real customer would ask them.
Common issues
| Message | What to do |
|---|---|
| Only Excel files (.xlsx, .xls) are accepted | Save your file as .xlsx or .xls, not .csv. |
| You can only upload Excel files! | Shown on the project form. Use an .xlsx or .xls file. |
| Invalid headers. Expected exactly: …. Missing: …. Unexpected: …. | Fix the header row. Add the missing headers and remove the unexpected ones. Download the sample file to compare. |
Frequently asked questions
Which file types can I upload?
Only Excel files, .xlsx or .xls. CSV files are not accepted for keywords or prompts.
What headers does a keywords file need?
Exactly Keywords, Brand, Category and SubCategory. The order does not matter, but nothing can be missing and nothing extra can be added.
What headers does a prompts file need?
Exactly Prompts, Category and SubCategory, in any order, with nothing missing and nothing extra.
Who can upload keyword files?
Project admins and owners. Keyword files are managed in the Client panel, which viewers cannot open.
Related articles
- Account & TeamProject SettingsView, create and edit tracking projects for each channel, and manage keyword and prompt files, from Project settings in the Client panel.Read
- Rank TrackingGoogle SERPTrack your Google keyword rankings: overview KPIs, ranking trend, group wise ranking, the keyword table and SERP snapshots.Read
- AI VisibilityAI Visibility OverviewRead the AI Visibility Overview screen: KPI cards, visibility trends, the leaderboard, answer positions and top prompts.Read
- Account & TeamRoles and PermissionsWhat owners, admins and viewers can do in Prism, and how project modules and page access decide which pages each member sees.Read
Was this article helpful?
Still stuck? Try troubleshooting or email support.