Hi all,

I am struggling to find out how best to correctly analyse some data - because I don't know what to search for, not due to the complexity of the methods. I am hoping to get some direction on what to apply to analyse my problem:

The average sales conversion rate of (as a %) is a factor of two known categorical variables: the salesperson, and the source of the lead. There may be more degrees of freedom that I don't necessarily know of.

What I would like to do is somehow understand the conversion rate potential of:

- A single salesperson independent of the lead sources they work.

- A single lead source independent of the salesperson who works it.

What I would like to be able to say is:

- that Daniel has the potential to convert at 5% assuming an ideal lead source, and

- Inbound Email has the potential to convert at 4% assuming an ideal salesperson.

As you can see, I know what I am looking for and I'm fairly sure it's possible with the data I have but I don't understand the terminology at all!

Not sure if this will help but I have started to aggregate the data into a table:

SALESPERSON1 SALESPERSON1 SALESPERSON1

----------------------------------------------------------------------

LEADSOURCE1 | 5% | 2% | 1%

LEADSOURCE2 | 2% | 1% | 1%

LEADSOURCE3 | 5% | 3% | 2%

----------------------------------------------------------------------

Any help would be greatly appreciated.

Daniel