I try to pull twitter ads data to google sheets but query failed. The reason is that "the end_time can be a maximum of 90.days+1.hours after the start_time".
However, I want to pull last 12 months data and one week ago, query was working.
Could you please help me to pull last 12 months twitter ads data?
I believe that you're using Twitter organic data. There's no time restriction on Twitter Ads data but Twitter Organic Data is restricted for the last 90 days by Twitter.
I am sure about we are using Twitter Ads data. You can check it at this screenshot http://prntscr.com/i7leam
Feel free to inform me if I use organic data without knowledge.
this was indeed a bug on our query system. It has been fixed now and you should be able to get more than 90 days of data at a time. Sorry for the inconvenience.