Re: report api
Hi @Stephen G,
One option is with Google Data Studio. This is a beta product and free to use but is really neat and makes some truly great AdWords reports. They even give you a template to use.
You can get Google Data Studio here and you can learn more about its usage here. And our Analytics community next door has a fully-stocked help system of articles for Google Data Studio. I post over there fairly often, so if you have a new question, please do post it over there.
Google My Business & Google AdWords Top Contributor
Google Partner | GYBO Agency | Local Guide | My Profile