No data in reports

Problem

Your charts in Google Data Studio or Google Sheets show:

No data

Or your report displays empty results instead of the expected metrics and data. A report that comes back full but reads 0 down one whole column is a version of the same problem.

Why this happens

There are five main reasons why reports show no data:

1. The date range has no data: The report's date range has no data for that metric
2. The wrong account is connected: You connected the wrong account, or a different platform than you expected
3. API error: The platform returns an error, or its API is not available for a time
4. A metric is restricted: The connected account's role isn't allowed to see that metric, so the platform returns rows with 0 in those columns instead of an error
5. Your own server refuses us: For MySQL, MariaDB, PostgreSQL, WooCommerce and API Bridge, the data comes from a server you control. If it only accepts allowlisted IP addresses, it refuses Two Minute Reports and the report comes back empty. See Connection Blocked by a Firewall or IP Allowlist

Solution 1: check your date range

The most common reason for no data is that your report's date range has no activity.

For Google Sheets

1. In the Two Minute Reports sidebar, open Data Queries and edit the query.
2. Check the range in Date.
3. Change it to a longer period, or to dates further in the past.
4. Select Run query.
5. Check if data appears.

Example: If your ad campaign started on January 15, but your report shows January 1 to January 10, you see no data.

For Google Data Studio

1. Open your Google Data Studio report
2. Look for the date range control (usually at the top or in the filter bar)
3. Expand the date range or select dates when you know you had activity
4. The report loads the data for the new dates

Common date range problems

• Future dates: You set a date range for dates that haven't occurred yet
• A period with no activity: The date range covers a time when there was no activity (such as paused campaigns or off-season)
• A different time zone: The platform may use a different timezone than your report

Solution 2: check that the correct account is connected

Ensure you're connected to the right account.

Step 1: identify the account that you expect

• Which platform are you pulling from? (such as Facebook Ads or Google Ads)
• Which account or page? (You may have multiple accounts)
• What date range should have data? (When were your campaigns active?)

Step 2: check your connection and accounts

1. In Google Sheets, open Menu › Connections in the sidebar. For Google Data Studio, open Connections & accounts in the Hub.
2. Find the connection that your query or query config uses.
3. Check that its accounts include the correct account or page ID.
4. In Google Sheets, also check the accounts selected in the query. In Google Data Studio, check the accounts in the query config.

Step 3: check the account's activity

Sign in to the platform to confirm that the account has data:

• Sign in to Facebook Ads or Facebook Insights, and check the page activity
• Sign in to Google Ads, and check that campaigns are running
• Sign in to Google Analytics, and check the website traffic

Step 4: reconnect with the correct account

If you connected the wrong account:

1. Edit the connection: select the edit button in the sidebar's Connections, or Reconnect in the Hub.
2. Sign in to the platform with the correct account.
3. Grant the permissions that the platform asks for.
4. Return to your report, and run the query or reload the report.

See Token expiration and authentication for the detailed steps.

Solution 3: wait and try again (API delays)

Sometimes platforms have temporary errors, or are slow to return data.

What to do

1. Wait 5 to 10 minutes: API errors are often temporary.
2. Try again: Run the query again in Google Sheets, or reload the report in Google Data Studio.
3. Check the platform's status: Some platforms publish status pages:

• Google Cloud Status: status.cloud.google.com
• Facebook Status: facebook.statuspage.io

4. Give it time: If a platform had problems, wait for it to recover.

Scheduled refreshes

If a schedule does not update the data:

1. A temporary API problem can make it fail.
2. Check that the connection is active, and that its accounts have no warnings.
3. Run the query by hand to see if it works.
4. If it keeps failing, reconnect the connection.

Solution 4: check for a restricted metric

If the report has rows but one column reads 0 all the way down, the numbers aren't missing. The connected account isn't allowed to see them.

Google Analytics 4

A Google Analytics role can carry a data restriction on top of the role itself: No revenue metrics or No cost metrics. When the Google account that authorized the connection has one, Google Analytics doesn't reject the query. It returns every row and puts 0 in the restricted columns, so sessions, users, and key events match Google Analytics exactly while revenue or cost reads 0 for the same property and date range.

The restriction belongs to the Google account the connection was authorized with, not to the person reading the report. Your own Google Analytics access makes no difference.

See Revenue or cost metrics come back as 0 for the fields each restriction zeroes and the steps an administrator follows in Admin › Account access management or Property access management to clear it.

Prevention

Check date ranges first

• Use a date range that moves with time, such as the last 30 days
• You then see recent data, even if you forget to update the range

Compare metrics

• Create charts with different metrics from the same account
• If one metric shows data and another doesn't, it's likely a date range issue
• If no metrics show data, it's likely an account or API issue

Write down your setup

• Note which platform each connection connects to
• Record the account ID or page ID
• Document when you expect data to appear (such as campaign launch dates)

Troubleshooting checklist

• Does the date range include dates with activity?
• Is the correct account in the query or query config?
• Does the connection show Active in Connections & accounts in the Hub?
• Does the account have activity in that date range? (Check by signing in to the platform.)
• Is the connection free of errors and warnings?
• If a column reads 0 instead of being empty, does the connected account's role restrict that metric?
• Did you run the query or reload the report again?
• Did you wait a few minutes for the API to recover?

Still no data?

If you've gone through all solutions and still see no data:

1. Take a screenshot of your report showing "No data"
2. Note the date range you're using
3. Check that the platform account has activity for that date range (sign in to the platform)
4. Note which connection and account you use
5. Contact [email protected] with:
   • The screenshot
   • The date range used
   • The platform and account ID
   • Confirmation that the account has activity for that period

Our support team can investigate whether it's a data connectivity or platform-specific issue.