Since the Google developer team shares no info about their backlog, we might be waiting for the API for a long time.
I've tried Adwords API, Google Ads API, export via Google Ads Script and Google Big Query Data Transfer for Google Ads. Nothing worked.
The next step will be an attempt to schedule report email and automatically process it that way.. But I can't believe how bad is this feature planning.
Anybody has other ideas?