Error 500 when requesting information about Google Ads campaigns

API & integrations
1

Hello. I am trying to build a report combining data from google ads with other demensions and goals converison.

I am using this columns
{“column_id”: “timestamp”},
{“column_id”: “visitor_session_number”},
{“column_id”: “visitor_id”},
{“column_id”: “device_type”},
{“column_id”: “location_country_name”},
{“column_id”: “session_entry_url”},
{“column_id”: “source_medium”},
{“column_id”: “campaign_name”},
{“column_id”: “google_ads_campaign_name”},
{“column_id”: “campaign_content”},
{“column_id”: “sessions”},
{“column_id”: “goal_conversions”, “goal_uuid”: “a4d14308-782f-497f-b285-4b84ab135540”, “requires_events”: “false”},
{“column_id”: “goal_conversions”, “goal_uuid”: “f1a3efa9-bb01-40e4-91bb-d197dd72044c”, “requires_events”: “false”}

And i get an error 500 Requested query could not be computed (query memory limit)

then i try to reduce the number of columns only for 3 demensions and 3 metrics -

{“column_id”: “timestamp”},
{“column_id”: “visitor_id”},
{“column_id”: “google_ads_campaign_name”},
{“column_id”: “sessions”},
{“column_id”: “goal_conversions”, “goal_uuid”: “a4d14308-782f-497f-b285-4b84ab135540”, “requires_events”: “false”},
{“column_id”: “goal_conversions”, “goal_uuid”: “f1a3efa9-bb01-40e4-91bb-d197dd72044c”, “requires_events”: “false”}

and also get this error. The date interval is only a day.

2

Thanks for reporting the issue. Passed to engineers.