Re: Query to get All visits from an Ad, and orders made through an Ad.
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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/GbKOd0QZ89NB00c4BEOaiCQMqSpZdGP06cEg%40sfdc.net.
Re: Query to get All visits from an Ad, and orders made through an Ad.
My campaigns are active but i get 0 for all orders. Although the dashboard does show 11 purchase_conversions. On Tuesday, February 2, 2021 at 2:25:59 AM UTC+5 Google Ads API Forum Advisor Prod wrote: > 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 > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/0d478745-c1dc-4067-b771-353372de99ddn%40googlegroups.com.
Re: Query to get All visits from an Ad, and orders made through an Ad.
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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/QZR0l0QNVCUS009H2tUegtRv2tFnugHLAEUA%40sfdc.net.
Re: Query to get All visits from an Ad, and orders made through an Ad.
Any upate in this inquiry? El miércoles, 20 de enero de 2021 a las 21:44:52 UTC-6, adsapiforumadvisor escribió: > 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. > > > Best regards, > > [image: Google Logo] > Peter Laurence Napa Oliquino > Google Ads API Team > > > ref:_00D1U1174p._5004Q2B1eb1:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/3b019fc8-9a81-45ce-a61a-6cd0767a430fn%40googlegroups.com.
Re: Query to get All visits from an Ad, and orders made through an Ad.
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. Best regards, Peter Laurence Napa Oliquino Google Ads API Team ref:_00D1U1174p._5004Q2B1eb1:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/Q2ZFz0QN9MEB00IfzTWDvtTQGvyR98BVWKhA%40sfdc.net.
Re: Query to get All visits from an Ad, and orders made through an Ad.
Hi, sorry for the delay,
I wans't sure to answer, since the Reply privately to author option appears
disabled to me, menaing i will be showing private info, but i need an
answer, so it seems that i need to answer to all. The customer ID i'm using
is: 9117658864, and i'm not sure how to check the request ID, the full Log
is:
[2021-01-20 10:12:36,553 - INFO] Request
---
Method: /google.ads.googleads.v6.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com:443
Headers: {
"developer-token": "REDACTED",
"login-customer-id": "2302183531",
"x-goog-api-client": "gl-python/3.8.5 grpc/1.33.2 gax/1.23.0 gapic/8.0.0",
"x-goog-request-params": "customer_id=9117658864"
}
Request: customer_id: "9117658864"
query: "\nSELECT\n campaign.id,\n
campaign.name,\n
customer.conversion_tracking_setting.conversion_tracking_id,\n
metrics.interactions,\n metrics.clicks,\n
metrics.conversions,\n metrics.impressions,\n
metrics.average_cpc,\n metrics.all_conversions,\n
metrics.all_conversions_from_order,\n
metrics.all_conversions_from_store_visit\nFROM campaign\n
WHERE campaign.resource_name =
\"customers/9117658864/campaigns/11898883393\"\n"
Response
---
Headers: {
"google.ads.googleads.v6.errors.googleadsfailure-bin":
"\n\u0002\n\u0002(1\u0012\u0002Cannot 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.",
"grpc-status-details-bin": "\b\u0003\u0012%Request contains an invalid
argument.\u001a\u0003\nCtype.googleapis.com/google.ads.googleads.v6.errors.GoogleAdsFailure\u0012\u0002\n\u0002\n\u0002(1\u0012\u0002Cannot
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.",
"request-id": "kBglceyXnXkc7aLfXB6CFQ"
}
Fault: errors {
error_code {
query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE
}
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."
}
[2021-01-20 10:12:36,553 - WARNING] Request made: ClientCustomerId:
9117658864, Host: googleads.googleapis.com:443, Method:
/google.ads.googleads.v6.services.GoogleAdsService/SearchStream, RequestId:
kBglceyXnXkc7aLfXB6CFQ, IsFault: True, FaultMessage: 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.
Traceback (most recent call last):
File
"C:\Users\papuc\Documents\Dev\environments\GServices\lib\site-packages\google\ads\google_ads\interceptors\exception_interceptor.py",
line 92, in __next__
return next(self._underlay_call)
File
"C:\Users\papuc\Documents\Dev\environments\GServices\lib\site-packages\grpc\_channel.py",
line 416, in __next__
return self._next()
File
"C:\Users\papuc\Documents\Dev\environments\GServices\lib\site-packages\grpc\_channel.py",
line 620, in _next
return self._next_response()
File
"C:\Users\papuc\Documents\Dev\environments\GServices\lib\site-packages\grpc\_channel.py",
line 607, in _next_response
raise self
grpc._channel._SingleThreadedRendezvous: <_SingleThreadedRendezvous of RPC
that terminated with:
status = StatusCode.INVALID_ARGUMENT
details = "Request contains an invalid argument."
debug_error_string =
"{"created":"@1611159156.31500","description":"Error received from peer
ipv6:[2607:f8b0:4012:801::200a]:443","file":"src/core/lib/surface/call.cc","file_line":1062,"grpc_message":"Request
contains an invalid argument.","grpc_status":3}"
>
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files\Python38\lib\runpy.py", line 194, in
_run_module_as_main
return _run_code(code, main_globals, None,
File "C:\Program Files\Python38\lib\runpy.py", line 87, in _run_code
exec(code, run_globals)
File
"C:\Users\papuc\Documents\Dev\CanastaServerless\Develop\GetCampaign\get_campaign.py",
line 98, in
main(google_ads_client,
RE: Query to get All visits from an Ad, and orders made through an Ad.
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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/jHkod0QN7R2Z00YotvTG1PTSG_voi9MqjRmA%40sfdc.net.
Query to get All visits from an Ad, and orders made through an Ad.
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? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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 on the web visit https://groups.google.com/d/msgid/adwords-api/4f323682-d723-4293-8048-61bbf9a4977bn%40googlegroups.com.
