Dashboards & Reporting

SThompson7
Contributor

Custom Report

SOLVE

Hi,

 Is there a way to create a custom report that shows:

Company owner

Total sales revenue 2020 

Total sum of all deals

what percentage of sales came from deals

 

thanks

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Custom Report

SOLVE

Hi @SThompson7,

 

It's not possible to visualize all of this information within one report, but you could create multiple reports.

 

Company owner <> Total sales revenue 2020

 

Is there a reason why you're distinguishing between company owner and rep in general? If not, you could use a report from the report library (Menu > Reports > Reports > Report library) for this, "Deal leaderboard - amount closed by rep", hover your mouse over it, click Edit in builder and specify your desired timeframe under Filters on the upper right.

 

Total sum of all deals

 

You could use the template "Deal closed totals vs. goal" from the report library for this. Does that work?

 

what percentage of sales came from deals

 

What do you mean with "what percentage fo sales came from deals" – what other paths could sales (= revenue?) take in your portal?

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

4 Replies 4
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Custom Report

SOLVE

Hi @SThompson7,

 

Where do you store the information about these direct sales?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

SThompson7
Contributor

Custom Report

SOLVE

On the Companies 

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Custom Report

SOLVE

Hi @SThompson7,

 

It's not possible to visualize all of this information within one report, but you could create multiple reports.

 

Company owner <> Total sales revenue 2020

 

Is there a reason why you're distinguishing between company owner and rep in general? If not, you could use a report from the report library (Menu > Reports > Reports > Report library) for this, "Deal leaderboard - amount closed by rep", hover your mouse over it, click Edit in builder and specify your desired timeframe under Filters on the upper right.

 

Total sum of all deals

 

You could use the template "Deal closed totals vs. goal" from the report library for this. Does that work?

 

what percentage of sales came from deals

 

What do you mean with "what percentage fo sales came from deals" – what other paths could sales (= revenue?) take in your portal?

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

SThompson7
Contributor

Custom Report

SOLVE

Thank you.  Some of our sales are direct sales that we don't create deals for.

0 Upvotes