Top 3 Data Hacks For Cleaner More Usable Data (Google Analytics).

Top 3 Data Hacks

There has been a 70% increase in internet usage over the last few weeks meaning more people are online now more than ever (Forbes, 2020). Utilising your data right now couldn’t be any more important so here are 3 of the most fundamental tips for cleaner, more accurate data for your organisation.

  1. Exclude IP Addresses 

Do you know how many businesses we have worked with who tell us that their traffic to their website is so enormous and they are getting tons of hits. When we ask the question how many leads does your website generate usually the answer is a tiny fraction of the traffic… There is a reason for that.

MOST organizations are not excluding their own visits to their website…In order to have more accurate data you need to exclude your office & home IP addresses as well as any other IP address you do not want to be collecting data for on your website this includes colleagues IP addresses, and their homes IP addresses. By excluding IP traffic from internal sources you will have a more concrete understanding of who is actually coming to your website and for what.

Filter Exclude All IP Addresses

Step 1 – 

Google ‘what is my IP address’ on your laptop inside of your office & home. Google will surface your IP address copy that exact address.

Step 2 – 

Go onto Google Analytics > Admin > Under The View Tab You Will Find Filters > Click On Filters > Add Filter > Name It ‘Exclude Office IP Address > Click On ‘Select Filter Type’ & Choose ‘Exclude’ > Select ‘Traffic From The IP Addresses’ > Click On Select Expression & Click ‘That Are Equal To’ > Paste Your IP Address > Click Save. (Do this for all internal IP addresses you do not want to be tracking data for).

This will now exclude any data coming from your IP address so you are not tracking your own visits and activity to your website. 

2. Use ‘Not Provided’ Filter 

Advanced Filter ‘Not Provided’

Google sometimes struggles to identify specific traffic sources which is extremely unhelpful when you are monitoring your website traffic. Often all of the traffic that Google cannot differentiate gets put into the ‘Not Provided’ bracket which prevents you from seeing where traffic is coming from, this filter helps you see exactly your traffic is coming from.

Step 1 – 

In The Same Filter Section Click ‘Add Filter’ > Filter Name ‘Not Provided Filter > Next Click On ‘Custom’ > Then Click On Advanced > For Field A -> Extract A Select ‘Campaign Term’ From The Drop Down Items > Add This Formula – (.not provided.) > Next For Field B -> Extract B Select ‘Request URL’ From The Drop Down Items > Add This Formula (.*) > Next For Output To -> Constructor Select ‘Campaign Term’ From The Drop Down Items > Add This Formula – np – $B1 

This filter will ensure that Google doesn’t just put useful traffic into the ‘Not Provided’ category and you loose out on seeing highly useful traffic sources and vital data.

3. Exclude ALL Bots 

Exclude All Hits From Known Bots & Spiders

We worked with one organisation who were getting on average over 10,000 hits to their website per month (so they thought). The data being recorded was being use to make key marketing decisions but the data was inaccurate. They had a bot crawling their website every month which was completely screwing their data and making them think their newly launched website was the next best thing. There is a really easy setting that Google Analytics has carefully place inside the the view setting.

Steps – 

Go To Admin Console > Click On ‘View Settings’ > Scroll Down > Under Section ‘Bot Filtering’ > Tick The Box Stating ‘Exclude All Hits From Known Bots And Spiders’

This will rid any traffic coming from bots And spiders, squeaky clean data!

What will this help you achieve?

  1. Firstly his will help you understand how well your site is performing per week/month inline with business objectives.
  2. You will clearly be able to see the amount of visitors to your website & what they are looking at more clearly.
  3. More accurate, cleaner data that you can actually use to base business decisions off of and improve your strategy.
  4. Save resources & time not wasting it on campaigns that are never going anywhere because the data is wrong!