Geckoboard

Optimze your spreadsheet data before connecting it to Geckoboard by fetching just the data you need for your metrics.

Prepare your spreadsheet for connecting to Geckoboard

Learn more about the import features of Google Sheets and Excel that can populate spreadsheets connected to Geckoboard.

Learn how Google Sheets' ImportRange function helps import data samples and run calculations in a separate sheet from the source.

Using Google Sheets' query functions you can make all your spreadsheet calculations and aggregations before connecting to Geckoboard.

Using the query function, count the number of occurrences of each unique value in a spreadsheet before connecting to Geckoboard.

By linking GA to your Adwords and AdSense accounts you pair a GA add-on with Spreadsheets to aggregate or manipulate your data.

Geckoboard doesn’t support any sort of modification or calculation of your data, so any changes must be done outside of Geckoboard first.

Set your own refresh interval by writing a script using Google Apps Scripts.

Use Supermetrics to schedule an automatic daily refresh of your data on Google Sheets for use in Geckoboard.

If you want to avoid "No data to visualize" and prefer seeing 0s when your formulas reset, we recommend using IFERROR or ISBLANK.

Need help grappling with bringing your spreadsheet data to life? We'll have you up and running in no time.

Parepare your spreadsheet for Geckoboard by importing data to it, formatting it, performing calculations and reducing errors.