Learn more about your ecommerce customers' behavior with advanced checkout funnel analysis [VIDEO]
Ecommerce analytics are tricky to begin with. Add tracking your subscription services on top of that and you’re dealing with a whole other animal! Do you use Google Analytics to report on your Shopify store’s one-off purchases AND recurring orders? Check out our video on Littledata’s advanced checkout funnel analysis to find out how we’ve made subscription analytics easy. https://youtu.be/EU3Cj2Z6AII Traditional ecommerce stores typically track one checkout funnel per property. The benefit is that this makes it easy to analyze the drop-off at each point. But, if you have multiple checkouts to track one-time orders and subscription purchases, important insights might go unnoticed when GA aggregates your data. Littledata automatically differentiates between your checkout funnels to show whether they’re subscription or one-time purchases. That way you know exactly what each funnel’s checkout completion rate is for different order types. This gives you the power to tailor your remarketing strategies for specific checkouts or products, further increasing your ads’ relevance to possible customers. Note: Do you trust your subscription tracking? Get accurate subscription tracking with the ultimate ReCharge guide for Shopify Littledata integrates with the top subscription ecommerce apps—including ReCharge Payments, Bold Commerce, and Ordergroove—and automatically tracks both Shopify and subscription checkouts. “Littledata is a must-have if you’re running Recharge and Shopify; it helped us figure out what channels were getting us our future subscribers and what helped convert them.” —Better Way Health To access your checkout reports in Google Analytics, go to your ecommerce analysis reports. From there, you can view your checkout behavior reports to get a general understanding of when users are dropping off throughout the checkout process. Find out how to segment your data between Shopify and subscription checkouts to measure the exact drop-off rate at each stage of the checkout process for each checkout funnel in our latest learning video. Capture data at every turn In addition to tracking your checkout funnel completion rates for subscription checkouts, Littledata tracks crucial sales and marketing metrics, so you can: Get accurate marketing attribution data for subscription revenue, including first-time payments and recurring chargesUse custom dimensions to measure customer lifetime value (LTV)Track performance by payment source, subscription plan type, and product categoryView complete sales and marketing data with combined server-side and client-side trackingMake better, informed decisions for your Shopify store Resources Watch a quick demo video on how Littledata worksFind out how to calculate LTV with Google AnalyticsDownload the ultimate guide to subscription trackingCheck out our ReCharge FAQSubscribe to our YouTube Channel for more videos about analytics
Two ways to calculate customer lifetime value for ecommerce using Google Analytics data
Many of our customers come to us with a similar question: "how do I measure ecommerce lifetime value (LTV)?" The latest episode in our Learning Videos series shows you how to do just that for both your one-off purchasers and subscription customers. Our step-by-step tutorial covers two methods of calculating customer LTV using your Google Analytics (GA) data. You'll get to know Littledata’s custom dimensions in GA and learn how to visualize your calculations in Google Data Studio. During installation, Littledata automatically creates several custom dimensions in your connected Google Analytics property. These custom dimensions include: Lifetime Revenue, the sum total a customer has spent in your Shopify store (including one-time purchases and subscription orders) Shopify Customer ID, the unique identifier Shopify assigns to each customer Last Transaction Date Payment Gateway Purchase Count They offer better data to help you understand your customers' buying behavior, then calculate and visualize their LTV. To kick things off, you'll first need to export your data from GA to Google Sheets or another spreadsheet tool via CSV. Once you’ve enabled the GA add-on in Google Sheets, you're ready to get started. Method 1: Calculate LTV by Lifetime Revenue, Shopify Customer ID, and Transaction Count In the first method of calculating lifetime value, we’ll use Transactions as the metric. The dimensions we'll use—Shopify Customer ID and Lifetime Revenue—correspond with ga:dimension5 and ga:dimension3, respectively. Use the image below as a guide to set up your report: Next, set your Metrics Reference as Transactions and your Dimensions Reference as Custom Dimensions. After you run the report, Google Sheets should look something like this: Finally, use Google Sheets' built-in functions to calculate the average or median LTV of your customers. Method 2: Calculate LTV by Source/Medium, Transaction ID, Shopify Customer ID, and Transaction Revenue This second LTV calculation method helps you track which marketing channels bring in your most valuable customers: the ones who spend the most over time. In this method, use Transaction Revenue as the metric and Source/Medium, Transaction ID, and Shopify Customer ID as the metrics. These correspond with ga:sourceMedium, ga:transactionId, and ga:dimension1 respectively. This method requires the widest date range possible to capture the most transactional data possible—preferably since you started using Littledata. Before running the report, your Google Sheet should appear as follows: After exporting your data, your result will look like this—a list of transactions with source/medium and revenue data: Next, select all the data in your report to create a pivot table, aggregating by source/medium per customer. The result will reveal the total revenue per customer, per source. After completing the pivot table, you're ready to visualize your data in Data Studio. Build Reports in Google Data Studio Google Data Studio is one of our recommended reporting tools for ecommerce sites. Why? Because it's free, powerful, and works really well with Google Analytics. The first step in visualizing your data is to import your data into Google Data Studio by setting Google Sheets as your source. To do this, select your Google Sheets file followed by the pivot table you created in the previous method, and add it to your report in Google Data Studio. Change the data source by setting the aggregation to median so results yield the median lifetime revenue per traffic source. Your report dimension should be set to ga:sourceMedium and your metrics should be set to ga:transactionrevenue and ga:dimension1. Modify Shopify Customer ID from sum to count distinct to reveal the total unique customer IDs, which we'll use to sort our data. Sort by Shopify Customer ID to see the traffic source that brings the most customers to your site. The resulting report shows you the median lifetime revenue per traffic source, sorted by the total customers per source. References Quick Tips for Subscription Stores Using Custom Dimensions in GA 3 Deep Dives into Customer Lifetime Value for Ecommerce Sites LTV from GA vs LTV provided by Littledata How to Calculate Customer Lifetime Value in GA for Shopify Stores Custom Dimensions for Calculating Customer Lifetime Value Subscription Analytics Does Littledata work with my ecommerce reporting tool?
Do you need a Google Analytics expert to help with your Shopify data?
At Littledata, we believe Google Analytics (GA) is one of the best free tools out there. Google Analytics is a great platform to access detailed data about your Shopify store’s user behaviour and sales performance. Regardless of your industry, as long as your Shopify store is in business, you need a platform where you can monitor your marketing performance and identify ways to increase your conversions. Google Analytics is the one of the most popular analytics platforms for a few reasons: It’s free. It can show nearly any metric you want to track, straight out of the box. But with a lot of data comes a lot of complexity. Even for experienced analysts, Google Analytics can be a hurdle at times. Your Shopify data needs constant monitoring since it's the single biggest factor in your marketing and sales decisions. And who better to do that than proven Google Analytics consultants! [subscribe] What to expect from a GA expert A Google Analytics expert will (or should) always know what to look for and where to find it, even before opening GA. Why? Because they’ve learned through experience to take the time and think through the data insights merchants need most. [tip]Here's what you should expect from a Google Analytics expert[/tip] On the other hand, if you’re taking the self-learning path and tackling GA by yourself, you’re really trying to achieve two things at the same time: become a web analyst and learn the GA platform. But are either of those time-efficient tasks to help grow your store? Probably not. Here's another thing: while a Google Analytics expert will help you make sense of your Shopify data, it's the digital implementation specialist who ensures you have the right Enhanced Ecommerce Conversion (EEC) data in your GA dashboard in the first place. Whether your EEC tracking will be implemented via GTM or other tools, the end game is the same: Get me the correct data in GA. And for this, Shopify and Shopify Plus stores are in luck — Littledata automates the EEC tracking so you don’t have to. Why get an expert? If Littledata automates tracking, why is it necessary to hire an expert? For things like Day to day checks on basic metrics like revenue and transactions Basic campaign monitoring for Facebook Ads, Google Ads, etc. For the most part, you can do these on your own. But a tool like Littledata provides the raw data in Google Analytics for much more granular insights, and that’s where a GA expert will come in handy. Here's an example: With every transaction, Littledata accurately sends to Google Analytics a set of raw properties (e.g. Shopify CustomerID, TransactionID and campaign parameters). For this data, a Google Analytics expert will be able to link the source or campaign path with customerID’s and transactionID’s in a custom report. This custom report will show the true return on ad spend (ROAS) based on different attribution models. Determining which conversions are linked to a first interaction or an assisted interaction will help you measure and optimize your marketing campaigns with more accuracy. [tip]Find out the real ROAS of your Facebook Ads for your Shopify store[/tip] Metrics that matter One of the main metrics marketers want to know is Customer Acquisition Cost (CAC) per channel. If you get that right, you’ll know exactly where to increase your marketing spend. And in doing so, you’ll probably acquire more customers for about the same fixed budget. A GA expert will be able to gather your (true) marketing costs from all your marketing campaigns over a given time period, and calculate the amounts by channel. This sounds easy, but things can get a bit more complicated when you're trying to find the CAC based on each attribution model. By now you should know your ROAS and CAC, but what about customer lifetime value (LTV)? In other words, you should know how much $$$ your marketing leads are spending with you, what your acquisition cost is per customer, and where to find the highest converting leads. But do you know how much time they are spending with your brand? Which channels are bringing the stickiest clients? Which channels bring the most repeat purchases (or subscriptions)? LTV is one of the most coveted metrics for ecommerce managers. A GA expert will help you calculate LTV by summing up the gross profit from all historic transactions for each individual customer, then splitting those conversions by channel and calculating the median for each. And if you want things laid out for you in plain english, at Littledata we provide the necessary custom dimensions you need to accurately calculate LTV. So what's the verdict? For Shopify merchants, Littledata is one of the best solutions to ensure reliable data for accurate marketing attribution and buyer behaviour. And since your Shopify store already needs fixing when it comes to data collection, an enterprise plan (with full support and a dedicated team of Google Analytics consultants) just may be an answer to your prayers. With Littledata enterprise, get all the analytics support you’ll ever need, for a fraction of the cost to hire an experienced Google Analytics consultant. Get in touch with our team today to see how an enterprise plan can accelerate your path to scale! ?
How to set up cross-domain tracking in Google Analytics
New Klickly integration for Shopify stores
We're excited to announce a new integration with Klickly! Get ready for smarter analytics. Many Shopify stores know that their data isn't accurate, but they don't know where to start. Littledata tracks everything automatically. Our new Klickly integration offers full sales and marketing tracking, plus a free custom report to help you get higher ROI on Klickly campaigns. [note]*updated* Since dissolving the Klickly integration, we've enhanced our marketing attribution smart connections even more, including Google Ads and Facebook Ads.[/note] What’s Klickly? Klickly is an invite-only, commission-based advertising platform that enables ecommerce merchants to run unique buyable ads on thousands of well-known websites. With risk-free, commission-based pricing, you don't pay commission until Klickly gets you a sale. Setup takes less than 10 minutes, and there are no long-term agreements or fees. Stop paying for clicks + impressions that don’t lead to sales. Klickly lets you pay only when ads drive sales and set the commission that’s right for you. Benefits of Littledata's Klickly integration: Campaign reporting – Get automated reporting for sales from Klickly Ads Marketing attribution – Connect marketing channels and campaigns with shopping cart activity and buyer behaviour, with automated tracking for Shopify stores Optimisation – Make data-driven decisions with Littledata’s industry-leading analytics audit, smart connections and industry benchmarks Setup guide For the Littledata - Klickly integration to work, you need to have both apps installed for your store. Install Klickly and Littledata Ask the Littledata support team to activate the Klickly report for you Yes, it’s that easy! You can contact Littledata support from the Intercom widget in the app, or just reply to any of our onboarding emails :) Enterprise plans for larger Shopify stores and Shopify Plus If you run a larger Shopify store on Shopify or Shopify Plus, we’re here to help you scale. Littledata offers enterprise plans that include custom setup and a dedicated account manager. This can include anything from GTM setup to custom reporting. Larger stores looking for an enterprise plan are encouraged to sign up for a free trial of Littledata, then contact us for a free consultation so we can take an in-depth look at your setup. If you’re a digital agency with multiple customers on Shopify using Klickly, even better! Check out our agency partner program for Shopify experts. If you're looking for accurate, actionable analytics, Littledata's new Klickly integration will help you scale the smart way. Say hello to a better way! [note]*updated* Since dissolving the Klickly integration, we've enhanced our marketing attribution smart connections even more, including Google Ads and Facebook Ads.[/note]
Why don't my transactions in Google Analytics match those in Shopify?
What we learned at Techsylvania 2018
My first design sprint
Littledata believes that happiness and productivity go hand-in-hand, but what does that look like in practice? In this post I'll share a bit about our workplace culture and most recent design sprint, from the perspective of me, our newest team member! Four years ago a new company emerged - Littledata. Fast forward to today and we have major ecommerce customers around the world, including Made.com, Figleaves and Age UK. Our consulting business has grown to develop a suite of ecommerce analytics technology that anybody can use - including an industry-leading analytics audit, automated reporting with Google Analytics and even a dedicated Shopify reporting app. And the team has continued to expand - Meet our great team here My story I joined Littledata two months ago, and it's already been an amazing journey. I was working as a marketing specialist at a Romanian company when a friend pinged me about the opportunity to work at Littledata. I was not looking for a job at the time but I was impressed about the innovative app they had created, so I knew I had to meet them. Initially, I applied for an open position listed on Littledata's careers page. Unfortunately, my background experience in that field was not so generous and I did not get the job. (True story!) But no worries there, as Littledata saw potential in my good attitude, proactive work ethic and willingness to learn. After some additional interviews and a test project, they gave me a chance and created a new position for me as a marketing assistant. This was a clear sign of an open-minded work culture that invests in its employees and focuses as much on potential as on experience. In short, I accepted the job and joined the European team. It was one of the best professional decisions I've ever made. Since I joined Littledata I've learned more in two months than in an entire year at other companies. My colleagues and supervisor took time and patience to teach me and guide me through skills that otherwise I couldn’t have learned by myself. Littledata is a data company - and Google Analytics isn’t easy stuff - but since we’re dedicated to making analytics as painless and as useful as possible to our customers, it’s an exciting and exhilarating place to work. There are new challenges and great successes every single day in the office. Besides the best mentorship I am receiving, my peers proved to be very fun and sociable. It’s a place where we do work as a TEAM, helping and supporting each other. The only competition we have is from our competitors. Moreover, the perks I got with the job with remote-working hours and annual offsites in a different countries, easily trump the perks of working at big corporations. I discovered that the fast evolution of Littledata is due to its employees. Littledata’s senior staff believes that true innovation comes from happy employees. (Want to see the data? There is statistical evidence that happiness and a positive workplace culture drive both productivity and profit.) By focusing on building a strong internal bond, offering excellent benefits, and driving diversity, Littledata created a one-of-a-kind workplace environment. Things weren’t always easy though. They’ve had their share of challenges. See how Littledata went through the challenges of developing a Shopify integration. [subscribe] Where do we work? As Littledata grew, the team expanded worldwide. Our offices are located in New York City, London, and Cluj-Napoca (Romania), and we have employees and consultants in over eight different cities. Here in Cluj, the workspace was recently renovated and each room is personalised after each employee’s personal mark. In this way, we all feel comfortable and productive at our workspace. Many times we don’t even use our office desks, preferring to work intently on our sofas and bean bag chairs, or outside in the hammocks. We might have a remote work culture, but we stay constantly connected. Our communication strategy includes Skype for official meetings and Google products (Calendar, Drive, etc.) and Slack for fast chatting, collaborating and updating. To keep track of our projects we use Trello cards, where we split the team into different boards, depending on their department. We found that it’s the best way to connect all our team and not get lost in a messaging abyss despite the different time zones. My first design sprint In order to bring clarity in our roadmap and kickstart new features, we embrace the Design Sprint philosophy. A design sprint is a five-phase framework that helps answer business questions through a fast-paced prototyping and user testing. Understand (review background and user insights) Diverge (brainstorm what’s possible) Converge (rank solutions, pick one) Prototype (create a minimum viable concept) Test (validate with users) Basically, we pick a time and a place where we all gather up every three months and do some Sprint-Planning focused on a specific goal. The process helps to spark innovation and align team members under a shared vision. Through this hyper-focus, we can build better features and launch them faster. I recently joined a Design Sprint that took place in a beautiful villa on the island of Mallorca. In the first day I assisted at a short introduction from our organizer, followed-up by the schedule presentation of our 5 day sprint-design and reviews from my colleagues regarding the last sprint. Afterwards, we separated into two groups, the product team and the marketing team. I joined the marketing team, and for the next 5 days we worked on new ways to promote Littledata by answering the needs and the common questions our customers have. After we all agreed on the most important topics to cover we split up into three teams of two people each. One team managed a new promotional video, the other took on the app’s features process, and the last one worked on a customer onboarding process. I was in the app’s features team - check them out: Littledata’s features. The product team came up with a way to increase engagement in our Shopify app and started to develop an exciting new feature that we’ll be launching next quarter! On the 4th day the product team and the marketing team reunited, presented their work and ideas, and voted on each other’s ideas. The last working day was the prototype day where both teams tested their prototypes with real customers. This was an essential part of the Sprint and definitely worth doing if you’re thinking of running a Design Sprint yourself! The Sprint-Planning was also a great way for catching up with each other and spending quality time with all the team members. Our leisure time was spent in Spain, traveling and engaging in fun activities. Work hard, play hard! We even spotted one of our customer's products, Micro-scooters, in a shop window Palma's old city! Perks In my opinion, one of the biggest perks of working at Littledata is the remote-working hours. A flexible and personalized work schedule gives the employees the opportunity to balance work and personal life very efficiently. Besides, the company offers the benefit of working from home when needed. We can work from a coffee shop, a HubSpot, a park or wherever we feel like it. You can work from anywhere ... just make sure to have a good internet connection. Healthcare is also assured. No need to worry about this topic, because for employees in Romania, Littledata grants personal health insurance through our Groupama collaborators. Wellness is also supported by weekly fruit baskets, tea, coffee and other yummy snacks. Integrating all of these pieces together, we create a comfy and positive environment for our employees. Workplace culture (P.S., we're hiring) Our growing team is open to hiring new staff members who bring value and personality into Littledata. Having a strong professional background helps, but a drive to learn is just as important. Get involved and be proactive. We encourage learning in all of our activities. We look for people that are passionate, ambitious and always want to challenge themselves. Another criteria that we are fond of is respect. Our company has a strong policy in respecting its employees. As we are very diverse in culture, we coordinate to celebrate each person's birthday and major life events. And last but not least, we are fun folks. Be serious in your work, but have a positive and cheerful attitude. And guess what? We are hiring! We have big plans building some awesome products. So come join us, either as an employee or as a collaborator, to create new features using the latest analytics technology. Check out our open positions here. We’d love to hear your opinion - what do you think a great workplace looks like? Leave a comment below and subscribe to our newsletter for the latest in everything analytics.
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