PromInc / organic-search-analytics

Import organic search analytics from Google Search Analytics (Google Webmaster Tools) and save to a MySQL database
36 stars 19 forks source link

Adding bulk report #50

Open nepohex opened 7 years ago

nepohex commented 7 years ago

First of all GREAT THANKS for this tool! Keep going well! I started to write my own, until I found your comment in google api library, just in time and it's saved my weeks :+1:

Please, add:

nepohex commented 7 years ago

3rd, huge problem now, bound with 2nd: As I said I got 20+ domains, and all of them are almost empty 85 days past. For some of them its like from 0 to 5000 queries in past few days. I've collected all data, and now when I open data capture page and want to collect newest data, script starts to collect again each of this empty domain for every 90 days.

PromInc commented 7 years ago

I'm hearing 2 issues here - reporting that groups domains together and changes to how the data is captured.

Grouped Domains in Reports

On my todo list somewhere (either documented digitally or mentally) is a feature to group domains under the settings section. That would allow for lumping a blog on a subdomain and an ecommerce store on a separate subdomain into one report for the full domain (as an example). This would do the same as you are requesting here only would require grouping in the settings as opposed to the reports page. Maybe both would be ideal. Something to think about what the best user experience is. Full disclosure I do not have an ETA on this feature at this time. It sounds like you may have some experience in development - I welcome pull requests to help advance this project together!

Data Capture

It sounds like the concern of the new domains will not be an issue 85 days from now. To me that seems like a minor issue that is an issue with diminishing need.

It is possible to capture data for one singe day. It does require scrolling to that date per domain and clicking the button, so becomes slightly tedious.

All in all, I feel your reporting concerns could be resolved with the recently added CRON functionality. You can read some basic steps on how to get this running in the Wiki.

The CRON task would capture data for a specific date at a specified time of the day - hands free data capture! If you put a little bit of effort into a bash script you can loop through all of your domains in one script. This means the web interface would only be needed for reporting and not data capture.

PromInc commented 7 years ago

FYI I just updated the CRON functionality page in the Wiki with additional information.