Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

GA4 Weekly missing weeks for Total users

Answered
Edison Coronado User

I've tried all of the week dimensions and there seems to be an issue with the all of them, there are missing weeks. I can't find a week dimension that has all of the weeks, there are always some skip. This has to do specifically with the attribute (Total users) and the dimensions (Date) paired with any week dimensions. End-goal: to have a record for each week and the date with the first day of the week and maybe the week number. Thanks!

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Edison,

    Thanks for reaching out. After digging into this, the gaps are coming from how the GA4 API defines weeks, not from Fivetran and I don't think this is something we can solve.

    The yearWeek dimension has known limitations that Google documents here: January 1 is always week 01, weeks start on Sunday, and the first and last weeks of the year can have fewer than 7 days. A week spanning Dec 31/Jan 1 gets split in two: Dec 31 stays in the prior year's last week, Jan 1 starts week 01 of the new year. Fivetran fetches both partial windows and passes them through as-is, so what you're seeing in your destination is what the API actually returned.

    isoYearIsoWeek sidesteps the January 1 issue since it uses ISO 8601: week 1 is the week containing the first Thursday of the year, and weeks start on Monday. But it has its own version of the same problem. The last few days of December can land in week 1 of the next ISO year, and early January days can belong to week 52 or 53 of the prior year. Calendar year and ISO year just don't align cleanly at the edges.

    Neither dimension gives you a contiguous weekly series. That's how the GA4 API works.

    If you need week-over-week data with a real week-start date, the most reliable option is syncing at daily granularity and aggregating in your warehouse with DATE_TRUNC(date, WEEK(MONDAY)). You get full control over how weeks are defined without being tied to GA4's boundary rules. Alternatively, you could access the raw GA4 event data via our Google Analytics 4 Export connector. 

    Hope this helps.

    Luke