Google Analytics Advanced Connector - dataset showing multiple rows per Month

nicangelica
nicangelica Member
edited June 2021 in Connectors

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

  • nicangelica
    nicangelica Member
    edited June 2021

    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.