Target roas only gives me zero but my target roas is non-zero

[Vinicius Gentile]

I am using this query to get target roas but it always gave me zero

        """

        SELECT

            metrics.clicks,

            metrics.cost_micros,

            metrics.impressions,

            metrics.conversions_value,

            metrics.conversions,

            segments.date,

            campaign.id,

            campaign.name,

            campaign.status,

            campaign_budget.amount_micros,

            campaign.id,

            campaign.advertising_channel_type,

            campaign.target_roas.target_roas

        FROM campaign

        WHERE

            AND metrics.impressions > 0

        """

[Google Ads API Forum Advisor]

Hello,

Welcome to Google Ads API Support team. Thank you for reaching out to us.

Would you be able to share to us the complete request and response logs with request id and request header generated on your end? Kindly also include the screenshot of the data you want to retrieve in UI. Asking this so we can validate and further investigate your concern on our end.

Note that these logs can be requested or provided to the developer handling the Google Ads API transactions when logging of the API requests has been enabled. You may check here (https://developers.google.com/google-ads/api/docs/best-practices/logging#client_library_logging) and click your client library for the specific guideline to enable it.

For REST interface requests, you can enable logging via the curl command by using the -i flag. This will cause the tool to include the HTTP response headers in the output.

Links to the highlighted words above:

• request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
• response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
• request id - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

You may send the requested details privately via “Reply To Author” option. If that option is not available to you, send it directly to googleadsa...@google.com instead, and let us know here once it is provided.

This message is in relation to case "ref:_00D1U1174p._5004Q2lJqgR:ref"

Thanks,
 

Google Ads API Team