MGWM

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

Table of Contents

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:

Before (Keywords, but no Landing Page URLs)

After (Keywords, with Landing Page URLs)

Here’s what we’ll cover in this article:

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

1. Create a new Google Data Studio report. Add Google Search Console as a data source and select URL Impression.

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.

2. Using the same table your previously created, click Blend Data.

3. Click “Add Another Data Source” and select your GSC Site Impression data.

4. Set up your data source as shown in the screenshot below:

5. You can now add a column for Average Position to your table.

There it is, you've got keyword, landing page URL and average position all in one table.

Griffin Roer

Griffin Roer

Griffin has spent more than a decade in the search engine marketing industry. After years of working as an SEO consultant to some of the country’s largest retail and tech brands, Griffin pursued his entrepreneurial calling and founded Uproer in May of 2017. He's also served as a board member for the Minnesota Search Engine Marketing Association.

See More Insights

SearchLite - Don't Sleep on Category Page Content

This month’s SearchLite intro was written by Content Manager, Skye Sonnega Hey everyone, We recently livened up this dull Minnesota winter with two fantastic additions to the Uproer team! Eric Davison joined as a Senior SEM Analyst, and Jenny Hudalla joined as a Content Specialist. These folks are bright, hardworking, Minnesota-local, and coming in

Read More
MGWM

Sr. Manager, SEO & Operations

Dave Sewich

Dave made an accidental foray into digital marketing after graduating from the University of Minnesota Duluth and hasn’t looked back. Having spent the first part of his marketing journey brand-side, he now works with the Uproer team to help clients realize their goals through the lens of search.

When not at work, you’ll find Dave staying active and living a healthy lifestyle, listening to podcasts, and enjoying live music. A Minnesotan born and raised, his favorite sport is hockey and he still finds time to skate once in a while.

Dave’s DiSC style is C. He enjoys getting things done deliberately and systematically without sacrificing speed and efficiency. When it comes to evaluating new ideas and plans, he prefers to take a logical approach, always sprinkling on a bit of healthy skepticism for good measure. At work, Dave’s happiest when he has a chance to dive deep into a single project for hours at a time. He loves contributing to Uproer and being a part of a supportive team but is most productive when working solo.

Founder & CEO

Griffin Roer

Griffin discovered SEO in 2012 during a self-taught web development course and hasn’t looked back. After years of working as an SEO consultant to some of the country’s largest retail and tech brands, Griffin pursued his entrepreneurial calling of starting an agency in May of 2017.

Outside of work, Griffin enjoys going to concerts and spending time with his wife, two kids, and four pets.

Griffin’s DiSC style is D. He’s driven to set and achieve goals quickly, which helps explain why he’s built his career in the fast-paced agency business. Griffin’s most valuable contributions to the workplace include his motivation to make progress, his tendency towards bold action, and his willingness to challenge assumptions.