Archive for the ‘web analytics’ Category

Jan 29
2014

Allaedin EzzedinWe are happy to announce that E-Nor has been nominated for the 2014 Digital Analytics Association (DAA) Awards for Excellence in not one, but TWO categories! The DAA is a global thought-leader within the analytics industry that strives to help organizations facing the challenges of data-acquisition and application. We’ve been a proud corporate member of the association for many years and have benefited greatly from their partnership, so it’s a great honor to be nominated.

Industry Rising Star Nomination

Our manager of Digital Analytics, Allaedin Ezzedin, has been nominated for the individual category of Digital Analytics Rising Star. Described as a “hero” of analytics, Allaedin is a senior digital marketing consultant and a Certified Web Analyst with more than 7 years of experience under his belt. He is a “powerhouse” when it comes to attacking data challenges, where each carefully planned solution he creates meticulously and comprehensively covers all angles of the issue. Allaedin very involved in the industry, writing several popular articles/blog posts, several creative ebooks, even founding the company CampaignAlyzer (an online tool for campaign tagging).

Most Influential Agency Nomination

The second nomination is in the group category of Most Influential Agency for E-Nor, Inc. A great and heartfelt thank you to all the customers, community and team members. Our teams collective consulting expertise has allowed recognized brands, from Fortune 25 to start ups, to become more data-driven. We have delivered strategies, implementations, consulting and training to help companies leverage their data for making insightful marketing decisions over the years. We’ve also contributed to the industry with blog posts and articles, providing the latest strategies and developments in the art and the science of digital analytics.

How to Vote

There actually is no external link or place on the website to vote. As a DAA member, you should have received an email with your personal link to the online voting, so check your inbox! Click or copy that unique voting link into your browser.

We are very pleased that our hard work and devotion has allowed us to reach thus far. If you are a DAA Member, please vote for us!
Update: Allaedin Ezzedin is a finalist! Contrats Allaedin!

Nov 04
2013

web congress thumb
This year, we’re proud to announce our Principal Partner, Bilal Saleh, will be conducting an Analytics Workshop as one of the sessions of WebCongress Miami!

What Marketers can learn from Network Engineers
With a background in mobile telecommunications, Bilal draws a parallel between digital marketing and network engineering, particularly decision making based on measurement and analysis with the ultimate goal of achieving the best results with minimum resources. Network engineers not only build systems based on objectives/outcomes, resources/constraints, and timelines – but they continuously monitor and measure their outcomes, then tweak and optimize till their goals are reached.  These same practices can be applied to digital marketing strategies and practices to achieve highest ROI.

Workshop Objectives

Bilal will be going through what you need to know in order to “engineer” a winning digital marketing strategy, including:

  • Proper KPI’s to measure
  • Ecommerce foundational and Advanced Analytics techniques
  • The power of segmentation vs. aggregation

Workshop Details

Date: Friday, 8th November, 2013
Place: Venture Hive, 1010 NE 2nd Ave Miami, FL 33132
Contact: miami@webcongress.com
Included: Presentation and Certificate

Who Should Attend

  • Marketing Managers & Business Owners
  • Search Marketing Managers
  • E-Commerce, B2B and Media/Content Site Owners
  • Web Strategists and Digital Marketing Consultants

About WebCongress

WebCongress is an event covering attracting professionals and media from all over Europe, and Latin- America with one goal: teaching online marketing strategies by involving leading companies in the industry. Each year it’s organized in different cities in Spain and in the world such as San Francisco, Miami, Bogota and Amsterdam, with an average attendance of more than 10,000.

Click here for details about the WebCongress Conference in Miami
Click here fora pdf about our WebCongress Analytics Workshop
Click here to Register for the WebCongress Conference in Miami!

Jul 18
2013

E-Nor Texas - Google Analytics Certified PartnersClick here to read the official press release.

As the saying goes, everything is bigger in Texas. So as E-Nor gets “bigger,” it just so happens that we’re growing our analytics and digital optimization services for the Central U.S. with a new office based in the Dallas, Texas area. Local resident, Patricia Hinojos has been named Senior Consultant, and will manage client services for the location.

Patricia has more than 10 years of experience in the digital marketing realm, including consulting and implementation of digital strategies for various industries such as hospitality, health services, legal, technology, manufacturing as well as other consumer and business service industries. She has an in-depth knowledge of online user experience, digital analytics, SEO, SEM, social media and online brand management. Hinojos has a passion for leveraging digital marketing and providing intelligence for more effective customer engagement, operations and growth. She has held positions with Fortune 50 organizations, and works with strategic business development, training, marketing communications and international channel management.

“I am excited to work with E-Nor, after years of independent collaboration. The entire team here exhibits the highest level of passion for, and expertise in, measurement and optimization and they deliver on their promises. Plus, this is a fun team to work with. I’m happy to bring E-Nor a personal connection to Texas and the Central US.,” shares Patricia.

In addition to her love for digital marketing, Patricia is passionate about supporting youth organization in entrepreneurship and community service. She has supported the National Foundation for Teaching Entrepreneurship (NFTE) as a trainer and competition judge, and has also served at the local level in various philanthropic leadership positions within the National Charity League and Young Men’s Service League.

Patricia Hinojos E-Nor Google Analytics Certified PartnersAs part of E-Nor’s Central US expansion, Patricia will assist, advise and implement analytics solutions and help clients derive insights to impact the business. The new office will expand the organization’s presence in Texas and beyond, to continually offer leading edge digital analytics services, strategy, implementation, training and support, consulting, as well as Google Analytics Premium services.

For more than a decade, E-Nor has been a trusted advisor to many of the world’s top brands, Fortune 500, governmental agencies and those aspiring to establish a data-driven culture. With the addition of Patricia to our already well-seasoned staff, E-Nor is on it’s way to becoming aligned with the Texas slogan, and offering up BIGGER and better services to those in Central US.

To learn more about our expansion, contact Patricia Hinojos at (866) 638-7367 ext. 213 or patricia@e-nor.com.

Jun 21
2013

tableau ontario california mapCanada, oh Canada. We’ve extracted a handful of gems from you…Maple Syrup…Hockey…The Toronto Raptors and Vancouver Grizzlies…even Justin Bieber. Apparently, you’re also #1 in the world in fruit juice drinking (real statistic), which is an amazing talent.

If you’re a frequent reader, you might be used to us posting advanced analytics topics, such as Google Analytics Premium, Integration with Tableau, Qualitative and Quantitative integration, Cohort analysis, etc. For analytics ninjas, this post might be a bit lite. However, when you’re stuck in the complex, you overlook and forget about the basics, which have their own value – so a refresher is always good.

The Challenge: Pageviews from Canada but No Leads?

While assessing one of our client’s content marketing strategies, we found they had an exceptional amount of pageviews from Ontario, Canada. They were concerned though. For some reason though, they haven’t gotten one sales lead from that region. Are they missing out on top Canadian dollars?!

We were hoping that their analytics data could give us some insights as to what was happening and why they weren’t getting leads from there. In this post, we’d like to demonstrate how we used Google Analytics in a simple/basic way to extract some insights into such questions.

A Closer Look For Patterns

When we looked at their data, we created an advanced filter that only showed visits from the region Ontario and we saw this:
ontario filter google analytics

ontario blog traffic google analytics

Anything jump out at you? It seems that most of the urls in the top content from Ontario have “/blog” in it (the client has 2 sites connected to this domain – a main site and a blog).

Interesting. We were wondering if that pattern had any connection.

Validating the Theory

So we compared this to a region where they were getting a healthy amount of traffic and successfully generating leads – California. When we filtered traffic for California, at first glance, the pageviews looked fine. Thinking about the pattern from Ontario (“/blog”), we then filtered even further for only California blog traffic. There really didn’t seem to be anything unusual.
california blog traffic google analytics

So what was the issue then??? Well, keep in mind, we’re not only concerned with pageviews, we’re concerned about leads. In other words, conversions define as leads, which in this case, the client defined it as contact-form submissions. Both reports show a healthy amount of pageviews, however, one region is generating leads, one is not.

Looking at the conversion report for California, overall, it maintained a healthy look. But after again filtering for only blog conversions, then comparing it against Ontario, that’s when we uncovered the gem! Consistency in the theory!

blog-only-california-conversions

Conclusion

Voila! When both regions are filtered for blog traffic, the percentage of conversion balances out (in this case, the visits were almost equal so the conversion being 1 is an equal percentage of conversion)! We can’t say definitely, but after drilling down the data, signs lead to the blog not necessarily generating leads the way the client wanted (and since most Ontario visits were blog visits, they don’t so much get Ontario leads).

That’s one way to get insights using some critical thinking and the tools in Google Analytics. Of course, there are infinite ways to torture the data and therefore infinite insights.

Real Analytics ninjas may also be thinking that form conversion shouldn’t be looked at in a vacuum – for the blog, there should always be micro conversion goals, such as email newsletter subscriptions, sharing, comments, does it refer to the main site, and generate interest or micro conversions there, etc.

The next next step is our analysis is understand the behavior of users across multiple sessions and answering questions like: are visitors who read the blog come back and convert in later sessions.

We promised to keep this blog post lite, so we will answer this question in a future post! :) Now it’s your turn, how do you use Google Analytics to derive actionable insights.

May 09
2013

Feras Alhlou portrait thumbnail
Feras Alhlou Digital Analytics Assoication 2013 Board NomineeWe’re excited to announce Feras Alhlou has been nominated for a seat on the 2013 Digital Analytics Association Board.  The DAA is a non-profit, volunteer-powered organization consisting of big names in the analytics industry that, among other things, aims to unite and educate individuals who have a passion and aptitude for digital analytics.  

If you’re a member of the DAA, and believe in Feras’s vision for the organization, vote for him! When asked by the DAA Election Committee where he would like to see the organization in two years, his response was:

“Looking ahead, I envision DAA as a leading organization in the broader analytics space. I would like to see membership go beyond web analytics to also include a larger spectrum of marketers and business analysts. As the industry tends to grow, so too should DAA, to embrace those who utilize various digital aspects in their day-to-day responsibilities.

“DAA should be seen as an educational resource throughout the communities in which the organization is established. By reaching out to existing businesses, colleges and universities, DAA can be seen as the go-­? to organization for digital know-how. And in turn, grow and gain membership.”

Background

Feras is the Principal Consultant of E-Nor, Inc. which he co-founded in 2003. He is passionate about improving his client’s ROI and has led his organization to implement and launch successful digital marketing and analytics strategies for E-Nor’s diversified client base. Under his leadership, E-Nor has worked with numerous Fortune 500 companies and organizations within the educational, government, retail, B2B, High-tech and non-profit sectors. The company has achieved qualifications as a Google Analytics Premium Authorized Reseller, Google Analytics Certified Partner (GACP), Google AdWords Certified Partner, Google Urchin Software Certified Partner and Google Website Optimizer Certified Partner.

Feras has an extensive background in digital marketing consulting, search marketing, web analytics, mobile and marketing optimization. He has traveled the globe educating businesses and marketing consultants on the subjects of search marketing, online marketing and digital analytics. He is a member of the Digital Analytics Association (DAA), co-chair of the San Francisco Bay Area DAA chapter, and serves on the DAA Examination Sub-Committee.

Feras is a blogger and writer, and has been published in WebProNews, Wall Street Journal/Smart Money, Web Marketing Today, Independent Retailer and the official Google Analytics blog, among others. He is also a speaker at various marketing and analytics industry conferences throughout the world.

Prior to E-Nor, Feras was the Vice President of Professional Services and Consulting for Syndeo Corporation, a telecom application provider. Feras received a Masters of Engineering Management from the University of South Florida and a Bachelors of Science in Electrical Engineering from the University of Tulsa. Feras is married and has three children and enjoys volunteering, reading, skiing and Aikido.

Some Funny Campaign Material! Help us by sharing!

on his way to deliver a Digital Marketing & Analytics workshop in Qatar, we took the liberty of coming up with these funny campaigns posters. Everything in them are 100% true and accurate and have not been embellished or edited in any way ;)

feras-obamify-300px

Feras Alhlou Romney Slogan

Feras Obama Family Parody Image

Feras Romney Portrait Parody

Feras Bush Baby Crying Parody

Apr 19
2013

…and boy is Jasmine jealous!

alladin and alice campaignalyzer founderWorking in the Silicon Valley is an awesome ongoing adventure. The spirit of entrepreneurship, creativity, hard work, and fun is always there. Even large companies like Google have the “20 percent time” program, where Googlers are allowed to use 20 percent of their work week to pursue any special project they like, which Google claims many of their innovative products to have originate from.

Here at E-Nor, such innovative spirit is integrated in our culture and company’s DNA. We try to think about data and analytics beyond the 8 (official) working hours :) Such spirit can be found in a project of one of our lead analysts and long time blogger, Allaedin Ezzedin, in a little fairy tale called “Alice in Marketing Wonderland”.

For your digital marketing amusement, if you’re a child of Analytics ready for a wondrous journey through a world of marketing fantasy, watch the video below!

If you are an Apple user, download the iBook version of the story here.

Mar 11
2013

google analytics new user permissions

Previously, Google Analytics had only 2 roles (“Admin” and “User”), which are very limited. They announced today that they’ll be expanding the flexibility of access – which is good news for anyone that has multiple hands in their Google Analytics accoqunt cookie jar (you have multiple accounts/properties/profiles but want to give…

  • …different employees different access/security roles to specific properties/profiles.)
  • …particular clients/agencies view or admin access to specific properties/profiles, etc.)

For detailed instructions on the new permissions system and how to set it up, visit the Google Analytics support entry here.

Google Analytics Account Tiers – 101

For those that are new to the structure of Google Analytics accounts, they’re broken down as follows:

  • Google Analytics Accounts – this is the general account you set up for analytics. It would be on an organization basis. Example, an analytics account for E-Nor, Sony, Proctor and Gamble, etc. This is the large bucket and you get an assigned ‘UA’ number.
  • Properties – Under the account, you can have multiple “properties” – website 1, website 2, mobile app, etc.
  • Profiles – Within each property, you can have multiple profiles. Maybe for your website, you want a profile that only shows E-Commerce data. Another example, say you’ve filtered out all your company traffic from your profiles so you only see data from “visitors”, not your developers doing work on your site. You also have a backup profile (always have an unfiltered control back up profile!!!). Etc.
  • Users – In order to give someone access to a Google Analytics account/property/profile, they must have a Google Account.

google-analytics-account-structure-diagram

The “Old Ways” and its Limitations

God Mode
As it works now, the user permissions are pretty limited. You can only have admin access at the account level (all properties/profiles under the sun). Nothing in between.

If you have multiple properties (say website and mobile app), and you want to give a specific user/client admin access to only a portion of that (say, yet you want say the website development team to only have access to the website property/profiles), this wasn’t possible.

User “View Only” Access per Profile
Also, you could only give users “view only” access per profile. If you wanted to give users “view only” access to all profiles within a property, you’d have to manually select each profile under that property and give them access.

Enhancements and Improvements

User Permissions at Every Level!

Analytics users have been requesting more granular user permissions. Today, we got the answer from the Google Analytics Blog. They’re expanding these options and will allow you to basically set access at every tier. Set users to have view/admin specific to properties, profiles, and/or the entire account. No more worrying about a user having too much admin access. No more having to manually select profiles per property – you can set access to whole properties.

google analytics new permisions

Tiered Access
We now have the ability to give different access specific to each tier.

For example, while a user can now have permission to say view the entire property, you can also limit their admin access within that property (per profile). Example, give the website developers access to view the entire web property, but only edit the E-Commerce profile.

The only trick is admin access inherits permissions from its parents. Meaning, if you have full account admin access, it wouldn’t make sense then to only have “view” access to specific properties/profiles under that account – you have full access.

New User-Role: Manage Users
We know that today Google Analytics has 2 roles of access – “admin” access (which gives users permission to edit Google Analytics accounts/properties/profiles) and “view only” access.

They’ve now added a third role called “Manage Users”, which allows that that user to add and delete other users as well as assign them permissions. This is different from “edit” and “view” permissions.

Conclusion

Pretty cool! Give certain employees/agencies specific access so they don’t mess up other profiles! (NOTE: Your account may not yet have this feature, but Google is working on migrating all accounts to have this within the upcoming weeks, so keep checking for it).

For more information on the new permissions system and how to set it up, visit the Google Analytics Support entry here.

Mar 08
2013

combine qualitative and quantitative dataA couple of weeks ago, I wrote a post about marrying qualitative and quantitative data, giving recommendations on how to conceptually combine both types of data for more useful insights. For the savvy marketers and the analysis ninjas out there, you want a tighter integration, and of course, more segmentation on the qualitative data. Visitors told you “No, I didn’t accomplish what I came to the site for” and “that pricing was too high”. Now, maybe you want to know…

  • …where these “No’s” and “Yes’s” are coming from
  • …what content they are consuming
  • …what campaigns are driving these segments so you optimize at the source

In this post, we’ll cover this – the insights you can get from a direct integration of Google Analytics and Qualaroo.

Google Analytics – Quantitative Data Tool of Choice

It’s no secret that Google Analytics is our web analytics platform of choice. It’s a “monster” when it comes to providing web usage stats. It’s the gold standard. And as far as pricing, the cost benefit is unbeatable – it’s free (and if you want more data and enterprise analytics consulting, Google Analytics Premium is there for you). When planned and implemented right, you can get a wealth of qualitative data on your website – what pages are visited, where they come from, what keyword they searched for, how long they stayed, who converted – etc etc etc.

Qualaroo – Non-Invasive Voice Of Customer Survey

As far as qualitative data, Qualaroo can be your best friend. As an internet surfer, I’m sure your feelings are consistent with the rest of the world – forms and surveys are kind of annoying. They’re long, tedious, and often a waste of time. What we like about Qualaroo is how non-invasive it is. A small question will pop up and a visitor has the option of quickly answering it, or quietly dismissing it. We feel this increases the likelihood of it being answered.
We also love its configuration flexibility. “Nudge” the question after 30 seconds. After a visitor has visited 2 pages. Publish the survey from a certain date, shut it off after a certain date. Display only on certain pages. Etc.
Note: to integrate Qualaroo data in Google Analytics, you need to sign up for Qualaroo’s enterprise edition.

Google Analytics and Qualaroo Integration

With the ability to integrate Qualaroo data into GA, you now have a very powerful surveying, measurement tool. You can see “what’s” happening on your site by looking at the Google Analytics metrics. Then, with Qualaroo integrated into Google Analytics, you get a deeper understanding about “why”. Google Analytics itself will tie the connections between your qualitative data and quantitative data, between your “what” and “why”.

ROI by Channel

Here’s a simple example. Your company sells a SaaS product targeting CMOs and Marketing Managers at medium and large companies. You have your paid search campaigns running on AdWords and Bing and you want to expand into new paid social ad campaigns. You have ads on the following social networks:

  • Facebook
  • Twitter
  • LinkedIn

Your landing page is converting, but it’s not converting like it should be, and you’re looking to really cut down your ad spend and optimize ROI. Your quantitative numbers tell you the following:

  • Your spend is about equal (budget was set by yourself).
  • There actually is a lot of traffic from Facebook and Twitter and LinkedIn.
  • However, it looks like you are getting very few conversions.
  • You wonder:
    • “Why is that?”
    • “Should you continue spending on these channels?
    • If you shut down these campaigns, what opportunity are you missing?”

Thus, we add the following survey:

Qualaroo Survey - Did you accomplish what you came for

Your goal is to understand what’s happening and why your visitors can’t find what they are looking for and thus not converting. With Qualaroo Enterprise version enabled, some cool Qualaroo event user interaction can be reported in GA (an event is fired based on user interaction with the survey). The image below shows the number of events when responders answer “No, we didn’t accomplish what we came here to do”. Here is what we see in GA (go to Content –> Events –> Top Events –> and then click on the Qualaroo Enterprise Event Category):

qualaroo google analytics events aggregate

Your first reaction is :( , so many people (and a high percentage of the total responses) can’t find what they are looking for, no wonder they are not converting. Time to dig deeper and segment.

As we know, once you have the event captured in GA, you can make it a goal or segment on it in whichever way you like. In our case, we want to understand where the No’s are coming from. Let’s take this specific event and segment the report by channel (apply secondary dimension to the Top Events Report) and voila! You have the channels responsible for driving the unengaged visitors.

Google Analytics Qualaroo exvent segment by Channel

In the snapshot above, you see LinkedIn is a potential culprit here. We love LinkedIn and we’d expect it to generate high value leads, what’s going on here? Our paid ad LinkedIn campaign appears to be bringing visitors who are not interested in the SaaS product. After verifying the statistical significance (and correlating the number of “no” events with the traffic volume from the respective source) and looking at some of the survey responses, so of the answers to tell us why you didn’t find what you came here for were very revealing, here is a sample of these answers, once you read them, you’ll know exactly why the campaign is not converting.

  •  ”I can’t find the technical product description”
  • “your product appears to be solid, but I am interested in customization features and API import/export capabilities”
  • “how technical does the system admin need to be, I can’t tell from the info provided”
  • “I am a system admin and I need to know your system up-time and technical support you provide, can’t find this information”

Most of the answers/comments were of a technical nature, and appears to come from IT folks and your LinkedIn ad campaign (including the landing page) is all designed around speaking to the CMOs!

These insights are very actionable. Two immediate actions are now taken to adjust our targeting options, and really optimize our ROI (by maybe putting our budget towards these better channels).

  1. Cost savings: Enhance the LinkedIn targeting to marketing managers
  2. New opportunities: create a new campaign/new landing page with information requested for the IT folks.

 

ROI by Keywords

Now, say you’re spending on Google AdWords. You really want to know if specific campaigns or keywords are driving the traffic and unengaged visitors.

Again, we take the specific event and segment the report by keyword (apply secondary dimension to the Top Events Report) and voila! You have the culprit keywords.

qualaroo google analytics events keywords

Is this super insightful or what?! (keywords blurred to keep our clients identity anonymous…)

Stop bidding on these keywords or direct traffic from these keywords to a lower price-point product and see your sales go up like you’ve never seen before!

Here you have it, if you feel like you are hitting a wall and not sure what to do to improve your conversion rate, go back to the basics and “listen to your customers”!

How have you used voice of customer tools to improve your site and campaign performance? Very interested to hear your stories.

Feb 27
2013

Googel Analytics Real TimeWhen working with high volume sites, slicing and dicing the data can be challenging, and looking for insights is very much like Tom Hank’s famous quote from the movie Saving Private Ryan – it’s like “finding a needle in a stack of needles”!

At E-Nor, we’re proud to work with some of the most recognizable brands in the world. Our clients expect sophisticated measurement and deep insights, more than “ancient” basic metrics like “total visits” or “site wide conversion rates” :) .

So what do you do? One thing I’ve learned over the years (the hard way at times!) is that as a consultant, and the same applies to marketers and practitioners, you should focus on what matters most to the business. Find creative ways to measure/report/analyze and find “gems” that truly impact the business. Along the way, that will make you look like a hero (and will ensure long-term employment!).

In this post, I’ll cover the challenges and solutions for understanding user behavior and cohort analysis across multiple platforms. The business we’re using as example is a large media organization where you “Sign Up” to access content. You then have the option to upgrade and buy a “Premium Subscription” as well as access to buy exclusive products and services. And in case you are just getting used to this type of analysis, a typical cohort analysis will show you the behavior of a “class” of visitors, typically segmented by an action on a specific date or date range.

We’ll cover:

  1. The Cross-Platform Challenge
  2. The Measurement Approach
  3. Integrated Reporting & Insights

1- The Challenge – Web, Mobile and Offline

In this multiple device, multiple platform world, understanding user behavior and measuring “what matters” require planning (and a bit of process) way before jumping into tagging and JavaScript. Especially as we start shifting our thinking from measuring visits and conversion rates, to visitors and customer lifetime value. I won’t get into the technical instrumentation of cohort analysis (just Google it, you’ll find many posts on the basic “how-to”). I’ll focus on the user-centric approach and marketing insights.

“Out of the Box” Cohort  - Mixpanel Analytics
Some analytics tools have cohort analysis built in their standard reports. For example, you could be using the Mixpanel platform (and assuming you’ve planned and implemented your events properly), you’ll get very meaningful cohort reports that can shed some light on user behavior over time. Say you have a content site where a subscription to access is required, you’d want to know if your users are coming back and consuming that great content you produce, if a cohort of users whom you acquired in a specific time period, are likely to be more loyal than others.

A standard Mixpanel cohort report will look like the snapshot below:

cohort mixpanel screenshot

The first column shows the date at which the “Sign Up” occurred. The “People” column shows how many people signed up on that day (e.g. 10,324 on Feb 5th, 2013) and the percentages represent the percent of people who come back after x-amount of days (where x is 1 to 12 in this chart). So for the Feb 5th cohorts, 1.84% of them came back and consumed more content two days after signing up.

In addition and without a lot of digging, you can clearly see that the segment of visitors who signed up on February 8th are super engaged in the first seven days, and they are coming back for more every other day. On the other hand, those who signed up on February 6th, behave completely different. They are interested initially and then their interest taper off.

Campaign Segmentation in Mixpanel
You are hungry for more insights, what do you do? Jump over to Mixpanel’s Segmentation reports (you can segment on the fly by region, referral and even Google Analytics utm parameters) and dig deeper to find the source of those who signed up on the 8th. You’ll notice here that the campaign that peaked on the 8th (in green) is likely to be a very good driver of such an engaged audience.

cohort_mixpanel_feb05-feb10_segmentation
That’s good to know, but you are still not yet satisfied. The data above is from the web channel only. You are missing other acquisition channels.

In line with our cross-platform and the 360-degree customer view approach, let’s take this analysis to the next level for a large media site. Visitors register to access and share content, and with a paid “Premium Subscription” option then have access to discounted/exclusive products and services. You’d want to track user behavior across all potential channels on which a prospect might convert. A prospect can buy a Premium Subscription:

  • On the website
  • On their mobile app
  • Dial the 800 number and sign up “offline”

2- Solution Design – Analytics & Measuring Across Platforms

This large media site uses Google Analytics Premium and also has Flurry Analytics for their mobile app. But no matter what analytics platform you are using, this multiple-way conversion presents quite a challenge to cohort analysis in any one analytics product. Time to stitch and tie!

To have the 360-degree view of the customer, and stitch all the disparate data from the web, mobile and offline, there is a technical implementation aspect and a little bit of process. So yes, work is required, but the anticipated results are definitely worth all this pre-requisite hard work.

The highlights of what is needed include:

  • Web data — extract data from Google Analytics Premium
  • Mobile data — download your events data from Flurry
  • Offline — export your purchase data from your backend

And here are the details:

Web Analytics: Google Analytics Premium unsampled reports with the following metrics/dimensions:

  • Revenue
  • Date of transaction
  • Cohort date – The date the Premium Subscription took place, and is stored in a visitor-level Custom Variable 1
  • Unique customer ID, (of course, no personally identifying information), stored in visitor-level Custom Variable 2 (we will use this for the advanced user-centric tip at the end of the post)

Note: As previously stated, this is not a technical post, but here is how you’d set up Custom Variables. You’ll also need the help of your IT/dev team to coordinate the passing/managing of the unique ID in the backend system.

In Google Analytics, run an eCommerce -> Sales Report, and choose your Cohort date (CV1) as a secondary dimension, you’ll have something like this:

cohort_sales-performance_20130109
The table above shows the dates/revenue after the Premium Subscription date (e.g. CV1 = 20130109, January 9, 2013) during which a transaction took place, along with the revenue associated with these transactions. Now, say you want to see how the January 9th cohorts did compared to the January 12th cohorts. , Simply create an advanced segment for each of the Cohort dates and the graph will look as follows:

cv-advanced-segment

Here are the findings:

  • The January 9th cohorts brought in 2.84% of the revenue
  • The January 12th cohorts brought in 1.94% of the revenue
  • There were no more sales from either cohorts after January 21st

Once the “Cohort date” data has been collected, you can also plot it in Excel or Tableau in a traditional cohort chart. We will cover this later in the post.

Before we move on to more analysis, insights and actions, we still need to complete the picture. Remember, our subscribers can upgrade to a Premium Subscription using the mobile app as well. So let’s take a look at the mobile data next.

Mobile Analytics Data – Flurry Analytics come to the rescue
This client is an early adopter of mobile and has leveraged the powerful capabilities of Flurry Analytics since day one. The client has done their homework and planned out their user actions (aka Events) and did not just settle to track screens and buttons, but is also tracking outcomes like In-App Purchases (IAPs).

Similar to what we gathered from Google Analytics, in Flurry Analytics we want the following information:

  • An event when the Premium Subscription purchase takes place, date stamped for our cohort analysis (e.g. 20130109)
  • Revenue associated with purchases
  • Unique user ID (and again no PII please!). The user ID will show in your Flurry Event Log (we will use this for the advanced user-centric tip at the end of the post)

flurry event

As you see in the image above, your “time stamped” mobile app eCommerce data is now available.

We can create a segment in Flurry under Manage –> Segments and choose the Premium Purchase Date as the custom event/parameter for the segment, and then export this data (download as CSV or leverage the Flurry API). If you are downloading the CSV, your parameters (revenue, etc.) will be available in one cell in Excel, and you can easily parse the parameters you want to include in the report.

Offline – Backend Data
Well, we are almost there! Since the client’s system allows for offline Premium Subscription upgrades as well, we need this offline data integrated too. These elements are required from your backend:

  • Premium Subscription date
  • Date of purchase
  • Revenue
  • Unique customer ID

And finally, we download the offline data in a CSV file, and we are ready to rock and roll!

Note: if you are forward thinking and like to get your hand into the latest and greatest, then Universal Analytics (from Google Analytics) will be an option here. With Universal Analytics you will be able to import the offline user interactions into Google Analytics and map it to existing data.

3- Integrated Reporting – Customer 360-View, Tableau Dashboarding & Insights

If you’re using a data warehouse or a database one approach would be to present all this data in Tableau using its optimized connectors available for many data environments. If you haven’t made the investment into your infrastructure yet, or you don’t have the IT resources to leverage these connectors in Tableau, you could extract your data into CSVs from Google Analytics Premium, Flurry and your backend system and upload it into Tableau.

Now that you have your data ready from the three data sources (web, mobile and offline), it’s time to tie it all together, visualize, analyze and find some awesome actionable insights. Your common element for this analysis is going to be the Premium Subscription Date.

tableau-data-environments

Aha! The cross-platform full picture is ready for you. You see the value of those who signed up on the 9th of January (in terms of sales and revenue), and you start understanding where they came from, what offer resonated with them among other factors.

Advanced Tip# 1 – Google Analytics Tableau Integration
If your business is a pure online play, and your subscribers can only buy on the website, I have a very nice surprise for you (kept this till the end to reward the loyal readers :) ). With Tableau version 8, there is a native integration between Tableau and Google Analytics (in beta but works well), meaning you can pull your dimensions and metrics directly from GA and into Tableau. You bypass the need to download files, reformat and upload. I’ll share the tips on doing so in a post by our Tableau geek extraordinaire Shiraz in the next few days. (Please note if you have a large site with high volume and you are getting sampled reports, this method will not work for you. For now, you’ll have to download the unsampled reports and then upload into Tableau).

Advanced Tip# 2 – User Centric Analytics
In-line with our emphasis on concepts such as user-centric analysis (and Universal Analytics), and in capturing data from different sources, I emphasized the need to include a unique user ID when customers buy the Premium Subscription. Once you have this common user ID (aka key) you can run all sort of sophisticated analyses in your Tableau or a BI tool of your choice. Examples include:

  • Customer Lifetime Value (LTV)
  • Recency & frequency across platforms (web, mobile, offline)
  • Segment high ticket item customers
  • Map demographics data (available in Flurry and/or your backend system) with web data
  • Plus more and more scenarios that I’ll leave for future posts

So there you have it, how to create a cohort analysis across mobile, web and offline platforms. I hope you found this post useful and I look forward to hearing your comments and input!

Feb 26
2013

browser-bar-google-analytics

What in the….? “Google Analytics” is a browser?!

(For the quick answer, skip to the “Conclusion” below…)
We ran into a confusing situation the other day with a client. They were getting traffic from a browser called “Google Analytics“. It threw us for a loop, because obviously, we’re familiar with Google Chrome, Firefox, the awesomeness of Internet Explorer (sarcasm), Opera, and Safari. Haven’t had the chance to use the Google Analytics browser though.

That’s cause there isn’t actually a Google Analytics browser as you might have guessed. So we were weirded out to see that in our reports. What does it mean when you see on your reports that a large number of visits are coming from “Google Analytics”?

Browser equals Google Analytics

Here’s what we figured out:

On a hunch, we decided to segment for mobile traffic only.
Google Analytics - Advanced Segment Mobile

The number of visits from the browser “Google Analytics” essentially didn’t change (the change was so minor, we could assume this was due to sampling). Thus, it looks like this traffic is pretty much mobile traffic.

Browser = Google Analytics - after mobile advanced segment

For this client in particular, they saw a spike of traffic that corresponded to this number. We asked if anything special happened around the time of the spike. They confirmed that they had recently launched a new version of their mobile app.

Need Help With Google Analytics? Click Here

Conclusion: The Answer Is…

After some more digging and testing, we concluded that when the browser says “Google Analytics”, it’s mobile app traffic! Apps using either the iOS or Android SDK for Google Analytics will report their usage under the browser “Google Analytics.” Not sure when Google will change that, but hopefully, that will help anyone trying to solve that mystery explain to their executives or clients where this traffic is coming from. One method of preventing this from happening entirely is to report mobile app traffic to an entirely different account than your web traffic.