SQL for Marketing Analysis – All Google Analytics Analysts Should Know
Marketers and Marketing Analysts generally depend on the tools or IT department to help them pull the data for marketing purposes. There comes a time when they can’t just wait around for IT to help them data pulls and manipulations. They have to know how to do it on their own. This course is for those marketers who would like to know how to use SQL to conduct their marketing analysis. The course uses MYSQL to show how SQL works but all the leanings and syntax are applicable to other databases … [Read More...]
5 Online Google Analytics Courses You Might Like
Few Online Courses to Learn Google Analytics I came across few online courses on Google Analytics that might help you as you are learning or improving your Google Analytics skills. I have not personally not gone trhough these courses so can’t vouch for how good they are but I have used the reviews of others, who have taken these courses, to rank them. If you have an online course that you teach or love, then send me the link to include it in this list. Google Analytics for Beginners … [Read More...]
6 Reasons Why Your Google Analytics Reports Might Be Wrong
Missing Tags – This is the most common error of wrong data. This generally happens when new pages are added or the exiting pages are redesigned/recoded and the developer forgets to include the tags. Make sure all of your pages are tagged with Google Analytics code. You can use a tool like GAChecker, to verify if the Google Analytics tags are missing on any pages of your site. Mistagged Pages – Incorrect implementation or double tagging leads to wrong data in Google Analytics. Double … [Read More...]
How to Filter out Bots and Spiders from Google Analytics
A common misconception is that Google Analytics or any other JavaScript based Web Analytics solution filters out Spiders and Bots automatically. This was true till few years ago because most of the spiders and bots were not capable of executing JavaScript and hence were never captured by JavaScript based Web Analytics solutions. As shown in 4 reasons why your bounce rate might be wrong, these days bots and spiders can execute JavaScript and hence are showing up in your Web Analytics … [Read More...]
5 Reasons Why You Should Use Google Experiments
Google Experiments is an A/B testing tool that is available within Google Analytics interface. This post is not about what A/B testing is, why you should conduct A/B tests and what other tools are available but really to make a case for using Google Analytics as your testing platform. I am not getting paid to write this or have any affiliation with Google. This post is in response to a question I received from a reader of my blog. Free –There is absolutely no cost for the Tool. You … [Read More...]
How to View Click Map of a Page in Google Analytics
Click maps are a great way to visually see where visitors are clicking on a page. Google Analytics provides click map under Content --> In-Page Analytics (See below). Click on In-Page Analytics and the first page that you will see is your site’s home page. To view a different page, either click on a link on the home page (still within In Page Analytics) or select a page from drop down available on top left (see below). Other options Select click, goal value or a goal to display on … [Read More...]
How to View the Visitor Flow of Specific Pages in Google Analytics
Open Visitor Flow Report Under “Audience” menu open in “Standard Reports”. See below. This view will give you the visitor flow for the complete site. Left click on the page that you want the visitor flow for and select “Explore traffic through here” from the menu. Now you have the visitor flow for that page (see below) … [Read More...]
How to Create a Filter to Tidy up Email Referrals
Roll up Yahoo Mail, Hotmail referrals If you send marketing emails without campaign tagging or an external company e-mail your sites links to its users that have Yahoo Mail or Hotmail, users will arrive at your site via one of the many Yahoo or Hotmail servers. So searching for mail.live.com in your referral report gives you hundreds of referrers which are actually one and the same referral link. You tend to get referrals like above ( ”xy342w.mail.live.com”). You can roll these … [Read More...]
Why is the Operating System Report not showing iPhone and iPad visits?
If you recently looked at Operating System Report under Browser & OS Report in or Mobile Devices Report in Google Analytics then you must be wondering what happened to your traffic from iPhone and iPad? Why are you not seeing any more traffic from these devices? Starting May 30th Google Analytics has consolidated both iPhone and iPad into iOS in the Operating System Report. (See the graph below). iOS is the operating system used by both iPhone and iPad and hence the change to correctly … [Read More...]
Google Website Optimizer Moves to Google Analytics – Experiments under Content Section
Google Analytics and Google Website Optimizer have merged. Now Google Website Optimizer, a free A/B and Multi-variate testing tool, is available in Google Analytics via Experiments link under Content Section (see image below). You can create and manage all your tests within Google Analytics without going to Google Website Optimizer site. Functionality Difference between Experiments and Google Website Optimizer Easy Implementation – Since you already have Google Analytics on your … [Read More...]
