How to Create Working Age and Gender Charts
Many of our clients have difficulty creating age and gender charts in their reports. This article will tell you everything you need to know to create a functioning age or gender table with most connectors.
Match [collection] fields
Most demographic data comes in collections. [Collection] fields come in pairs and will have the same names. The Schema Explorer in your Hub can be used to find them.
On some connectors, these are Key/Value pairs where the Key must be set as a dimension and the Value as a metric.
On other connectors, they are labeled as dimensions and metrics.
Do not add fields from different collections
Combining fields from different collections will result in Community Connector Error: Invalid Combination with a Collection.
Related Articles
Community Connector Error: Invalid Combination with a Collection
This article will help to resolve the following community connector errors. Cause This error occurs when two incompatible fields are placed in the same table together. In this example, Total People Who Viewed By Country could not be combined with ...How to Generate a New API Key
Only accounts with a Custom plan (formerly Enterprise) that includes API access can generate API keys. API access is not automatically included in all Custom plans; it depends on the terms of your specific agreement. This article will show you how to ...How to Filter Out Deleted Deals in Hubspot
An API limitation in Hubspot makes it impossible to remove deleted deals from your data set. Follow the instructions in this article to learn how to filter out deals that you no longer want in your reports. Looker Studio Select a chart that contains ...Looker Studio Demo Template Guide
When connecting to Looker Studio, there are a few best practices to keep in mind. From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Demo Power My ...Sign Up for Power My Analytics and Create Your Hub
Ready to streamline your marketing data collection and reporting? This guide will walk you through the process of signing up for Power My Analytics and creating your hub. By the end, you'll be set up and ready to automate your marketing data and ...