Category Archives: Google Analytics

Google Analytics

Tracking Restaurant Orders in Google Analytics

Being able to see your basic website usage stats like visits and page views is good, but being able to understand what channels drove more revenue and transactions is even better. A vast number of web analytics software provide the flexibility to do this type of custom tracking, but little do we know the advantages it can bring.

I recently began testing a more unique usage of Ecommerce Tracking in Google Analytics for restaurant websites. And so far, it’s been a fairly smooth sail. If you’re just starting with Ecommerce Tracking in Google Analytics, I recommend reading Justin’s 4 part series on this subject on his blog.

One might think that Ecommerce tracking is only for online stores. And yes, it’s been built right from the start to serve online retail websites that have a checkout engine. But, any website can have its own funnel and way to convert visitors into monetary gains. My approach from the very start was; “how can I fill as many of the fields with the relevant data points on a food order as possible?”

The Restaurant Scenario

Local restaurants struggle to keep up with all the activities that are happening online. They:

  • Don’t have the bandwidth to manage their online presence;
  • Lack the knowledge to do things right that will drive results; and,
  • Shouldn’t have to because they should focus on what they do best; Cook!

Some of you may dined at a Cathay Restaurant in Ottawa at some point (if you’ve ever visited the city). My family used to own that. About 2 years ago, we sold it as the partners, including my dad, were ready to retire. The restaurant business was also becoming more fierce as more variety started to hit the city. One of the struggles was online. We didn’t have an online ordering system. As a result, there were customers that we lost because we didn’t have an online menu for them to place an order without needing to pick up the phone and calling. I see two benefits with online food ordering systems today:

  1. It gives local restaurants another acquisition medium to gain more customers;
  2. Reduce mistakes on delivery addresses and orders; and,
  3. It relieves the stress and reduces the amount of work for employees who answer phone calls to take orders.

Almost every restaurant will offer delivery and takeout services. This is essentially what we want to track in our analytics backend. So yes – this requires communication between two systems; your database for where orders are stored and Google Analytics. By creating a communication channel between these two systems, we can start to answer the following:

  • How many delivery / takeout orders were places over a time period in relation to our website traffic
  • Which day(s) do people visit the website more, and does that correlate with online orders
  • What combinations of food orders are most popular for online orders
  • What is the most popular dish for online orders
  • From what sources / mediums were most orders driven from
  • What sources / mediums assisted in the converting of a customer
  • # people who viewed our menu and left
  • # people who viewed our menu, proceeded to checkout and left (unsuccessful conversion)
  • and probably more…

Being able to look this data and determine what sources drove more online orders is, to a business owner, golden! As an analyst, I would then be able to go back to my client and tell them where they need to invest more money in order to drive more qualified traffic and conversions.

I’ve been in luck to work with Menu.ca’s online ordering system, injecting their’s systems data (transactionID, items, etc.) inside Google Analytics. Their system is robust, clean and serves local restaurants owners well. They are also a cost-effective solution for any business what requires a custom website and an online ordering system.

menu.ca and google analytics logo

Getting this into Google Analytics

For e-commerce tracking to work in Google Analytics, we will need to turn the Google Analytics e-commerce tracking option ON in your profile settings, and then add a few lines of code to our receipt page.

Step 1: turn on e-commerce tracking in admin > profile > profile settings

ecommerce profile setting in google analytics

Step 2: write the code and upload it to the receipt page

There are three methods we need to call: _addItem(), _addTrans() and _trackTrans(). I’m not going to go through the nitty gritty so you’ll have to either follow the detailed documentation or check out the 4 part series I mentioned earlier (it’s awesome again). But let’s walk through how we define our methods / variables.

The _addItem() method is where we add each individual dish from our menu. For instance, we may have the following:

_addItem(transactionId, sku, name, category, price, quantity)

  • transactionId = orderID
  • sku = dishID
  • category = delivery/takeout
  • price = price of the dish
  • quantity = number of orders per dish

For the addItem(), you may even add a Delivery Fee to your order list if delivery was selected. When takeout is selected, you will need to disregard the delivery charge.

_addTrans(transactionId, affiliation, total, tax, shipping, city, state, country)

  • transactionID = orderID
  • affiliation = restaurant name
  • total = total after taxes and other charges
  • shipping = tip amount
  • city, state, country = disregarded, I didn’t use these fields

Finally, in order to push this information into Google Analytics, we need to execute the _trackTrans() method. Once that happens, you should start to see this data populate in your Ecommerce Reports.

How does the data look inside Google Analytics?

You’re probably wondering how this data populates into the Google Analytics reports… here are a few screenshots of the data I’ve got right now:

ecommerce overview report

The E-commerce Overview report will give you high level performance metrics for a given timeframe. It will how you the how well your site converted your visitors, how much money you made, how many orders were placed and the average value of each order.

google analytics ecommerce transaction report

The e-commerce Transactions report will break down each order transaction, detailing the revenue, tax, delivery tips (if delivery was selected and the customer confirms a % tip on the site prior to checkout) and the amount of dishes per order.

conversion by source

This is cool – for the first time, restaurant owners can see where most of their “qualified traffic” is coming from. This All Traffic (under Traffic Sources) report breaks down by source / medium where most visitors came from, and from where they converted. *Valuing a source requires us taking a look at the amount of traffic and transactions that took place. So while Bing has a high per visit value, it didn’t drive nearly enough traffic and sales as Google organic. It’s interesting to see other mediums like Facebook, Urbanspoon, TripAdvisor and Yelp driving sales too.

google analytics mobile ecommerce report

How many orders came from mobile device compared to desktop?

Closing Thoughts

The steps to implement this properly to bring accurate / real-time data into Google Analytics was definitely a walk in the park. It required some creativity, careful planning and some technical skills to get custom code up and running. Google Analytics offers a good solution for tracking restaurant orders, but it could be better.

Because the commerce tracking fields are limited to the variables outlined above, there are a few things that I was hoping to include but couldn’t:

  • Upsell items (i.e. pizza toppings often come at an additional cost. If toppings could be grouped within an item, that would be cool!)
  • Categories for transactions (currently we are only able to categorize items, which makes sense from an ecommerce standpoint. Categories for transactions would allow us to categorize delivery and takeouts).
  • Payment methods – cash on delivery, credit card or debit are often the sorts of options that delivery services offer these days.

I would be happy to hear if anyone’s gone through this exercise before and if they saw benefits of this feature for restaurant websites. If you have any other ideas for me to try out, please let me know below!

Google Analytics

Using Month of Year Dimension in Google Analytics Custom Reports

Lately, I've been spending a bit more time inside the Google Analytics Custom Reporting section making notice of some new dimensions appearing in the drop downs (notably the month of year dimension). I'm a huge fan of simplifying and automating the reporting process and I think custom reports delivers on allowing Google Analytics to be more flexible for analysts to create their own views of how to lay out data in a table.
 
Custom Reporting vs Standard Reporting
 
Justin Cutroni wrote a great column on what custom reports are and how you can construct your own to suit your needs. To illustrate how useful this (these) dimensions are, I will walk you through an example here.
 
Let's pretend you are an SEO today and you've been tasked by your manager to give a report and presentation on how the company's been doing in search. So you log into Google Analytics and head over to the Organic Search reports, stretch your 
timeline back one year, take a screenshot and show your boss in a PowerPoint deck. Let's also say that in the past year, there were 20K+ keywords that brought new and existing readers to your site. So you export that as a CSV, so a bit of Excel magic and present that too. 
What do you think your boss will say? He will probably say 'thanks' and wack you across the head and tell you to come back with something better! 
 
So why might this not work? 
  • It takes too much time; everytime you need a report like this you need to navigate to the organic search report, configure your dates and take screenshots that are deemed useless when it comes to reporting
  • Can't scale it; continuing down this path will not only be time consuming, but the process doesn't make sense if you know exactly what you want and there are other solutions to get it done quicker 
  • Be a creative thinker ('like a boss'); your boss probably hired you to do this because he say something in you. Maybe he knew you can do something but also wanted you to go beyond a simple screenshot of a trendline
So how might you approach this differently? 
 
Let's use Custom Reports :)
 
First, you will want to navigate to the Custom Reporting section of Google Analytics. You can find along the top orange navigation bar. Then, you will wanted click Create Custom Report. Here, you will need to give your report and the report content sections names. Here is what I have: 
 

 

Custom Reporting in Google Analytics
 
After you've done that, you'll need to select your Metrics and Dimensions. 
 
The metrics we will choose here will be Visits, Revenue and Transactions because I'm interested in understanding  how the volumes of visits from organic search correlate with sales. 
 
Metrics in Custom Reporting
 
For dimensions, we will select Month of Year
 
Month of Year Dimension
 
As you can see, Google Analytics allows you to assign specific time dimensions to your custom reports. I believe this is a new feature (correct me if I'm wrong) in Google Analytics and haven't heard it being up at all in the Analytics community. This dimension is extremely powerful because it allows you to aggregate all your visits into buckets (months) and get a nice table showing you how many visits came in each month, how much money was made and how many transactions were processed. 
 
In the past, I've had to use NextAnalytics to generate a report like this. But not anymore! 
 
Finally, the last step is to apply a filter to your report. Because we're interested in visitors who performed a search to come our website, we will include visits where medium is organic, as shown below: 
 
Filter Organic Custom Reports
 
Now you're done! If this was your first custom report ever created, give yourself a pat on the back! 
 
Here is what my report looks like in the end: 
 
Custom Report with Month of Year
 
Remember, if you are exporting this data, remember to increase your row count because on default it will only export 10 rows (10 months). 
 
I don't think custom reporting is all that difficult. Do you? If you have any thoughts or ideas about my approach above, please share your comments below, would be happy to hear from ya! :)
 
Now, get out and have fun with custom reports!

 

Google Analytics SEO Web Analytics

My first impressions of the (not provided) data in Google Analytics

Many of my friends working in the SEO space have expressed grief around Google's recent change on how they track organic search visits in Google Analytics. I too, am not very happy with this change, but like many others who have expressed their opinions in the Google analytics blog, it will have me twiddling my thumbs to decide what to report on if the % of organic search ever exceeds 10%…

A bit of background of what happened… the change is reflected on users who are signed into their Google account and makes a secure search under httpS://www.google.com. For example, if you make a search for "super mario custume" in Google, your query data will not be seen in the website owner's analytics software. Instead, the reports show up as (not provided) under the Organic Search report in Google Analytics v5. If you are still working in v4, then it will be in your keyword report under Traffic Sources where source = organic. With that in mind, the # of organic search traffic in Google Analytics will still be tracked (the quantative figure), just not the actual keyword. 

You might begin to see this in your reports:

Google Analytics Organic Search Traffic report shows (not provided) as a keyword
Unfortuantely, my site's monthly traffic is only in the 2,000's so the figures might be quite small to report. It does not appear to be affecting a high percentage, and no where near 10% right now.

SEOmoz put up an emergency whiteboard friday on their site last night shedding a bit of light on this issue and provided a way to track the https change over time. Avinash also shared with his followers a method for tracking this change over time by creating a custom report in Google Analytics. I will report back here / Cardinal Path's blog with some results to show how much this change is affecting site traffic once we gather enough data (probably within a week's time).

A few bulleted points that I pulled out from other discussions around the sphere included:

  • @justincutroni tweeted "As a result of the Google switch to secure search I'm seeing about 1.5% of Organic searches bucketed as (not provided)" – link to tweet
  • mattgratt on the SEOmoz blog – 2.2% is very consistent with what we're seeing.  I've seen as high as 4% on sites serving highly technical audiences, down to .5% and less on sites that serve a less technical audience - link to article

Overall, I think this will affect greatly in our organic search reporting if the direction of the trend points Up. But if this is here to stay, let's take a look at this in a bigger picture and refocus ourselves back to goals, things that are important to your business. One item your business may want to keep an eye on is;

  • % of conversions from (not provided) traffic 

Will this loss of intelligence (not being able to see what keyword logged in visitors used before converting) affect how we do our keyword resesarch / reporting? Only time will tell…

Please share your thoughts in the comments below.