When it comes to running a successful online store there’s a lot to keep track of. From high-level metrics like revenue or number of orders, down to more detailed information such as customer feedback, there simply isn’t one ecommerce analytics tool that covers it all. So as a business owner, how can you oversee all the different parts of your online store without wasting minutes or even hours every time you need to look up some important data?

In 2015, LayerVault, which created version-control software for developers, shut down. Despite appearing, externally at least, to be a healthy startup, the company struggled to find product-market fit and had to close as a result. When LayerVault failed, Kelly Sutton, co-founder of the startup, took stock of what went wrong and what the company might have done differently. One issue that stood out was that they didn’t define and track startup metrics.

As we head into 2021 after possibly one of the strangest and most unsettling years in living memory, we thought it was about time to take stock and reflect on how Geckoboard has changed over the course of the past 12 months. Like many other businesses this year, we have had to adapt not only the way we work but the way our dashboards work for our customers too.

Google Sheets has a built-in function called ImportXML which can be used to scrape publicly available structured data from webpages. ImportXML imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. In this post we’ll show you how to use the ImportXML function to aggregate Pinterest followers from different Pinterest accounts into a Google Sheet, and then visualize that information using Geckoboard’s Spreadsheets data source.

Clubhouse have just released a new Google Sheets integration. If you’re not familiar with Clubhouse it’s a project management tool designed for software teams. We’ve been using it at Geckoboard since 2016 and have never looked back - you can read more about why we switched to Clubhouse from Trello here. The new integration automatically exports all your Clubhouse tickets and accompanying metadata to a spreadsheet.

This is a guest post written by Stuart Cooke, Marketing Manager at Irish Parcels a courier comparison service that helps retailers and ecommerce providers find the best shipping solutions for their products. -- The Covid-19 pandemic has meant businesses around the world have had to close their doors for months, with many left with no choice but to adapt quickly and take their goods or services online.

It’s the end of the month, and you’re preparing to update your team and your manager on the status of your project. You know it’s going well, but you have to show them. How do you share the project’s successes, and any concerns you have, in a quantifiable way? The answer is key performance indicators (KPIs). KPIs measure specific aspects of performance, enabling you to monitor and share progress in a clear, objective way.

It’s the end of the quarter and time to do a health check on your ecommerce business to see how things are going. But you collect data from so many sources—how do you know which ecommerce KPIs (key performance indicators) are the most important? As Laura Moss, co-founder of Adventure Cats, advises, “The sheer number of KPIs you can track can be overwhelming, especially if you're new to ecom or a small business owner like I am.

When setting out to build a dashboard to display key metrics, there are several different approaches you can take - each with their own pros and cons to consider. Here we’ll walk you through some of the most popular approaches to help you decide which type of dashboard will best serve your needs. First though a quick caveat.

In 2020, according to a survey by Owl Labs, nearly 70% of full-time workers in the US are remote. As a result of the pandemic, many teams had to switch to remote work suddenly. They needed to figure out new ways to achieve the teamwork and collaboration they had in an office setting. Buffer’s State of Remote Work survey found that remote workers cited collaboration and communication as one of their biggest struggles.