Query to get All visits from an Ad, and orders made through an Ad.

[market test]

Hi, 

I'm trying to get a report with statistic of a campaign, which includes how many visits received the store from an Ad, and how many orders got. Reading the Docs, i found that there are 2 metrics that could get me that info: metrics.all_conversions_from_order and metrics.all_conversions_from_store_visit. I've the ConversionActions created, i've GTag setted on the Frontend, yet, when i try to query that data, i get an error.

This is my Quey:

SELECT

          campaign.id,

          campaign.name,

          customer.conversion_tracking_setting.conversion_tracking_id,

          metrics.interactions,

          metrics.clicks,

          metrics.conversions,

          metrics.impressions,

          metrics.average_cpc,

          metrics.all_conversions,

          metrics.all_conversions_from_order,

          metrics.all_conversions_from_store_visit

        FROM campaign

        WHERE campaign.resource_name = "[resource_name]"

This is the error:

message: "Cannot select or filter on the following metrics: \'all_conversions_from_order\'(could not support requested resources: \'CAMPAIGN\'), \'all_conversions_from_store_visit\'(could not support requested resources: \'CAMPAIGN\'), since metric is incompatible with the resource in the FROM clause or other selected segmenting resources."

I got to communicate with a Google associate to try to solve this, but i only got this info about this problem:

  - It matters which report is specified in the WHERE clause of your query. 

  - These are both segmenting resources in the extension_feed_item report. Metrics.all_conversions_from_order and metrics.all_conversions_from_store_visit apply to feed items only. Use the extension_feed_item report type in the WHERE clause of the query to get these metrics. 

  - Metrics.all_conversions should work fine from campaign report  

But i dind't understood at all how to use extension_feed_item, i tried to change it on the FROM from campaign to extension_feed_item, but it just returned nothing. Does someone knows how to get this data for reporting from a Query?

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out.

So our team can better look into the issue, could you provide your customer ID and the complete request and response logs, along with the request ID?

You can enable logging by referring to this sample guide in Java. If you are using a different client library, their respective logging guides should also be available in the same page.

You may then send the requested details using the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2B1eb1:ref

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for sharing these details.

Allow me to reach out to the rest of our team so we can discuss and investigate further. We'll reach out to you once we have gathered our findings.

[market test]

Any upate in this inquiry?

[Google Ads API Forum Advisor Prod]

Hello - 

It seems that using extension_feed_item in the FROM clause (without metrics.interactions) is the correct solution here. The reason no results are returned from this query is likely because the client account in question is a test account without any active campaigns.

Is there a reason you would expect metrics for conversions to be returned from this account? Perhaps there is a different account you can use that has live campaigns?

Let me know if you have any other questions.

Best,
Ben, Google Ads API Team

ref:_00D1U1174p._5004Q2B1eb1:ref

[Anum Hassan]

My campaigns are active but i get 0 for all orders. Although the dashboard does show 11 purchase_conversions.

[Google Ads API Forum Advisor]

Hi Anum,

Could you clarify which account you're referring to? Is it the test account discussed below, or a different one?

Thanks,

Ben, Google Ads API Team

ref:_00D1U1174p._5004Q2B1eb1:ref