Data warehousing is how AgencyAnalytics stores your clients' historical data so it can be quickly and reliably pulled into reports and dashboards. Each integration has different rules for sharing data via its API, which can cause discrepancies when you're reporting across multiple integrations over time.

Warehousing solves this by retrieving data more often and more quickly, resulting in shorter load times for client dashboards and reports. In many cases, it also lets AgencyAnalytics provide much more historical data than the integration's API would normally allow.

What this means:

Data warehousing only begins after you've connected a supported integration to a Client in AgencyAnalytics. If you haven't connected the integration yet, you'll need to do that first before any data can be pulled or warehoused.

Not every integration warehouses the same number of days. The table below shows each warehoused integration and the number of historical days of data warehoused (or the number of days first fetched before data layers in).

Once you connect a supported integration to a Client, AgencyAnalytics immediately begins pulling your data. Here's what happens step by step.

Step 1: After you connect the integration, either visit the prebuilt integration dashboard or add widgets using its data. During this initial period, you'll see a message that the integration is initializing.

Step 2: Wait for the initial period to finish. This usually takes 1 to 2 days, while AgencyAnalytics pulls the most recent data from the integration.

Step 3: Once the integration is initialized and the current data is available, AgencyAnalytics starts warehousing historical data. This process takes 4 to 14 days, depending on the amount of data in your connected account and the API data limits for each integration. This is done gradually to avoid hitting API rate or daily limits that could disrupt data flow from the integration.

Step 4: Check how much historical data has been warehoused by visiting the prebuilt integration dashboard and checking the tracker in the upper-right corner.

When a number on your dashboard looks off, it's helpful to know whether AgencyAnalytics is still pulling in new data, everything's synced, and that's simply the correct number, or something's actually gone wrong. The data freshness indicator answers that at a glance, so you don't have to guess or open a support ticket to find out.

You'll find it as a clock icon in the tooltip at the top of your dashboard. Hovering over it tells you, in plain language, the last time your data was fetched, how current it is, and what (if anything) you need to do next.

By default, all warehoused data is encrypted at rest. When possible, we warehouse 365 days of historical data. We backfill from the connected date and then store each new day to ensure up-to-date data is available. Anything older than 1 year will be removed from warehousing.

If an integration disconnects, AgencyAnalytics doesn't automatically delete the warehoused data. This means a brief disconnection won't require the integration to initialize and fetch all 365 days again. Simply reauthorize the connection, and your data will be available again.

Simpli.fi is an exception. While AgencyAnalytics doesn't automatically delete Simpli.fi data, Simpli.fi's API limits the number of days of data that can be pulled at a time. If Simpli.fi remains disconnected for a while, the warehoused data becomes outdated, and it takes time to fetch and update the data after reconnection.

At this time, you can't manually delete your warehoused data. This is to prevent accidental deletions that would disrupt your client reporting. If you'd like your warehoused data deleted, contact our Support team, and they'll start that process for you.

Data freshness indicators apply to warehoused integrations, the ones where AgencyAnalytics stores and syncs your data on a schedule. Integrations with a live API connection already pull data in near real time, so there's nothing new to show for those.

Check the tooltip first, it'll tell you what caused the issue and whether there's an action you can take. If you're not sure what to do next, [contact our support team](https://help.agencyanalytics.com/en/articles/2571116-contact-customer-support) and they can help you sort it out.

It's an estimate based on your local browser time, not an exact schedule. We intentionally keep it approximate rather than promising a precise time.

Not currently. The tooltip is designed to be plain-language, so you won't see error codes, IDs, or internal service names, just what happened and what it means for you.

If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄