Getting Started with Templates
Power My Analytics provides ready-made Data Studio demo templates that let you connect your data and start reporting right away. You can also customize these templates to match your brand and reporting needs.
- Data Studio Demo Template Guide — Learn how to use PMA demo templates, customize them for your needs, and add additional data sources.
- Can I Customize Data 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
Data Studio reports are powered by data sources that connect to your PMA hub. Understanding how these connectors work and how to manage them is essential for a smooth reporting experience.
- Understanding How Data Studio Connectors Are Assigned to Power My Analytics Accounts — Learn how PMA matches your active Google browser session to your PMA account when creating Data Studio connectors, and why email address alignment matters.
- How to Reconnect a Data Source in Data Studio — Reconnecting the data source should always be the first thing you try when receiving unexplained data errors on your report.
- How to Connect a Google Sheets Report to Data Studio — Guide for connecting Google Sheets reports created with the PMA Spreadsheets Addon directly to Data Studio.
- How to Avoid Duplicate Reports in Data 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
Data Studio gives you control over how your PMA data is structured and displayed. This section covers field configuration, data blending, and calculated fields.
- Change Field Type in Data Studio — Access and modify field types in your Data Studio connector configuration through the Resource menu.
- All Fields Are Dimensions in Data Studio Configuration Screen — Explains why all fields may display as dimensions (green) rather than color-coded metrics and dimensions after a Data Studio data modeling update.
- Data Studio Blending Super Guide — Comprehensive guide to blending data from multiple sources, covering join types, calculated fields in blends, and troubleshooting common blending issues.
- Troubleshooting Calculated Fields in Data Studio — Identify and fix common calculated field errors, including the most frequent issue of missing parentheses.
- 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
Once your Data Studio report is ready, you may need to share it with clients or export it for distribution.
- Export a Data Studio Report to PDF — Instructions for downloading your Data Studio reports as PDF files, with notes on limitations regarding paginated results and visibility boundaries.
- Transfer Ownership of a Data Studio Report — Step-by-step instructions for transferring report ownership to another user, including domain matching limitations.
Understanding Totals and Summary Rows
Grand totals and summary rows in Data Studio can sometimes display unexpected values. These articles explain why and how to work around these behaviors.
- Data 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.
- Data 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.
- Incorrect Summary Row Whenever Filter Is Applied — Incorrect summary row data for Unique fields when filters are applied is a known Data Studio and Google Sheets issue.
Troubleshooting Errors
If you are encountering error messages in your Data Studio reports, start by clicking the wrench icon or "See details" link on the error to find the specific error details. These articles address the most common Data Studio errors.
- Data 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.
- 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.
- Community Connector Error: Authorization Error— Resolve authorization errors that occur when connecting to PMA data sources in Data Studio.
- Community Connector Error: Conflicting Selections in Connector Configuration — Address errors caused by selecting incompatible configuration options in your report.
- Community Connector Error: Current Combination of Data Breakdown Columns Is Invalid — Fix invalid data breakdown column combinations.
- Community Connector Error: Service Invoked Too Many Times for One Day — Address rate-limiting errors when reports query PMA data sources too frequently.
- Community Connector Error: The data source API took longer than the 60 second Google Sheets or Data Studio timeout — Troubleshoot timeout errors caused by large data requests or slow API responses.
- 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.
- 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.
- 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.
- Connector Error: Can't Mix and Match Fields from Different Tables — Address errors caused by combining fields from different report tables.
- Connector Error: Please click 'REFRESH AUTHENTICATION' and reauthenticate with Power My Analytics — Resolve expired authentication by disconnecting and reconnecting your data sources.