Managing Data Freshness in Looker Studio Dashboards

How Data Freshness Works in Looker Studio

Looker Studio does not store data — it queries your connected data sources in real time when a dashboard loads or when filters change. "Data freshness" refers to two distinct things: (1) how often your underlying data source updates with new data, and (2) how often Looker Studio queries that source vs. serving a cached version.

Data Source Update Frequencies

Each data source has its own refresh schedule outside of Looker Studio:

• Google Analytics 4: Data is available with a 24-48 hour lag for some metrics. Realtime data (last 30 minutes) is available via the Realtime connector, but it shows limited metrics.
• Google Ads: Data is typically available within a few hours. Conversion data may take 24-72 hours to finalize due to conversion windows.
• BigQuery: As fresh as your pipeline makes it — can be real-time with streaming inserts, or batched daily if you use scheduled queries.
• Google Sheets: Updates whenever the sheet is updated — instant if managed manually, or on your script's schedule if automated.

Looker Studio Cache Settings

For each data source in Looker Studio, you can set a cache duration (in the data source edit view). Options range from "None" (no cache — queries run on every page load) to "12 hours." The default is usually 12 hours for most connectors.

For dashboards where data changes daily, a 12-hour cache is appropriate and speeds up load times significantly. For real-time operational dashboards, set cache to "None" but be aware this increases query cost for BigQuery data sources.

Forcing a Cache Refresh

Any dashboard viewer with edit access can force a data refresh by clicking the refresh button in the report toolbar. This bypasses the cache and queries the source immediately. Viewers without edit access see data based on the last cache update.

Displaying Data Freshness to Viewers

Add a text element to your dashboard showing the data lag — for example, "Google Ads data: updated daily by 6am. GA4 data: updated by 9am." This prevents viewers from worrying that "today's" numbers look low — they haven't populated yet.

For BigQuery-backed dashboards, add a "last updated" timestamp by including a max(update_timestamp) field from your data model as a scorecard. Our Looker Studio service handles data freshness architecture for all dashboards we build.