Back to Blog

How To View Search Console Queries, Clicks & Landing Pages In One Location

March 6, 2018

By Jennifer Kaite
No Comments

Have you ever wanted to see query and landing page data in one spot? Now, I know what you’re thinking… can’t you view a list of queries and pages in Search Console and Google Analytics? Yes, you absolutely can but there is not an option to view them together.  Search Console allows you to see a list of queries, but to view the pages you have to click on that specific query and cannot be filtered together. In Google Analytics, you can view search queries but again cannot add a secondary dimension allowing you to place search query and landing page data in one table. We have the answer to this dilemma, thanks to a handy reporting tool, Google Data Studio.

Check out our Wednesday Wisdom from Greg!  He shows you how you can build a custom table with the specific dimensions and metrics you choose in Data Studio. That’s right, you have the option to display queries and their landing pages together, including the number of URL clicks. Follow along with Greg in the video above or down below with our step-by-step instructions with screenshots.

Step 1: Creating your table

The first step is to create your table. To do this you will go to the toolbar at the top and find the chart symbol.

Next, select the table to start adding the dimensions and metrics you want to display. You can find those in the right-hand toolbar.

Step 2: Selecting Your Dimensions & Metrics

Using the right-hand toolbar, set your source to “Search Console” and then you can choose the dimensions & metrics you want to display.

When you open the dimension picker select “query.” To add another dimension click “Add dimension here” and choose “landing page” from the menu. Repeat the same process for the metric and select “URL Clicks.”

Tip: If you want to only show URL clicks greater than zero, you can create a filter located at the bottom of your toolbar.

Step 3: Exporting Your Data

Once you have created your table you have the option of exporting it into google sheets, excel or a csv. Then you can manipulate this data in any way you see fit.

And it’s as simple as that! We hope this short guide has benefited you. Follow along on our social media for future Wednesdays Wisdom and keep a lookout for more helpful blogs like this one!

Jennifer Kaite

Jennifer Kaite

Jenn is a Digital Marketing Coordinator at Cypress North. She assists with multiple client projects in any way she can. Jenn’s day to day tasks range from data collection to reporting, social media marketing to content creation, and much more. Jenn takes pride in the work she produces, facing new challenges with a positive attitude and determination that produces powerful results.

See Jennifer's Most Recent Posts

Share this post

Leave a Reply

Search our blog

Start A Project


What's next? might like one of these


How to Create a High-Quality Email...

Optimizing Your Contact Database for Effective Email...

Read article


How to Set Up Google Ads Automated Rules

Learn How To Set Up Automated Rules In Google Ads &...

Read article


Importing Campaigns from Google Ads into...

Learn How To Import Campaigns Into Microsoft & Common...

Read article