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.

• Related Articles

• Error: Data Appears Blank in Cells in Google Sheets Report

  If your Power My Analytics data appears blank in Google Sheets but becomes visible when you click on the cells, this is likely caused by incorrect column formatting. This article will help you identify and resolve this common formatting issue. Error ...

• How to Reconnect a Disconnected Data Source

  Sometimes a connected account can become disconnected from your Power My Analytics hub, causing errors in reports. This article will show you how to reconnect a disconnected data source in your hub and get your data moving again. What Happens When a ...

• 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 ...

• 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 ...

• 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. ...