I need a php script to obtain certain metrics for a list of domain names from [url removed, login to view] using the semrush api. I need a simple form to upload a domain name list of up to 1000 names(a textbox should be fine), and then the script must make the results available as a csv file that I can download from a link.
The semrush api documentation is here - [url removed, login to view]
I want these metrics from the main report for the us database:
Main report - Dn, Rk, Or, Ot, Oc, Ad, At, Ac
Dn - A site name.
Rk - Rating of sites by the number of visitors coming from the first 20 Google search results
Or - Keywords that this site has in TOP20 Google Organic results
Ot - Estimated number of visitors coming from the first 20 Google search results (per month)
Oc - Estimated cost of purchasing the same number of visitors
Ad - Keywords that this site has in TOP20 Google AdWords
At - Estimated number of visitors coming from AdWords (per month)
Ac - Estimated expenses of the site for the advertising in AdWords (per month)