Find conversion rate from Net New and Basic/Classic Vendors onto Card and Premium ACH

[RockieTucan]

Hi All,

I am trying to identify conversion rate from net new (No Membership) and basic/classic (Network Match) vendors onto card and accepted card (Premium ACH). To do that, I will need to identify that the vendor was targeted for card, enrolled in card, and was either net new prior or basic/classic prior to enrollment. Same for Premium ACH. After that, I can say was the target net new or basic/classic and then after that did they accept or not. The last accept or not filter should give the conversion rate, accepted/(accepted + did not accept) = conversion rate %. Any ideas what I am missing here? What steps would you take to find the conversion rate?

[binuacs]

@RockieTucan The requirement is very much confusing, would you be able to provide a sample input file and expected output results?