Google Analytics Advanced Connector - dataset showing multiple rows per Month
I have datasets with Month of Year selected as dimension from Google Analytics Advanced Connector and I noticed that some of my datasets are producing multiple rows per month while some do not. When summing up the values, they do add up to the total except for averaged columns (i.e. Avg. Page Load Time, Avg. Session Duration, etc.). To add, I use the Filter option to filter only specific pages for some of my datasets. But regardless if there are Filters or not, datasets are still producing multiple rows.
Here's my sample dataset with multiple rows per month:
Does it have something to do with my selected metrics/dimensions/Date Range? Or does it have something to do with my Filters? Any insight would be helpful. Thanks!
Answers
-
Update:
I did some testing by combining metrics in separate datasets by combining metrics together. It seems that when there are Filters applied in the connector settings and User is selected from the metrics, the rows are being broken down into multiple rows based on those filter conditions.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive