Product updates

QuickBooks Online and Help Scout data sources

We’ve just shipped two new data sources:

QuickBooks Online: Keep track of a range of invoice metrics from QuickBooks, including sales, amounts due, paid and overdue invoices and more.

Help Scout: Monitor support productivity metrics from your Help Scout mailboxes throughout the day, including first response time, new conversations, closed conversations, resolved conversations, time to resolution and more.

Log in to your account and click ‘Add widget’ to give them a spin!

Intercom beta: more metrics and improvements

We’ve shipped some improvements for our Intercom data source beta, including the ability to use a tag to filter any metric or break it down to show top tags. We’ve also added 10 new metrics like Conversations replied to, Reassigned conversations, Snoozed conversations, Reopened conversations, and more.

Our Product Manager Helena has made a quick video showing some less obvious tricks to getting more out of your Intercom widgets, covering:

• Comparing volume to the same date last week (instead of yesterday)
• Getting hourly data
• Comparing multiple metrics on one chart
• Breaking down metrics with group by and split by

You can check it out here.

Support for Excel files in nested OneDrive folders

If you have an Excel file in Microsoft OneDrive, it’s no longer necessary to move it to the root folder of your OneDrive account in order to use our Spreadsheet data source. Our integration with OneDrive will now allow you to work with Excel files stored in any nested folder within your OneDrive account.

Filters added to our Google Analytics 4 beta

We’ve been working on adding more functionality to the beta of our new Google Analytics 4 data source, and we’re excited to have shipped filters! Now you can dial metrics in by source, medium, campaign, by specific pages or locations, see specific event data, and a whole lot more.

Support for Microsoft SQL Server databases

Our database integration now supports Microsoft SQL Server databases, in addition to our existing support for MySQL, PostgreSQL, and Amazon Redshift databases 🎉.

Intercom data source beta

We’ve shipped a beta of a brand new Intercom integration which includes a whole range of improvements over our existing integration, particularly for support teams.

As well as including new metrics like conversation ratings, first and last close time and assignment times, the new integration also allows you to access historical data; when you connect your Intercom account, Geckoboard will import an initial 31 days of conversation data, which gets added to whilst you have your account connected to Geckoboard.

We’ll be adding more metrics over the coming weeks, but in the meantime, please share any feedback or suggestions you have with the team - we’d love to hear how you get on.

New: Google Analytics 4 data source beta

Now you can visualise data from your Google Analytics 4 properties using our brand new data Google Analytics 4 data source. Our existing Google Analytics data source remains unchanged, but has been renamed to Universal Google Analytics.

Additional metrics and filtering on GA4 metrics is coming soon, but the initial release already includes handy presets for things like new users by medium, new users Vs total users, views per page, engagement time and more.

We’d love to know how you get on - get in touch if you have any feedback to share!

Note: To avoid discrepancies between what you see in GA Vs Geckoboard, please double-check your dashboard’s timezone matches the timezone of your GA property.

Three new data sources - Aircall, Baremetrics and ProfitWell

We’ve quietly added three new data sources to Geckoboard in the past few weeks:

• Aircall: Keep an eye on useful information from your call centre operation in real time, including current agent availability, calls and wait times
• Baremetrics: Share key metrics like MRR, active customers and LTV with your team and investors
• ProfitWell: Get eyes on subscription KPIs like churned, downgraded, upgraded and reactivated MRR, number of customers, and more

All three data sources are currently in beta, and we’re keen to hear your feedback. Log in to your account to give them a try, and let us know what you think.

Our new Shopify data source is out of beta

We’ve been refining our new Shopify data source and are thrilled to bring it out of beta! If you haven’t tried it already, our rewritten integration with Shopify brings:

• More metrics, including sales, orders, orders that have been cancelled, unfulfilled, fulfilled or that are pending, and average order value and more
• New ways to break these metrics out, for example by location, order tag or channel, and now you can compare these on the same visualization
• Easy comparison of today’s performance against previous periods, and the same day last week
• Simpler authentication between Geckoboard and Shopify accounts
• The ability to pull data from multiple Shopify accounts
• And much more!

For more information check out our docs, or give it a spin yourself!

Bring 1000s of new data sources onto your dashboard through Zapier

We’re always expanding the range of data sources you can access in Geckoboard, and today we’re excited to add Zapier to the mix. With over 3000 of their own integrations, connecting Zapier to Geckoboard means you can now visualize and share interesting data from almost anywhere. (See the full range of information Zapier can pull here).

How it works

Our Zapier integration is a little different to our other integrations, and starts with an empty dataset you create in Geckoboard. You’ll then need to log in to Zapier (or create an account), and make a zap that pulls data from your chosen source and then sends it to the dataset you created. Your data can then be visualized, filtered, and aggregated in a variety of ways by clicking Datasets in your Geckoboard account.

For more detailed setup instructions, check out our setup guide!