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 :)

If you're tracking multiple sites or apps in Google Analytics, you can connect all of these views to your Littledata account and easily switch between them. Watch this quick video to learn how to add or remove a Google Analytics data source in the Littledata app. [embed]https://www.youtube.com/watch?v=xoISTTx1zlw[/embed] FAQs - Working with multiple Google Analytics views How do Littledata reports link to Google Analytics views? When you click to set up another site you will see a list of all the Google Analytics properties and views linked to your Google account. Typically you will only be interested in one of the views, which contains data for the site or app you are working on. When you select a view, Littledata fetches the data it needs to enable core features such as our intelligent Google Analytics audit and industry benchmarking. Note that this doesn't commit you to purchase anything. The underlying data in your Google Analytics account is not affected unless you opt-in to our automated fixes, which let you automatically fix particular aspects of your Google Analytics setup. [subscribe] How many websites or apps can I track? You can set up standard reporting for as many websites as you like. However, if you're using Littledata's Pro services for advanced custom reporting, this is priced per view or data source. You can switch between these sites using the drop-down menu in the top bar. Does your reporting work with mobile app properties? Right now, some of the features will work - such as dashboards, alerts and buyer personas - but audit and benchmarking are specifically for websites. How do I add or remove a site? Once you've connected multiple web properties to your Littledata account, you can manage them using the My Sites page under the profile photo drop-down menu in the upper right. Can Littledata handle micro-sites? Yes. If each micro-site have it's own Google Analytics view, then go ahead and connect them all to your Littledata account. If the micro-sites are all under one web view, then ask the Littledata team about custom solutions to create a multi-site dashboard that lets you visualise Google Analytics data from many micro-sites and benchmark against each other. We have done this for a range of customers and are happy to discuss the details of what is involved in reporting on multiple micro-sites, whether just a few or several hundred!

Last night we gave a live demo of the Littledata app at TechHub London's Tuesday demo night. It's always exciting to share Littledata with other entrepreneurs and business owners, and to get their feedback about Google Analytics issues (everybody has some!). But in this post I'm putting our app aside for a moment in order to share some thoughts on the other company demos from the event. After all, isn't sharing feedback and ideas what the TechHub community is all about? My Film Buzz MyFilmBuzz is an early stage mobile app – launched eight weeks ago with 150 users. The user interface is really intuitive; making use of great visuals from movies and Tinder-style swiping to rate movies. The commercial problem is competing with established players like Rotten Tomatoes with big established audiences. Can a better interface tempt film viewers away? HeathClub TV HeathClub TV offers personalised training videos and exercises, selling via personal trainers who create their own profile and packages. A bit like Udemy for personal training courses, the trainers take a cut of the course fees. Again personal fitness is a very competitive market – the founder said one competitor spent £1.5m on their first version mobile app. I’ve personally enjoyed the 8-fit mobile app, with a similar mix of video exercises but without the marketplace for trainers to produce content. It will be interesting to see if the user generated content model wins out in this market. Trevor.io Trevor helps companies visualise data sources from their own business, such as SQL databases. The user interface makes a good job of simplifying a complex task, switching between table and graph views. As a data geek, I love it! We thought about a similar product in the early stages of Littledata, so my big question is: how many users have the analytical knowledge to create the data integrations, but aren’t comfortable using SQL or similar. At Littledata, most of our analysts progress to coding, because it makes them quicker to do the analysis – but then we are an unusually techy company. Grocemania Grocemania allows customers to place orders from local retailers, charging a small delivery fee (£2.50) and small minimum order (£10) subsidised by 15% commission from the retailers. They have launched a pilot in Surrey with nine retailers. The strategy seems to be to undercut other delivery companies, with lower delivery costs from freelancers and passing stock control onto the retailers. The presenters got a groan for highlighting how they reduce employment costs, but my real concern is how they can profitably undercut companies like Amazon who are ruthless pros at retail and delivery. [subscribe] Worksheet Systems Similar to Trevor, Worksheet Systems aims to solve the problem of storing lots of data in interconnected spreadsheets. Their idea is to split the user interface and database inherent in a complex spreadsheet, and present as a kind of Google Sheet – rather than the customer building an actual database. It looks really powerful, but I wasn't clear what it can do that Google Sheets doesn’t; we use Sheets for lots of smaller ‘databases’ in Littledata, and it’s both simple and powerful. Crowd.Science Crowdfunding for scientific projects, helping scientists raise money from individual donations, business sponsorship and charitable trusts. They take 5 – 10% commission of the money raised. It seems like a great model: crowdfunding is well proven in other areas, and some scientific projects have real public benefit. As the trustee of a grant-giving trust, I know the way we find projects is fairly inefficient, so this platform would be a great benefit as it takes off. Realisable Realisable is an Extract, Transform and Load (ETL) tool, with a visual business rules editor to transform a data source. Their live demo uses a job to transform unshipped orders from Shopify into a format that can be exporting to an accounting package, adding a customer ID to the transactions. I investigated this market in 2016, and there are some very big companies in the ETL market. Many of their products suck - a great opportunity - but there are ones with better user interfaces like Stitch Data. Talking to the founders afterwards, their strategy is to dominate a channel (in their case, Sage consultants); I know this has really worked for another ETL tool, Matillion for Amazon RedShift. Conclusion What’s my favourite idea (outside of Littledata)? Crowd.Science has the biggest potential commercially I think, but I do love Trevor’s product.

This week we're excited to introduce Buyer Personas, a game-changing new feature for marketers and ecommerce teams that are serious about hacking growth at a major scale. Do you know which types of customers are most likely to convert? Gathering customer data is one thing, but turning it into actionable insights is another. We've found that Littledata users are often struggling to find the exact differences between web visitors that buy and those that don't buy, especially when it comes to particular marketing channels. Littledata's new Buyer Personas feature automatically generates user personas based on your particular Google Analytics ecommerce setup or conversion goals, making it easier than ever to target your marketing and on-site content at those shoppers most likely to engage, convert, and grow with your online business in the long term. For example, if you know that users who arrive on your site on the weekend, in the afternoon are more likely to buy, then you should allocate more of your budget to those times. Or if users on tablets are most likely to convert, then target campaigns and ad formats most relevant for that screen size. [subscribe] Accurate Data If you have a decent Google Analytics setup it is possible to look at how different attributes of the user (age, browsing device, time of visit, etc.) affect their likelihood of converting. The better the data setup for your 'people analytics', the more detailed the report can be – when's the last time you audited your website's Google Analytics setup? Buyers or Users? We’re calling the new feature Buyer Personas since this is often requested by retail customers, but it is equally relevant if you have another conversion goal (eg. registrations, event bookings). In all of these cases, your customers are essentially 'buying in' to your product or service. You can switch the conversion metric at the bottom of the Buyer Personas page in the app. Marketing Channels Buyer personas give you actionable insights on particular channels, such as paid search, while also improving your overall understanding of your ideal customer base. The feedback is split out by channel so you can action it more easily: how you would re-organise your paid search marketing is very different to how you re-target your email marketing, but both are needed. The reality is that most smaller websites won’t have any of the ideal people of their site. We are not saying that only that exact profile will convert but that, by targeting the marketing on those who convert most easily, you can improve your return on investment. Pick the category with the biggest potential audience first. The first iteration of the new feature is live in the app this week. We look forward to hearing your feedback! Note that to generate Buyer Personas, you will need an active conversion goal or ecommerce tracking setup, and a minimum of 50 conversions in the previous month. Don't have a Littledata account yet? Sign up today to fix your Google Analytics setup for free and start generating buyer personas.

Google Analytics is a free Web analytics service that provides statistics and basic analytical tools for search engine optimisation (SEO) and marketing purposes. The service is available to anyone with a Google account. As a person that’s at the beginning and trying to get familiar with the field of analytics and data, it’s definitely important to understand how Google Analytics works. There are four components that come together and make Google Analytics work: 1. Collection 2. Processing 3. Configuration 4. Reporting Collection: Data can be collected from different sources, such as a website, a mobile application or pretty much any device that has a connection to the internet. For a website, in order to collect the information, we need to include a Tracking code (JavaScript). This code should be included on every single page of the website in order for Google Analytics to capture the information properly. The JavaScript that we get from Google is okay, but don’t forget that it tracks a limited amount of information. If you are active in a niche field of work, you might want to take a look at adapting that code in order to track the correct data. For a mobile application, we need to use a specific software development kit (SDK), depending on the operating system. In this case, activities will be tracked instead of pageviews. Because we might not always have an internet connection available, the hits will be stored and sent to afterwards to Google’s collection centres. Processing + Configuration: The processing step is the one that takes the longest to finish. It can take anywhere up to 4 hours (24 hours in Google's T&Cs) to turn all the raw data into reports that you are able to interpret and monitor. This doesn’t happen easily, but the only way you can skip the queue is by paying for Google Analytics 360. In Google Analytics, the configuration part comes in and it applies certain filters to the data that is collected. While some of those filters (new or returning users, linking between pages and time spent on certain pages) are pre-configured, you also have the possibility to apply some filters of your own to this process. Remember that you will not be able to change that information once it is stored in the database. Reporting: The final step what the users get to see. By using Google Analytics' own interface, you have access to all the processed information and this is the place where you can manage it from. There is also the possibility of using different applications by creating a custom code in the reporting API. Here is a short list of benefits that you will gain after using Google Analytics: 1. Visitor Segmentation: New vs Returning users, Geographical location and referral source. 2. Page visits: Finding out which pages are the most visited. 3. Locating the website: Finding out how the users got to your website and tracking the keywords they used. 4. Website optimization If you'd like some more information, please get in touch or leave a comment below! Get Social! Follow us on LinkedIn, Twitter, and Facebook and keep up-to-date with our Google Analytics insights.

Websites and apps typically gather a huge flow of user behaviour data, from tools such as Google Analytics and Adobe Analytics, with which to better target their marketing and product development. The company assumes that either: Having a smart web analyst or online marketer skim through the reports daily will enable management to keep tabs on what is going well and what aspects are not Recruiting a ‘data science’ team, and giving them access to the raw user event data, will surface one-off insights into what types of customers can be targeted with which promotions Having worked in a dozen such companies, I think both assumptions are flawed. Humans are not good at spotting interesting trends, yet for all but the highest scale web businesses, the problem is not really a ‘big data’ challenge. For a mid-sized business, the problem is best framed as, how do you extract regular, easy-to-absorb knowledge from an incomplete online behavioural data set, and how do you present / visualise the insight in such a way that digital managers can act on that insight? Littledata is meeting the challenge by building software to allow digital managers to step up the DIKW pyramid. The DIKW theory holds that there are 4 levels of content the human mind can comprehend: Data: the raw inputs; e.g. the individual signals that user A clicked on button B at a certain time when visiting from a certain IP address Information: provides answers to "who", "what", "where", and "when" questions Knowledge: the selection and synthesis of information to answer “how” questions Wisdom: the extrapolation or interpretation of this knowledge to answer “why” questions Information is what Google Analytics excels at providing an endless variety of charts and tables to query on mass the individual events. Yet in the traditional company process, it needs a human analyst to sift through those reports to spot problems or trends and yield genuine knowledge. And this role requires huge tolerance for processing boring, insignificant data – and massive analytical rigour to spot the few, often tiny, changes. Guess what? Computers are much better at the information processing part when given the right questions to ask – questions which are pretty standard in the web analytics domain. So Littledata is extending the machine capability up the pyramid, allowing human analysts to focus on wisdom and creativity – which artificial intelligence is still far from replicating. In the case of some simpler insights, such as bounce rates for email traffic, our existing software is already capable of reporting back a plain-English fact. Here’s the ‘information’ as presented by Google Analytics (GA). And here is the one statistically significant result you might draw from that information: Yet for more subtle or diverse changes, we need to generate new ways to visualise the information to make it actionable. Here are two examples of charts in GA which are notoriously difficult to interpret. Both are trying to answer interesting questions: 1. How do users typically flow through my website? 2. How does my marketing channel mix contribute to purchasing? Neither yields an answer to the “how” question easily! Beyond that, we think there is huge scope to link business strategy more closely to web analytics. A visualisation which could combine a business’ sales targets with the current web conversion data, and with benchmarks of how users on similar sites behave, would give managers real-time feedback on how likely they were to outperform. That all adds up to a greater value than even the best data scientist in the world could bring. Have any questions? Comment below or get in touch with our team of experts! Want the easier to understand reports? Sign up!   Get Social! Follow us on LinkedIn, Twitter, and Facebook and keep up-to-date with our Google Analytics insights.

If the lack of consistency between Shopify’s dashboards and the audience numbers in Google Analytics is confusing, you might conclude that it’s safer to trust Shopify. There is a problem with the reliability of transaction volumes in Google Analytics (something which can be fixed with Littledata’s app) - but using Shopify’s reports alone to guide your marketing is ignoring the power that has led Google Analytics to become over by over 80% of large retailers. Last-click attribution Let’s imagine your shoe store runs a Google AdWords campaign for ‘blue suede shoes’. Shopify allows you to see how many visits or sales were attributed to that particular campaign, by looking at UTM ‘blue suede shoes’. However, this is only capturing those visitors who clicked on the advert and in the same web session, purchased the product. So if the visitor, in fact, went off to check prices elsewhere, or was just researching the product options, and comes back a few hours later to buy they won’t be attributed to that campaign. The campaign reports in Shopify are all-or-nothing – the campaign or channel sending the ‘last-click’ is credited with 100% of the sale, and any other previous campaigns the same customer saw is given nothing. Multi-channel attribution Google Analytics, by contrast, has the ability for multi-channel attribution. You can choose an ‘attribution model’ (such as giving all campaigns before a purchase equal credit) and see how much one campaign contributed to overall sales. Most online marketing can now be divided into ‘prospecting’ and ‘retargeting’; the former is to introduce the brand to a new audience, and the latter is to deliberately retarget ads at an engaged audience. Prospecting ads – and Google AdWords or Facebook Ads are often used that way – will usually not be the last click, and so will be under-rated in the standard Shopify reports. So why not just use the analytics reports directly in Google AdWords, Facebook Business, Twitter Ads etc.? Consistent comparison The problem is that all these different tools (and especially Facebook) have different ways of attributing sales to their platform – usually being as generous as possible to their own adverting platform. You need a single view, where you can compare the contribution of each traffic source – including organic search, marketing emails and referrals from other sites – in a consistent way. Unfortunately, Google Analytics needs some special setup to do that for Shopify. For example, if the customer is redirected via a payment gateway or a 3D secure page before completing the transaction then the sale will be attributed to a ‘referral’ from the bank - not the original campaign. Return on Advertising Spend (ROAS) Once you iron out the marketing attribution glitches using our app, you can make meaningful decisions about whether a particular form of marketing is driving more revenue that it is costing you – whether there is a positive Return on Advertising Spend. The advertising cost is automatically imported when you link Adwords to Google Analytics, but for other sources, you will need to upload cost data manually or use a tool like funnel.io . Then Google Analytics uniquely allows you to decide if a particular campaign is bringing more revenue than it is costing and, on a relative basis, where are the best channels to deploy your budget. Conclusion Shopify’s dashboards give you a simple daily overview of sales and products sold, but if you are spending more than hundreds of dollars a month on online advertising – or investing in SEO tactics – you need a more sophisticated way to measure success. Want more information on how we will help improve your Shopify analytics? Get in touch with our experts! Interested in joining the list to start a free trial? Sign up! Get Social! Follow us on LinkedIn, Twitter, and Facebook and keep up-to-date with our Google Analytics insights.

Stop using vanity metrics to measure your website's performance! The pros are using 5 detailed metrics in the customer conversion journey to measure and improve. Pageviews or time-on-site are bad ways to measure visitor engagement. Your visitors could view a lot of pages, yet be unable to find the right product, or seem to spend a long time on site, but be confused about the shipping rates. Here are the 5 better metrics, and how they help you improve your Shopify store: 1. Product list click-through rate Of the products viewed in a list or category page, how many click through to see the product details? Products need good images, naming and pricing to even get considered by your visitors. If a product has a low click-through rate, relative to other products in the list, then you know either the image, title or price is wrong. Like-wise, products with very high list click-through, but low purchases, may be hidden gems that you could promote on your homepage and recommended lists to increase revenue. If traffic from a particular campaign or keyword has a low click-through rate overall, then the marketing message may be a bad match with the products offered – similar to having a high bounce rate. 2. Add-to-cart rate Of the product details viewed, how many products were added to the cart? If visitors to your store normally land straight on the product details page, or you have a low number of SKUs, then the add-to-cart rate is more useful. A low add-to-cart rate could be caused by uncompetitive pricing, a weak product description, or issues with the detailed features of the product. Obviously, it will also drop if you have limited variants (sizes or colours) in stock. Again, it’s worth looking at whether particular marketing campaigns have lower add-to-cart rates, as it means that particular audience just isn’t interested in your product. 3. Cart to Checkout rate Number of checkout processes started, divided by the number of sessions where a product is added to cart A low rate may indicate that customers are shopping around for products – they add to cart, but then go to check a similar product on another site. It could also mean customers are unclear about shipping or return options before they decide to pay. Is the rate especially low for customers from a particular country, or products with unusual shipping costs? 4. Checkout conversion rate Number of visitors paying for their cart, divided by those that start the process Shopify provides a standard checkout process, optimised for ease of transaction, but the conversion rate can still vary between sites, depending on payment options and desire. Put simply: if your product is a must-have, customers will jump through any hoops to complete the checkout. Yet for impulse purchases, or luxury items, any tiny flaws in the checkout experience will reduce conversion. Is the checkout conversion worse for particular geographies? It could be that shipping or payment options are worrying users. Does using an order coupon or voucher at checkout increase the conversion rate? With Littledata’s app you can split out the checkout steps to decide if the issue is shipping or payment. 5. Refund rate Percent of transactions refunded Refunds are a growing issue for all ecommerce but especially fashion retail. You legally have to honour refunds, but are you taking them into account in your marketing analysis? If your refund rate is high, and you base your return on advertising spend on gross sales (before refunds), then you risk burning cash on promoting to customers who just return the product. The refund rate is also essential for merchandising: aside from quality issues, was an often-refunded product badly described or promoted on the site, leading to false expectations? Conclusion If you’re not finding it easy to get a clear picture of these 5 steps, we're in the process of developing Littledata’s new Shopify app. You can join the list to be the first to get a free trial! We ensure all of the above metrics are accurate in Google Analytics, and the outliers can then be analysed in our Pro reports. You can also benchmark your store performance against stores in similar sectors, to decide if there are tweaks to the store template or promotions you need to make. Have more questions? Comment below or get in touch with our lovely team of Google Analytics experts!   Get Social! Follow us on LinkedIn, Twitter, and Facebook and keep up-to-date with our Google Analytics insights.