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.



    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. ...
      • Installing the Power My Analytics Add-on for Google Sheets

        If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...
      • Missing or Delayed Data in Google Business Profile

        This article will address the following issue: Up to 4 days of data are missing or delayed in Google Business Profile. Cause This is a known feature of the Google Business Profile API. Data can be delayed by up to 4 days. If more than 4 days of data ...
      • Error: Missing Google Analytics Scopes

        This article will address the following error: Missing Google Analytics Scopes Cause You may receive this error when connecting to a Google Analytics account. It is a result of insufficient permissions granted to Power My Analytics. Solution Step 1: ...