Getting Started with Templates

1. Looker Studio Demo Template Guide — Learn how to use PMA demo templates, customize them for your needs, and add additional data sources.
   
2. Can I Customize Looker Studio Templates? — Instructions for branding your report, customizing themes and layouts, removing unused elements, and adding new charts and data sources.
   

Connecting and Managing Data Sources

1. Understanding How Looker Studio Connectors Are Assigned to Power My Analytics Accounts — Learn how PMA matches your active Google browser session to your PMA account when creating Looker Studio connectors, and why email address alignment matters.
   
2. How to Reconnect a Data Source in Looker Studio — Reconnecting the data source should always be the first thing you try when receiving unexplained data errors on your report.
   
3. How to Connect a Google Sheets Report to Looker Studio — Guide for connecting Google Sheets reports created with the PMA Spreadsheets Addon directly to Looker Studio.
   
4. How to Avoid Duplicate Reports in Looker Studio — Understand how copied reports can become linked to the original, and learn how to prevent and fix duplicate report issues.
   

Working with Fields and Data

1. Change Field Type in Looker Studio — Access and modify field types in your Looker Studio connector configuration through the Resource menu.
   
2. All Fields Are Dimensions in Looker Studio Configuration Screen — Explains why all fields may display as dimensions (green) rather than color-coded metrics and dimensions after a Looker Studio data modeling update.
   
3. Looker Studio Blending Super Guide — Comprehensive guide to blending data from multiple sources, covering join types, calculated fields in blends, and troubleshooting common blending issues.
   
4. Troubleshooting Calculated Fields in Looker Studio — Identify and fix common calculated field errors, including the most frequent issue of missing parentheses.
   
5. Custom or Calculated Fields Show the Wrong Numbers — If your calculated fields are producing inaccurate results, wrapping formulas in the SUM() function typically resolves the issue.
   

Report Sharing and Export

1. Export a Looker Studio Report to PDF — Instructions for downloading your Looker Studio reports as PDF files, with notes on limitations regarding paginated results and visibility boundaries.
   
2. Transfer Ownership of a Looker Studio Report — Step-by-step instructions for transferring report ownership to another user, including domain matching limitations.
   

Understanding Totals and Summary Rows

1. Looker Studio: Grand Total Over a Date Range is Less Than Sum of Individual Rows Broken Out By Date — Unique count fields display de-duplicated grand totals, which will appear lower than the sum of daily rows when users are counted across multiple days.
   
2. Looker Studio Summary Row Errors When Using Filters — Summary rows may display incorrect data when filters are applied. Best practice is to use either filters or summary rows, but not both together.
   
3. Incorrect Summary Row Whenever Filter Is Applied — Incorrect summary row data for Unique fields when filters are applied is a known Looker Studio and Google Sheets issue.
   

Troubleshooting Errors

1. Looker Studio Error: "You are not part of this organization, please check your access token or organization ID" — Fix this error by switching data credentials from Viewer's to Owner's credentials in the resource settings.
   
2. Invalid Field Name Error: The data source associated with this component has invalid characters in its field names — This error requires PMA support assistance and cannot be resolved independently.
   
3. Community Connector Error: Authorization Error— Resolve authorization errors that occur when connecting to PMA data sources in Looker Studio.
   
4. Community Connector Error: Conflicting Selections in Connector Configuration — Address errors caused by selecting incompatible configuration options in your report.
   
5. Community Connector Error: Current Combination of Data Breakdown Columns Is Invalid — Fix invalid data breakdown column combinations.
   
6. Community Connector Error: Service Invoked Too Many Times for One Day — Address rate-limiting errors when reports query PMA data sources too frequently.
   
7. Community Connector Error: The data source API took longer than the 60 second Google Sheets or Looker Studio timeout — Troubleshoot timeout errors caused by large data requests or slow API responses.
   
8. Community Connector Error: There Was an Error Caused by This Connector — A general error that may require reconnecting your data source or contacting PMA support.
   
9. Community Connector Error: This Instagram Account Is Not Connected to a Facebook Page — Fix Instagram reporting errors by ensuring the Instagram account is properly linked to a Facebook Page.
   
10. Community Connector Error: You Must Select a Valid Config when Connecting to the Data Source — Resolve configuration errors that occur when connecting to a PMA data source.
    
11. Connector Error: Can't Mix and Match Fields from Different Tables — Address errors caused by combining fields from different report tables.
    
12. Connector Error: Please click 'REFRESH AUTHENTICATION' and reauthenticate with Power My Analytics — Resolve expired authentication by disconnecting and reconnecting your data sources.