Hi team - I'm having issues with Google Analytics (Universal Analytics), when I try to leverage the Custom Report feature. I can generate a custom report with no issues, up until I start adding goal conversions. This custom report works just fine:

[{"name": "nodus_test", "dimensions": ["ga:date","ga:source","ga:medium","ga:keyword", "ga:campaign", "ga:adContent"], "metrics": ["ga:sessions","ga:transactionRevenue"]}]

But this one generates entirely NULL results:

[{"name": "nodus_ga_customconversions", "dimensions": ["ga:date","ga:source","ga:medium","ga:keyword","ga:campaign","ga:adContent"], "metrics":["ga:sessions","ga:users","ga:goal1Completions","ga:goal2Completions","ga:goal3Completions","ga:goal4Completions","ga:goal5Completions","ga:goal6Completions","ga:goal7Completions","ga:goal8Completions","ga:goal9Completions","ga:goal10Completions","ga:goal11Completions","ga:goal12Completions","ga:transactionRevenue"]}]

Has anyone ever faced this issue? I have been banging my head against this for days, with no luck.

@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2617 to ensure timely resolution!

Hello! If you pull the goals data with Query Explorer, does it return the data correctly?

Hello! If you pull the goals data with Query Explorer, does it return the data correctly?

Hi @Nataly Merezhuk (Airbyte) - I was able to get this working! The primary issues seems to be that if you request a Goal Conversion that hasn't been defined in GA yet, instead of returning NULL values for that column, it makes the full report null. I think it would be worthwhile to update documentation for folks to know that as they're configuring.

Oh thanks for the info, so glad you got it working! I made an issue to add this to the documentation. https://github.com/airbytehq/airbyte/issues/17679