Pierre Lannoy

Hosterra

Full featured analytics for WordPress APIs.
Traffic is a full featured analytics reporting tool that analyzes all inbound and outbound API calls made to/from your site.
At this time, Traffic can report, for inbound and outbound traffic:
<ul>
<li>KPIs: number of calls, data volume, server error rate, quotas error rate, effective pass rate and perceived uptime;</li>
<li>domains, subdomains and endpoints details;</li>
<li>metrics variations;</li>
<li>HTTP codes, protocols and methods details;</li>
<li>geographical repartition of calls;</li>
</ul>
Traffic supports multisite report delegation (see FAQ).
Traffic supports WP-CLI commands to:
<ul>
<li>display (past or current) API calls in console – see <code>wp help api tail</code> for details;</li>
<li>toggle on/off main settings – see <code>wp help api settings</code> for details.</li>
</ul>
For a full help on WP-CLI commands in Traffic, please <a href="https://perfops.one/traffic-wpcli" rel="nofollow ugc">read this guide</a>.
<blockquote>
Traffic is part of <a href="https://perfops.one/" rel="nofollow ugc">PerfOps One</a>, a suite of free and open source WordPress plugins dedicated to observability and operations performance.
</blockquote>
Traffic is a free and open source plugin for WordPress. It integrates many other free and open source works (as-is or modified). Please, see ‘about’ tab in the plugin settings to see the details.
<h4>Support</h4>
This plugin is free and provided without warranty of any kind. Use it at your own risk, I’m not responsible for any improper use of this plugin, nor for any damage it might cause to your site. Always backup all your data before installing a new plugin.
Anyway, I’ll be glad to help you if you encounter issues when using this plugin. Please read carefully the FAQ at the bottom of this page before requesting support.
<h4>Donation</h4>
If you like this plugin or find it useful and want to thank me for the work done, please consider making a donation to <a href="https://www.laquadrature.net/en" rel="nofollow ugc">La Quadrature Du Net</a> or the <a href="https://www.eff.org/" rel="nofollow ugc">Electronic Frontier Foundation</a> which are advocacy groups defending the rights and freedoms of citizens on the Internet. By supporting them, you help the daily actions they perform to defend our fundamental freedoms!

Traffic

Full featured monitoring & analytics for WordPress APIs.

Just place some SQL on in the box and save it as a report. 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 place your reports on the User’s Dashboard based on Roles. You can also put a report on a Page or Post using a shortcode like [SQLREPORT name=”My Report” style=”padding: 6px;” /]
There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site: 
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar] 
Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query.
If you want to include an “Export to CSV” button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode. 
Note: Adding this shortcode to the just one time will insert the “Export to CSV” button at the top of every HTML Table on the page.
<h4>Automatic Database Backups</h4>
Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.

EZ SQL Reports Shortcode Widget and DB Backup

Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.

Traffic vs EZ SQL Reports Shortcode Widget and DB Backup