Hi,
Thank you for posting your concern.
On AdWords API perspective, you may use AdWords API reports below to get data you are looking for:
Also, you may refer to this guide and these examples for more details about AdWords API reports.
Please let me know if you have further clarifications.
Regards,
Hiroyuki
Google Ads API Team