No Data in Reports

Problem

Your charts in Looker Studio or Google Sheets show:

No data

Or your report displays empty results instead of the expected metrics and data.

Why This Happens

There are three main reasons why reports show no data:

1. Date Range Has No Data: The report's date range doesn't contain any data for that metric
2. Wrong Account Connected: You connected the wrong account or a different platform than expected
3. API Error: The data platform is returning an error or the API is temporarily unavailable

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 Reports

1. Open your Google Sheets report
2. Check the date range filter at the top of the sheet
3. Change the date range to a longer period or dates further in the past
4. Click Refresh to reload the data
5. Check if data appears

Example: If your ad campaign started on January 15th, but your report filters for January 1-10, you'll see no data.

For Looker Studio Reports

1. Open your Looker 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 will auto-refresh with new data

Common Date Range Issues

• Future Dates: You set a date range for dates that haven't occurred yet
• No Activity Period: The date range covers a time when there was no activity (paused campaigns, off-season, etc.)
• Different Timezone: The platform may use a different timezone than your report

Solution 2: Verify the Correct Account Is Connected

Ensure you're connected to the right account.

Step 1: Identify the Expected Data Source

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

Step 2: Check Your Data Source

1. Open Two Minute Reports
2. Navigate to Data Sources
3. Find the data source used in your report
4. Click Edit to view the account details
5. Verify it shows the correct account/page ID

Step 3: Verify Account Activity

Log directly into the platform to confirm the account has data:

• Log into Facebook Ads/Facebook Insights and check page activity
• Log into Google Ads and verify campaigns are running
• Log into Google Analytics and check website traffic

Step 4: Reconnect If Wrong Account

If you've connected the wrong account:

1. In Two Minute Reports, click Edit on the data source
2. Click Authenticate or Re-authenticate
3. Log into the correct account
4. Grant permissions when prompted
5. Return to your report and refresh

See Token Expiration and Authentication for detailed re-authentication steps.

Solution 3: Wait and Refresh (API Delays)

Sometimes platforms experience temporary errors or delays in returning data.

What to Do

1. Wait 5-10 minutes: API errors are often temporary
2. Refresh Your Report: Click the refresh button in Google Sheets or Looker Studio
3. Check System Status: Some platforms publish status pages:

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

4. Try Again: If a platform was experiencing issues, give it time to recover

Scheduled Reports

If a scheduled report is not updating:

1. It may be failing due to a temporary API issue
2. Check the data source status to see if there were any errors
3. Trigger a manual refresh to see if it recovers
4. If failures persist, you may need to re-authenticate the data source

Prevention Strategies

Verify Date Ranges Proactively

• Set up a date range filter that auto-updates (last 30 days, last 90 days, etc.)
• This ensures you always see recent data, even if you forget to update the range

Use Multiple Data Points

• 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

Document Your Setup

• Note which platform each data source connects to
• Record the account ID or page ID
• Document when you expect data to appear (campaign launch dates, etc.)

Troubleshooting Checklist

• ✓ Date range includes dates with expected activity?
• ✓ Correct data source connected to the report?
• ✓ Data source shows as "Connected" in Two Minute Reports?
• ✓ Account has activity in that date range (verified by logging into platform directly)?
• ✓ Data source doesn't have any authentication errors or warnings?
• ✓ Tried refreshing the report?
• ✓ Waited a few minutes for API recovery?

Still Seeing 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. Verify that the platform account has activity for that date range (logged in directly)
4. Note which data source is connected
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.