The Ultimate Guide to connecting Segment to Redshift (and other powerful analytics tools)
Cloud data warehouses offer a way for ecommerce companies to scale as the size of their data increases, promoting unlimited storage space, cost optimization and analytics horsepower. But where do you start? Are there no-code solutions that are also best-in-class? Segment is an increasingly popular way to connect website data to a data warehouse such as AWS Redshift. In this guide we'll take a close look at exactly how this works, and the pros and cons for your longterm company data needs. Using Segment to connect Shopify to AWS Redshift What is Segment? Segment is a powerful Customer Data Platform (CDP) solution, but it's also much more than that. Segment provides businesses the ability to organize customer activity events from various platforms to a broad range of destinations, One of those destinations can be a data warehouse - an ecosystem that serves as the centralized source of data collection. This includes the big three: BigQuery, Redshift, and Snowflake. The technology focuses on the tasks of collection, storage, and management of business data - with the purpose of turning operational data into meaningful information. For any company looking to harness the value of the activities gathered inside their CDP, it’s a no-brainer that bringing a data warehouse into the mix is the next best step. Amazon Web Services (AWS) and its data warehouse offering, Redshift, remains the market leader in this space because of its compatibility with data integration pipelines and analytics tools. One of your Segment destinations can be a data warehouse such as AWS Redshift For ecommerce sites this can be difficult to implement manually (not to mention maintenance time, costs and complexity!), but Littledata's Shopify source for Segment does this automatically. With Littledata’s capabilities, you have the ability to direct, track, and identify custom events across all critical customer activities, including across your Shopify website, whether that's a simple Shopify instance, a headless Shopify setup or multiple country stores doing international sales. Coupling that with Segment’s unified CDP takes powerful data to activation, and the ability to direct platform data to marketing channels for increased engagement, conversion and retention. Whether you want to use a data warehouse for deep analysis, audience building or real-time recommendations, Littledata + Segment + Redshift is a proven solution for Shopify stores. Setting up your Redshift data warehouse Segment's documentation portal gives a step-by-step breakdown of provisioning a Redshift cluster, configuring a database user, securing data ingestion, and providing a path to data collection into your Redshift instance. Breaking the process down in digestible chunks, here are the necessary steps to go from data to data warehouse: Choose the best instance for your needs: Dense vs. Compute StorageProvision a new Redshift Cluster: 5 simple steps from start to finishCreate a database user: Creating a user to manage your instanceConnect Redshift to Segment: Select sources, credentials, and go Redshift allows users to start small and scale up on-demand as needs grow Collecting events in Segment Event tracking is a critical part of the data collection process. Creating a plan tracking plan associated with measurable business outcomes, such as acquiring new customers, increasing retention and activating new leads, and mapping those outcomes to business goals, is an important step in the data journey. Understanding this relationship will provide guidance to the relevant events or actions that must be configured to successfully track. With Littledata's automated solution, you can avoid the blocking-and-tackling of configuring the best-in-class event strategies surrounding (client side) device-mode and (server side) cloud-mode events: Device-Mode events include Cart Viewed, Page Viewed, Product Clicked, Product Image Clicked, Product List Viewed, Product Shared, Product Viewed, Products Searched, Registration Viewed, Thank you Page Viewed Cloud-Mode events include Checkout Started, Checkout Step Completed, Coupon Applied, Customer Created, Customer Enabled, Fulfillment Created, Fulfillment Updated, Ordered Cancelled, Order Completed, Order Refunded, POS Order Placed, Payment Failure, Payment Info Entered, Product Added, Product Removed To streamline the process for ecommerce sites, Littledata's tracking script automatically sends events to Segment through its analytics.js library, making it easy to collect all the critical event activities associated with a customer’s store journey - from browsing behavior through the checkout funnel and repeat purchases (including recurring billing for stores selling by subscription). Additionally, from every event where this is an identifiable customer (from both device-mode and cloud-mode), Littledata will send an Identify call - the identification of a customer when the customer logs into your storefront, a last step of the checkout process, with the order, and also after a purchase with a customer update. With Littledata’s streamlined modeling, data can be accurately represented and pushed to downstream destinations, such as marketing activation channels and data warehouses. [subscribe heading="Littledata connects Shopify to Segment and your data warehouse" button_text="Book a demo" button_link="https://www.littledata.io/app/enterprise"] Connecting Segment data to your data warehouse Now that your Redshift instance is up and running, the next step is to connect to Segment and start collecting data into your data warehouse. There are two ways to complete this step - one, through Segment’s native migration, and the other, utilizing no-code data pipeline tools (recommended). Whichever process you choose, you will have the opportunity to push data out of Segment into your data warehouse environment and start utilizing it across your business. Option 1: Segment’s native migration As mentioned, Redshift data warehouse is one of the many destinations that Segment can send data to. You can directly connect to Redshift from within Segment to stream event data. Segment’s catalog provides direct integration to best-in-class data warehouses Essentially, it’s as simple as: Login to your Segment App and proceed to the Catalog sectionIn the top menu, choose DestinationsSelect Redshift in the Storage Destinations list After configuring your user permissions and selecting the data sources you would like to sync, you’ll enter in your credentials and connect to your data warehouse. Voila! Data will now be continuously replicated into your Redshift instance based on your plan: Free: Data refreshed (synced) 1x per dayTeam: Data refreshed (synced) 2x per dayBusiness: Data refreshed (synced) as fast as hourly As for historical data, all plans will allow loading up to 2 months of your historical data, with the Business plan allowing for full historical backfills. Since Segment provides an environment to support many, it requires a premium plan to collect complete history and sync data real-time. Segment’s infrastructure is suitable for instantaneous data collection to downstream points Option 2: Leverage data pipeline services The second way to get data out of Segment into your data warehouse is through data pipeline platforms. Data pipeline or ETL (Extract, Transform, Load) platforms, provide prebuilt integrations to over 100+ enterprise software sources, and focus on a maintenance-free structure where replica data is automatically transformed, standardized, and normalized on collection. The automated adjustment to schema and API changes, allows business users to streamline developer tasks in a no-coding required environment. Companies like Stitchdata ("Stitch") and Fivetran, leaders in the space, provide frictionless, subscription-based memberships that allow integrating data to data warehouse destinations convenient for any business size. ETL platforms streamline data from end-to-end and require limited technical lift To set up, simply sign into your console, click on the Segment icon in the available integrations, and enable. You will automatically be pushed into the Segment tool to confirm authorization and (another voila!) data will begin replicating. Stitchdata’s user-friendly interface for connecting platforms to destinations The benefits of cloud-ETL platforms, not only include their out-of-box integrations, but the list of features included to help visualize, maintain, and support ongoing data integration tasks: Over 100+ database and SaaS platform integrationsIn-app support including email alert monitoring and support SLAs14-day free trial to kick-off and vet the platform prior to fully onboardingSOC2 security compliant, encrypted communication and an AWS cloud backed environment Ecommerce data With the appropriate event tracking configured at data collection by Littledata, your data can be properly analyzed for ecommerce store performance. The downstream output can be properly displayed by: Customer behavior before, during and after purchaseOrder performance relative to average order value, add-to-carts, average order size, and cart abandonmentShopper engagement including product views and purchasesCoupon and discounting activitiesCustomer checkout funnel and stage of drop-offConversion rate and lifetime value With the emphasis on accuracy completed at the inception data collection stage, the ability to produce the above areas of performance becomes that much more straightforward. This means spending more time analyzing and visualizing data, then transforming and modeling data for analytical use. Empowering your data Once your data is available in your data warehouse, replicating frequently, and building history, it’s time to utilize it. That can come in a number of various opportunities, depending on your business needs. Most notably, companies will focus on transforming data into actionable blocks and pushing into business intelligence (BI) tools. Transformation To properly stitch event data together - say in the case to tie all interactions by a site visitor to achieve multi-channel attribution - companies can leverage existing packages that transform, marry and enrich data points. These packages - or prebuilt libraries - produce powerful results that end up restructuring data from their raw state to analysis-ready. Fishtown Analytics’ product dbt does just that, performing user-stitching, simplifying data structures, and speeding up data modeling to use instantly within reporting, analytics, or machine learning applications. Leveraging transformation can streamline data modeling and enrich data for analytical-use BI Tools Companies usually begin the conversation here, “I’d like to see a dashboard like X” or “Can we get a report showing Y?”. In fact, what they are looking for is a way to properly view data in digestible, actionable views. BI (Business Intelligence) tools do just that - whether it’s through data visualizations (dashboards), self-service analytics, or prebuilt reporting. Enterprise BI and SaaS tools like Looker and Tableau (like outlined in the table below) create the speedy path to data viewing. They can be simply connected to a data warehouse and publish dynamic views for instant performance tracking. Data can be presented in dashboards across many dynamic charts, tables, and graphs BI Tools Breakdown CategoryVendorsBreakdownMarket LeadersTableau, Looker, PowerBI, Mode, DatabricksEnterprise tier platforms with extended featuresRisersDomo, Klipfolio, Kissmetrics, SigmaSaaS-oriented products with cost on user and dashboard usePrebuiltGlew, Daasity, Dashthis, Rubix3Ecommerce focused with prebuilt visualsOpenDataStudio, MetabaseOpen-source/no-cost platforms So a straightforward reporting and visualization solution with the setup we've described in this article, would be to connect Shopify to Segment, then Segment to Redshift, then Redshift to Tableau. Learn more about how to connect BI tools to your Shopify data in Segment, whether as a Segment destination using alias calls or a dynamic view pulling from data in your warehouse. Another option is connecting reporting tools directly to Google Analytics data in parallel with your Redshift setup (for example, use Tableau on top of GA for marketing analysis and Looker on top of Redshift for deeper analysis and predictive analytics). Building for the future Companies that put an emphasis on building the foundational components of data ingestion, management and analytics early on see many benefits. Primarily, you are able to increase your ability to measure and understand your business properly. Data warehouses provide an opportunity to collect all of your store, site, customer, marketing, other relational data - all in one place. This creates a centralized view of your business and gives an upper hand to companies looking to take a data-driven approach to growth. Cloud tools and no-code options remove the need for technical resources, freeing up dollars that can go elsewhere without sacrificing the ability to use and analyze data. No matter the size of your business, taking data seriously is the first step to empowering your business for the future. Data warehouses are no longer the property of only mega enterprises. Want to build a modern ecommerce data stack but not sure where to start? Get in touch for a free consultation. [subscribe heading="Littledata connects Shopify to Segment and your data warehouse" button_text="Book a demo" button_link="https://www.littledata.io/app/enterprise"]
Littledata at Codess
I was proud to be invited by Microsoft to speak at their Codess event in Bucharest last week to encourage women in software. We talked about how Littledata uses Meteor, Node and MongoDB to run scalable web applications; slightly controversial because none of these are Microsoft technologies! The event was well run and well attended, so I hope it inspires some of the attendees to start their own projects...or to join Littledata (we're hiring).
ReCharge report pack for subscription-based businesses
There's never been a better time to grow a subscription-based business. But the landscape is also more competitive than ever. How do you rise above the noise and obtain devoted subscribers? With our new ReCharge report pack, any recurring-product business can get advanced analytics to help obtain a devoted subscriber base. It's the latest addition to our automated packages of analytics reports. [note]Now, with a revamped ReCharge connection — ReCharge v2 — you can track subscription lifecycle events with ease![/note] The new pack includes a curated selection of reports proven to help subscription-based ecommerce sites get more traffic and increase recurring revenue. Each report automatically pulls relevant data from your Google Analytics account and turns it into actionable reports, with essential tables and smart visualisations. Growth of subscription-based businesses From vitamin supplements to hacker boxes, product subscription companies are on the rise. Getting products in the mail every month is a huge chunk of the future of ecommerce. According to the Subscription Trade Association (SUBTA), the subscription box industry alone is on track to generate more than $90 billion in annual revenues in the coming decade. SUBTA itself was only formed a little over a year ago, coalescing around this exciting new ecommerce community, and their first events have all sold out. Entrepreneurs who want a piece of subscription industry growth need to optimise every part of the customer life cycle. You don't just need more traffic, you need better-quality traffic. And you don't just need to improve the user experience (UX) on your site, you need to create an engaging customer experience (CX) that drives conversions, brand devotion and upsells. Sounds easy, right? Think again. Luckily there are solutions like ReCharge and Littledata that work out of the box to help you run and optimise a subscription business. [tip]Get accurate tracking for repeat orders with the ultimate ReCharge guide for Shopify and Shopify Plus.[/tip] What's in the new report pack Our popular ReCharge integration was built to give subscription-based companies accurate marketing attribution for signups and sales in their Shopify stores, but it's quickly grown to be even more detailed, offering deep analytics across the subscription customer life cycle. Automatically connecting marketing campaigns to recurring payments is just the beginning. The first ReCharge report pack makes it easy to keep tabs on where your customers are coming from, the balance between new signups and recurring payments, and how different subscription plans are contributing to revenue. The pack contains a general overview widget plus four key reports for digging deeper into recurring revenue. Which marketing campaigns are driving the most first-time purchases? Is organic search outperforming your PPC campaigns? Is revenue per recurring purchase growing at a steady rate? Those are questions with answers. The ReCharge report pack will help you: Get a concise overview of weekly performance Increase marketing ROI with a clear understanding of how different channels and campaigns are contributing to customer growth Build a sustainable subscription business by optimising revenue segments and payment solutions The Reports tab in your Littledata dashboard automatically shows all relevant report packs, so check them out today and reach out if you have any questions. The ReCharge pack pairs well with our Basics pack, which includes essential reports on site performance and user behaviour. PS: Still waiting to try our Shopify reporting app? Don't delay! We have a plan for every sized business, and ReCharge integration is free!
5 steps to higher ecommerce search traffic
Search traffic is essential for ecommerce growth, and it takes time to build. In this guest post, SEO expert Bill Widmer highlights 5 easy steps to rise to the top. There are over 1 billion websites on the internet today, with almost 2.4 million websites created every day. Of those sites, only 10 make it to the front page of Google. And the top result gets 30% or more of all the search traffic. Where does that leave you? If you don’t take SEO seriously, there’s no way your ecommerce site will beat the competition. If you want to make tens of thousands of extra sales every year, without spending a dime on marketing, listen up. It’s time to boost your ecommerce search traffic. Step 1: Start a blog and produce high-quality content Don’t think you can get away with slapping together a few paragraphs about your latest collection and calling it a blog article. The content gods are watching! In all seriousness, quality content is crucial to ranking on the first page of Google. It’s one of their top 2 ranking factors to determine what to show (the other is backlinks). But what exactly does quality content entail? Let’s hear it from the horse’s mouth: Google's basic principles for high-quality content Make pages primarily for users, not for search engines. Don't deceive your users. Avoid tricks intended to improve search engine rankings. A good rule of thumb is whether you'd feel comfortable explaining what you've done to a website that competes with you, or to a Google employee. Another useful test is to ask, 'Does this help my users? Would I do this if search engines didn't exist?' Think about what makes your website unique, valuable, or engaging. Make your website stand out from others in your field. In a nutshell, Google wants you to focus on providing value to your readers with every blog article. Producing high-quality, long-form content (at least 1,500 words) is the key to ecommerce content marketing and pleasing the search gods. Pro Tip: Not sure what kind of blog articles to produce? As a general rule of thumb, steer clear from anything that’s too obvious and salesy (eg. 5 Shoes From Our Latest Collection That You’ll Love). Instead of this, try to produce content that’s useful to your customers (eg. How To Maintain Leather Shoes: A Comprehensive Guide). With these less salesy articles, you can still include links and call to actions for readers to shop your products after they’re done reading the article. As an added bonus, these articles can help you rank for keywords which your product and category pages can’t (such as 'how to maintain leather shoes'). Step 2: Fix your on-page SEO On-page SEO refers to elements which you can optimise within your website (off-page SEO, on the other hand, deals with external links and other factors). Image from FlightMedia.co With on-page SEO, the first thing you need to do is select the keywords you want to target. Once you’ve got your keywords in mind, optimize your title, header tags, content, image alt texts, and metadata for each page and post on your website. If this sounds like Greek to you, don’t stress. Here’s a step by step guide which will take you through the entire process. Pro Tip:Only target one keyword per page to increase your chances. However, it’s always a good idea to include LSI keywords! [subscribe] Step 3: Add internal links to your most important pages By adding internal links (links from one page on your site to another page on your site), you’re helping Google to understand the relationship between the different pages and posts on your ecommerce site. The more internal links a specific page or post on your website has, the more 'important' it is deemed by Google. Think of your website as a pyramid, with the most important content - your 'cornerstone' content - at the top. You should be linking from your cornerstone content to other related pages in order to pass on link value to them. At the same time, link to these cornerstone pages from other pages in order to bolster their standing. Want to learn more about internal links? Check out this article. Step 4: Build external links Once your internal links are done, it’s time to move on to building external links. You might need to invest some budget into this, but since Google has confirmed that external links are amongst the top 3 ranking factors, I’d say it’s definitely worth your while. First, look for influencers in your industry and reach out to them to enquire if they’d be willing to link to your website in exchange for a small fee OR for a partnership. You can use platforms such as Mailshake and VoilaNorbert to speed up the communication process. Another way of getting backlinks is to guest-post on other websites. Whilst this typically takes longer to execute, it’s a great way of building your brand and establishing thought leadership whilst getting more backlinks. Step 5: Consider paid traffic Assuming you’ve completed all the above steps (and you reallllly should!), this doesn’t mean you’ll see results overnight. It’ll take some time (a few months, or even a year) for you to experience a boost in your organic traffic. In the meantime, you can consider 'supplementing' with paid traffic. Image from ThinkDigi.org The two most commonly used channels are Facebook Ads and Google Ads - and there are tons of useful resources online that will teach you all the basics (read this guide for Facebook ads or this guide for Adwords). Alternatively, if you don’t want to handle your ads yourself, you can always outsource them to an expert. Once those ads are running, a full-cycle analytics platform like Littledata is essential to help you optimise your ad spend and connect it to revenue. After all, the idea isn't just to get more traffic, but to get the best kind of traffic and sell to your best type of customer - the kind that's more likely to convert. The truth about ecommerce growth A few parting words. A lot of ecommerce store owners think that as they become more established, they’ll automatically have more people visiting their website. The truth is, word of mouth can only get you so far - and if you’re serious about growing your ecommerce store and increasing your profits, you’ll need to boost your search traffic through SEO and the other methods discussed above. And you'll want to optimise that search traffic by paying attention to specific metrics such as bounce rates from mobile Google search. Do you want to see a nice exponential curve in your search traffic analytics, or are you content to have your traffic flatlining? The sooner you get started, the sooner you’ll be able to snag that highly coveted spot in the first page of Google. I’m rooting for you! Bill Widmer is a content marketing and SEO expert who has worked with many well-known brands like Content Marketing Institute, Social Media Examiner, and SEMrush.
Introducing Report Packs
We're excited to announce that the first automated report packs are live in the app! Each pack contains a curated set of reports proven to help ecommerce businesses scale faster and smarter. Looking for next-gen analytics reporting that doesn't break the bank? We developed report packs to make advanced analytics accessible to every customer - in just the right combination. You can subscribe to an entire pack for one low monthly price. Why we built report packs Call us crazy, but we believe that every ecommerce business should have the tools to automatically transform their Google Analytics data into actionable insights. Otherwise, what's the point of all that tracking? Unlike the reporting features in some other analytics apps, Littledata's reports never sacrifice accuracy for usability, nor the other way around. Put simply: we have no time for fluff. We believe that the most useful analytics can - and must - be both clean and accurate, and we've built the app's reporting functionality around the actual reporting needs of successful ecommerce businesses, based on our experience with enterprise customers, Shopify stores, and some of the biggest charities in the world. Our analysts considered the many setups we’d built for customers on top of the core Littledata app, and the idea for report packs grew out of this work. We found that growth-oriented ecommerce businesses weren't just looking for clutter-free analytics, but the right combinations of reports to guide ad spend, marketing channel priorities, ecommerce site design and customer journeys. As a result, report packs are next-gen reporting with just enough algo-awesomeness to keep the data geeks happy while letting your marketing team focus on actionable insights to increase engagement at every stage of the shopper journey, from first views and clicks to repeat buying behaviour. The first three packs We've launched three report packs to start: a Basics pack, an Ecommerce Performance pack, and a Shopify marketing pack. Basics pack Overview of site performance Sessions and bounce rate by city Sessions by device type Pages where users enter and exit The Basics pack includes four essential reports on site performance and user behaviour. It's a must-have for any ecommerce site with active users, whether you have a ton of conversions or are still growing your shopper base. Ecommerce Performance pack Overview of ecommerce stats Product category performance Number of sessions to make a transaction Number of days until a purchase is made Many Littledata customers use an enhanced ecommerce setup in Google Analytics. With four essential reports on shopping behaviour and store performance, the Ecommerce Performance pack will help you get the most out of that setup and make data-driven decisions for rapid growth. Shopify pack Conversion rate by marketing campaign Conversion rate by marketing channel When users are most likely to buy Shopping behaviour by channel The Shopify pack includes four reports that connect marketing channels with shopping behaviour. Built to give our Shopify app users a pro reporting experience, the pack contains essential analytics for growing a Shopify store through intelligent targeting. Anticipated addition to our reporting feature set Report packs offer high value at a lower price point by automating data collection and presentation based on proven ways to use and interpret Google Analytics data. Even though they're newly launched, they've already become a much-used feature alongside our popular custom reports, which agencies and large ecommerce stores use to dig deeper into marketing channels and user behaviour specific to their site design and business models. We recommend starting with one report pack and then adding more packs and custom reports to fit your needs. Subscribe to a report pack today to lock in an early-bird discount and start making better-informed marketing and product decisions. New to Littledata? Sign up for a free analytics account. PS. Our developers are hard at work on a number of new report packs, including packs for enhanced ecommerce, ReCharge subscription businesses, email marketing, Facebook ad performance, and more. Subscribe to this blog for the latest updates.
How to see shopping behaviour for each product you sell (VIDEO)
Product performance can seem confusing, but it doesn't have to be. In this quick video, we show you how to use Google Analytics to see shopping behaviour related to each product you're selling. All you'll need to see this report is a site connected to Google Analytics with the Enhanced Ecommerce plugin setup. [embed]https://www.youtube.com/watch?v=YVGAdHTkw3s[/embed] Using the Shopping Behavior report in Google Analytics Whether your ecommerce site is large or small, the Shopping Behavior report makes it easy to drill deep into user behaviour to understand why some products are converting better than others. If a particular product isn't selling well, the Shopping Behavior report will help you figure out why. It shows how far shoppers engage with your products, from initial list views through to shopping cart activities. [subscribe] Reasons a product might not be selling well It isn't at an optimal place in a product list or display The product details, such as images and description, aren't sending the right message Customers are abandoning their shopping carts completely, or removing that particular product (or group of products, such as multiple pairs of jeans) after adding it Who knows? You haven't audited your Google Analytics setup lately so your customer behaviour data can't be trusted to help you improve Each of those issues requires different actions, sometimes by entirely different departments (ie. marketing, pricing, ux)! That's what makes the Shopping Behavior report so important for improving ecommerce sales and conversions. We hope you enjoyed this latest video in our series of Google Analytics how-to guides. Need help setting up Enhanced Ecommerce in Google Analytics, or ensuring that your data is accurate? Contact a Littledata consultant today.
5 (bad) reasons not to do a Google Analytics audit
Does this sound familiar? 'We know our data's bad, but we don't have the time or resources to fix it'. Or, even worse: 'I checked a bunch of other metrics and they didn't justify our current ad spend, so I think I'll just present that same old report at the meeting today...again. Luckily we haven't fixed our Google Analytics setup to track too much relevant data about other marketing channels, or to connect those channels directly to revenue, because then we might need to change our whole strategy!' There's still a lot of confusion out there about the role and scope of an analytics audit. With a free audit tool directly in the app, Littledata is on a mission to change this. Here are some (slightly exaggerated) versions of common objections to doing an analytics audit, and how to overcome them. 1. You don't know what a Google Analytics audit is Okay, not to start this somewhat ironic post with an entirely un-ironic objection, but not understanding the process is probably the only good reason not to audit your analytics setup. Luckily an analytics audit is actually very straightforward: it's simply a check of your analytics configuration and implementation. Some consultants and last-gen apps can make the audit process seem confusing and disorienting. If that's been your experience, we're here to help. Our free Google Analytics audit tool explains the process in real time. Not only that, but many tracking and reporting issues can be fixed automatically by the app (hello, intelligent algorithm!). 2. You don't believe in marketing ROI There are a lot of fluffy tools out there. Google Analytics isn't one of them. It's not that all digital marketers take action based on analytics, but a majority of the top ones do. That's what makes them the best. If you need convincing that accurate data is the secret sauce behind higher marketing ROI (return on investment), check out the recent Google Analytics research with Econsultancy, where they found that '60% of leading marketers routinely take action based on analytics, and are also 48% more likely than mainstream marketers to say their strategy is strongly data-driven'. 3. You trust everything you read online Failing to audit your analytics setup is basically the same as believing that everything you read online is true, no matter the source. Why? Because bad data produces bad reports. This is true no matter how fancy your reporting templates might be, or how much time you've spent making spreadsheets of Google Analytics data look accessible. Unless you regularly audit your analytics setup, how do you know if you're tracking the right things in the right manner? This is especially true if you're using an otherwise awesome ecommerce platform like Shopify, which has notoriously questionable tracking that also happens to be easy to fix with the right analytics app. [subscribe] 4. You think that the customer is always wrong Customer happiness isn't just a buzzword, it's increasingly what's driving the growth and expansion of online businesses, especially in the ecommerce space. Big players like Amazon learned this early on, and they built an effective - and addictive - customer experience around heaps of data on everything from affiliate ads to repeat buying activity. Think you don't have access to those same tools? Think again. If you want to build a better customer experience, it's essential to start with the correct Google Analytics setup and end the guessing games about where your leads and customers come from, and how they act. That's where the audit comes in. 5. You're betting on failure Are you betting that your own company will fail? Unless you secretly run an ecommerce hedge fund and have shorted your own startup, this is probably a bad idea. Auditing your data tracking across the customer life cycle is a sure way to see what's working, what's not, and what can be improved. Otherwise you're stuck with bad data and revenue tracking that might not have much to do with the reality - or the future - of your online business. Is there a better way? Look, we get it. Change can be scary, but choosing to stay stuck in the same data rut isn't the way forward. We've helped over a thousand online businesses fix their Google Analytics setup to capture accurate, relevant data. Littledata's industry-leading automated audit tool is free to run as often as you'd like. Sign up today and start trusting your data.
How to set up Site Search tracking in Google Analytics (VIDEO)
What are visitors searching for on your website? Watch this quick video to learn how to set up Site Search tracking in Google Analytics. Site Search makes it easy to track search activity on your site. In the video we show you how to: Set up Site Search for a web property connected to your Google Analytics account Understand which query parameters you're using, and apply them to your Site Search setup View the resulting search metrics, including visits with search, total unique searches, specific search terms (what web visitors are searching for), and search depth Tracking on-site search terms is surprisingly easy! All you'll need to get started is a Google Analytics account and a search box on your site. [embed]https://www.youtube.com/watch?v=OlsMBWFt5aQ[/embed] What are visitors searching for on your site? On-site search is one of the things we scan for with our free Google Analytics audit tool. Many online businesses forget to add this to their Google Analytics setup, focusing instead on external search data such as that from Google AdWords (or ignoring search activity altogether!), but this is a mistake. Capturing on-site search terms is essential for any online business that that is serious about growth. Understanding what web visitors are searching for - and how that leads to deep engagement with your site or app - can help you improve site UX (user experience), develop product offerings which your customers are already hungry for, and get a higher ROI from product marketing campaigns and ad spend. For more details on the Site Search feature and how to identify search query parameters, check out the Google Analytics help guide. Still have questions? The Littledata team is always here to help. You can contact us directly in the app, or feel free to connect with our Google Analytics consultants for larger projects. [subscribe] Hint: Use search-related benchmarks to find out how your on-site search traffic compares with other sites in your industry and location. The Littledata app includes analytics benchmarks to make this as easy as possible. For example, you can compare usage of internal search on your website against internal search usage on all websites. Once you've set up Site Search, you will automatically be able to see relevant search-related benchmarks in your Littledata dashboard.
Custom reporting for marketing agencies
Are you a digital marketing agency looking for new reporting solutions? As our agency partnerships continue to grow, we thought it would be useful to outline how Littledata's custom reporting helps forward-thinking agencies cut down on reporting time, visualise data and improve performance for their clients. The marketing landscape is complex, but your reporting doesn't have to be overly complicated. With such a wide range of channels and sites to track, many agencies struggle to find the best analytics tools. To you we say: Welcome, you've finally found a solution that both simplifies and enhances the reporting process. Smarter reporting and accurate analytics Do you produce regular campaign performance reports in Excel or Google Sheets for your clients? Have you rejected other reporting solutions as being too rigid or complex for your needs? Then Littledata’s custom reports could work well for you and your clients. We automate the data fetching and calculations you currently run manually, and display the results to clients in a streamlined web app. We'll even show you the most important metrics, and report on key changes - automatically. One key advantage over tools such as Tableau, Data Studio or Chartio is that you can define a template report and then roll it out for many different web properties (or segments of websites) with the click of a button. Compared with other solutions you may have considered we also offer: Full support in data setup, report design and client onboarding Branded report packs for your clients and customers Complete life cycle data on your clients' customers, from marketing attribution to repeat purchases (including for subscription-based businesses) 1st line support to end users Flexibility to calculate any metrics (using Google Sheets in our processing pipeline) Comparison to industry benchmarks for sales, marketing and web performance - or create private benchmarks amongst your own client base Actionable insights for any online business to improve marketing ROI and increase conversions, whether one large ecommerce site or a series of micro-sites Integration of Google Analytics with Google Search Console data for powerful SEO reports [subscribe] We’re also open to discussions about white-labelling the Littledata app. This type of partnership works best for agencies with at least 20 clients ready to take advantage of our intelligent analytics tools. Please contact us if you’d like a demo, to see how this has worked for existing customers, or to discuss a particular client’s needs. Get ready to love your 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