Category : ReCharge
My ReCharge talk: which marketing channels bring you profitable customers?
This past September, our team attended #ChargeX in LA, an annual conference for the Shopify ReCharge community. There were agencies, app developers, and a ton of Shopify Plus stores using ReCharge to power their subscription ecommerce. Day 1 of the conference was mainly focused on partner agencies looking to build off the ReCharge platform, while day 2 was designed for Shopify merchant success. We saw plenty of familiar names and faces, but perhaps the highlight of the weekend was sharing my talk which orbited around lifetime value: which marketing channels bring you profitable customers? Check out my full talk below. If you have questions, be sure to get in touch with support or our team of Google Analytics experts. If you have questions about our advanced Google Analytics connection for ReCharge stores, we're here to answer those too. Enjoy the talk! https://youtu.be/ubFDTY1M6HU Main points How agencies can measure which marketing channels bring in the most profitable customers Current fragmentation for marketing attribution – customer purchase data and browsing data in seperate silos Overview of the many channels that all funnel into calculating lifetime value from pre-checkout through subscription renewal How to predict which visitors will be high value, and experiment with what content you push to them Three levers that impact Customer Lifetime Value (LTV)
Top 6 coffee brands using ReCharge for Shopify
In a recent post, we discussed the top four benefits of a Shopify ReCharge connection. As mentioned in that post, ReCharge helps Shopify and Shopify Plus merchants sell subscriptions easily and smoothly. When you connect ReCharge to your store (it works for both Shopify and Shopify Plus), you'll see ReCharge's full feature set at work — track a variety of subscription types, including single product, mixed cart & entire cart subscriptions. Why connect ReCharge with Shopify? The ReCharge and Shopify APIs allow ecommerce managers and developers to: customize the checkout experience for customers personalize how those customers manage their subscriptions automate product discount codes order cancellation processes or updated pricing on select items And that's just scratching the surface. Installing ReCharge on your store also means orders are processed faster (thanks to an increased API call limit). [note] Littledata's Google Analytics app is designed for better subscription ecommerce, including accurate tracking for marketing attribution and checkout steps.[/note] For Shopify Plus merchants, ReCharge also has full compatibility with top-rated apps like Klaviyo and Smile.io. However, without hiring expensive Google Analytics consultants, ReCharge customers don't have a way to get full lifetime value reporting for ecommerce subscribers — until recently. [subscribe heading="Get Littledata's ReCharge connection for Shopify" background_color="green" button_text="get the connection" button_link="https://www.littledata.io/connections/recharge"] Using Google Analytics to sell more subscriptions From first-time transactions and repeat orders to marketing campaigns at every stage of the funnel, Littledata's advanced Google Analytics integration for ReCharge merchants lets you capture the entire subscriber journey and segment first-time from recurring purchases. Littledata connects your Shopify store and ReCharge data automatically, so data from every step your customers take is reeled into Google Analytics: There's a reason ReCharge is a highly-rated tool for Shopify merchants — it really works! One of the newer industries where subscriptions have quickly become popular is coffee. Below, check out 6 coffee subscription brands that currently use both Shopify and ReCharge for ecommerce success. 1. Groundwork Coffee A Littledata customer, Groundwork Coffee is an organic coffee roaster based in Venice Beach, CA. For over 30 years, Groundwork has valued local community impact and pushed global, responsible coffee sourcing through its popular cafés and online store. While Groundwork sources from nearly every major growing region in the world, the roaster's mission is to "ensure that none of those offerings come at the expense of the farmers who brought them to market." 2. Dripkit Dripkit sells coffee beans, coffee gear and gift sets online through its popular Shopify store. One of the better known "gear brands" in the industry, Dripkit partners with esteemed roasters to pair their top roasts with Dripkit's single-serve pour-over. Take barista-quality coffee on your morning commute to work, enjoy it at home, or even take it on a camping trip! Dripkit also offers a coffee quiz to help first-time customers and new coffee drinkers narrow down their choices. 3. La Colombe La Colombe is a large roaster and wholesale coffee brand originally based in Philadelphia, PA with locations throughout the US. La Colombe offers online brew guides, a popular coffee subscription and a signature canned draft latte that can be found in grocery stores like Trader Joe's, Whole Foods and Publix. 4. VitaCup A Littledata customer, VitaCup offers infused coffee and tea with vitamins and superfoods. From coffee grounds and espresso pods to tea bags and quick caffeine shots, VitaCup has a wide product selection for coffee consumers of all kinds. 5. Heart Coffee Roasters Heart Coffee Roasters is perhaps Portland's biggest household name among coffee connoisseurs. Known for its high-rated coffee and premium coffee products, Heart's impact stretches far beyond its three physical locations. Heart has a popular coffee subscription where customers can enjoy a new bag of beans every one, two or four weeks. 6. Brio Coffeeworks Brio Coffeeworks is a specialty roaster, retail boutique and espresso bar located within the Southend Arts District of Burlington, VT. Brio sells a variety of blends, decaf and single origin coffee from across Africa and Central America. Brio also sells apparel, coffee gear and even educational books for those new to the coffee world.
Quick tips for subscription stores using custom dimensions in Google Analytics
One of the challenges subscription businesses face is differentiating between order types. The problem For Shopify merchants, offering single purchase options complicates things even more — with single purchase options, order data will show in two places (Shopify and ReCharge). This leads to a major disconnect between user behaviour and orders, unable to leverage the full potential of Google Analytics. At this point, you probably have a multitude of “known unknowns”, such as: Which traffic sources drive more first time subscription orders? What's my conversion rate on one time purchases? What's my average customer lifetime value (CLV or LTV)? Do my one time purchasers end up converting to subscribers? What's my churn rate month over month? The solution Bridging the gap with Littledata Littledata helps bridge different platforms by linking orders betweenShopify, ReCharge and Google Analytics. [subscribe] Differentiating between order types With Littledata’s improved tracker, merchants can differentiate between order types. For this, we use the Affiliation dimension. In the Google Analytics report, it will look something like this: Right away, this information answers a few questions: What is the distribution between my order types? Are my recurring subscription orders growing month over month? Is the average order value (AOV) of subscribers higher than that of one time purchasers? Both of these can be viewed in this custom report. What traffic sources drive the most sales? One of the questions our team is asked most often is what sources of traffic drive the most subscription orders? Short answer: the Affiliation dimension can be used as a secondary dimension in the source/medium reports, or use this custom report. By using filters to single out an order type, you can easily determine what traffic sources drive the most first time subscription orders. Segment more Segmentation opens up new ways to look at the data as well. Creating two segments for one time purchases and first subscription purchases, you can see how the two types of purchases differ. Look for behavioural differences like: Do One Time purchasers AOV higher or lower compared to First Subscription orders? Are users testing the product first and then committing to a subscription? Littledata custom dimensions Google Analytics custom dimensions are an excellent way to expand your data collection and reporting power. With our Shopify app, Littledata adds these custom dimensions: Littledata - Shopify Customer ID Littledata - Last Transaction Date Littledata - Purchase Count Littledata - Lifetime Revenue Littledata - Payment Gateway With the help of these custom dimensions, we can answer the following questions: What's my median customer lifetime value (CLV)? How many purchases do customers make in their lifetime? What's my churn rate month over month? Since these are custom dimensions, they cannot be aggregated on Google Analytics, meaning the data will need to be displayed using a different method. For this, we’ll use Google Sheets with the Google Analytics add-on to query the data and pivot tables. Step1 - Query all the data you need Metrics Avg. Order Value Revenue Dimensions Littledata - Shopify Customer ID Littledata - Lifetime Revenue Littledata - Purchase Count Affiliation - to differentiate between the order types. It should look something like this: In this case, the custom dimensions are at index 4, 6 and 8. This may differ depending on your setup. Step 2 - Run the report After you run the report, this will create another sheet in your document. It will look something like this: Step 3 - Create a pivot table In the rows section, add the Affiliation dimension to differentiate between the order types. Shopify will mean a one time purchase (normal purchase). The other two order types are the first subscription order and recurring order. In the values area, add: The user IDs summarised by countunique The customer lifetime value summarised by median so that we have the median LTV. We use median over average so that this number is not influenced too much by the outliers. Purchase count summarised by median. Average order value The end result should look something like this: Step 4 - Interpret the data In this report, we can instantly draw some conclusions: Most customers make single purchases rather than subscribing Subscription first order median purchase is 2, so this means users have purchased in the past before committing to a subscription Subscribers purchase 8 times (median value), with a median CLV is around $500. How to take this further Since we know most customers order at least once before committing to a subscription, we can calculate the average number of days between a single purchase and a first subscription purchase. When you’re armed with that type of information, you can adjust your email marketing flows accordingly and adjust your remarketing campaigns to shorten or lengthen the number of days your ads show to leads. With the help of the Customer IDs, we can also calculate the month over month churn rate (we’ll get to that in a follow-up post). It's your turn now How do you use these additional events and custom dimensions in your segmentation? What was your biggest insight using these events and custom dimensions? How did it influence your marketing campaigns? Share your experience (and current approach with GA) via the live chat in the bottom corner. I'm curious about the different ways you make use of these additional data points! In the meantime, our team is here at the ChargeXSummit in Santa Monica sharing all about our ReCharge connection for subscription-based stores.
Upcoming ecommerce events in NYC & LA
We had a great time at Shopify Unite in June, but that was just the beginning of ecommerce conference season. What's up next? In the next few months the Littledata team will be hitting up both US coasts at major ecommerce events in New York City and Los Angeles, plus some smaller meetups in Austin, Nashville and the UK. Will you join us? Meet Magento (New York, NY) September 5-6, 2019 It's no secret. Littledata isn't only for Shopify stores. Our Magento customers include successful ecommerce brands like Horace and Micro Scooters. We help Magento sites get better ecommerce tracking in Google Analytics since the beginning, and our new Welt Pixel partnership has taken automated tracking to the next level. You can , plus use Littledata connections like Facebook Ads and Google Ads to sync ppc data with ecommerce tracking. That's why we're especially excited to be attending Meet Magento NYC this year. With presentations 'for merchants by merchants', it's always a truly informative time. While we won't be speaking at this year's event, Littledata team members will be around to chat about analytics and keep an eye out for ecommerce trends like how merchants and developers are handling headless ecommerce and multi-channel attribution. We're happy to hop on a quick demo. If you'll be there too, come say hi! ChargeX Summit (Santa Monica, CA) September 19-20, 2019 We can't wait for the ChargeX summit in Los Angeles. And it's not just about getting a slice of that legendary Los Angeles sunshine in the land of Littledata customers like Groundwork coffee and Rachel Zoe's Box of Style. ChargeX is ReCharge's annual user conference. ReCharge has been one of our most successful partnerships, and we continue to hone the ReCharge connection to help sites get accurate data about recurring payments and customer lifetime value (CLV/LTV). The Littledata team will be at ChargeX to chat about getting better data about your subscription ecommerce business. Littledata CEO Edward Upton will be presenting on agency day, along with a killer lineup of industry experts including Benjamin Crudo from the Diff Agency and Kelly Vaughn from the The Taproom agency. But that's not all. The second day of the summit is all about merchants. We'll have a large presence there to chat about how we can build a smarter, more profitable system for everyone. Confirmed speakers include: Jesse Horowitz - Co-CEO/Founder at Hubble Contacts Kaitlin Holliday - Retention Manager at Four Sigmatic Paul Tran - CEO at Manscaped Chris Traverse - Head of Engineering at Huel Lanie De Pasquale - Sr. eCommerce Manager at Kopari Beauty If you're selling products by subscription, this is the conference for you. Whether or not you're already using ReCharge or Littledata, you can attend the conference! Get your ticket today before they sell out :) And if you're based in LA or will be around for the summit, drop us a line. Should you attend that ecommerce conference? Check out the Littledata conference checklist to find out if it's worth the cost.
Top 4 benefits of connecting ReCharge with your Shopify store
As the most popular recurring billing solution for Shopify stores, ReCharge helps Shopify and Shopify Plus merchants sell subscriptions easily and smoothly. ReCharge's feature set also allows for a variety of subscription types, including single product, mixed cart & entire cart subscriptions. In our last post, we talked about major challenges for Shopify store owners who manage subscription orders. Today, we're outlining a major solution. Why use ReCharge? By installing ReCharge, Shopify merchants can customise subscriptions for their store (including custom promotions via Advanced Discounts API). The ReCharge and Shopify APIs allow developers to customise the checkout experience for customers and personalise how those customers manage their subscriptions. And that's not all — with access to the ReCharge API, Shopify merchants can harness the power of marketing automation. Whether you want to automate product discount codes, order cancellation processes or updated pricing on select items, you can do just that. Installing ReCharge on your store also means orders are processed faster (thanks to an increased API call limit). For Shopify Plus merchants, ReCharge has full compatibility with popular apps like Klaviyo and Smile.io. Why connect ReCharge with Shopify? As mentioned above, ReCharge helps Shopify store owners easily sell and manage subscriptions. However, without hiring expensive Google Analytics consultants, ReCharge customers don't have a way to access a complete data collection in Google Analytics — until recently. [subscribe heading="Get Littledata's ReCharge connection for your Shopify store" background_color="green" button_text="get the connection" button_link="https://www.littledata.io/connections/recharge"] Wait, why Google Analytics? Arguably the most powerful free tool available to marketers, Google Analytics is a robust data platform that allows for multi-layered tracking, buyer behaviour analysis, segmenting by user characteristics and much more. While GA offers free features and hundreds of metrics for stores of all sizes, it certainly isn't without shortcomings. However, Littledata offers a way to maximise the power of Google Analytics' powerful data platform along with the Shopify ReCharge connection: How to optimise the Shopify ReCharge connection Unfortunately, simply installing ReCharge on your Shopify or Shopify Plus store limits the full power of the connection. That's where we come in. Littledata's Shopify ReCharge connection opens the door to accurate data for recurring transactions through an automated, advanced Google Analytics integration. With Littledata's connection, merchants not only benefit from accurate data — they get more features, automated tools and ways to track their store's performance in GA: 1) Automatically track first-time payments & recurring transactions Shopify reporting is now 10x easier. With Littledata's Shopify ReCharge connection, merchants can enjoy easy tracking of the entire customer journey along with accurate marketing attribution. The best part: you won't need to lift a finger (after granting GA access, of course). 2) Get marketing attribution for subscription revenue Littledata's smart technology automatically connects your ReCharge checkout with Google Analytics for accurate subscription revenue, including first-time payments and recurring transactions. 3) Segment your performance Whether by payment source, subscription plan type or product category, connecting ReCharge with your Shopify store allows you to track performance by segment. Not only does this ensure accurate tracking of your entire ecommerce funnel, but it also frees you to take full advantage of automated Shopify reporting to grow revenue (including report packs designed for subscription analytics). 4) Benchmark your site See how you stack up against other subscription-based Shopify merchants with Littledata's powerful ecommerce benchmarking tool. Not only will integrating ReCharge allow you to see website benchmarks by industry, but you'll also see which key metrics are succeeding and which of them have room for improvement. The ReCharge connection also offers access to professional-level subscription analytics tools. How the Shopify ReCharge integration works From marketing campaigns to first-time transactions and recurring revenue, integrating Littledata with ReCharge lets you capture the entire subscriber journey and all the crucial data it produces. With Littledata’s magic sauce, your Shopify store and ReCharge data are automatically connected and reeled into Google Analytics. Once the two are integrated, Littledata’s revenue optimisation tools pull straight from your Google Analytics data. Connect the apps you know and love In addition to the ReCharge connection, Littledata lets you loop in the subscription tools and marketing apps you rely on most — Facebook Ads, Google Ads, CartHook, Refersion, and more!. Bottom line: Littledata automates the process to ensure accurate sales data and marketing attribution for your Shopify store. You can view the data directly in Google Analytics, or in the Littledata app.
3 massive hurdles for merchants who manage subscription orders
For merchants who run subscription-based businesses, accuracy is crucial for tracking recurring orders. The problem: popular platforms like Shopify provide merchants with native analytics that are broken. In other words, these platforms don't offer a complete picture (or an accurate one) of data that subscription-based stores depend on. There are many potential blockers for these store owners, but we narrowed it down to three: 1) Customisable orders & levels of membership Many successful subscription-based stores allow shoppers to customise their monthly orders. While this is an effective draw for consumers, it causes all kinds of headaches for the teams that manage the orders. The ability for customers to customise monthly orders adds layers of complexity for teams who manage product inventory, fulfillment and logistics in the back end. Perhaps the best example is from the hugely popular Dollar Shave Club. Known for their humor-driven marketing approach, the brand constantly encourages its subscribers add more and more products to their monthly shipments, which go out at different times each month. Due to the brand's meteoric growth over the past five years, this creates headaches — imagine fulfilling dynamic orders each month (different cart sizes, products and membership levels) for hundreds of thousands of customers across America. The 'curated box package' is another common subscription model. StitchFix, a curated clothing company for men and women, surprises its customers each month with a package containing 'personalised' new outfits. While the surprise factor might not be a draw for some, the brand's main appeal is the diversity of its products. Every month, StitchFix's variety is what appeals to its majority millennial market. Whether your store offers dynamic monthly ordering (where customers can change the contents of their cart) or follows a more traditional subscription model, it's crucial to have data you can trust. This means finding an ecommerce solution built to handle both customer changes and increased payload as your store scales. [subscribe heading="Automatically track your subscription orders" background_color="green" button_text="find out how" background_link="https://www.littledata.io/connections/recharge"] Affiliate marketing & partnerships It's common for subscription-based stores to partner with affiliate marketers to generate an additional source of revenue and tap into new customer groups. However, with more customers comes more demand, and the importance of accurate data only increases — this includes tracking sales made through affiliate partners, commission owed on each sale, etc. 2) Customer loyalty & reward programs When done right, effective customer loyalty programs create more loyal customers, boost customer retention and increase sales. These programs aren't used by every subscription-based brand, but for the brands that use them, they really do work, according to LoyaltyLion. However, as high shopper expectations continue to soar, the landscape for rewards programs is getting more competitive. Shoppers know that if they don't absolutely love one aspect of a brand's rewards program, they can easily run to a competitor that offers what they're looking for — whether it be a cheaper price tag, better discounts or more rewards available. Mark Hook, Head of PR and Communications for retail management software Brightpearl, had this to say: Over two-fifths of millennial shoppers (45%) admit to being less loyal to brands when compared to a year ago, and are quicker to abandon buying from companies that don’t meet expectations A great example of a rewards program within a subscription is Nike+. By putting the mobile shopping experience at the top of its priority list, Nike has developed multiple apps that work hand-in-hand with the Nike+ loyalty program by allowing its members to 'take the brand wherever you go.' By offering easy member access to the program, Nike gets higher engagement from community members and increased brand loyalty from repeat buyers. However, for merchants, a successful customer loyalty program hinges on back end analytics and whether or not it's set up properly. For merchants relying on Google Analytics for tracking, do you have custom dimensions set up? Are there parameters to track recurring orders, free trial offers, promo codes or even brand events? 3) Payment security & order changes Ecommerce businesses not operating on a subscription model typically receive credit card information every time a transaction is made. On the other hand, subscription-based businesses store data for recurring purchases, which simplifies the user experience and helps encourage users to continue paying each month. With potentially millions of credit card numbers stored in a database, brands are constantly at risk for large-scale fraud. This forces brands to invest in airtight security measures to protect your own revenue and the sensitive data of your customers. Merchants need to stay prepared for orders with expired credit card info, subscription cancellations and changes to recurring orders — all of which make it tougher to accurately track individual events and transactions. Running a subscription-based store with data you can trust Even with these hurdles, there's a shiny silver lining for merchants who rely on subscriptions. Littledata's plug-and-play ReCharge integration connects with Shopify and Google Analytics to do the following: Automatically track first-time payments and recurring transactions Provide accurate marketing attribution for subscription revenue Segment performance by payment source, subscription plan type and product category Benchmark your site and offer access to professional-level subscription analytics tools With Littledata's Shopify ReCharge integration, there's a better way forward for merchants who manage subscription orders. BullyMax, a popular nutrition and muscle-building supplement for dogs, and Dry Farm Wines, a health-focused natural wine club, are two top subscription brands that have seen great success with Littledata's Shopify ReCharge connection. Read more about our topintegration for subscription analytics. In a follow-up post, we discuss a fool-proof solution for Shopify merchants who manage subscription orders. Check it out!
How to succeed with subscription ecommerce: podcast and virtual summit
We're excited to participate in eCommerce Master Plan's virtual summit for subscription ecommerce this week. Littledata CEO Edward Upton is one of the lecturers, and that's not all! Over 10 industry experts have contributed in-depth online sessions to the summit, with advice for a variety of sites. This popular online conference is the place to be, whether you're just launching subscription products or looking to optimize revenue and customer lifetime value for an established brand. eCommerce Master Plan Virtual Summit The summit is a gathering place for thought leaders and growing brands. Sessions are live today, Tuesday 30th April, and unlocked for participants until 5pm on Thursday 2nd May. In one of the online sessions, Ed shares essential advice about Customer Lifetime Value (CLV) for subscription ecommerce. Get the inside scoop on how to calculate CLV and what it means for your business. The summit is a who's-who of next-gen ecommerce apps and consultants. Ed is joined by experts from ReCharge, Churn Buster and more. Topics include everything from launching and scaling a subscription box company, to specifics about Facebook Ads and loyalty programmes. Why attend the summit? Why should you attend this 3-day annual conference? Chloe and the team break it down into the most convincing reasons: HUGE OpportunityThe latest Royal Mail research predicts the Subscription Box market will be worth £1 billion in 2022. This Summit will give you the knowledge to grab your share of that market growth It's a different ball gameSubscription eCommerce is a very different type of business to a 'normal' eCommerce business. Different challenges, different opportunities. This Summit will explore those differences, and how to make the most of them to build and grow your subscription business. Keep OptimisingLearn multiple ways to optimise and improve the marketing of subscription products. We couldn't agree more. It's why we built, and why we regularly highlight content specifically for online retailers selling things by subscription - whether it's the heart of your business (like it is for our customers Athletic Greens and Dry Farm Wines) or simply a part of your wider product mix. Plus, it's a virtual summit so travel costs are nonexistent. So start brewing that coffee at home and hop online for non-stop learning. Sign up today! Free podcast with subscription ecommerce tips Want to learn more before signing up? Conference organizer (and ecommerce mastermind) Chloe Thomas has you covered. Check out Chloe's latest podcast (the 213th episode!) on top tips from the summit - including some from Littledata. If you're looking for even more free content, this podcast episode is a great compliment to Ed's appearance on the eCommerce Fastlane podcast, where he breaks down how to get a complete picture of your store's performance, from marketing channels through repeat buying behaviour. Thanks and see you at the summit!
How to calculate customer lifetime value (CLV) for subscription ecommerce in Google Analytics
Many of Littledata's subscription customers come to us with a similar problem: how to calculate return on advertising spend, considering the varying customer lifetime value (CLV) of subscription signups. Calculating marketing ROI for subscription ecommerce is a big problem with a number of potential solutions, but even the initial problem is often misunderstood. In this post I break down what the problem is, and walk through two proven solutions for getting consistent, reliable CLV reporting in Google Analytics. What is customer lifetime value? I work with all kinds of subscription ecommerce businesses: beauty boxes, nutritional supplements, training courses and even sunglasses-by-the-month. All of them want to optimise customer acquisition costs. The common factor is they are all willing to pay way MORE than the value of the customers' first subscription payment... because they expect the customer to subscribe for many months. But for how many months exactly? That's the big question. Paying for a marketing campaign which bring trial customers who cancel after one payment - or worse, before the first payment - is very different from paying to attract sticky subscribers. A marketing director of a subscription business should be willing to pay WAY more to attract customers than stay 12 months than customers who only stay one month. 12 times more, to be precise. So how do we measure the different contribution of marketing campaigns to lifetime customer value? In Google Analytics you may be using ecommerce tracking to measure the first order value, but this misses the crucial detail of how long those shoppers will remain subscribers. With lifetime customer value segments we can make more efficient use of media, tailor adverts to different segments, find new customers with lookalike audiences and target loyalty campaigns. There are two ways for a marketing manager to see this data in Google Analytics: one is a more difficult, manual solution; the other is an easier, automated solution that ties recurring payments back to the original campaigns. A manual solution: segment orders and assign a lifetime value to each channel It's possible to see the required data in GA by manually segmenting orders and assigning a lifetime value to each channel. For this solution you'll need to join together: (a) the source of a sample of first orders from more than a year ago, by customer number or transaction ID and (b) the CLV of these customers The accuracy of the data set for A is limited by how your Google Analytics is set up: if your ecommerce marketing attribution is not accurate (e.g. using Shopify's out-the-box GA scripts) then any analysis is flawed. You can get B from your subscription billing solution, exporting a list of customer payments (and anonymising the name or email before you share the file internally). To link B to A, you'll need either to have the customer number or transaction ID of the first payment (if this is stored in Google Analytics). [subscribe] Then you can join the two data sets in Excel (using VLOOKUP or similar function), and average out the lifetime value by channel. Even though it's only a sample, if you have more than 100 customers in each major channel it should give you enough data to extrapolate from. Now you've got that CLV by channel, and assuming that is steady over time, you could import that back into Google Analytics by sending a custom event when a new customer subscribes with the 'event value' set as the lifetime value. The caveat is that CLV by channel will likely change over time, so you'll need to repeat the analysis every month. If you're looking to get away from manual solutions and excessive spreadsheets, read on... A better solution: tie recurring payments back to the original campaign(s) What if you could import the recurring payments into Google Analytics directly, as they are paid, so the CLV is constantly updated and can be segmented by campaign, country, device or any other standard GA dimension? This is what our Google Analytics connection for ReCharge does. Available for any store using Shopify as their ecommerce platform and ReCharge for recurring billing, the smart connection (integration) ties every recurring payment back to the campaigns in GA. Here's how the connector works The only drawback is that you'll need to wait a few months for enough customer purchase history (which feeds into CLV) to be gathered. We think it's worth the wait, as you then have accurate data going forward without needing to do any manual imports or exports. Then, if you also import your campaign costs automatically, you can do the Return on Investment (ROI) calculations directly in Google Analytics, using GA's new ROI Analysis report (under Conversions > Attribution), or in your favourite reporting tool. Do you have a unique way of tracking your marketing to maximise CLV? Are there other metrics you think are more important for subscription retailers? Littledata's connections are growing. We'll be launching integrations for other payment solutions later this year, so let us know if there's a particular one you'd like to see next.
Subscribe to Littledata news
Insights from the experts in ecommerce analytics
Get the Littledata analytics app
Start your free 14-day trialLearn More