Heat maps can be a really efficient way of analysing data. The colour variation can quickly help you spot the highs and lows of your data as well as trends. Often collating the data for your heat map can take a fair amount of time though, putting you off doing this rewarding exercise.

Let me show you how to turn your Google Analytics data into a heat map, fast!

 

Now if you’re more a visual person, here’s the YouTube video for you…

 

 

In Google Analytics, head to Customisation and select Custom Reports. Add in metrics you’d like to analyse, e.g.:

  • Sessions
  • Transactions
  • Revenue
  • Conversion Rate
  • AOV
  • Goals
  • Goal Conversion Rate
  • Average Session Duration
  • Pages per Session

 

Under dimensions select Day of Week Name and Hour. You can pop a filter on if you want to analyse a particular set of users.

For example, if you’re analysing data to improve your PPC efforts you might want to select medium = cpc. If you’re trying to work out the best time to post on social media to drive conversions, select Default Channel Grouping = social.

Next, hit Save.

 

If you’re analysing data for an e-commerce site, try this template. It includes Sessions, Transactions, Conversion Rate, Revenue, AOV and Average Session Duration.

 

Once you’re in your report, make sure you can see all available rows of data and you have the correct date range selected. If you’re planning on making changes from the information you glean, choose a decent period of time. My suggestion, at least 90 days.

Now we’re going to export to Excel. It’s important that you choose Excel for exporting this report as we need to use a pivot table, something that Google Sheets or Apple’s Numbers just don’t offer. (*Update: Google Sheets have now released a pivot table feature woohoo! If you want to export to Google Sheets and use that for the following steps you now can.)

 

Open your report in Excel and navigate to the Dataset1 tab. Use the Insert menu to create a pivot a new pivot table. Arrange the fields as follows:

Day of Week Name > Columns
Hour > Rows
Transactions (or whichever metric you’re analysing) > Values

 

Now you should have something along the lines of….

 

Pre heat map data

 

Time to add the heat map!

Select the data ignoring any blank or total column/rows. Back in the Home menu, from Conditional Formatting select Colour Scales and choose whichever scale floats your boat.

 

Google Analytics Data With Heat Map Applied - Beeson Media

 

There you have it. Your Google Analytics data in a heat map. Woohoo! 🎉

Bet that was faster than you thought!

But….now that you’ve got the heat map, what are you supposed to do with it? 🤔

 

Capitalise on the Highs, Fix Up the Lows

 

See a few pockets of great results? Awesome. Capitalise on these where you can…

  • Increase PPC bids
  • Use sales driven messaging on social media
  • Schedule blog posts to go live
  • Send email campaigns
  • Launch new products
  • Have flash sales

Where you have sections of low performance, review your marketing strategy for these times. Are your ads visible? Are you posting on social media at these times? Or if you’re location specific, are these simply times where your target market is asleep? If so, reduce any wasted marketing efforts.

 

For All the PPCers Out There

 

Conversion data heat maps and ad scheduling go hand in hand. If you don’t already adjust bids according to their hourly performance, get on it!

Use the method above to find the best converting hours for you then checkout the BrainLabs Digital 24 Hour Bidding script to automate the process. This can reduce wasted spend on your account by loads and help you maximise conversions.

 

So there you have it. Google Analytics, custom reports, pivot tables, data heat maps and even AdWords scripts.

Enjoyed this post? Learned something new? Ah, that’s great! 🙌 How about showing your appreciation by sharing it? Every little bit helps ☺️

Thanks for reading and happy analysing!

 

Are Your Facebook Ads Making Any Money?

All the marketing experts are preaching Facebook Ads along with the awesome results they're seeing. But so many businesses are hesitant to get on board. Who can blame them? Realistically, Facebook ads haven't been around that long compared to other...

How To Optimise Facebook Ads Through Targeting

  How To Optimise Facebook Ads Through Targeting Most people have a love/hate relationship with Facebook. However you feel about Facebook, you have to admit that Facebook Ads are pretty fantastic. There's so many different options giving you endless ways...

How To Boost RLSA Performance With Powerful Google Analytics Audiences

RLSA (Remarketing Lists for Search Ads) are a fantastic way of helping boost performance for your paid search activity. You can target certain groups of people, adjust your bids for these audiences or even tailor ad copy for them. This can help you increase your...

Kick Start Your Facebook Ads With This Foolproof Campaign

I love Facebook Ads.   They remind me of my fiancé in many ways; crazy intelligent, totally surprising, always make you wonder what they’re thinking, but once you crack the code they’re just the best fun ever. What can I say, I’m a bit of (ok a LOT of) a Facebook Ads...

How Can I Tell If My PPC Campaign Is Working?

After running your Pay Per Click campaign for a few weeks, you'll want to take a look at the figures to see how it's performing. Impressions, clicks, click through rate, conversion rate...there's a lot of numbers floating around but how can you tell if your results...

 

Join our free PPC email course!

 

This course will take your Google AdWords account from meh to AWESOME in just seven days! From keyword types, to ad scheduling, we'll teach you everything you need to know to get a whole heap more conversions for a heck of a lot less.

 

 

Pin It on Pinterest

Share This