How to See the Ranking Page URL for Your Keywords in Google Search Console

When I’m viewing Performance reports in Google Search Console, I find it frustrating that I can’t see the landing page URLs for my search queries. Doesn’t it help to know which page is ranking for a given keyword? Yes, yes it does.

Thankfully, you can easily fix this problem using Google Data Studio. Check it out:

How to use Google Data Studio to see landing page URLs for each keyword

2. Create a table and select your Google Search Console data source. Set up your table’s dimensions and metrics as shown in the screenshot below:

3. View your table and you’ll now be able to see the landing page URL for each keyword.

But how come you can’t add a column for Average Position? Search Console doesn’t calculate keyword ranking positions at the URL level, but rather at the site level. Hence, it’s not available in the URL Impression report. So, you have two options:

You could export and combine your data from Google Search Console and Google Data Studio into one spreadsheet using vlookups, or;

You can use Google Data Studio’s “blend data” feature to add a column to your table for Average Position (I’ll show you how to do this next)

Use Data Studio’s blend data feature to add the Average Position to your table

1. In the same Data Studio report, add Google Search Console’s Site Impression report. You should now have both data sources added.

Hey Joshua – is your blended data configured exactly as shown in step 4? I run into errors with Data Studio quite often, even when things seem to be set up correctly. When that’s the case, here are a few ways I’ll try to troubleshoot the error:

Remove and re-add the data source

Remove any filters you may have added (or copied over)

Hit the “Refresh data” button in the top-right menu

If you have any more details on the error message you’re seeing, I’m happy to try and help you figure out what’s going wrong.

You are correct in that the average position is still based on site data, not individual URL data. However, I find it helpful to be able to view which URLs rank for each keyword. If you have a keyword that is associated with multiple landing pages, then the position you see in your table will be averaged across all of those individually-ranked pages.

Hello Alex, have you found the solution for identical keyword but for different LP will remain the same problem? I am facing same problem and I need to know each keyword position for each LP
Would you please share your solution if you have found?

Hi Griffin, first off I wanna say thanks for the awesome tutorial but it could have been excellent if we don’t get an error when adding the Blended Data source. Apparently I can’t get it to work because of the Join Keys. Landing Page does not appear as an option in GSC Site Impression data? I need this for a report.Please help! 🙁

Hi Windee, I just went through the instructions again to confirm they work as shown. Follow the screenshots carefully… when you blend the two data sources (URL Impression & Site Impression) you remove “Landing Page” as a join key and add it back as a dimension in the URL Impression data. Only “Query” is used as the join key. Hope this helps you complete your report.

Hi,
thanks for the tutorial. However when I tried following this, the average position was different compared to the one displayed in google search console. I also added score cards to summarise the total clicks and impressions, for a specific landing page (I added a filter for landing page), but they are different to the totals in google search console. The numbers for individual queries of the landing page are the same (except for the average position, as mentioned above). Do you have any idea why this happens?

The reason for the discrepancy is that the Average Position metric comes from GSC’s Site Impression data. This means that the Average Position you see is not specific to the landing page, but rather to the keyword’s average ranking for your entire website. Unfortunately, this is the only way to tie the data together in Data Studio and I recognize that it has limitations.

When you look at the keyword’s Average Position in Google Search Console and filter by landing page, you’ll see the Average Position for THAT keyword on THAT page. Let me know if you need further clarification.

Hey Griffin,
I think I understand what you are saying, thank you very much!
Just one last thing; I’ve noticed that in both gsc as well as data studio when you add up all the individual clicks for a landing page they don’t match with the total number displayed in the summary card, which is probably due to privacy reasons (google isn’t allowed to list some clicks) at least I’ve read something like that. But when using the blended data, the summary card shows the smaller amount of clicks (only the clicks that google is allowed to show are added up). Have you noticed this discrepancy as well? And is there maybe a way to change this, and have the actual total displayed? Would you recommend to just not use the blended data in this case?

Interesting. I haven’t noticed a discrepancy in the “URL Clicks” metric between GSC and GDS when using blended data. Although, this isn’t something that I’ve looked into before. In this case, I would recommend using unblended data since this metric is readily available by selecting the “URL Impression” option when adding GSC as a data source.