Count the Maximum contribution factor for every vendor

Hi All,

Hope you are doing well!.. I am trying to get the maximum count of the contribution factors for every vendor.. And I am trying to search for the words -Promotion,Availability,BuyBox in the contribution column and identify the one with the maximum count for every vendor ..The contribution field has multiple text along with the words Promotion,Availability,BuyBox which is the challenge that i am facing ...Please find attached the excel file with the expected output..Can you pls help with the same...

Thanks,
Arun