GA4 source connector - YearMonth not working properly (data exported is by date)

  • Is this your first time deploying Airbyte?: No, using it since last year
  • OS Version / Instance: Windowns
  • Deployment: Docker
  • Airbyte Version: Airbyte 0.44.3
  • Source name/version: GA4 - version 0.2.0
  • Destination name/version: BigQuery - version 0.2.3

Custom report, the output does not match with the request.

Json request:
[{“name”: “Customer_retention_monthly”, “dimensions”: [“streamName”,“newVsReturning”,“month”], “metrics”: [“totalUsers”,“activeUsers”]}]

Description of the issue: I export the data for 2 month, so rather than having

  • #month * #stream(5) * TypeOfusers (3) = 2x5x3= 30 lines

I have in the export one line per date (so 60 days) x #streams(5) x typeofUsers(3) = 297 lines where year month is 30 times the same value.

Using the tool I get it right, but with airbyte to big query it is then incorrect :slight_smile: Did anyone else faced this issue before? :slight_smile:

Any help is welcome !