I’ve made app that you migh find useful
CTR by Average Position
The first app computes Google Search Queries CTR by Average Position.
With a big website it looks like this
app code is open sourced here
Crawl Recursively XML sitemaps
The second app help to detects, Crawl and Download XML sitemaps
this app rely primarily on the xsitemap package