Data Studio is a potent tool for creating interactive visualizations and dashboards. You can use it to build beautiful reports quickly and easily. But what about connecting to external data sources like Google Analytics or AdWords? This video shows how easy it is to do this with the Data Studio connector.
The Data Studio Connector allows you to pull data directly into Data Studio from different data sources, including Google Analytics, Bing Ads, Twitter, Facebook, YouTube, Amazon, Salesforce, Shopify, Magento, Stripe, MailChimp, GitHub, Slack, and many others.
You can export your data to CSV files, JSON files, Excel spreadsheets, and SQL databases.
How to connect to Search Console
Google says it wants to help small businesses grow. So what does that mean? How do you use Search Console to improve your site’s visibility? Let’s take a look.
Sign in to Data Studio. Click on the top left corner of the page. Then, select Datasource. You should now see a list of tables. Scroll down and select Search Console connector.
Choose the table that you want to analyze. For example, if you see the number of impressions each URL received, choose Site Impressions. If you wish to know the revenue for each URL generated, choose the table called Url Revenue.
Make sure that you are signed into Data Studio and Search Console with the same Google account, or else you won’t be able to see all the properties available. To find out how much money your ads generate, choose site Url Revenue with the table you want to track.
Configure the data source
To rename a field, type CTRL + R or select Rename Field from the Data Source Fields Menu.
Type Ctrl + N or Select Add New Field from the Data Sources Menu to add a new field.
To change the data type of a field, type Ctrl + C or select Change Data Type from the Data Source Settings Menu.
Select Alt + A or Aggregate from the Data Sources Fields List to change how aggregated values are displayed.
Control who sees the data
Data credentials are used to give people access to information without sharing their credentials. They allow you to control how much information about yourself you want to share. When someone requests access to your data, you decide whether they see everything or just some parts. This lets you protect personal information like credit card numbers, social security numbers, or medical records.
Viewers’ credentials work differently. They require each viewer to provide their credentials to access the data. If you use viewers’ credentials, you must ensure that no one else knows your viewers’ passwords.
You can choose between two different types of viewers’ credentials. Both options require you to set up multiple accounts.
Create new reports from the data source
Click the button next to DATA SOURCE to add it to the report. You can select multiple data sources.
You can create a new report from the selected data source. If you want to use another data source, click ADD NEW DATASET.
Analyze Google Search Console data in Google Sheets
Google Search Console provides valuable metrics about your website’s performance on mobile devices. You can use it to track changes over time, identify issues, and even see what keywords are driving traffic to your site. But one metric that isn’t included in the standard reports: is the number of impressions each keyword gets. If you want to know how many times people saw your ads, you need to make some adjustments. Luckily, Google offers a way to do just that.
This tutorial will show you how to download and analyze data from Google Search Console into Google Data Studio. We’ll start by creating a spreadsheet where we store our data and then connect it to Google Data Studio via a Google Sheet connector. Finally, we’ll dive deep into the data and determine how much money each keyword brings in.
Comparing branded vs non-branded search queries’ performance
You know it’s important to distinguish between branded and non-branded searches because you’ve been doing it since day one. But what about now? How do you make sure you’re determining correctly? Here are three ways to help you decide whether to spend money on non-branded keywords.
1. Look at your overall campaign performance
If you haven’t already done so, look at your total search volume. If your branded search volumes are growing while your non-branding search volumes are shrinking, that’s probably a sign that you’re spending too much on non-branded terms. You want to focus your resources on driving quality leads and customers to your website.
2. Use the data tool
Google Search Console offers several tools to compare your branded and non-branded search traffic. For example, you can use the Keyword Planner to find out how many people searched for a specific term and how often those people clicked on the ad. Then you can use the AdWords interface to see how many impressions each keyword received. You can even track the number of conversions per keyword.
We’ve introduced a new setting named data precision which allows us to control how much data we pull from the Search Console API each month. This helps us provide accurate data for our customers.
With enhanced data precision, we’ll make multiple requests to the API and combine them. We might request fewer or more data points daily, depending on the settings.
When using the enhanced data precision settings, you can choose how many days you want to look back. You can select the option one day, seven days, 30 days, 90 days, 180 days, or 365 days.
Data precision is essential if you’re looking to accurately calculate conversion rates or other metrics. Splitting your date range into smaller chunks will allow us to generate better data.
Export Search Console data
To export your data, go into the Search Console Performance report and choose Export Data. Select a date range, save it, and select Google Sheets. This will allow you to import the data into Google Sheets.
You can also use the Search Analytic API for an automated solution.
Enhance Search Console data
Google recently announced it would begin to display information about how many impressions each URL receives in Search Console. This feature is called “URL Impressions.” Use this tool to see what happens when someone visits one of your web pages.
The data are displayed in a table format; you can sort them by date, location, or keywords. You can even filter out certain types of traffic, such as mobile devices.
You can find the URL Impression report under the Audience section of the Search Console.
Hugo is another Data Studio fan that specializes in reports and dashboards. He runs is own business from home and uses Google Data Studio in his reporting for his clients