Archive for 2014
It’s easy to sign up for cool tools without really reading the full terms of service, especially when those services are complimentary. Google Analytics is one of those “cool tools”! Really robust, really useful, sometimes so useful, our business depends on it. But do we really know the limits?
You’re garnering leads, conversion rates are increasing, the Key Performance Indicators you’ve chosen are displaying progress, and the hits to your website are sky-rocketing! Life is good when suddenly an error message starts flashing on your reporting dashboard – you’ve exceeded 10 million hits per month!
Why did you hit the data limit? Well, it’s part of the terms of service we neglect to read . Google Analytics terms of service states, “…the service is provided without charge to you for up to 10 million Hits per month per account.”
Is it really that big of a deal? If you’re hitting the limit, probably. Reason being, most likely at this volume, your data is important, and Google Analytics will automatically start sampling your data. That means not all your data will be available in your interface, which could lead to inaccuracies and limit the insight you can derive.
All the work and investment you put in your digital properties – websites, mobile website, mobile apps, to become one of the leading businesses in your industry – it’s obviously important to accurately analyze your data and have as much access to it as you can.
You have 3 overlying solutions:
1. Upgrade to Google Analytics Premium
The first is the easiest most straightforward way to overcome these limits. Upgrading to Google Analytics Premium gives you 1 billion hits per month, not to mention access to “amped-up” reporting features for your business. Plus, you won’t be going at analyzing your data alone – it also includes technical and implementation support, which at this volume, can be a big help.
It is indeed a paid service, but it’s worth it to avoid the hassle and get the proper processing power and support you need for your growing organization. For more information and consultation about Google Analytics Premium, contact E-Nor.
2. Limit Hits to Google Analytics by Setting Your Own Sample Rate
Since Google Analytics standard only allows a number of hits, the second option you have is to report/send fewer hits to your analytics account. A “hit” on a site is a pageview, event or any other transaction. The reason this may help is that a single visit could potentially be registered as multiple hits. That is, say a user interacts with your website and views multiple pages, fills out a form and purchases a product, these interactions will be reported as multiple hits, regardless of all these actions being associated with one unique visitor or even one visit. Setting your own sample rate will minimize the hits, but put the control in your hands (rather than letting the system choose the sampling rate for you when you’ve passed their limit).
This is done at the code level. Talk to your developers about setting a new sample rate using the _setSampleRate method in the tracking code. This method allows you to choose the number of visits after which you want to count. For instance, you choose to track one visit after every 10 visits, so your sampling rate is 10. Say you have 100,000 visits a day. If you track with a sample rate of 10, your visits will be reported as 10,000 hits. Thus, allowing you to reduce your overall data limit.
3. Selective Tracking To Minimize Hits
If you’re only interested in certain types of hits, you may be able to get rid of what’s unnecessary. For example, since every Event counts as a hit, you may want to re-strategize and figure out what Events are really necessary. Instead of tracking every unique user-interaction as an Event, pick and choose what’s important to track so that the tracking code doesn’t record excessive hits and inflates your data limit.
If you are a video heavy website, you may not need to track everything, such as when the user starts the video, when they pause the video, have reached midway, and/or reached the end. You might want to simply track when the user starts the video or when they’ve completed watching the video. This cuts downs the number of times tracking code is fired and lowers the hits.
If you’re an ecommerce website, and heavy on products, you don’t have to track every single metric involved, maybe only product pages visits, shares, social interactions, Add-to-Carts and so on. Once again pick and choose which metrics will best reflect your website’s performance with selective metrics.
Stay tuned for our more in depth article on tips to deal with sampling.
Creative solutions are built from knowing the basics to the bone. Every so often, we like to go back to basics for our beginner readers and remind everyone else. Here’s a quick review and infographic of the “ABCs of Google Analytics”.
In the Google Analytics interface, on the left side there is the Google Analytics reporting menu. You’ll realize they’ve done a great job of organizing things based on intuitive marketing strategies.
A is for Acquisition: What brought visitors to your site?
These items in GA essentially show you what’s driving traffic to your digital properties, website, mobile site, mobile app, etc, telling you where your visitors coming from. Some examples of what kind of traffic you are getting are paid, referral, organic, and direct traffic. Also, the technological world we live in may have visitors coming to your site from multiple touch points several times before converting. Universal Analytics helps you tie all of these things together (including even offline data if you want).
B is for Behavior: What did the visitors do once they got there?
Once visitors get to your website or mobile app, what are they doing? The “behavior” area tells you what your visitors are engaging with on your digital properties. At a higher level, they might be visiting and interacting with the home page or other landing pages, traversing the site, visiting several pages (or bouncing!). Also, if set up correctly, Behavior not only includes what pages they visited, but specifics of how they interacted with your pages and site(s). For example, Events you’ve set up to be triggered by playing videos, clicking links, using the slider button and reading through content, would all be found here, so you can see the details of exactly what’s happening.
C is for Conversion: Did they do what you wanted them to do?
This is what it all comes down to! By setting up Google Analytics goals and enhanced eCommerce, you’ll be able to tell if your online marketing efforts are truly working. After all, who needs a bunch of visitors engaging with your site if they’re not contributing to your bottom line, like becoming leads by submitting forms or buying products. Here is where you can see all your goal conversions, like downloading material, form submissions, add-to-carts, completed checkouts, etc.
For your reference and visual pleasure, below is an infographic to demonstrate these basic concepts and flow in Google Analytics.
We are proud to be partnering with Rising Media to be producing the Evolve with Google Analytics conference! Millions of organizations are using Google Analytics, but have yet to tap its full potential. As experienced Google Analytics Certified Partners, we know the platform in and out, and will put you in touch with the foremost thought-leaders and practitioners of the analytics industry. I invite you to attend the inaugural launch of Evolve with Google Analytics. Attend the conference to learn about:
• Unlocking the Power of Universal Analytics
• Truth in Advertising
• App and Cross-Device Insights
• Customer 360: Integrating Web and CRM Data
• Google Tag Manager Best Practices
• Testing and User Experience Integration with Google Analytics
• Google Analytics Live Clinics and more
You’ll have the opportunity to network with fellow marketers and practitioners and share real life stories on leveraging Google Analytics to enhance your organization’s data-driven decision culture.
Evolve your measurement for better insights and competitive advantage.
We look forward to seeing you October 6 – 7, 2014 in Boston!
Conference Chair, Evolve with Google Analytics
P.S. Early bird registration rates end Friday August 8th. Register today & save $300.
We do quite a bit of analytics consulting for government agencies and it’s really inspiring to see what some of the organizations do with digital marketing. Many governments globally, not just here in the U.S., invest heavily in e-government initiatives and, as the U.N. defines it, “…the employment of the Internet and the world-wide-web for delivering government information and services to citizens.”
As a matter of fact, the U.N. has a number of studies and surveys to rank global leaders in e-Government initiatives, including this survey that ranks top 50 countries (for more information on the criteria of choosing the top 50, reference the survey).
On our end, and in a similar fashion to what we publish on digital analytics adoption in the Fortune 500 every year, we thought we’d assess the digital analytics adoption of the U.N.’s top 50 e-governments. We expect wide-spread adoptions of digital analytics among the leaders, since we’d assume to be in the top, they’d have heeded the old adage, “You can’t improve what you can’t measure.”
- We looked for known web analytics platforms and if they are installed on the sites
- As an indicator of analytics adoption in these countries, we used either the president’s page or the official governmental portal.
Orange is the New Analytics Platform
Check out the following visualization of the research data in Tableau.
We’ve been aware through anecdotal evidence that many governmental agencies deploy Google Analytics Standard or Google Analytics Premium, but this data actually shows these top ranking countries adopt digital analytics and rely overwhelmingly on Google Analytics to deliver results. While the adoption of Google Analytics doesn’t come as a surprise (given it’s user-friendly interface and powerful capabilities), the magnitude of its lead over other tools is a bit surprising.
If you are considering an analytics solution for your government portal, and you choose Google Analytics, you’ll be in the company of the leaders!
Recently, an issue came to light with one of our clients which turned our world upside down – quite literally.
In the graph (shown below), Unique Pageviews vs. Pageviews was compared for a given date range for a select group of pages.
If you click on the image to zoom in, you’ll notice something weird. For some reason, the line of the Pageviews metric — which is higher in number — is lower visually than the unique pageviews.
What the @#$^ is happening?
The unique pageviews line (the higher of the lines) is graphed according to the y-axis scale on the left. What you probably didn’t notice is the pageviews line (the lower of the two lines) is graphed according to the secondary y-axis on the right. Yes, there is another y-axis on the right side.
Because the scales are different, they’re spatially and visually apples and oranges in terms of height.It’s a bit counter-intuitive and weird, but we thought we’d share this finding with you in case any runs into this issue and get’s confused.
Still confused? That’s ok. At least you know why now
Also, see cool interactive data visualization chart of 2014 World Cup data here.
As the month-long World Cup Tournament in Brazil is at an end, it is amazing to see that the biggest winner of the tourney is not the one who scored the most on the green field, but rather, the one who scored the most on social media.
The most watched sporting event on earth generates millions of social mentions and millions of viral video views produced by individuals as well as major brands for marketing and advertising.
During the USA match against Belgium, for example, the US Goalkeeper, Tim Howard’s, name exploded all over the internet after his astonishing performance and his world record saves in the match. He was lauded greatly by his fans on different social networks and was even briefly named the U.S. Secretary of Defense on Wikipedia!
Neymar, the 22-year-old Brazilian striker with four crucial goals and successful pass rate, has been leading the World Cup social buzz as well. He is by far the most talked about player of the tournament with 33 million social mentions. He has 12.5M followers on Twitter and has been in the spotlight ever since his two goals scored in the first match, all the way until his last match in the tournament where he took a knock in the back from a Colombia defender, causing a fracture to his third lumbar vertebra.
Obviously, social mentions can correlate positively or negatively based on the performance of the players and their teams. In order to understand and analyze the online data generated by this social buzz, we need to marry that data with real-time offline data generated by the “feet” of the players.
To get the best of both worlds, detailed statistics were collected by the E-Nor consultants using Google Analytics (Universal Analytics) for every World Cup player, team and match, including:
- Pitch condition
- Goals scored
- Goals against
- Fouls committed
- Fouls suffered
- Attempts on target
- Attempts off target
- Games played
- Minutes played
- Yellow cards
- Red cards
Here is a sample of the matches report:
This report shows the top 5 scored players:
Here are few other snapshots of the data in action:
Teamwork and Performance
The aspect that fascinates me the most in soccer is a team attempting play as one complete system intending to score one goal.
Although this year’s World Cup winner, Germany, may have no internationally recognized stars, such as Neymar, Messi, and Ronaldo, I enjoyed watching all their games in the tournament. The beauty of their team work definitely overcame the absence of entertainment from an individual superstar, and ultimately led them to true victory. Congratulations to Germany, very well deserving champions indeed!
Here is how the top 8 teams performed:
Pitch Conditions and Performance
Poor pitch conditions could easily hurt the playing style and the performance of teams. A well-maintained playing surface helps players with running and quick-passing. According to data gathered, teams had a hard time scoring on wet and dry pitches, while scoring was above average on soft pitches.
Here is the same report based on the temperature during the match. Do you see any correlation?
Age and Performance
While the 36-year-old Ivory Coast striker, Didier Drogba, wasn’t directly involved in any goals, his presence was enough to energize his team and to worry the opponent’s defense! This is my response whenever someone criticizes the performance of players who pass the 35-year-old milestone. Maybe I am biased in my view, but that is why we need to look at data and what it says about players’ age and their performance.
History and Performance
While this is the first time for us to record World Cup data in Google Analytics, it was impossible for us to enjoy looking at trending event or to predict based on historical data. With this humble experiment that we conducted for the 2014 World Cup, we are hoping that we left the doors of possibilities wide open for other smart people to build on top of this and provide data and soccer lovers a more comprehensive coverage of the World Cup data all in GA
||1958 1962 1970 1994 2002
||1954 1974 1990 2014
||1934 1938 1982 2006
It has been said that this World Cup will be the most social sporting event in history and it certainly was. All available data easily validates that assertion. World Cup data also provides major opportunities for brands and for marketing agencies. As you see in the experiment, Google’s Universal Analytics infrastructure can handle the marriage of the two worlds; offline and online activities. I believe with the new Google Analytics platform we will see many creative solutions built to answer real business needs that we failed or were unable to answer in the past.
Interested in our collected data? Send us your email address and we will grant you a temporary ready-only access to our 2014 World Cup GA reports.
The World Cup is the most viewed global event (yes, even more than the Olympic Games). Internationally, one of the most, if not the most, common sport is soccer (known as football in places other than the U.S.), and for good reason. Who can resist the fun of the sport! This year, there was the fastest goal scored by U.S. (32 seconds!), Algeria’s defense against Germany, and the mighty Tim Howard’s record-making game for most saves in a single game (16 saves people! 16!) — just to highlight a few!
The beauty of Universal Analytics is you can pull in any sort of data into the Google Analytics interface. To demonstrate this, in our last post, we pulled World Cup data (up till 7/7/2014) into Universal Analytics.
We looked at the following data:
- Top Matches
- Team Performance
- Top 10 Scored Players
- Players with Red Cards.
It’s already cool that you can see the data in GA, because now you can take advantage of the cool reports and filters and really chop up the stats. But the data is in multiple reports, so to really analyze the data, you’d have to click through to look at all the info. Plus, it’s mostly numbers, so it’s hard to really tell a story.
We wanted to show that there are even other fun and engaging ways to present and share data.
Tableau Software – Interactive Data Visualization
“There is a magic in graphs. The profile of a curve reveals in a flash a whole situation — the life history of an epidemic, a panic, or an era of prosperity. The curve informs the mind, awakens the imagination, convinces.” – Henry D. Hubbard
Endless tables of numbers might seem intimidating to some of us, particularly marketers who usually aren’t as technical. Sure, you could create charts in Excel, but it’s 2014, why limit ourselves to static 2-Dimentional shapes and charts? Let’s really wow our audience.
Tableau is an awesome data visualizaiton tool that lets you pull in data directly from your analytics account into the software. From there, you can create really cool interactive dashboards and visualizations. The tool provides several interactive elements geared towards helping the user slice and dice data on the fly. Check it out!
Behold! Hover/click over any country and see how the data changes below!
The “viz” above is more than just a bunch of static charts – a story unfolds, each country is denoted by its location on the map as well as flags. Hover over the country of your choice and get the data you want. It’s that flexible. Tableau users, download this report for free.
Make your predictions on the World Cup!
You now don’t have to guess who’s going to win strictly based on your favorite team, you now have the data to prove it! Who do you think will win the 2014 World Cup?
Soccer image by Pallus23 of Deviant Art.
Every World Cup game I watch overwhelms me with the amount of historical numbers and statistics thrown around by game commentators about the teams and players. Soccer fans, including myself, are becoming numbers addicts more and more and we enjoy game analytics and prediction as much as we enjoy the games themselves.
There was a time, not so long ago, when statistics in soccer were only as complex as goals scored (with maybe a few other small metrics!)
This is similar to Digital Analytics where we used to foolishly measure website performance based on rudimentary data, such as the infamous hit counters! (Sad days, I know!) Thank goodness that isn’t the case anymore as every day more advanced metrics are introduced and the entire world is exposed to and becoming more familiar with data/statistics in all fields and aspects of life. Rudimentary metrics have been replaced with a world of rich numbers and sophisticated metrics. For example, soccer fans and analysts have more data to work with than most could ever use after years of analysis.
Here at E-Nor, we wanted to make this year’s World Cup even more enjoyable and interesting for marketers and analysts in the Digital Analytics industry. So we decided to record some key players’ activities as they are happening and send that data to our beloved analytics and reporting tool – Google Analytics.
As you may know, Universal Analytics is a game changer when it comes to the possibilities of what can be measured using Google Analytics. With the Universal Analytics Measurement Protocol, we can make HTTP requests and send raw user interaction data directly to Google Analytics servers. This gives us the power to measure users’ interaction from any environment – including the soccer field!
Just for fun, we collected around 300 events for every match. Lots to look at and hopefully enough information to satisfy dedicated soccer fans
In this first blog post, I will share a few reports that we already gathered during the first round of the competition. Next post, we’ll take another angle and show you how we did it and share some code samples.
This report shows the top 10 matches based on the goals scored:
This report shows the performance of the teams that made it to the round of 16. Yes, we made it; Go USA
This report shows the top 10 scored players in the first round:
This report shows the names and positions of the players with red cards:
Photo from Getty Images
As a Google Analytics Premium Reseller for several government agencies, we’ve noticed that Web and mobile analytics is as important to government digital initiatives as it is for the private sector. Fundamentally, it’s about organizations leveraging digital media to offer products and services to a target audience or to communicate and connect with constituents.
Similar to their counterparts in the private sector, federal communication managers, webmasters and those in charge of digital initiatives (eGovernment, Digital Government, etc.) need to navigate through oceans of data to derive insights to impact the business. This is easier said than done with scarce financial and human resources, and the fast pace of innovations in digital analytics.
It’s As Easy As ABC.
With a couple of tips using the “ABC’s” of digital analytics, you can simplify the complexity a bit.
This post is intended to provide reporting tips and best practices for analytics relating to government websites. If you are looking for a comprehensive how-to implementation guide check out our other technical posts on our blog for implementation best practices and posts similar to our Universal Analytics Resource Kit.
The concepts presented apply to any analytics platform, but the naming convention and the sample reports are all taken from Google Analytics (GA), since it’s the most commonly and widely used analytics platform.
We will also leverage the “ABC” framework to highlight three important reporting aspects of every government digital program:
- A for Acquisition- how visitors came to the site.
- B for Behavior- what they did when they got there.
- C for Conversion- did they do what you wanted to them to.
In addition to and for each of the above sections, we will show how you can leverage Google Analytics’ recent demographic reports to better understand your audience (here is a link on how to enable demographics in Google Analytics reports).
*Disclaimer #1: There was no personally identifying information used for the examples provided; all are aggregated data and/or case studies.
*Disclaimer #2: Data in the reports below do not reflect any specific government site; reports/numbers are listed for illustration purposes only.
Acquisition – How Visitors Came to Your Site
1. Figure out what’s driving the traffic to your website or mobile app.
Acquisition reports allow you to answer the following questions:
- Where is the traffic coming from?
- What social media networks are really working for the organization?
- Which defined campaigns are driving qualified traffic?
Let’s take a look at the Department of Education site as an example, specifically the Free Application for Federal Student Aid (FAFSA) office. Students and parents can submit the FAFSA forms through the Education Assistance Agencies or can submit the form online. Let’s say the application deadline has just ended and it’s time to analyze the traffic patterns to the online form section.
- Where did the traffic come from?
- What sorts of searches were made?
- Is most of the traffic organic or other sites referring traffic to the online form?
In the sample report below, Social is the second highest source of traffic. Perhaps specific universities had FAFSA awareness campaigns via social media and drove students to the site.
Knowing what drives the most traffic to your site (for example, the most effective social network) can help you know where to focus your attention and ad dollars in your next campaign. When we get into demographics, you can see that maybe the age group that is sharing the FAFSA information is a younger group, more inclined to use social media for communication.
Google Analytics traffic reports are available on the left side under Acquisition –> Channels
Google Analytics also offers mobile analytics capabilities. If you have a mobile app for one of the key user experiences/functions of the organization, you can easily track user adoption.
Under Acquisition –> New Users, the following report is available:
The report will show a count of:
• New Users (The number of first-time users during the selected date range.) as well overall new and returning users and the number of sessions for these users.
• A breakdown of new users by operating system (in the case above, there is an iOS app only, and if an Android version existed, it would show in this report)
• As well as New Users by App Version
2. Segment traffic by Demographics.
Now that we see that forms have been filled out, we want to know the age range of those who have opted to filling out the online form. Perhaps there is a difference between older parents vs. younger students in using online paperwork. In Google Analytics we can apply “Age” as Second Dimension and break out the traffic data by age and see the trend for adoption between the generations.
In a case like this, it makes sense that that the most popular demographic is 18-24 (since FAFSA is typically for college students).
Now that you know your most valuable marketing channel is social and mostly younger students are filling out online forms, you can tailor the messaging/designs of your campaign to the younger crowd, and focus your marketing spend on social networks.
Behavior reports in Google Analytics allow you to understand what users are doing once they have come to your website.
3. Identify engaging content.
Now that visitors are on the site, what are they doing? Downloading forms, how-to guides or videos?
Let’s look at the Teachers Loan Forgiveness Program, which is a program that encourages individuals to go into teaching by offering to forgive part of their student loan.
Say the University Career Center sends out an email to all students enrolled in the Teaching Credentials track about this particular program. In Google Analytics, you notice that there is a lot of traffic from that email. However, do you know what these visitors are interacting with on the site?
The benefit of these reports is not only can you see which pages have the most views or how much time they are spending on those pages, but you can also monitor “Event” interactions on the page, such as video “Play”, “Pause”, or “Watch to End” events (this does require custom code/event implementation). So if you’ve spent marketing dollars producing a video demonstrating how to apply for the program and want to know if it’s actually getting played or if they’re watching the video all the way through, you can see that here.
Google Analytics Events are available in Behavior –> Top Events –> Videos:
In this example report, 2,326 users have watched through the end! That’s about 40% of those who pressed play. Impressive! Seems like the video is engaging and getting the necessary information across, so it was a good investment. Maybe you’d want to invest in more instructional videos.
Note: for Mobile Apps, all user interactions within the app (buttons, clicks, navigation, etc.) can be tracked in Events.
4. Combine Demographics & Engagement to see who is doing what.
Are older users more likely to watch the video or younger users? By segmenting the engagement by demographics, you get deeper insights and can once again can narrow your efforts – tailor your messaging, wording, and visuals to the users you know are more likely to engage.
You can also see what demographic is lacking in engagement and maybe place an alternative focus on them. For example, if you find that only younger users are playing the video, you may want to have the instructions in text for older users who aren’t so inclined to play it.
While segmenting by age and gender, we can also throw social in the mix. How is this information shared across social networks? Perhaps the younger age bracket prefers sharing your page (by clicking on the “share” event you’ve created) on one social network, while an older age range prefers another. Again, knowing which age/gender comes from which social networks can help you tailor and target your paid ads and even organic postings.
Ultimately, this is the goal of your site or app. Traffic and even engagement have little value if your visitors aren’t converting. Conversions happens when users complete a task you want them to complete, which you can define and trigger in Google Analytics as a Conversion Goal. For example, this may include submitting and completing a form/application (such as FAFSA), downloading a pdf, even purchasing a product or making a payment/donation.
5. Find out if visitors are accomplishing site goals.
You’re a communication manager for a governmental agency in Dubai, UAE. You want to know how many people are leveraging the eServices applications on the site to acquire permits, doing business in the UAE or process online payments.
Let’s cover a common use case that this site can leverage. People traveling to Dubai typically want to know more about the entry visa process, what’s involved to enter the country, and better, apply for the entry visa online. One of the “goals” in Google Analytics can be set up to measure how many visitors go to your eServices section and apply for visa online. By setting up this “goal” in Google Analytics, you can now measure the conversion rate (i.e. the completion rate) of the site visitors who applied for an entry visa.
Just like any other good analyst or marketer, you heed the advice and set up this “goal” and you see that your online application completion rate is 2%. We now have numbers, let’s get some insights. You start to see a steady increase in this number, you go from 2% to 3% to %4.5. Great, what can this data tell us? The increase in completion rate, could be a good indicator of visitors’ adoption of this new eService (which means cost savings over the manual visa application). Or it could be an indicator of increased interest in visiting the country. There are other factors that could contribute to the fluctuation of the goal complete rate (such as seasonality, major business/sports events, etc..) but at least you now have a baseline that you can leverage in gaining additional insights.
6. Segment Conversions by Demographics to see who is accomplishing site goals.
Let’s pull an example from a relatively recent political event. Say you are in charge of communication in the new Ukraine government, and the country is undergoing drastic governmental changes. One of the government goals is to communicate directly with constituents. You intend on doing so by building up a large database of email addresses. You set up “email list subscription” as a Google Analytics Goal and track conversion by the various demographics segments.
What age/gender is subscribing to your newsletter? This could be a political indication of many things – it could indicate who is politically concerned or active, who is being politically neglected, or which group you might need to find other ways to communicate with.
Again, segment by demographics and you might find that majority of email subscribers are middle-aged men. As the Ukraine government, you now can tailor your email information to that demographic, but you also might want to figure out how to reach the other demographics, such as younger adults and women.
Bonus: Advanced Data Visualization Tip for Content-Rich Government Sites
All the reports we’ve shown in the post so far are from within the Google Analytics interface. They are easy to access and easy to share. For advanced users and those who are stitching data from different sources, leveraging a data visualization platform such as Tableau might be the way to go, so this tip is for you! With powerful visualization tools like this, you can quickly and easily tell a story that raw numbers just can’t.
For example, many government sites have a lot of informational pages. A common reporting request is to quickly trend all pageview data in a month-over-month format. Tableau can do just that! Once you pull in the data and organize it by content categories, you can easily see which content is popular compared to others, or which has more views and at what times.
In the sample report below, and for Category #2, notice how those pages have the most views consistently than all the other pages, especially in 2014 (The darker the green the more views you have). Thus Tableau makes it easy for to see how pages (or any metric) are doing with just a quick glance.
Keep an eye out for the next post on how to create Advanced Segments to drill down and find actionable insights from the various audiences we discussed in the post above!
Have other ideas, metrics or reports that work for your government site? Share and comment below.
Picture from Getty Images
No, this isn’t the new horror movie by M. Night Shaymalan, but there is a twist at the end!
A couple of weeks ago, Google Analytics made slight changes to their labels. They changed “Visits” into “Sessions” and “Unique Visitors” into “Users”. While intuitively this makes a lot of sense, many of our clients have been confused by the affect this has on the math and the metrics presented by GA, particularly the total visitors aren’t adding up to the total users.
New Visitors and Returning Visitors Don’t Add Up to Total Users
Let’s pretend you’re an analyst for the California DMV and you’ve been asked to find out how many people have renewed their vehicle registration online for a given time-period. Easy – you create an advanced segment to filter converted traffic (in this case, traffic that ended in registration renewal) and you look at the Sessions/Users reports to find out.
You have a total of 7875 users.
New Visitors + Returning Visitors = (7007 + 1316) = 8,323!
Which one is the correct answer of how many people signed up? First the long lines at the DMV were killing you, now the data discrepancy makes you want to poke your own eyes out.
(Note: often times sampling may cause mathematical errors, so if you’re a Google Analytics Premium subscriber, you can look at the unsampled data to triple-check and make sure it’s not being sampled.)
So, what the heck is the issue here?
New Labels, Old Definitions
Before we can figure out what’s happening, we need to understand the Google Analytics definition of each term.
A session is the period time a user is actively engaged with your website, app, etc. All usage data (Screen Views, Events, Ecommerce, etc.) is associated with a session. “Sessions” then represent the total number of Sessions within the date range.
Users that have had at least one session within the selected date range. If you think about it, this is a little easier to intuitively grasp than the difference between a “unique visitor” and a “visitor”.
The number of first-time users during the selected date range.
New (first-time) or Returning user.
An estimate of the percentage of first time visits. What this really is saying is “sessions that are of a new user”. This is the part that’s a bit confusing. If you’re a Returning Visitor coming for your second session, in plain english, this might be another “new” session, but in GA, it’s not. So by definition, returning users will not have new sessions.
Solving the Mystery: Returning Visitors and Double Counting
So to get the amount of DMV users that have renewed their registration online, looks like it’s between one of two things – adding New and Returning Visitors (different from “new and returning users”) or use the User total?
Looking at the Returning Visitors (and taking into account the date-range) is key here when making that decision and why the totals don’t match.
Users may be doubled as both New and Returning Visitors within a given date-range.
Meaning that if a New Visitor came during this time period and returned during this same time period, they’d be counted twice (within a given date-range, both as a New Visitor and a Returning Visitor.
Returning Visitors may also be “unique” within a given date-range.
What if visitor X came before the given date-range, but then later returned within the given date-range? How would they be counted? They would be counted as a Returning Visitor but that first visit would not be counted as a New Visitor within the specified date-range.
While sessions can increase indefinitely, a User can only be counted a maximum number of twice as a visitor.
What if visitor X returned 3 times within a date-range? They would be counted once as a New Visitors (if it was their first time), once as a Returning Visitor, but that 3rd visit, they already have been counted as a Returning Visitor, so while the sessions would increase, the Returning Visitor metric would NOT increment!
Calculating the New Visitors who were doubled as Returning Visitors within a date-range
To get the true number of visitors who were doubled within the date range, you’d need to separate the unique Users from the Visitors aggregate (New + Returning Visitors). Adding up the New and Returning Visitors will include:
- New Visitors
- New Visitors that may have doubled as Returning Visitors if they came back within the date-range
- Returning Visitors whose New Visits aren’t within the date range, and thus only counted once within Returning Visitors.
So the Visitors aggregate (New + Returning) is 7007 + 1316 = 8,323. Subtract the unique Users from that (7875) and you get 448. Again, since the Users are unique, you are basically getting rid of all Unique Visitors. The Returning Visitors with New Visits outside of the date range is actually a “Unique Visitor” respective to the date range, and since you are getting rid of all the Unique Visitors, whatever is left has to be the doubled visitors, which is 448.
Calculating the “Unique” Returning Visitors
Then to get the Returning Visitors that have New Visits outside of the date range, just take the Returning Visitors and remove the doubled visitors that we calculated above. So 1316 – 448 = 868. Those are “Unique Returning Visitors” if you will.
So, to the original question – in this particular case, how many individual users renewed their registrations online? Intuitively you may have thought, “Just add New and Returning Visitors”. As you can see now, those metrics may not add up the way you think it should. You’re better off going with the round number of users, and thus, the number of users who have converted (renewed their registration online) according to this report is 7875.
For more information on how users are calculated in Google Analytics, click here.