SQL Reports | Eli's Blog

I added a shortcode to my SQL Reports Plugin so you can put a report you’ve created into a Page or Post. Just use the shortcode “SQLREPORT” with the attribute “name” being the name or your desired report. Like this:
[SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /]

The below example is a Report that I make to see the effect that Google’s SSL Search has been having on my Keyword Data. I broke it down by Locale so that I could see the differences between the use of google.com as compared to the other country codes.

Impact of Google Blocking Keyword Data with SSL Search

Domain	Total Visits Referred	Keywords Blocked by SSL	Percentage Blocked
www.google.com	229	85	37%
www.google.co.uk	9	4	44%
www.google.nl	8	0	0%
www.google.de	6	1	17%

This plugin allows you to create reports simply by entering in the SQL. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click.

You can download the plugin from the WordPress Repository or here.