PowerMetrics and data reconciliation

We've redesigned our reconciliation strategy. When you make fundamental changes to a data source, for example, updating a value for a past date or removing columns in a spreadsheet, our new strategy ensures your instant and custom metrics automatically update to align with the data source changes.

This article includes:

How reconciliation used to work

Metrics could auto-update but it depended on when the data source changes occurred and the type of data service that was being used. Most services had a reconciliation window of 2 days but this varied.

If you made a change to a data source that was being used for a metric, and the change occurred in the last two days of the previously successful data ingestion (the reconciliation window) then the metric would update based on the changes you made. If the data source changes occurred before the reconciliation window ( > 2 days) then the metric would not reflect the changes. When this happened, you had to manually update the metric by either creating a new metric or by editing the existing metric and deleting and replacing its stored historical data.

How reconciliation works now

No more worrying about data service imposed reconciliation limits! Our new strategy moves past those limitations to ensure changes in your data are automatically transmitted to your metrics.

How do we do it? When we refresh your metrics, we compare the entire existing data for the metric with the current refresh window to detect any changes in your data. If there are changes, we ingest the differences and your metrics are automatically updated to match the current information in the data source.

Note: Our new reconciliation strategy applies to all instant and custom metrics that were added to your account starting on April 1, 2022 (the release date of our new strategy).

Can I reset my older metrics to use the new reconciliation strategy?

As mentioned above, the new reconciliation strategy took effect on April 1, 2022. If you want to apply it to metrics that were created prior to that date, you can edit the metric and choose the "Delete and replace data" option. Go here to learn more.

Why didn’t my metric update?

When doing comparisons to reconcile your metric, we divide the refreshed data by day. If you change your data source by removing an entire day of data, we won’t have anything to compare to so that day will be ignored and data for that day will not be removed from the metric.

However, if you remove a row of hourly data, for example, you remove a row for April 29 @ 7:00 PM, that change will be recognized and your metric will be updated. This is because the data on April 29th is being grouped together. When the row for 7:00 PM is removed and we do a comparison, we detect the difference and account for it in your metric.

Have more questions? Submit a request