[ISSUE] Google Ads Query Builder / Validator.

[Steven Jeanne]

Hi, 

I Have an issue with those queries : 

SELECT change_event.changed_fields,
change_event.new_resource,
change_event.old_resource,
change_event.resource_change_operation,
change_event.resource_name,
change_event.change_date_time

FROM change_event WHERE ad_group.id = 17189668520 AND change_event.change_date_time BETWEEN '2021-12-05' AND '2021-12-07'
LIMIT 10000

And 
SELECT change_event.changed_fields,
change_event.new_resource,
change_event.old_resource,
change_event.resource_change_operation,
change_event.resource_name,
change_event.change_date_time

FROM change_event WHERE ad_group.id = 17189668520 AND change_event.change_date_time DURING LAST_30_DAYS
LIMIT 10000

It tells me the query is valid, but when I call it I get an exception message :

{{ "changeEventError": "START_DATE_TOO_OLD" }} 
"The requested start date is too old. It cannot be older than 30 days." 

I suppose the date limit is 30 DAYS NOT INCLUDED.

[Google Ads API Forum Advisor]

Hi Steven,

Thank you for reaching out to the Google Ads API team.

As you’ve mentioned that you’ve encountered an error START_DATE_TOO_OLD usually start_date can not be older than 30 days. To resolve this issue, you can pass start_date as 2021-12-06. Let me know if you have any questions.

Thanks,

Nirmita Patel Google Ads API Team

 

ref:_00D1U1174p._5004Q2TnmL0:ref

[Steven Jeanne]

Hi ! 

That's what I though afterwards. I'm filtering on 29 days now. 

I have another problem, I'm going to do a new post. It's not the same issue.

Thank you

[Google Ads API Forum Advisor]

Hi Steven,

Glad to help you, If you have any additional questions or require further clarification please let us know.