Magento Business Intelligence Help Center

Understanding the "Last successful update began" field

BROUGHT TO YOU BY:

Avatar

You may be curious what the "Last successful update began" field is inside your Integrations page:

Last_successful_update.png

What does the timestamp in this field mean? 

It shows the start timestamp (in the timezone set on your account) of the last successful update cycle on your account. Note that:

  • If any of the synced tables encountered an issue during the last update cycle, this timestamp is not updated.  
  • Hence, there may be cases when reports have been updated with fresh data, but the "Last successful update began" is still lagging.

How can the "real" last data point be identified? 

The latest data point for a particular integration is determined by the Last Data Point Received timestamp located on the right of each integration. That timestamp refers to the last point at which your data warehouse successfully received data points from that source, whether it be a database, API, or third-party integration. 

To check for freshness of data from specific tables, we recommend creating a quick SQL report that performs a MAX(timestamp) on the most important table on your account. Comparing this timestamp to the "Last Data Point" will indicate whether the issue affected the entire account or a subset of the tables. We recommend doing this for 3-4 important, commonly used tables. 

  • If the MAX(timestamp) values are more recent than Last Data Point Received, it means that a subset of the tables were affected, but the overall account's update cycle is stable. 
  • If the MAX(timestamp) values are equal to or before Last Data Point Received, it means that the account's update cycle was affected. In this situation, please reach out to support@rjmetrics.com.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk