I’ve implemented *Custom Conversion Variables* (e.g., tag: store_location) for website conversions. In the Google Ads UI I can segment under *Segments → Conversions → Custom variables* and see values as expected.
I’m trying to get the same breakdown programmatically—ideally via *BigQuery Data Transfer (Custom report with GAQL)*, or otherwise via the *Google Ads API*—but I can’t find GAQL fields that expose the custom variable *name/value* as segments. What I’ve tried (v21): 1. Works (no custom-variable segment): SELECT segments.date, campaign.id, campaign.name, segments.conversion_action, segments.conversion_action_name, metrics.conversions, metrics.conversions_value FROM campaign WHERE segments.date BETWEEN '2025-08-01' AND '2025-08-31' ORDER BY segments.date, campaign.id 2. Fails when I try to add custom-variable segments (examples I attempted): ..., segments.conversion_custom_variable, segments.conversion_custom_variable_value FROM campaign Validator errors: - 'segments.conversion_custom_variable' is not a valid field in the SELECT clause when 'campaign' is the resource in the FROM clause. - 'segments.conversion_custom_variable_value' is not a valid field in the SELECT clause when 'campaign' is the resource in the FROM clause. 3. I can list the variables themselves: SELECT conversion_custom_variable.resource_name, conversion_custom_variable.id, conversion_custom_variable.name, conversion_custom_variable.tag, conversion_custom_variable.status FROM conversion_custom_variable …but I don’t see a way to *segment conversions by those variables* in GAQL. *Goal output (daily):* date, campaign_id, campaign_name, custom_variable_tag, custom_variable_value, conversions, conversions_value (Conversion action name would be a bonus.) Questions: - Is there a GAQL-supported way to segment conversions by *Custom Conversion Variables* (name/value)? - If not currently supported in GAQL/BQ DTS, what’s the recommended programmatic export? (e.g., Google Ads UI scheduled report → Google Sheets → BQ feels like a workaround.) - Any timeline or feature request I can track for exposing this segment via GAQL? Thanks in advance! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/b67beda4-a625-4075-b593-18bd17821e0an%40googlegroups.com.
