Advanced AdWords Tip: Getting Hourly Conversion Data in Google Analytics

by Steve LaLonde – PPC Manager at DragonSearch 

I love Google Analytics.  It’s free – and everybody loves free stuff – but more importantly, it’s very powerful.  In fact, Google Analytics is a perfectly suitable analytics platform for probably 98% of websites.  It’s an arguably enterprise-class web analytics solution.  But Google Analytics is not perfect.  In fact, it’s missing a few key features.

#1 on my list of things Google Analytics is sorely lacking: Hourly Conversion Data for AdWords Traffic.  


 Having hourly conversion data for AdWords traffic in Google Analytics would be so great! After all, your web visitors behave very differently throughout the 24hr day. Wouldn’t it be nice to know when your site converts paid traffic most effectively?  For sites running Pay per Click advertising this data is very important, as it could – and should – inform your day parting schedules.  Problem is, when you look at AdWords traffic in Analytics, you can’t see hourly conversion data.  

Fortunately there’s a way to (kind of) see this AdWords hourly conversion data.  All you have to do is install another duplicate website profile, and apply a filter to the new profile.  In effect, you’ll be creating a new ‘duplicate’ analytics profile which tracks only AdWords visitors — giving you an easy way to see hourly conversion rates for AdWords visitors. 

To create the duplicate profile, go to Analytics settings –>  “add website profile” –>  “add profile for an existing domain” .  Then enter the following filter settings, and click “Save Changes”. 


*NOTE: Don’t forget to recreate your goals in this newly created profile!!! Just pull the goal URLs from your original site profile, and re-setup the goals in this new profile.   

 What you’ve created is a duplicate profile for your website, which will only show AdWords traffic.  This way, you’ll be able to look at Hourly Conversion Rates and Totals for AdWords – only traffic.  You won’t be able to get very granular – like down to the keyword or ad group level – but you’ll see obvious AdWords trends across the 24 hour time frame.  This can point out obvious times which your site converts PPC traffic at its best.  Use this data to inform your day parting schedules in AdWords, and watch conversion rates (hopefully) improve!  

 analytics goals tab

I hope you’re able to employ this little trick to isolate hourly conversion data for your AdWords campaigns.  

Tags: , ,

Leave a Reply

9 comments on “Advanced AdWords Tip: Getting Hourly Conversion Data in Google Analytics


I came to this post from SEW adwords forum. I am a newbie in the field of PPC management, your post is very useful for the peoples like me. Thanks for sharing this tip.


@ Ecreeds; No problem! Happy to provide a helpful tip.


Good info thank you! But I still have issues with other traffic sources leaking through. I set up the filter exactly as you instructed and I am still getting Yahoo organic and Direct traffic referrals showing up. Please help!

Thanks so much!


I see you deleted my comment regarding other traffic sources leaking through….does this mean there is no explanation?



My apologies, it’s still there.


Hi Mike,

Thanks for the comments. I’m not sure why you’re seeing other traffic sources leaking through the profile. One explanation would be if your ‘leaking in’ traffic has URLs which were tagged with the Analytics cpc parameter, they might be read as ppc traffic by analytics. In other words, if you tagged a Yahoo! campaign with the analytics URL builder, you would see this traffic in the profile. It doesn’t sound like this is the case, as you say you’re seeing Y! organic and also direct traffic.

I’m going to look into this now, but I’m not certain i’ll be able to figure out what’s going on. I will keep you posted!!

Laticia Tish

Keep working ,great job!

Bobbi Vattikuti

this article help me to come out some ideas to help me make my own schedule for my full time internet business.

Team Roster

Best you should edit the page title Advanced AdWords Tip: Getting Hourly Conversion Data in Google Analytics | DragonSearch Marketing; Internet Marketing Services & Consultants to more generic for your webpage you create. I loved the the writing still.