What is Google Data Studio?

Data Studio is a free reporting tool from Google. “ Your data is beautiful.” appeared on the landing page of [1] Data Studio , which was first introduced to users in June 2016 . The sentence [2] actually shows us the purpose of this reporting tool. Google last updated in April and introduced a number of new features. [3]Whether you are an advertiser or creating your own ads, Google Data Studio is a tool that provides you with data quality, conversions, the difference between your advertising campaigns and organic traffic, even detailed information about users’ phone models and many more that I haven’t mentioned. The feature that makes Data Studio different from other reporting tools is that it gathers frequently used Google Ads, Analytics, Search Console, Facebook and other platforms on a single home screen.

In this part of the Google Data Studio series, which will be in three articles, I will show more data, campaign, cost table addition and graphical distribution, date creation and reporting of features such as the number of clicks, impressions, click-through rates for keywords.

Adding Data

The first thing you need to do to create reporting in Google Data Studio is to add your targeted Google Ads, Analytics, etc. tools to Data Studio. Clicking “Create” will open a blank page and click “Create New Data Source”.

Then select the tool you want to report on. And after selecting your account, click on “Connect” on the top right and then on “Add to Report”. Finally, you will see a blank square screen. From here you can make any adjustments you want.

Adding a Cost Scorecard and Chart

You can add the grand total of the campaign you are advertising and even examine its distribution from days to hours. Since I have explained its general features here, it will be sufficient to take a look at the Data Studio panel for detailed reporting. To generate the Overall Cost, on the blank report page, hover above “add” and then click the scorecard. After creating the scorecard, you can write not only the cost but also the impressions and clicks in the “data” section and show them on the report page separately.

Showing the Cost in a Graphical Way

Above we have shown the cost total on the scorecard. Here we will go into a little more detail. You can show the cost by day, hour, week, month. You can even add the number of clicks to the metric and look at the ratio of the cost to the number of clicks. After hovering over “Add Chart”, select the chart indicated by the two arrows.

In the “Data” section, type “Cost” in the “Size” “Day” “Metric” box. As seen below, the cost will be distributed graphically. You can also select different tables from the “Add chart” section.

Custom and Automatic Date Creation

In Google Data Studio, you can change the date you want in a single chart, or you can change the date of the chart and data you add in bulk. For example, you created a report consisting of cost, impressions and campaigns on a page. When you add the “Date range” section and enter the dates you want, the reports such as cost, impressions, campaigns that I have mentioned above will show the data of the dates you entered. To do this, you need to automatically tick the “Default date range” under the “data” section in the charts. Hover over “add” and click “Date range”.

Then click on the box that occurs in the report and select “default date range”. As I said before, you can make visual adjustments from the “style” section. I chose blue and turquoise as seen below.

Reporting of Campaigns, Ad Groups, Keywords (Clicks, Impressions, Cost per Click, Click-through Rates)

There are many metrics and dimensions you can use in Google Data Studio for reporting and reviewing search ads. For these, you can analyze your data by selecting the graphics according to your needs. Since there will be a lot of numbers and texts here, you can choose the heat map table so that the report does not interfere visually. Higher digit values ​​are shown in darker color in the heatmap table.

Hover over “add chart” then select “heatmap chart”.

Type “Search Keyword” in the size field under the data section. If you want to examine the campaign or ad group, it will be enough to write them in the “size” section. In the metric part, “clicks”, “Impressions”, “Avg. Type “Cost”, “Cost” and “CTR”. After making the changes, a visual like the one below will appear.

There are many different features and details of Google Data Studio, which I tried to explain in the most general terms. In the second part of the article, I will talk about User Searches in Data Studio, reporting of clicks by age and gender, user device distribution and reporting of conversions.  Seoliz.net  , we create regular reports for our customers by using Data Studio data. For more information, you can call us or click the link below.

Furkan Tugrul Sari

Digital Transformation and Marketing Specialist