Data warehousing is how AgencyAnalytics stores your clients' data so it can be quickly and reliably pulled into dashboards and reports. Instead of asking each integration's API for data every time you open a report, AgencyAnalytics fetches it on a schedule and stores it. 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, do that first.

Some integrations are only partly warehoused. For example, HubSpot web traffic, forms, and email data, as well as Google Local Services Ads cost and call data, are pulled live from the integration rather than being warehoused.

The table below shows how many days of history AgencyAnalytics loads when you first connect each warehoused integration.

For some integrations, such as Yelp Ads, HubSpot, and StackAdapt, stored history keeps growing past this number over time. Others, such as TikTok Ads and Simpli.fi, only show data up to this limit in reports.

Once you connect a supported integration to a Client, AgencyAnalytics begins pulling your data immediately.

Stage 1: Connect the integration, then open its prebuilt integration dashboard or add widgets that use its data. While the first data loads, the widgets display the Initializing window.

Stage 2: AgencyAnalytics loads your most recent days and older history simultaneously. Older history loads backward in batches, so it stays within each integration's API limits. Once some data is in, some widgets can show "Please wait while your data is retrieved...".

This usually takes a few days and can take longer for large accounts or integrations with strict API limits, such as Simpli.fi.

Stage 3: Track loading progress with the status label in the dashboard header. While history is still loading, it shows Loading history and a progress bar. See the next section for details.

Most integrations load data in whole days, based on UTC time. This means:

Shopify orders, HubSpot, and BigCommerce are exceptions and do load part of today's data.

AgencyAnalytics also fetches the last few days again on each sync, so recent numbers can still change as the integration finalizes its data.

The status label shows whether a warehoused integration is up to date.

Step 1: Open a Client, then go to the integration's dashboard.

Step 2: Click the status label in the dashboard header, just to the left of the date picker.

Step 3: Review the details in the popup.

All warehoused data is encrypted at rest by default. For each integration, we load history back to the limit shown in the table above, then store each new day as it comes in so your data stays up to date. Data older than an integration's limit isn't available in your reports.

AgencyAnalytics only pulls data from external platforms. We never push data to them or change it, so your original data sources are never affected.

If an integration only disconnects, your warehoused data isn't deleted. Simply reauthorize the connection and syncing picks up where it left off.

Simpli.fi is an exception. Its API limits how many days can be pulled at a time, so if it stays disconnected for a while, it can take some time to catch up after you reconnect.

Yes, in these cases:

To avoid reloading history, reauthorize an existing connection instead of removing and re-adding it.

You can't manually delete warehoused data. This prevents accidental deletions that could disrupt your client reporting. To request deletion, contact our Support team.

Most integrations load entire days in UTC, so today's data isn't available yet, and yesterday's data can take several hours to arrive. Learn more in When New Data Shows Up above.

AgencyAnalytics fetches the last few days again on each sync, so recent numbers update as the integration finalizes its data.

Data marked as 1 day in the table above is a current or lifetime total, so the date range doesn't filter it.

The status label appears only for warehoused integrations and only on integration dashboards and Client pages. It doesn't appear in reports, PDFs, or custom dashboards.

That's a different warning. It means the integration only keeps the last few days of data, for example, "only retains the last 30 days." It isn't related to the sync status label.

Click the status label and follow the suggested action in the popup. Often this means reauthorizing the connection. AgencyAnalytics will also check again automatically. If it keeps failing, contact our Support team.

It depends on why the data is updating:

The status label uses plain language and doesn't show error codes. If a widget shows an error screen, it includes a Reference ID you can copy. Share that ID with our Support team so they can look into it faster.

No. AgencyAnalytics only reads data from your connected platforms and never writes or changes data in them.

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