Reset Views, Visits and Login report data for Paid Memberships Pro.

pmpro-reset-views-visits-login-reports.sql

/**
 * Ensure your table names match exactly. Change the prefix 'wp_' if needed.
 * Run simulation query first before executing this query.
 * Have a full database backup.
 */

DELETE FROM `wp_options` WHERE `option_name` = 'pmpro_views';
DELETE FROM `wp_options` WHERE `option_name` = 'pmpro_logins';
DELETE FROM `wp_options` WHERE `option_name` = 'pmpro_visits';

DELETE FROM `wp_usermeta` WHERE `meta_key` = 'pmpro_views';
DELETE FROM `wp_usermeta` WHERE `meta_key` = 'pmpro_logins';
DELETE FROM `wp_usermeta` WHERE `meta_key` = 'pmpro_visits';