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.

Net promoter score. Customer churn rate. Monthly recurring revenue. These are all high-profile customer success metrics, prominently featured in most posts on the topic. There’s no denying these metrics have value – but do they really tell the whole story? Key performance indicators (KPIs) like net promoter score and churn rate tell you if there’s a problem or if your company is doing well overall. But to figure out what to do next, you need to dig a little deeper.

There’s no doubt that your company benefits when employees are actively interested in their work. A recent Gallup survey revealed that highly engaged employees are more productive, have higher customer ratings, and are more likely to stay with the company. The value of employee engagement may seem obvious to you as a manager. Even so, many organizations struggle to keep employees interested in their work. Worldwide, just 15% of employees are engaged.

Geckoboard makes it easy to share your important metrics - whether your team are co-located or remotely distributed around the world. When you all share an office it's simple to put your dashboard up on a TV for everyone to see, but fostering that same culture of transparency and focus can be harder when you’re limited to communicating via Slack, email, and remote meetings.

Importing live data into a Google Sheet or Excel spreadsheet might seem like a daunting task, but it’s easier than you think… If you’re reading this you probably know spreadsheets are a useful way to aggregate, tidy and analyse data. But what you probably don’t know is that with some simple techniques and plugins, any humble spreadsheet can be transformed into an incredibly powerful, automated, data-gathering machine that can save you or your team hours of manual input.