{"id":4989,"date":"2022-02-16T12:04:27","date_gmt":"2022-02-16T09:04:27","guid":{"rendered":"https:\/\/trackingchef.com\/?p=4989"},"modified":"2022-09-04T17:04:00","modified_gmt":"2022-09-04T14:04:00","slug":"quick-tactics-for-ecommerce-analytics","status":"publish","type":"post","link":"https:\/\/trackingchef.com\/google-analytics\/quick-tactics-for-ecommerce-analytics\/","title":{"rendered":"Quick tactics for Ecommerce growth using Google Analytics"},"content":{"rendered":"\n<p>In this post, we discuss advanced tactics for using Google Analytics to drive growth in Ecommerce campaigns. These tactics were extracted from an expert session given by Assaf Trafikant, CEO of <a rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\" href=\"http:\/\/quickwin.co.il\/\" target=\"_blank\">Quickwin<\/a>, at a professional meetup hosted by Fixel.<\/p>\n\n\n\n<p>Assaf is a Web Analytics expert, who led the development of this professional field in Israel since its early days. He is also a CRO expert, working with brands in all shapes and sizes to drive incremental growth.<\/p>\n\n\n\n<p>This session in the video below was held in Hebrew but is summarized fully in English below. The full deck presented is available on <a href=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Assaf-Trafikant-Quick-Wins-for-Ecom.pdf\" data-type=\"URL\" data-id=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/02\/Assaf-Trafikant-Quick-Wins-for-Ecom.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">this link<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed\"><iframe title=\"Quick Tactics for Ecommerce Analytics - By Assaf Trafikant\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/exkeOzP4O6Q?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"tactic-1-the-right-campaign-sells-the-wrong-product\">Tactic #1 &#8211; The &#8220;right&#8221; campaign sells the &#8220;wrong&#8221; product<\/h2>\n\n\n\n<p>One of my favorite tactics is once we have enough campaign data, to check if certain campaigns, aimed at promoting Product X, are actually driving sales for Product Y. While we assume that any campaign aimed at Product  X can end up selling Product Y, as people frequently buy several items in a single cart, we&#8217;re looking to identify patterns that go deeper. <\/p>\n\n\n\n<p>For this analysis, we ignore campaigns that are based on brand and focus rather on ones promoting specific solutions. In a Pharma example, we&#8217;d look at campaigns for a hair conditioner that impacted the sales of hand soap. <\/p>\n\n\n\n<p>We&#8217;re interested in these patterns, as when these are large enough, we can often find a cheaper way to sell expensive products. For one of my clients selling protein powder, which is a rather expensive keyword, we were able to promote &#8220;Protein Shakers&#8221; instead. These sold at a bargain of 2$ with free shipping but drove sales for a protein powder that was far more expensive and profitable for the client. And of course, we had all this audience in our pixels for future campaigns. <\/p>\n\n\n\n<p>This insight came from analyzing the purchases of users that bought the protein powder and were frequently adding the protein shaker to their cart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2481850.png\" alt=\"image-2481850\" class=\"wp-image-5295\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2481850.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2481850-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2481850-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>The logic described here is as appears in Google Analytics, but can be applied across any similar web analytics platform such as MixPanel and others.<\/p>\n\n\n\n<p>For this analysis, I usually build a report off of Google Sheets data in <a rel=\"noreferrer noopener\" aria-label=\"SuperMetrics (opens in a new tab)\" href=\"https:\/\/supermetrics.com\/\" target=\"_blank\">SuperMetrics<\/a>.<\/p>\n\n\n\n<p>To the report I add the following dimensions: <br>Campaign, Keyword, Product Name, Product Brand.<\/p>\n\n\n\n<p>I care about the Brand as it allows me to easily identify the gap between categories promoted in the Campaign\/KW vs. the ones actually sold.<\/p>\n\n\n\n<p>These are coupled by the Item Quantity metric.<\/p>\n\n\n\n<p>The report is filtered to contain only campaigns that I can identify (otherwise I can&#8217;t identify the gap) and ones that have sold over a set amount of Product Y, which can vary across industries.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><a rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\" href=\"https:\/\/analytics.google.com\/analytics\/web\/template?uid=YwfI26qMRm2WH5xeG9nOLw\" target=\"_blank\"><strong>Quick link to import the report to you Google Analytics account.<\/strong><\/a><\/p><cite><strong>(make sure you edit the Brand in the filter!)<\/strong><\/cite><\/blockquote>\n\n\n\n<p>Another outcome of this analysis is manually altering the related products shown. If we decided to actively promote Product X for selling Product Y, we should match the related\/suggested products across the user&#8217;s journey to promote Product Y.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-5633879.png\" alt=\"image-5633879\" class=\"wp-image-5296\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-5633879.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-5633879-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-5633879-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"tactic-2-identify-user-retention-with-custom-dimensions\">Tactic #2 &#8211;  Identify User Retention  With Custom Dimensions <\/h2>\n\n\n\n<p>Another quick tactic I like to use is rooted deeply in the world of Gaming, with the logic of FTD&#8217;s (First Time Deposit). Acquiring a new user is far more valuable than a return purchase from an existing user, and most times will be more expensive to achieve. This is why it is highly important to be able to easily distinguish between new and return purchases. Accordingly, campaign conversions can be set to achieve these distinct goals.<\/p>\n\n\n\n<p>To achieve this, I send several user attributes that I pull out of the CRM, back into Google Analytics as Custom Dimensions (CD).<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7915247.png\" alt=\"image-7915247\" class=\"wp-image-5298\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7915247.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7915247-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-7915247-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"user-id\">User ID<\/h4>\n\n\n\n<p class=\"has-text-align-left\">This CD uses a non personally identifiable ID of the user (e.g. CRM ID)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"purchase-counter\">Purchase Counter<\/h4>\n\n\n\n<p>This CD shows the cumulative count of purchases done by that user.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"is-first\">Is First<\/h4>\n\n\n\n<p>Similar to the Purchase Counter, this CD carries a Boolean value (YES\/NO or True\/False).<\/p>\n\n\n\n<p><strong>Pro tip:<\/strong><br>This value (Is First) can also be used to trigger an event in GTM that can act as a separate conversion event for Google Ads\/Facebook Ads to optimize against, putting more focus on First Time Purchases.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"purchase-type\">Purchase Type<\/h4>\n\n\n\n<p>This CD carries the Checkout method selected by the user &#8211; Guest checkout, Returning Registered, or First Registered. <\/p>\n\n\n\n<p>Note that the first three CD&#8217;s are measured regardless of the method explicitly selected by the user (as Registered users can often checkout as Guests). Since we have a strict identifier, the user&#8217;s email, the data should always be accurate.<\/p>\n\n\n\n<p>The fourth CD, Purchase Type, enables us to identify if users prefer a Guest checkout, which might result in a more fragmented data set for the client. In this case, we might consider adding incentives to convince users to log in.<\/p>\n\n\n\n<p>In this report, Column A is the Purchase Count and the topmost row is the Month. We can easily observe that 30-35% of purchases are First Time Purchases.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9854090.png\" alt=\"image-9854090\" class=\"wp-image-5299\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9854090.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9854090-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9854090-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>In this report, we can easily see the distribution of checkout methods selected by users, with what is probably too high a ratio of Guest checkouts.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9400218.png\" alt=\"image-9400218\" class=\"wp-image-5300\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9400218.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9400218-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9400218-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>In one example I observed with a client of mine, we noticed that weekends drove a higher proportion of Registered checkouts. While we didn&#8217;t quite understand the reasons behind this, we decided to run campaigns aimed at first-time <strong>registered <\/strong>purchases on weekends and saw great results.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"tactic-3-stock-buyers\">Tactic #3 &#8211; Stock Buyers<\/h2>\n\n\n\n<p>Stock buyers are users that, well, purchase in large bulks. The definition of bulk can vary greatly, as in Fashion you might want to identify a person buying 5 pairs of jeans, while in CPG Retail the threshold would rise to 20 shampoo bottles.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9410375.png\" alt=\"image-9410375\" class=\"wp-image-5301\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9410375.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9410375-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-9410375-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><a rel=\"noreferrer noopener\" aria-label=\"Quick link to import the report to you Google Analytics account. (opens in a new tab)\" href=\"https:\/\/analytics.google.com\/analytics\/web\/template?uid=a8LhZ3rEQSeBucojFOugng\" target=\"_blank\"><strong>Quick link to import the report to you Google Analytics account.<\/strong><\/a><\/p><\/blockquote>\n\n\n\n<p>This report is pretty straightforward, and contains the Dimensions of Transaction ID, Product and the Metric of Quantity. The filters for the report will be set based on the logic described above.<\/p>\n\n\n\n<p>In one example, working with an online supermarket, we were able to segment a group of &#8220;Home Bakers&#8221;, by identifying users that purchased a large quantity of flour and eggs. We can now create an audience for these users specifically that can promote items that are more relevant to them.<\/p>\n\n\n\n<p>In another example, a client of ours asked me to identify users that purchase a stock so that they can identify if they are then reselling it elsewhere and abusing their discounts.<\/p>\n\n\n\n<p>This tactic can be used to identify trends, such as mini bottles of hand sanitizer (Alcogel) that are often purchased in bulk before the school year begins. We can use this insight to offer bulk discounts for these and use it to drive quality traffic.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3766749.png\" alt=\"image-3766749\" class=\"wp-image-5302\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3766749.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3766749-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-3766749-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"tactic-4-out-of-stock\">Tactic #4 &#8211; Out of Stock<\/h2>\n\n\n\n<p>When working with a large ecommerce site, I like to treat Out of Stock (OOS) as a 404 page on the site in terms of severity and to be informed of this in Google Analytics. I usually will send an event via GTM to indicate this.<\/p>\n\n\n\n<p>Even if the shop owner can&#8217;t change their stock, they can at least do some proactive response, such as triggering a pop-up that suggests they sign up to be notified when the item is back in stock, or suggesting other similar products.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2919818.png\" alt=\"image-2919818\" class=\"wp-image-5303\" srcset=\"https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2919818.png 1024w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2919818-300x169.png 300w, https:\/\/trackingchef.com\/wp-content\/uploads\/2022\/09\/image-2919818-768x432.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>In this post, we discuss advanced tactics for using Google Analytics to drive growth in Ecommerce campaigns. These tactics were extracted from an expert session given by Assaf Trafikant, CEO of Quickwin, at a professional meetup hosted by Fixel. Assaf is a Web Analytics expert, who led the development of this professional field in Israel [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,2],"tags":[],"_links":{"self":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4989"}],"collection":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/comments?post=4989"}],"version-history":[{"count":4,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4989\/revisions"}],"predecessor-version":[{"id":5304,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4989\/revisions\/5304"}],"wp:attachment":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/media?parent=4989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/categories?post=4989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/tags?post=4989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}