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
When viewing a report in Google Sheets using Power My Analytics' spreadsheets addon, numeric data may appear blank in the spreadsheet. However, the data becomes visible when you click on the affected cell.
Cause
This error can occur due to certain cell formatting being applied to the column. Cell values may disappear, or reappear, when the Power My Analytics spreadsheets addon sidebar refreshes the report.
Solution
Step 1: Identify Affected Columns
- Open your Google Sheets report containing Power My Analytics data. Look for columns where data appears blank but shows when you click on individual cells.
- Select the entire column by clicking on the column header (A, B, C, etc.).
- Go to Format → Number in the menu bar and check the current formatting applied to the column.
Step 2: Apply Correct Formatting
- With the column still selected, choose the appropriate format:
- Number - for metrics like Impressions, Clicks, Sessions
- Currency - for cost and revenue fields
- Percent - for rate fields like CTR, Conversion Rate
- Plain text - for campaign names and other text fields
- The data should immediately become visible in the formatted column.
- Click the refresh icon in the Power My Analytics sidebar to update your data. Verify that all data displays correctly after the refresh.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
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 ...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 ...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 ...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 ...Report a Different Time Zone in Spreadsheets
When reporting your data with our spreadsheets addon, you may want to adjust the date and time reported to account for a timezone offset. This article will show you how to use a formula to adjust the reported date and time in Sheets. Some connectors ...