Get a list of coupons used on recurring profiles in Magento

Magento-Get-Coupon-Codes-Used-on-Recurring-Profiles.php

<?php
require_once 'app/Mage.php';
Varien_Profiler::enable();
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
umask(0);
Mage::app('default'); 


$profile = Mage::getModel('sales/recurring_profile')->getCollection();

$couponCodes = array();
  
foreach ($profile as $p) {

	$data = unserialize($p->getOrderInfo());

	if (isset($data['coupon_code'])) {
	
		if (strlen($data['coupon_code']) > 1) {
		
			$couponCodes[] = $data['coupon_code'];
		
		}
	}

}

echo '<pre>';
print_r(array_count_values($couponCodes));
echo '</pre>';
?>