Missing Data in Google Sheets Report

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 ...
    • Manage and Configure Data Sources

      Power My Analytics has updated the Sources page to make it easier to manage, configure, and monitor your connected data sources. This article will explain the features of the Sources section in your PMA hub and how to use it to manage your data ...
    • 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 ...