Count downgrades to free levels as "cancellations" in reports in Paid Memberships Pro.

my_pmpro_reports_signups_sql.php

/*
	Count downgrades to free levels as "cancellations" in reports.
	
	Paste this into your active theme's functions.php or a custom plugin.
	
	Requires PMPro v1.8.8
*/
function my_pmpro_reports_signups_sql($sqlQuery) {	
	//figure out which levels are free
	$all_levels = pmpro_getAllLevels(true, true);
	$free_levels = array();
	foreach($all_levels as $level) {
		if(pmpro_isLevelFree($level))
			$free_levels[] = $level->id;
	}
		
	if(!empty($free_levels)) {
		$sqlQuery = str_replace('AND mu2.id IS NULL', 'AND (mu2.id IS NULL || mu2.membership_id IN(' . implode(',', $free_levels) . '))', $sqlQuery);
	}
		
	return $sqlQuery;
}
add_filter('pmpro_reports_signups_sql', 'my_pmpro_reports_signups_sql');
add_filter('pmpro_reports_get_cancellations_sql', 'my_pmpro_reports_signups_sql');