Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Report Data Not Updating

What to do when HubSpot data changes, but your reports still show old data

Date: July 2022


What Happened

  1. We updated data on deals & contacts
  2. The correct information was saved on the records
  3. The correct information was showing up on the deals board, contacts board, and company board
  4. The dashboard reports were not showing the correct updated information (filters were correct)

Solution

Report took about an hour to update with correct information, and was updating with partial correct information over the hour.

We connected with Hubspot, and the support agent was seeing the reports differently (and with updated information) when Denamico was not seeing it correctly.

Why did reports not show the correct data that was shown on the records?

Hubspot uses multiple servers to handle different actions on accounts. There is a records server, and an analytics server. The records server stores real time data for objects, and records of those objects. The analytics server stores a backup of the records server in a format ideal for reporting and data visualization. This is common with software because data visualization and reporting uses a lot of database power, and negatively impacts normal users.

Why did the support agent see the reports differently than Denamico did?

Hubspot and most SAAS companies use multi region data centers. This has multiple benefits.  Multi region servers decrease load times for users by connecting users to their closest geographical server, and multi region servers provide a fall back server in the event the users closest server region goes down. When multi region servers exist, they must also sync data between each other to always keep the most recent data, and provide that data to users in other regions. This sync of data usually happens real time, as fast as the servers can process it (under 1 second). However, this sync can sometimes get delayed due to data center issues at either data center (server needs to restart, data schema got update, etc.) When users in one geographic region are seeing different data than users in another geographic region, this is most likely due to a delayed server sync between regions. Each set of users is still being routed to their local server, but the data is not updated between the servers. In the case above, the records server was up to date in both regions, but the analytics server was not up to date in both regions.