Connect Power BI to your RankRise results

What you get

Three tables, each refreshed once a day:

• Google rankings. Where each of your tracked pages ranks on Google, week by week.
• AI answers. How often ChatGPT, Claude, Gemini and Perplexity mention you for each question, month by month. Google’s own AI answer is in here too.
• Google share. How much of the first page of Google is yours, compared with your competitors, week by week.

Each refresh brings the full history, so your trend lines stay complete.

Your key

In the app, open Workspace settings, then Connected apps. Under Your keys, type a Key name such as Power BI and choose Make a key. Copy it now. We show it once.

The key starts with rrm_. It can only read your results. It can’t change anything.

Treat the key like a password

If it ever ends up somewhere it shouldn’t, cancel it under Connected apps and make a new one.

Step 1: save the key as a parameter

Put the key in one place, so you only ever change it there.

1. In Power BI Desktop, open Transform data.
2. Choose Manage Parameters, then New Parameter.
3. Name it RankRiseKey. Set the type to Text. Paste your key as the value.
4. Click OK.

Step 2: add the three tables

1. Still in Transform data, choose New Source, then Blank Query.

2. Open Advanced Editor, and replace what is there with this:

   Power QueryCopy

   let
       Source = Web.Contents(
           "https://app.rankrise.com.au/feed/google-rankings",
           [Headers = [Authorization = "Bearer " & RankRiseKey]]
       ),
       Table = Csv.Document(Source, [Encoding = 65001]),
       WithHeaders = Table.PromoteHeaders(Table, [PromoteAllScalars = true])
   in
       WithHeaders

3. Click Done, and name the query Google rankings.

4. Do the same twice more. Change the last part of the address each time:

   • ai-answers for AI answers
   • google-share for Google share

If Power BI asks how to sign in

Choose Anonymous. The key in the query does the work.

Step 3: set the daily refresh

Once you publish the report, set a scheduled refresh of once a day in the Power BI service. Our numbers change at most once a day, so more often gains nothing.

Two things to know

Leave Google’s AI answer out of the main AI score. In the AI answers table, filter counts_in_answer_rate to yes before you work out how often the AI tools mention you. That gives the same percentage you see in the RankRise app. The no rows are Google’s AI answer, which the app shows separately.

Join to your own traffic on the page. Both the Google rankings table and the AI answers table have a page_path column, such as /your-page. The same web address ending appears in Google Analytics. So you can match a page’s rankings and AI mentions to its visits and conversions.

What the columns mean

Google rankings

Column	Meaning
page_path	The tracked page.
ranking_page_path	The page Google showed. Most weeks these are the same.
different_page_ranks	yes when Google showed a different page of yours.
google_ai_overview_cites_us	Whether the AI summary at the top of Google linked to you. Blank means Google showed no summary for that search that week, or we didn’t read it.

AI answers

Column	Meaning
page_path	The page we track for this question.
cited_our_pages	Your pages the answer linked to. We started saving these on 26 October 2026.
cited_pages_known	yes means we saved which of your pages the answer linked to. no means we don’t know. That’s the case for all Gemini answers and for any answer saved before 26 October 2026.
not_answered	How many times we asked an AI tool this question and got no answer back. We leave these out of your mention rate, so a failed request never makes you look worse.

Google share

Column	Meaning
searches_compared	How many searches that week covers. When this number changes, the weeks compare different sets of searches.