Google Ads API can't pull data older than 90 days?

[Zhisheng Zhou]

Hi. I am trying to pull data(2020-02-01) from click_view, and this is the request:

curl --location --request POST 'https://googleads.googleapis.com/v6/customers/{{customer_id}}/googleAds:search' \

--header 'Authorization: Bearer {{token}}' \

--header 'developer-token: ALkDA5a-bcH2N-mcan-UzQ' \

--header 'Content-Type: application/json' \

--header 'login-customer-id: 785XXXXXXX' \

--data-raw '{

"query": "SELECT customer.descriptive_name,ad_group.id,ad_group.name,ad_group.status,segments.ad_network_type,click_view.area_of_interest.city,click_view.area_of_interest.country,click_view.area_of_interest.metro,click_view.area_of_interest.most_specific,click_view.area_of_interest.region,campaign.id FROM click_view WHERE segments.date = '\''2020-02-01'\''",

"return_total_results_count": "true",

"validate_only": "false"

}'

And I got: 

         "message": "The requested date is too old. It cannot be older than 90 days."

Is there a way to get data older than 90 days plz?

Best,

Zhisheng

[Google Ads API Forum Advisor Prod]

Hello Zhisheng,

As stated in the click_view document, queries including ClickView must have a filter limiting the results to one day and can be requested for dates back to 90 days before the time of the request.

Regards,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2BeIHB:ref

[Zhisheng Zhou]

Thanks! What we can do if we need history date(older than 90 days)?

Best,

Zhisheng

[Google Ads API Forum Advisor Prod]

Hi Zhisheng,

Unfortunately, there is no workaround to get this data passed 90 days.