Ranking and AI Exports

What is it?

Rank tracking and the LLM Tool have their own download buttons. Unlike the table exports in Advanced Analytics, most of these files are made on Prism's server. Your browser then downloads them.

This page lists every download on these screens:

• Google SERP, Bing, Google Play Store, Apple App Store and YouTube rankings
• SERP features
• Keyword Setting in the Client panel
• The LLM Tool (AI Visibility) screens

Why use it?

• Send ranking reports to a client or manager.
• Keep a dated copy of where your keywords ranked.
• Work on citation or sentiment data in a spreadsheet.
• Back up or check the keyword list a project tracks.

Before you start

• Pick the right tracking project in the Project dropdown on the screen.
• Set your filters and dates first. Exports use what you have selected.
• Allow pop-ups for Prism. LLM Tool exports open in a new tab.

How to use it

1. Open the screen

   For example, go to Search Rankings→Google SERP.

2. Set your filters

   Choose the project, Select Brand, Category, Sub Category, Start Date and End Date.

3. Open the tab you need

   Pick Overview, Keywords, SERP Features or SERP Unified.

4. Click the download button

   Click Export, Opportunity, Download Opportunity or Download, depending on the table. Wait for the file to download.

Understanding the screen

Rank tracking keywords

The Keywords tab of Google SERP, Bing Rankings, Google Play Store, Apple App Store and YouTube Ranking has two buttons:

• Export
• Opportunity

Both files are made on Prism's server. They use your filters, the text in the search box and the keyword group you picked, such as All Keywords or Top 3. While the file is made, the button shows Exporting…. If the server sends nothing back, you see "Export failed: no file was returned."

Group Wise Ranking

The Group Wise Ranking table on each Overview tab has an Excel download. Prism builds this file in your browser. The sheet is named "Group Wise Ranking". The file name starts as shown below, followed by a code for the tracking project:

On Google SERP, the table shows each rank group by date, with KW (keyword count), SV (search volume) and SOV% (share of voice) for each date. On the other screens it shows keyword counts only.

SERP features

On Google SERP:

• SERP Features tab: the SOV Metrics box has a Download Opportunity button. The feature table below it has an Export button.
• SERP Unified tab: the SERP Feature Matrix has a Download button. It shows Downloading… while the file is made on the server.

A SERP feature is a special result on Google's page, such as a Featured Snippet or People Also Ask.

Keyword Setting

In the Client panel, open Keyword Setting. You can:

• click Export Keywords to download the tracked keywords. The file is named after the channel: google-keywords.xlsx, bing-keywords.xlsx, play-store-keywords.xlsx, apple-store-keywords.xlsx youtube-keywords.xlsx or llm-keywords.xlsx (for AI prompts).
• click Download sample file in the upload box to get a template with the right headers. Uploads accept .xlsx and .xls files only.

See Keywords and prompts.

Generated prompts

When you set up an AI (LLM) tracking project in the Client panel, you can let Prism write prompts for you with ✦ Generate with AI (instead of Upload Excel). When the prompts are ready, click Export Excel to download them. The file has three columns: Prompts, Category and SubCategory. Its name is your project name, then today's date, then "llm", for example Acme_2026-10-16_llm.xlsx. You can edit this file and upload it again later.

LLM Tool

These LLM Tool tables have an Export button:

Prism makes the file on its server and opens the download link in a new tab. The file uses your filters, and the search box and brand where the table has them. On Responses, Export is greyed out when there are no results.

Understanding the data

• Rank tracking exports use the project, brand, category and dates you selected.
• LLM Tool exports use the date and filters in the filter bar, such as All Platforms and All Categories.
• LLM Tool screens have no compare period. Each export is for the single date you picked in Select Date.

Example

For example, your manager wants a weekly ranking report. You open Google SERP, pick your project, and set Start Date and End Date to cover the last week. On the Overview tab, you download the Group Wise Ranking Excel file. It shows how many keywords sit in each rank group on each date. You attach the file to your weekly email.

Tips

• Set your filters before you click a download. Changing them later needs a new export.
• Use Download sample file in Keyword Setting before you upload new keywords. Headers must match exactly.
• If an LLM Tool export does not open, check your browser's pop-up blocker first.

Common issues

"Export failed: no file was returned." The server did not return a file. Check that the table has data for your dates, then try again. If it still fails, email enquiry@techmagnate.com.

An LLM Tool export does nothing. Prism shows no message when an LLM export fails. Allow pop-ups for Prism and try again. See Feature issues.

"No ranking data for the selected filters." There is nothing to export. Widen your dates or click Reset.