Add a custom report to the Memberships > Reports dashboard that displays a report of your membership site’s upgrades/downgrades.
See this blog post on custom reports to learn how to add the custom code to your site.
| <?php | |
| /* | |
| Changes Report for Paid Memberships Pro | |
| Title: pmpro_reports_changes | |
| Slug: pmpro_reports_changes | |
| */ | |
| //update this array for your desired reports. the format is: "report name" => array( initial_level_id, current_level_id ), | |
| global $pmpro_reports_level_changes; | |
| $pmpro_reports_level_changes = array( | |
| "Members upgrading from Level 1 to 2" => array( 1, 2), | |
| "Members downgrading from Level 3 to 2" => array( 3, 2), | |
| ); | |
| global $pmpro_reports; | |
| $pmpro_reports['changes'] = __('Membership Level Changes', 'pmpro-reports-changes'); | |
| function pmpro_report_changes_widget() { | |
| ?> | |
| <table class="widefat striped"> | |
| <thead> | |
| <tr> | |
| <th><?php _e( 'Name', 'pmpro-reports-changes' ); ?></th> | |
| <th><?php _e( 'Initial Level', 'pmpro-reports-changes' ); ?></th> | |
| <th><?php _e( 'Current Level', 'pmpro-reports-changes' ); ?></th> | |
| <th><?php _e( 'Count', 'pmpro-reports-changes' ); ?></th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <?php | |
| global $wpdb, $pmpro_reports_level_changes; | |
| foreach( $pmpro_reports_level_changes as $key => $pmpro_report_level_changes ) { | |
| $current_level = pmpro_getLevel( $pmpro_report_level_changes[1] ); | |
| $initial_level = pmpro_getLevel( $pmpro_report_level_changes[0] ); | |
| $changes_count_query = $wpdb->prepare(" | |
| SELECT COUNT(mu1.id) | |
| FROM $wpdb->pmpro_memberships_users mu1 | |
| LEFT JOIN $wpdb->pmpro_memberships_users mu2 ON mu1.user_id = mu2.user_id AND mu2.membership_id = %d AND mu2.id < mu1.id | |
| WHERE mu1.membership_id = %d AND mu1.status = 'active' AND mu2.id IS NOT NULL", $initial_level->id, $current_level->id); | |
| $changes_count = $wpdb->get_var( $changes_count_query); | |
| ?> | |
| <tr> | |
| <th scope="row"><?php echo $key; ?></th> | |
| <td><?php | |
| if( empty( $initial_level ) ) { | |
| echo '-'; | |
| } else { | |
| echo $initial_level->name; | |
| } | |
| ?></td> | |
| <td><?php echo $current_level->name; ?></td> | |
| <td> <strong><?php echo number_format_i18n( $changes_count ); ?></strong></td> | |
| </tr> | |
| <?php | |
| } | |
| ?> | |
| </tbody> | |
| </table> | |
| <?php | |
| } | |
| function pmpro_report_changes_page() { | |
| ?> | |
| <h1><?php _e( 'Membership Level Changes Report', 'pmpro-reports-changes' ); ?></h1> | |
| <table class="widefat striped"> | |
| <thead> | |
| <tr> | |
| <th><?php _e( 'Name', 'pmpro-reports-changes' ); ?></th> | |
| <th><?php _e( 'Initial Level', 'pmpro-reports-changes' ); ?></th> | |
| <th><?php _e( 'Current Level', 'pmpro-reports-changes' ); ?></th> | |
| <th><?php _e( 'Count', 'pmpro-reports-changes' ); ?></th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <?php | |
| global $wpdb, $pmpro_reports_level_changes; | |
| foreach( $pmpro_reports_level_changes as $key => $pmpro_report_level_changes ) { | |
| $current_level = pmpro_getLevel( $pmpro_report_level_changes[1] ); | |
| $initial_level = pmpro_getLevel( $pmpro_report_level_changes[0] ); | |
| $changes_count_query = $wpdb->prepare(" | |
| SELECT COUNT(mu1.id) | |
| FROM $wpdb->pmpro_memberships_users mu1 | |
| LEFT JOIN $wpdb->pmpro_memberships_users mu2 ON mu1.user_id = mu2.user_id AND mu2.membership_id = %d AND mu2.id < mu1.id | |
| WHERE mu1.membership_id = %d AND mu1.status = 'active' AND mu2.id IS NOT NULL", $initial_level->id, $current_level->id); | |
| $changes_count = $wpdb->get_var( $changes_count_query); | |
| ?> | |
| <tr> | |
| <th scope="row"><?php echo $key; ?></th> | |
| <td><?php | |
| if( empty( $initial_level ) ) { | |
| echo '-'; | |
| } else { | |
| echo $initial_level->name; | |
| } | |
| ?></td> | |
| <td><?php echo $current_level->name; ?></td> | |
| <td> <strong><?php echo number_format_i18n( $changes_count ); ?></strong></td> | |
| </tr> | |
| <?php | |
| } | |
| ?> | |
| </tbody> | |
| </table> | |
| <?php | |
| } |
Follow the directions outlined in this blog post on custom reports for help getting the report added to your site.
Update the $pmpro_reports_level_changes array to for your desired reports in the format: "report name" => array( initial_level_id, current_level_id ),.
Author: Kim Coleman
Kim Coleman is the co-founder of Paid Memberships Pro, the most trusted membership platform, which powers over 90,000 membership sites worldwide. With over two decades of experience in development, management, and marketing, Kim plays a pivotal role in shaping the product and guiding the team.
She specializes in content creation, video tutorials, and frontend development for the core open-source plugin and its various Add Ons, helping businesses of all sizes build and grow their membership sites.
Free Course: Membership Site Development—The Basics
Develop a deeper understanding of membership site development in this beginner-level course. Learn how to make your site work better, save yourself time and money, and improve your site's performance.
