Original subtitles

So, to get the average deal size for all the accounts,

I've set up a spreadsheet so that we can first calculate

the total bookings in dollars that we already did in the past,

in the previous video and then the number of deals for each of the accounts,

and then we're going to go ahead and calculate the average deal size.

So first, we're going to go ahead and

calculate the sum of the bookings for each of these accounts.

I'll just copy and paste it down,

and then the short number of deals where each of the accounts and then again,

I'm going to just copy this formula down.

I'm going to go ahead and copy these.

So, I'm going to just go ahead and copy and paste the values,

copy and paste the values,

and then to get the average deal size that we got from each of

the accounts all you have to do is you divide the total bookings by the number of deals,

and that tells you the average amount for

each deal or that we got from each of these accounts.

Right away, we can see,

Sam's Club had really high bookings that it seems to me there was a mix of

monthly and annual subscriptions that we got and the reason is because we know that

the monthly subscription is $16 and you're yearly subscriptions are $195.

So, with that knowledge in mind,

we can see that this- the amount that we got from Sam's Club and

Costco was a combination of monthly and yearly accounts, purely orders.

So, the average deal size tells us that.

We got a combination of monthly and yearly subscription from Costco and Sam's Club.

Case of Sprouts, the book yield was smaller,

but the booking size was bigger,

and that's because the average deal size

was a 195 which turns out to be a yearly subscription.

So, all of the a 150 deals that we got for Sprouts, for this account,

were all annual versus in Safeway

where even though we've gotten the more number of deals,

the unit price was $16 which happens to be a monthly subscription.

So, we didn't get as much bookings for that.

But this kind of analysis allows the sales team to see okay,

which account is actually generating more bookings for them and focus their efforts

on the type of deals that they get and the type of customer that they're getting.