How and When Metrics and Datasets Update

In general, metrics will only refresh when they're active, meaning that the dashboard is currently being viewed in a browser or app. The refresh interval of the metrics will affect how often the data is updated while that metric is active.

Active Metrics

A Metric is active and will update when:

  • Editing the metric and clicking Get Data from the Data tab of the Metric Builder.
  • Selecting Refresh in the dashboard action menu.
  • The dashboard is open on a computer and the metric hits its refresh interval even when using the Share URL.
  • A PDF report or a Slack post is scheduled to be sent. Before it is sent, Grow will update those metrics.
  • Opening the dashboard in the mobile app.
  • Pulling to refresh in the mobile app.

Note: When editing a metric, the Metric Builder will keep a 5-minute, short-term cache where we will not fetch new data even if you hit the Get Data button, unless you change the parameters. The exceptions to this are file-based data sources (Google Sheets, Dropbox, etc.). These will refresh the data each time you click the Get Data button.

Metric Update Frequency

You can see when each metric last updated from the dashboard by hovering your mouse over the metric or clicking the info button at the top right:

when-updated-hover.pngwhen-updated-info-button.png

Or in Expanded View by clicking the Details button at the top left:

metric-refreshed-exp-view.png

Understanding Metric Updates

All the metrics on a dashboard get queued up for a data refresh when a dashboard is active. This is indicated by the blue bar at the top of each metric. The fewer metrics you have on a dashboard, the quicker it updates.

Each metric will update the data used report by report. Grow pulls from the data source, which can be one of three different sources.

  1. Directly from the API
  2. From a dataset
  3. From a Warehoused Table

Using the Data Connection/API

If a report is tied directly to an API (using the data connection) it will fetch data from that software application.

Using a Dataset

When a report is using a dataset, it will trigger that dataset to update, using the same logic as when a metric updates, report by report. Additionally, Datasets have their own refresh intervals and are active when a metric built from it is being actively viewed.

If one dataset is used across multiple metrics on a dashboard, it will be updated once and update those metrics more quickly. So it is best to build metrics from common datasets.

If you nest datasets, each dataset has to update before the metric at the top layer updates. For example, if Report 1 in the metric is a dataset that contains a different dataset as one of its reports, then that second dataset will have to update before the dataset in Report 1 will update, then the other reports will update for the metric. The more nested datasets you have on a metric, the longer it will take to update the metric.

Using Warehoused Tables

When a report uses a Warehoused Table, it pulls whatever data is stored there. Warehoused Tables have their own refresh interval and keep your data up-to-date behind the scenes on that regular cadence. Each time a Warehoused Table finishes syncing (works only for Full Sync and not for Incremental Sync), all the datasets that are retrieve data from it are also refreshed.

Note that even then, the metrics that depend on those datasets won't update until they become Active.

Examples of How Metrics Update

The metric is set to update on a 15-minute refresh, with Report 1 using a dataset with a 1-hour refresh interval.

Every 15 minutes the metric will use the data in the dataset for Report 1. After an hour passes and the metric hits its next refresh interval, it will cause the dataset to refresh and pull the latest data for report 1.

The metric is set to update on a 15-minute refresh, with Report 1 using a data connection and Report 2 is a dataset set with a 1-hour refresh interval.

Every 15 minutes the metric will pull the latest data from the API for Report 1, and will use the data in the dataset for Report 2. After an hour passes and the metric hits its next refresh interval, it will update Report 1 the same way and it will cause the dataset to refresh and pull the latest data for report 2.

Troubleshooting

When it appears that some metrics are not updating, here are some questions to consider before contacting support:

  1. When was the last time you looked at the dashboard?
  2. Is it currently updating? (Do you see the blue bar at the top of any metrics?) Did you give it enough time to actually refresh?
  3. Does it have an error icon on the metric? (The yellow triangle at the bottom left of the metric.)
  4. Did you try to refresh the whole dashboard?
  5. Did you edit the metric to see if the data settings & transforms show any errors?
  6. In the Metric Builder did you try hitting Get Data to refresh the data?
Was this article helpful?