0405123696 petra@web-data-analytics.com

 627 total views,  6 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!


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

brett leggett

Hi Petra, Hope you are well, I checked out the Google Analytics and all I can say is AWESOME. You have essentially doubled her revenue in a month and the Google Ads seem to be popping off!

Brett Leggett Brett Leggett ✪ eCommerce Growth Specialist Ecommerce Google Ads April 23, 2020

Kiley Hay Baby Carriers Australia

I have been working with Petra for over a year now after changing from a much larger digital marketing provider and I could not be more pleased with the service and results my business is achieving.

With my previous providers I felt disconnected with limited communication. Petra on the other hand provides me with knowledge and information in a language I can understand that helps me make informed decisions not just about digital marketing but also my e-commerce business as a whole.

Petra has helped me navigate seasonal drops in trade creating a strategy that helped us grow and establish a healthy position in the market. It is an absolute joy to work with someone who loves what they do. I have complete confidence in recommending Petra to anyone considering e-commerce digital marketing, she is efficient, trusted and a true professional.

Kiley Hay CEO of Baby Carriers Australia Ecommerce 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

Nadia Rossi

It has been an absolute pleasure working with Petra over the last year and a half. 1834 Hotels centralises marketing for over 20 hotels around Australia, all with different branding and websites. On an analytics level Petra’s skills have allowed us to monitor and track our marketing efforts in the digital space. Bringing Petra onboard to manage our Google Ads was one of the best marketing decisions we have made. Her thoroughness and attention to detail is incredible, her insights have helped develop better marketing strategies and demonstrate to shareholders return on investment. I would highly recommend working with Petra.

Nadia Rossi Digital Marketing at 1834 Hotels Ecommerce / Hotel Google Ads April 23, 2020