What happens to my PowerMetric 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 PowerMetrics to automatically update to align with the data source changes. However, this is not always the case. PowerMetric 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 PowerMetric update?

If you make a change to a data source that's being used for a PowerMetric, and the change occurs in the last two days of the data set (the reconciliation window) then the PowerMetric will update based on the changes you made. If the data source changes occur before the reconciliation window ( > 2 days) then the PowerMetric 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 PowerMetric using the spreadsheet as your source. The next day you notice a mistake in yesterday's numbers and fix it. The PowerMetric 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 PowerMetric and you will need to manually update the PowerMetric (see below). 

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

Why do PowerMetrics work this way?

One of the benefits of PowerMetrics 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 PowerMetric if the change falls within the reconciliation window. To update the data outside of the reconciliation window, you will need to manually update the PowerMetric. (See below.)

How do I manually update my PowerMetric?

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

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