UNDER DEVELOPMENT
OCTOBOARD
TARIFAS
INICIAR SESSÃO
TESTE GRATUITO
TESTE GRATUITO

GALERIA DE DASHBOARDS E RELATÓRIOS

Selecione a sua aplicação preferida na nuvem e crie o seu primeiro dashboard de Redes sociais ou Desempenho comercial.
TODOS OS DASHBOARDS
RETORNA / DASHBOARDS / GOOGLE SHEETS

GOOGLE SHEETS DASHBOARD

Google Sheets data in your business and marketing dashboards.

Octoboard data dashboard: Google sheets dashboard
With Octoboard you can easily connect to any Google Sheets document and display data in a form of graph, pie chart, table. Once you point us to the Google Sheets document we will start pulling data automatically.

We offer an extensive set of features that will allow you easily connect and transform your data. Octoboard supports the following data types:

  • Single numeric value displays (with optional historic value tracking)
  • Data ranges - data displayed in graphs
  • Category data - pie charts, tables and funnels.
Sugestões
Turn on "Track historic data" feature and we will start keeping track of your data changes over time. Define frequency of updates and we will build historic bar, line and area graphs from a single data cell in the Google Sheets document.

As always, you can use "Compare" feature to see how your current data period compares to older data.
Notas
To connect to a Google Sheets document, provide your standard Google login and select the document you want to pull data from.
932
EXPERIMENTAR AGORA
Última revisão:
24-Mar-19
Intervalo predefinido:
90 dias
Atualizações:
Por hora para planos Premium

GOOGLE SHEETS MÉTRICAS

How do I connect to Google Sheets documents in Octoboard?
Connection to your documents is very straightforward. You can use our wizard to go through 3 simple steps from Google account login to data selection for your widgets. The following paragraphs cover each step in more detail.
OCTOBOARD dashboards, templates and reports gallery: Google sheet wizard configure data point
UTILIZAR ESTA MÉTRICA

STEP 1 - CONNECTING TO GOOGLE SHEETS

Descrição
To access the wizard do the following:

  • Press "ADD METRIC" button in the dashboard panel
  • Select "CUSTOM DATA" tab in the wizard
  • Select "GOOGLE SHEETS" panel as shown on the left
OCTOBOARD dashboards, templates and reports gallery: Google sheets wizard configure document
UTILIZAR ESTA MÉTRICA

STEP 2 - SELECTING DOCUMENT

Descrição
In this step you will specify what document to use for data display.

  • Select existing account or press "ADD ACCOUNT"
  • To add an account provide your Google account login details
  • Once you connect to account - select a Google Sheets document from the list below

Image on the left shows the document selection panel of the wizard.
OCTOBOARD dashboards, templates and reports gallery: Google sheets wizard configuration cells
UTILIZAR ESTA MÉTRICA

STEP 3 - SELECTING DATA FOR DISPLAY

Descrição
Once you have selected Google Sheets document, Octoboard will display its content. In this step you can specify the following:

  • Select type of data to display - single value, historic data, category data
  • Select data values the correspond to selected data type

With Octoboard you can select "Single value" and enable "Track historic changes". With historic data tracking enable we can display changes over time in a graph even for "Single value" data type.

We cover configuration parameters for each data type in the following sections.
What Google Sheets data types and visualisation does Octoboard support?
We support 3 different data types: Single values (with or without historical data changes) that is most suitable for numeric presentation; Value range - ideal for showing data series in graphs with dates along X axis; and Key-value pairs or "categories" - for data presented in tables or pie charts. For each data type a number of visualisations are possible - all discussed in the sections below.
OCTOBOARD dashboards, templates and reports gallery: Google sheets configuration single value
UTILIZAR ESTA MÉTRICA

SINGLE NUMERIC VALUE

Single value data for numeric displays (with or without historic data changes tracking)
Descrição
Single value data is a single numeric value read from a single Google Sheet cell. If we do not enable historic data changes tracking, the following visualisation types are possible for the single value data type:

  • Number with delta - you can specify time frame for delta calculation
  • Number or Gauge with target value - you can set target value in widget panel

You can select historic data tracking. If this feature is enabled, Octoboard will start tracking data changes and building timeline graphs automatically. The following visualisation types will become available in that case:

  • Line graph
  • Bar graph
  • Area graph

Once you have selected Single Value data, you can pick 1 value cell from the Google Sheets document to read data from. Make sure you select Data Sheet to read data from and define data cell either using your our or by typing cell reference in the edit box provided ("A1", "B4" etc).

You can select hourly or daily frequency of data updates. It will define how often Octoboard will try to connect to your document and re-read data value for dashboard display.
OCTOBOARD dashboards, templates and reports gallery: Google sheets configuration value range
UTILIZAR ESTA MÉTRICA

VALUE RANGE

Value range for display in data graphs
Descrição
In order to display a series of values in line, bar or area graph, your data should be stored "vertically" in your Google Sheets document, i.e. data should be stored in columns - one column for DATES and one column for VALUES.

  • DATES COLUMN - holds calendar dates for display in X axis on graphs
  • VALUES COLUMN - holds numeric values to display on Y axis in graphs

You can pick data ranges using your mouse or by entering columns manually in edit boxes provided. Once you have selected data ranges you can pick one of the following visualisation types:

  • Line graph
  • Bar graph
  • Area graph

You can also opt to show the last value of the data range. Octoboard will automatically detect data changes and display delta between last value and value before last. Pick one of the following data visualisation types for displaying last value:

  • Number with delta - delta will be calculated by comparing last two values
  • Number or Gauge with target value - you can set target value in widget panel

You can also specify how frequently you want Octoboard to connect to your Google Sheets document by setting daily (default) or hourly update frequency.
OCTOBOARD dashboards, templates and reports gallery: Google sheets configuration key value pair
UTILIZAR ESTA MÉTRICA

KEY-VALUE PAIRS

Value pairs or categories for pie charts and tables
Descrição
Key-value pairs is the type of data represented by keys (text values) and values (numeric values). They are sometimes called "category data". To load data you should specify two columns to read information from:

  • Keys - data column that holds texts (or "categories", such as pages of your website, for example)
  • Values - numeric values for each category (number of sessions for website pages)

You can pick keys and values using your mouse or by entering columns manually in edit boxes provided. Once you have selected data ranges you can pick one of the following visualisation types:

  • Pie chart
  • Table
  • Funnel

You can also specify how frequently you want Octoboard to connect to your Google Sheets document by setting daily (default) or hourly update frequency.
How can I access Google Sheet widget configurations?
Google Sheets widgets configuration is straightforward. As described above, you can configure document access, data type, data visualisation. These configurations are accessible through the following interface elements:
OCTOBOARD dashboards, templates and reports gallery: Google sheets dashboard
UTILIZAR ESTA MÉTRICA

WIZARD AND CONFIG PANEL

Data access and data types configuration via wizard and widget configuration panel.
Descrição
You can configure document access, data type and visualisation by invoking wizard and widget configuration panel. Click "ADD METRIC" or select "WIDGET MENU > CONFIG MENU ITEM" respectively to access these features.
OCTOBOARD dashboards, templates and reports gallery: Google sheets change visualisation
UTILIZAR ESTA MÉTRICA

WIZARD SWITCH MENU ITEM

Change widget data visualisation type directly in the dashboard
Descrição
This is the easiest way to change data visualisation. Octoboard know what data type is being displayed and will offer data visualisation options compatible with Google Sheets data being displayed. Go to "WIDGET MENU > SWITCH MENU ITEM" to access the feature.

Os clientes que utilizam o Google Sheets Dashboard
também associaram estas aplicações

Clicar para obter informações...
OCTOBOARD Dashboard Logo: Wordpress.comWordPress.COM
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Wordpress.orgWordPress.ORG
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: DisqusDisqus
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Twitter searchTwitter Search
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Google newsGoogle News
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Rss feedRSS Feed
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: MozMoz
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: AlexaAlexa
#brand-monitoring #blogging
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Google sheetsGoogle Sheets
#web-analytics #marketing-analytics
Clicar para obter informações...
OCTOBOARD Dashboard Logo: YextYext
#brand-monitoring #beta
Clicar para obter informações...
OCTOBOARD Dashboard Logo: BirdeyeBirdEye
#brand-monitoring #beta
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Google my businessGoogle My Business
#brand-monitoring
Clicar para obter informações...
OCTOBOARD Dashboard Logo: Seo auditSEO Audit
#brand-monitoring #web-analytics
Octoboard Logo
SUBSCREVER A NOSSA NEWSLETTERCriamos dashboards de redes sociais e de empresas e plataformas de análise de dados. Obtenha acesso antecipado e atualizações agradavelmente raras por e-mail.
EN
FR
ES
PT
NL
DE
IT
Sociogram - LinkedInSociogram - FacebookSociogram - TwitterSociogram - Google PlusSociogram - VKontakteSociogram - PinterestSociogram - Instagram
Octoboard - Dados para o seu negócioOcto Ltd Logo