I’m working on a solution that will be able to generate one funnel and its steps automatically based on certain criteria. This would be done through the GA4 API on GCP and have the data returned to be rendered on a custom frontend web application.

First I will explain what i try to do:

I am using below to pull GA4 data. But when i am adding certain dimensions like HostName or pagePath, its giving elevated numbers( mostly for users and sessions) than what actual values are, My guess is it calculates duplicates. How to get accurate results ?