Missing Data in Google Sheets Report
This article will assist with the following issue:
A Google Sheets report is missing data or does not show enough data for a date range.
Cause
Power My Analytics' Google Sheets connector defaults to a 1,000 row limit.
Solution
Check the sidebar under Options. The row limit can be increased up to 1,000,000.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Google Sheets Data Integration Guide
Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...How to Connect a Google Sheets Report to Looker Studio
In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations. ...Error: Missing Google Ads Scopes
When creating a report using your Google Ads account in Power My Analytics, you may encounter an error message stating "Missing Google Ads Scopes." This guide will help you understand the cause of this error and provide step-by-step instructions to ...Google Sheets Error: "Exception: Service Timed Out: Spreadsheets" or "Service Spreadsheets timed out when accessing document"
When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter a timeout error that prevents your reports from refreshing. This guide will help you understand the cause of this error and provide a straightforward solution ...Unable to Schedule Refresh in Google Sheets
This article will address the following error: Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value." Cause Google Sheets requires you to set a Time Zone. Additionally, you must be a member of the report's hub in order to ...