\n but understanding your data can be a challenge. If you set up a custom dashboard with data visualizations that work for you<\/b>, it might help you
\n make better decisions that are supported by data. This post is the first in a series of posts that will focus on exporting, enhancing, and visualizing
\n Search Console data using Google Data Studio<\/a>.\n<\/p>\n
\nIn today\u2019s post, we\u2019ll discuss how to bring your Search Console data into Google Data Studio. We\u2019ll show an example where we download Search Console data
\n into Google Sheets, enhance the data with geographical regions, and connect the spreadsheet to Data Studio.\n<\/p>\n
\nIn future posts, we\u2019ll discuss how to create data visualizations to help you monitor and analyze your data.\n<\/p>\n
Prepare the data and connect to Data Studio<\/h2>\n
\nIn order to import Search Console data into Data Studio, there are two roads you can take:\n<\/p>\n
- \n
- If you are happy to see the same data as you see in Search Console, you should use the Google Data Studio data connector. This option is straightforward:
\n visit the connector gallery<\/a>, choose Search Console, and find the property you\u2019d like to connect.
\n You can find a guide to the connector in the Data Studio Help Center<\/a>.<\/li>\n- If you\u2019d like to enhance the data provided by Search Console (for example, clustering countries into regions), you should first export the data from the web
\n interface or through the API. Then, you can manipulate the data with Google Sheets or BigQuery and connect it to Data Studio.<\/li>\n<\/ul>\n\nIn this post we\u2019ll discuss the second option, since it requires more steps and offers more customization opportunities. There are three main steps you need to take:\n<\/p>\n
- \n
- Export Search Console data.<\/li>\n
- Add your own data on top of it.<\/li>\n
- Import it into Data Studio.<\/li>\n<\/ol>\n
Export Search Console data<\/h3>\n
\nIn order to export your data, visit the Search Console Performance report<\/a>,
\n choose a date range, click Export<\/strong>, and choose Google Sheets. This will create a new spreadsheet, which we\u2019ll enhance in the next step. You can also use
\n the Search Analytics API<\/a> for a more automated solution, but that’s
\n out of scope for this post.\n<\/p>\n\n
![\"Search](\"https:\/\/alienroad.com\/wp-content\/uploads\/kb-gorsel\/g-af61711d4f22.png\" "\\"Search")
\n<\/p>\n\nYou can read more about the dimensions and metrics that will be available to you in the \u042d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u044c
\n report help documentation<\/a>.\n<\/p>\nEnhance Search Console data<\/h3>\n
\nTo show how to enhance your Search Console data, we\u2019ll use a neat Google Sheets function, IMPORTDATA<\/a>,
\n which can import data from a URL. In our example, we\u2019re importing the
\n ISO 3166 countries by region<\/a> table.\n<\/p>\n\nAdd a new sheet to the data you exported from Search Console and enter the following code to the first cell:\n<\/p>\n
<\/div>\n\n In the Search Console sheet, create a column for Region<\/strong> and use the
VLOOKUP<\/a><\/code>
\n function to match the regions to the countries.\n<\/p>\n\nHere is a sample sheet<\/a> showing how the final table would look.\n<\/p>\n
Embedded: Table showing Search Console data enhanced with country regions<\/em>\n<\/p>\n
\nEven though we\u2019re using an example to enhance the geographical data, you can use the same process to add any type of information. For example, if you have a query classification,
\n you could use that to group queries into categories.\n<\/p>\nConnect Google Sheets to Data Studio<\/h3>\n
\nFinally, connect your Google Sheets to Data Studio. To do this, visit the connector gallery<\/a>,
\n choose Google Sheets, and find your newly created spreadsheet; but make sure to choose the right sheet.\n<\/p>\n\nOnce the data is in Data Studio, the visualization work begins…\n<\/p>\n
\u0414\u0430\u043b\u0435\u0435<\/h2>\n
\nIn the next post in this series, Monitoring Search traffic (and more!) with Data Studio<\/a>, we\u2019ll discuss different types of dashboards and provide step-by-step examples for you to follow along.\n<\/p>\n
\nAs always, let us know if you have any questions through the Google
\n Search Central Community<\/a> or the Data Studio Community<\/a>.
\n Also, if you\u2019re on Twitter, make sure to follow us<\/a>; we\u2019ll announce future posts over there – stay tuned!<\/em>\n<\/p>\n
- If you\u2019d like to enhance the data provided by Search Console (for example, clustering countries into regions), you should first export the data from the web