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
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive