API : automatize our customers' SEMRush monthly reports

We need a simple admin where we can get our customers' SEMRush monthly reports We need an admin (protected with a password) where we can get our customers' monthly reports. We'll send these reports manually. There are only two filters : "site" and "month". Based on SEMRush API ([login to view URL]), create monthly reports about their competitor ads. We have to be able to create "groups" of keywords in a MySQL table or with a XML file (or whatever). Example : group "hotel", which includes all the keywords "hotel xxxx", "blablabla".. (We set up manually the list of keywords, we can add keywords in a group...). Keep it simple, we don't need a big development there. We need two kinds of reports : - an excel file : colums = Competitors, Country, Keywords, Position, Search Volume, CPC, Competition, Number of Results, Trends - a pdf file : four tables = 1°) monthly list of keyword groups and their status (protected or not) ; 2°) monthly list of keyword groups and the status of the country (example : France "OK", USA "Not OK", UK "OK"...) ; 3°) monthly list of common keywords with competitors for all groups ; 4°) list of all the competitors for all groups and number of keywords they use (for each group) We'll give you examples for these two files. It's really simple.