Category : Connections
Link Analytics to AdWords with our new Google Ads connection
To target -- and retarget -- the right shoppers, ecommerce sites need to connect customer behaviour and ecommerce data from Google Analytics with their Google Ads (AdWords) accounts. But until now that was a complicated process, to say the least. Marketers have spent years going through detailed setup steps to connect the platforms, or wading through spreadsheets with manual imports and exports, building custom audiences and segments. It was an ongoing headache, but they did it because connecting shopping behaviour data with AdWords campaigns gets big results. Now there's a better way. Littledata's new Google Ads connection makes it easy to link Analytics to AdWords. Ecommerce sites are using the connection for smarter targeting that increases online sales and customer LTV. Why should you link Analytics to AdWords? In past posts we've highlighted the benefits of linking Analytics with AdWords for a mutually beneficial relationship. Littledata's new connection automates the process to ensure accurate tracking and more targeted campaigns. Benefits include: Online sales data in AdWords reports, and visa versa. Add sales columns to reports in Google Ads and view Google Ads costs in Google Analytics. Abandoned cart campaigns. Get higher ROI with targeted PPC campaigns based on shopping cart activity. Ecommerce hyper-segmentation, especially for Shopify stores and enterprise clients. Since Littledata fixes ecommerce tracking across the checkout flow, the Google Ads connection is especially powerful for marketers looking to retarget with granular user behaviour data, such as product list views, product detail pages and adds-to-cart. Multiple accounts. Multiple views. Our Google Ads connections lets you link multiple AdWords accounts to multiple Google Analytics views. It's that simple. Wait, do you mean Ads or AdWords? Have you heard the news? Google AdWords is now Google Ads. Google pitched the switch to Ads as a large-scale rebrand for simplicity, but it's clearly targeted in part at bumping up competition against other 'ads' in common parlance: Facebook Ads, Instagram Ads and Twitter Ads, with Reddit Ads quickly gaining pace among SaaS companies in particular. We still talk about AdWords a bit on the blog (as does the rest of the internet, such as Search Engine Land), but soon we'll all have to adapt to the change. So we're calling this new connection a Google Ads connection, but we don't expect marketers to stop chatting about AdWords any time soon. How does it work? After you sign up for Littledata, you can connect Analytics to AdWords from the Connections tab in the Littledata app. Just follow a couple of setup steps and the app makes the connection for you. No more manual connections. Plus, we audit your analytics setup continually to ensure consistent ecommerce tracking, campaign tagging and UTM parameters. So what are you waiting for? Those products aren't going to retarget themselves... And don't forget to try our Facebook Ads connection to complete your marketing analytics stack. It's an easy way to link Facebook Ads to Google Analytics. All paid plans in the Littledata app include a variety of Google Analytics connections for Shopify, Shopify Plus, ReCharge, Refersion, CartHook and more. PS. The next iteration of our Google Ads connection will provide automation for retargeting using ecommerce segments. Sign up for Littledata today so you're first in line!
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.
Our top 5 posts from 2018
Happy new year! With a lot of big things on the way for Littledata this year, including new Connections to automate analytics for an even wider range of popular ecommerce apps and platforms, we wanted to take a moment to look back on the posts you found most useful with our current feature set. Last year we reviewed our top posts from 2017 and found that the focus -- not surprisingly -- was on Shopify and Google Analytics. This time around, our most-read and most-shared posts have really honed in on individual features and connections, especially for larger stores using one of our enterprise plans for full account management and unlimited automation. Interestingly, 4 out of the 5 top posts have a title in the form of a question. Perhaps a sign of 'plugged-in' (ie distracted) readers looking for a sense of engagement? 1. What's the real ROI on your Facebook Ads? For the past decade Facebook’s revenue growth has been relentless, driven by a switch from TV advertising and online banners to a platform seen as more targetable and measurable. When it comes to Facebook Ads, marketers are drawn to messaging about a strong return on investment. But are you measuring that return correctly? 2. Why don't my transactions in Google Analytics match those in Shopify? If we had a nickel for every time we hear this question! In this popular post, our partner manager breaks down common reasons for ecommerce data inaccuracy between Shopify and GA, and takes a look at how to fix those issues automatically. Find out the top 6 reasons for inaccuracy, including some orders never being recorded in Google Analytics! 3. New help center articles on Shopify tracking and ReCharge integration With detailed new articles on Shopify tracking and how our ReCharge integration works, the new Littledata Help Center quickly became a go-to resource for current customers and ecommerce managers this past year. Even before they become customers, many ecommerce industry folks are using the help center to get a clearer view of how to use Google Analytics effectively. We're happy to help! 4. Are you looking at the wrong Black Friday metrics? Paying attention to the right ecommerce metrics can help you establish the best customer base and shopping experience for long-term growth. But many retailers still focus only on the most popular metrics — especially during the online shopping craze of Black Friday and Cyber Monday (#BFCM). Over the next few weeks ecommerce managers will be obsessing over data, but which stats are the most important? Two popular metrics — ecommerce conversion rate and average time on site — may be misleading, so in this post our CEO recommends looking instead at longer-term benchmarks. 5. Average order value benchmarks 2018: how do you compare? Increasing average order value usually has a dramatic impact on profits and ROI from marketing spend. It is also a gift that keeps on giving, as optimisation in this area is something that can deliver ongoing results over the long term. The holiday shopping period in 2018 had us obsessed with one of our favourite ecommerce metrics: average order value (AOV). How does your site compare? This popular post includes a new infographic that breaks down the stats, using our set of private benchmark data about the ecommerce industry.
Introducing Shopify Flow connectors for Google Analytics
Littledata has launched the first Shopify Flow connector for Google Analytics, enabling Shopify Plus stores to analyse customer journey using a custom event in Google Analytics. In addition to Littledata's native connections with Shopify, Shopify Plus, Facebook Ads, ReCharge, etc., we have now launched a beta version of a Flow connector for Google Analytics. What is Shopify Flow? Flow is an app included with Shopify Plus, which enables stores to define automation pathways for marketing and merchandising. Think of it as an ‘If This Then That’ generator just for Shopify. For example, after an order is marked as fulfilled in Shopify’s admin you might want to trigger an email to ask for a review of the product. This would involve setting a ‘trigger’ for when an order is fulfilled and an ‘action’ to send an email to this customer. How do you use Littledata Flow actions? You install Littledata's Shopify app along with Shopify Flow Every time an order is created in your store we send it to Google Analytics, along with information about which customer ID made the order (nothing personally identifiable) You add Littledata's actions to your Flow Every time the order or customer event is triggered, even for offline events, the event is linked back to Google Analytics In Google Analytics you can then: Segment the customer base to see if these actions influence purchasing behaviour Visualise when these events occurred Analyse the customers making these actions: which geography, which browser, which marketing channel (in GA 360) Export the audience to retarget in Google Ads (in GA 360) Export the audience to run a website personalisation for using Google Optimize How do you set the actions up in Flow? Google Analytics customer event – can be used with any customer triggers, such as Customer Created Google Analytics order event – can be used with any order triggers such as Order Fulfilled, Order Paid, How else could I use the events? You can now link any of your favourite Shopify Apps with Flow connectors into Google Analytics. Some examples would be: Analyse if adding a product review leads to higher lifetime value Retarget in Google Ads after a customer's order is fulfilled Set up a landing-page personalisation for loyal customers (using Loyalty Lion connector) How much does this cost? The Flow connectors are included as part of Littledata’s standard subscription plans. You’ll need Littledata’s app to be installed and connected to link the events back to a customer – and to get reliable data for pre-order customer behaviour. [subscribe] Can Littledata set up a flow for a specific app? Our Enterprise Plans offer account management to help you configure the Littledata Shopify connection, including the Shopify Flow connectors. Get in touch if you have a specific app you'll like to make this work with.
Introducing our new Facebook Ads connection
We're excited to announce a new Facebook Ads connection in the Littledata app! The integration automatically pulls ad costs and campaign data into Google Analytics, and the open beta release is free to try for all users. How do you know if you're getting the highest possible ROI on your Facebook Ads? For ecommerce sites, it's a difficult question. By their very nature, PPC platforms can provide only a limited amount of reporting, tied to their own network and performance data. Ecommerce sites need an outside view of marketing channels, and a way to connect that ad performance with shopping behaviour and product performance. But where should you start? You can trudge through Facebook's limited reporting, make endless spreadsheets and play guessing games. Or you can take advantage of the latest data tech for automated reporting and comparative attribution models. New Facebook connection We built a robust Facebook integration to automate everything so you can get back to business.Our goal is to show you the real ROI on your Facebook Ads. And to do so as painlessly as possible. It's an easy connection in the Littledata app, with numerous core benefits: Fix your campaign tracking Automatically pull ad cost data into Google Analytics Enterprise-level reporting on marketing channels and product performance Complete view of how your ad spend contributes to product and subscription revenue In addition to the automated reporting in your Littledata dashboard, which includes reports on social referrals, checkout funnels and recurring billing, this new Facebook connection gives you unlimited access to accurate Facebook campaign data directly in Google Analytics. Data geeks can drill down into PPC details and build models of their own as well. [subscribe] Fix your campaign tracking The Facebook Ads connection has its own succinct set of audit checks to make sure you're tracking things correctly. It's a natural extension of our popular analytics audit tool. Once you connect your Facebook Business account, the app automatically checks for accurate campaign tagging and ecommerce event tracking. Sites change and new campaigns are added or adjusted on a regular basis, so our app takes care of the busy work to monitor your campaigns and keep everything up to date. Focus on the most important metrics Littledata offers a range of AI-based reporting directly in the app, from dashboard visualisations to ecommerce benchmarks. The Facebook Ads connection extends your reporting capabilities to reveal essential metrics such as: Google Ads vs Facebook Ads conversion rates and revenue share Multi-channel attribution Top products sold from your Facebook Ads, including subscription products Landing page performance No need to wade through data in GA. With report packs, it's easy to get useful analysis with just a couple of clicks. Top report packs for Facebook Ads connection users include: Social traffic pack, with reports on social channel referrals from sites like Instagram, Pinterest, Twitter and Facebook, including untagged social traffic and top campaigns Ecommerce performance pack, with reports on average order value (AOV), days to transaction, sessions to transaction, and details like product subcategory performance A dedicated Facebook Ads pack, with reports on revenue contribution, Google vs Facebook PPC stats, landing page performance, multi-channel attribution and more! Not a Littledata user yet? Find the plan that's right for you, whether you're on Shopify, BigCommerce, Magento or any other platform. Every subscription plan includes at least two free report packs, and enterprise plans include custom tracking and reporting. Plus, integrations like ReCharge, CartHook and Shopify are included at no extra cost. Try the new Facebook Ads connection today and let us know what you think! We're confident that this powerful new integration will help you get a higher ROI on your ad spend, with more sales from your best types of customers.
ReCharge integration for subscription analytics
We're excited to announce that Littledata's Shopify app now integrates seamlessly with ReCharge! The integration makes it easy to get an accurate data stream about your ReCharge subscriptions in Google Analytics. What is ReCharge? ReCharge is the most popular recurring billing solution for Shopify stores. It lets you easily sell subscriptions on a Shopify store. ReCharge has a robust feature set for stores selling physical products on subscription, allowing for single product, mixed cart & entire cart subscriptions. The app powers thousands of stores processing tens of thousands of orders daily, including Littledata customers like Tiege Hanley skin care and BIOHM probiotics. Until we built this new integration, ReCharge customers didn't have a way to get a complete data collection in Google Analytics without hiring expensive GA consultants. How the integration works Integrating Littledata with ReCharge lets you capture data about the entire subscriber journey, from marketing campaigns to first-time payments and recurring revenue. The integration uses Littledata's magic sauce to connect Shopify and ReCharge data to Google Analytics. The reporting includes essential information for understanding business performance: End-to-end Google Analytics tracking for the subscriber journey Marketing attribution for subscription revenue, including first-time payments and recurring charges Segmentation by payment source, subscription plan type and product category With this integration plus the power of Littledata's analytics audit tool, you ensure accurate tracking of everything in your ecommerce funnel. You can then take advantage of automated reporting to help you increase revenue, including report packs built specifically for subscription analytics. Littledata's revenue optimisation tools pull directly from your GA data. Advanced users can can also use that data directly in GA - and connect it to dashboard tools like Data Studio and Supermetrics. And the price is right! Littledata provides Google Analytics for ReCharge stores at no extra cost. It's a free integration for any Shopify store using both apps! [subscribe] Setup guide For the Littledata - ReCharge integration to work, you need to install both apps for your Shopify store, then connect them by activating the integration. Install ReCharge Install Littledata’s Shopify app Follow these steps to activate the integration Note that you will activate ReCharge’s basic Google Analytics integration as part of the setup process, but you need to complete the Littledata integration to get full marketing attribution and to track recurring subscriptions (not just first-time payments). For more information about how our ReCharge integration works, check out our knowledge base. If you’re looking for custom setup or help with reporting, consider one of Littledata’s enterprise plans. Higher-tier plans include a dedicated account manager and support from analytics experts. We have many happy ReCharge customers, so please get in touch if you have any special requests! This post was updated in June 2018
Subscribe to our blog
Get the latest posts in your email
Get the Littledata analytics app
Complete picture of your ecommerce business. Free Google Analytics connection, audit and benchmarks.Sign up