Hi,
Thank you for reaching out to the Google Ads API support team.
Based on the error message, it seems you've passed an invalid argument in the
'WHERE' clause for the 'campaign.start_date' field, which is causing the
BAD_VALUE error. The current query you provided is valid and doesn't include
the 'campaign.start_date' field, so we were unable to identify the issue with
the query that contains the 'campaign.start_date' field. However, you can use
this GAQL query for fetching the overall metrics for your campaign:
SELECT metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc,
metrics.cost_micros,
campaign.start_date, campaign.end_date FROM campaign WHERE campaign.id =
{campaign ID}
If you don't specify any date segments then it will fetch overall metrics of
the campaign from the account. However, you can include the date segments as
per your requirement to retrieve the date wise metrics. I would recommend you
to refer to the 'Date Ranges' documentation for more information. You can use
the search or searchStream methods in making the API calls while retrieving the
data. Additionally, you can utilize the Google Ads Query Builder and Query
Validator to build and validate the queries for retrieving the data from the
Google Ads API.
This message is in relation to case "ref:!00D1U01174p.!5004Q02vFx5A:ref"
(ADR-00267275)
Thanks,
Google Ads API Team
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 on the web visit
https://groups.google.com/d/msgid/adwords-api/O_-Lh000000000000000000000000000000000000000000000SJJTZ800N9250N35S3mqQcGrnnIU0w%40sfdc.net.
