0405123696 petra@web-data-analytics.com

 1,047 total views,  9 views today

Today’s topic is a little more advanced, for people who are working in the digital marketing arena already and trying to use Google Analytics. Perhaps you’re trying to report some numbers to a client.

In Google Analytics, if you are familiar with the format you tend to have words on the left and numbers on the right.

The words on the left, those are called ‘Dimensions’ and it will include things like page names, events, country, product name, gender… basically anything that is text.

Then you have metrics which are the numbers and they come on the right-hand side of the tables. So you’ll see sessions, users, session duration, conversion rate, bounce rate… i.e. all the numbers and percentages.

What you’ll discover in Google Analytics — well the whole main point of Google Analytics – is that Google Analytics automatically aggregates all the numbers on the right for a particular piece of text on the left for any date range you choose.

A big problem happens when you have two or more pieces of text that have been separated for some reason, but they are supposed to be reported as one. When you go to report on what happened, you have two or more separate numbers and it gets messy. Today’s video will explain to you how to fix this issue using Google Data Studio!



Okie dokie! Well, hopefully, that will come in handy for you too if you’ve ever been scratching your head about how to clean up data that’s already happened.

Next time you can use filters in Google Analytics to make the data aggregate well and save yourself all the time and effort, but that’s another post for another day.

Take care and have a good one!


Erica Stacey Scout Digital

I recently worked with Petra to improve my understanding of Google Tag Manager.

Petra not only provided a solid overview of GTM set up and event tracking, she also provided many tips on best practice, and answered the questions that I didn't even know to ask!

Petra is patient, fun to work with, and her analytical programming mind is hell bent on finding the BEST solution to any data, analytics or tracking problem.

Erica Stacey Scout Digital Marketing Strategy Session June 21, 2017

Sophie Abnett

Here at 1834 Hotels we centralise the marketing for many different hotels. It can be an enormous undertaking to monitor and track the performance of each one, especially when they are all on separate webpages.

Petra helped to resolve this difficulty by creating a central hub in Google Tag Manager and Google Analytics with Cross-domain tracking and Ecommerce as well. She created many valuable analytics dashboards and reports that draw from the centralized source. Now that we have all the analytics tracking working it has improved the accuracy of our reporting and the insights have helped develop better marketing strategies.

Petra’s skills and wealth of knowledge is fantastic. I would recommend Petra without hesitation.

Sophie Abnett Digital Marketing Project Manager at 1834 Hotels Ecommerce / Hotel Google Analytics, Google Tag Manager & Google Data Studio Integration April 23, 2020

leesa dawson

I am so grateful to have met you, as I think your insights are the BEST I have ever come across.

Leesa Dawson CEO, The Uniform Stylist Ecommerce Google Ads April 23, 2020

david clayton myomasters

Your attention to detail is beyond what I had expected. The detail of the data is incredible. The best part though was to learn the profile demographic - which is very different to whom I think I've been trying to target through social.

David Clayton Director, Myomasters Massage Health Clinic Google Ads April 23, 2020

claudia impedovo

Our main purpose for generating these reports is about findings out information that will curb our strategy. The Audience Engagement Report provided us with new findings about our audience. We implemented new marketing elements based on those findings and they have increased sales.

Claudia Impedovo Brand Manager at Spendless Shoes Ecommerce Google Analytics, Google Tag Manager & Google Data Studio Integration April 23, 2020