Category : Data Strategy
How to use Enhanced Ecommerce in Google Analytics to optimise product listings
Ecommerce reporting in Google Analytics is typically used to measure checkout performance or product revenue. However, by analysing events at the top of the funnel, we can see which products need better images, descriptions or pricing to improve conversion. Space on product listing pages is a valuable commodity, and products which get users to click on them – but don’t then result in conversion – need to be removed or amended. Equally, products that never get clicked within the list may need tweaking. Littledata ran this analysis for a UK retailer with Google Analytics Enhanced Ecommerce installed. The result was a scatter plot of product list click-through-rate (CTR) – in this case, based on the ratio of product detail views to product listing views – versus product add-to-cart rate. For this retailer, it was only possible to buy a product from the detail page. We identified three problem categories of product, away from the main cluster: Quick sellers: these had an excellent add-to-cart rate, but did not get enough list clicks. Many of them were upsell items, and should be promoted as ‘you may also like this’. Poor converters: these had high click-through rates, but did not get added to cart. Either the product imaging, description or features need adjusting. Non-starters: never get clicked on within the list. Either there are incorrectly categorised, or the thumbnail/title doesn’t appeal to the audience. They need to be amended or removed. How we did it Step 1 - Build a custom report in GA We need three metrics for each product name (or SKU) - product list views, product detail views and product add to carts - and then add 'product' as a dimension. Step 2 - Export the data into Excel Google Analytics can't do the statistical functional we need, so Excel is our favoured tool. Pick a decent time series (we chose the last three months) and export. Step 3 - Calculate List > Detail click through This website is not capturing Product List CTR as a separate metric in GA, so we need to calculate as Product Detail Views divided by Product List Views. However, our function will ignore products where there were less than 300 list views, where the rate is too subject to chance. Step 4 - Calculate Detail > Add to Cart rate Here we need to calculate Product Adds to Cart divided by Product Detail Views. Again, our function will ignore products where there were less than 200 detail views. Step 5 - Exclude outliers We will use an upper and lower bound of the median +/- three standard deviations to remove improbable outliers (most likely from tracking glitches). First we calculate the median ( =MEDIAN(range) ) and the standard deviation for the population ( =STDEV.P(range) ). Then we can write a formula to filter out all those outside of the range. Step 6 - Plot the data Using the scatter plot type, we specify List > Detail rate as the X axis and Detail > Add to Cart as the Y axis. The next step would be to weight this performance by margin contribution: some poor converters may be worth keeping because the few sales they generate are high margin. If you are interested in setting up Enhanced Ecommerce to get this kind of data or need help with marketing analytics then please get in contact. Get Social! Follow us on LinkedIn, Twitter, and Facebook and keep up-to-date with our Google Analytics insights.
5 myths of Google Analytics Spam
Google Analytics referral spam is a growing problem, and since Littledata has launched a feature to set up spam filters for you with one click, we’d like to correct a few myths circulating. 1. Google has got spam all under control Our research shows the problem exploded in May – and is likely to get worse as the tactics get copied. From January to April this year, there were only a handful of spammers, generally sending one or two hits to each web property, just to get on their reports. In May, this stepped up over one thousand-fold, and over a sample of 700 websites, we counted 430,000 spam referrals – an average of 620 sessions per web property, and enough to skew even a higher traffic website. The number of spammers using this tactic has also multiplied, with sites such as ‘4webmasters.org’ and ‘best-seo-offer.com’ especially prolific. Unfortunately, due to the inherently open nature of Google Analytics, where anyone can start sending tracking events without authentication, this is really hard for Google to fix. 2. Blocking the spam domains from your server will remove them from your reports A few articles have suggested changing your server settings to exclude certain referral sources or IP addresses will help clear us the problem. But this misunderstands how many of these ‘ghost referrals’ work: they are not actual hits on your website, but rather tracking events sent directly to Google’s servers via the Measurement Protocol. In this case, blocking the referrer from your own servers won’t do a thing – since the spammers can just go directly to Google Analytics. It's also dangerous to amend the htaccess file (or equivalent on other servers), as it could prevent a whole lot of genuine visitors seeing your site. 3. Adding a filter will remove all historic spam Filters in Google Analytics are applied at the point that the data is first received, so they only apply to hits received AFTER the filter is added. They are the right solution to preventing future spam, but won’t clean up your historic reports. To do that you also need to set up a custom segment, with the same source exclusions are the filter. You can set up an exclusion segment by clicking 'Add Segment' and then red 'New Segment' button on the reporting pages and setting up a list of filters similar to this screenshot. 4. Adding the spammers to the referral exclusion list will remove them from reports This is especially dangerous, as it will hide the problem, without actually removing the spam from your reports. The referral exclusion list was set up to prevent visitors who went to a different domain as part of a normal journey on your website being counted as a new session when they returned. e.g. If the visitor is directed to PayPal to pay, and then returns to your site for confirmation, then adding 'paypal.com' to the referral exclusion list would be correct. However, if you add a spam domain to that list then the visit will disappear from your referral reports... but still, be included under Direct traffic. 5. Selecting the exclude known bots and spiders in the view setting will fix it Google released a feature in 2014 to exclude known bots and spiders from reports. Unfortunately, this is mainly based on an IP address - and the spammers, in this case, are not using consistent IP addresses, because they don't want to be excluded. So we do recommend opting into the bot exclusion, but you shouldn't rely on it to fix your issue Need more help? Comment below or get in touch!
How to audit your Web Analytics Ecommerce tracking
Subscribe to Littledata news
Insights from the experts in ecommerce analytics
Try the top-rated Google Analytics app for Shopify stores
Get a 30-day free trial of Littledata for Google Analytics or Segment