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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 55 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive