What happens to my metric if I make changes to my data source?

When you make fundamental changes to a data source, for example, updating a value for a past date or removing columns in a spreadsheet, you might expect related metrics to automatically update to align with the data source changes. However, this is not always the case. Metric auto-updates are dependent on a couple of factors: when the change occurs in the data source and the type of data service that's being used.

Why didn't my metric update?

If you make a change to a data source that's being used for a metric, and the change occurs in the last two days of the data set (the reconciliation window) then the metric will update based on the changes you made. If the data source changes occur before the reconciliation window ( > 2 days) then the metric will not update with the changes.

Note: Most services have a reconciliation window of 2 days but there are some exceptions, for example, the reconciliation window for Google Analytics is 7 days.

Here's an example: Your spreadsheet includes dates up until today. You create a metric using the spreadsheet as your source. The next day you notice a mistake in yesterday's numbers and fix it. The metric will update accordingly. But, if a week goes by before you notice the mistake and then fix it in your data source, your change will not be picked up by the metric and you will need to manually update the metric (see below). 

Note: Changes to modelled data sources, such as adding or removing columns and changing date formats, also affect associated metrics. For more information, go here.

Why do metrics work this way?

One of the benefits of metrics is that they store data over time, enabling you to see trends in your data. As a result, you will only see changes in a metric if the change falls within the reconciliation window. To update the data outside of the reconciliation window, you will need to manually update the metric. (See below.)

How do I manually update my metric?

There are couple of options, both of which will result in a metric that displays your current, modified data:

  • Create a new metric using the updated data source.
  • Edit your existing metric and choose the Delete and reimport data option. Learn more here.
Have more questions? Submit a request