# New Customer Reporting

**URL:** <https://community.breww.com/t/new-customer-reporting/1792>\
**Category:** Help & advice\
**Tags:** reporting, sales, leads\
**Created:** [11 November 2022 18:25 UTC](https://community.breww.com/t/new-customer-reporting/1792 "2022-11-11T18:25:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![oliver-hurlow](https://community.breww.com/user_avatar/community.breww.com/oliver-hurlow/32/494_2.png) [@oliver-hurlow](https://community.breww.com/u/oliver-hurlow)\
**Post date:** [11 November 2022 18:25 UTC](https://community.breww.com/t/new-customer-reporting/1792/1 "2022-11-11T18:25:46Z")

</div>

I’m trying to build a report that includes a field for % Revenue by New Accounts as a way to compare relative successes of new account generation and growth of existing accounts.

Does anyone have any bright ideas how that might be done?

Maybe a way of reporting on leads that have become customers and then placed their first order?

Any help appreciated!

Cheers,

Oli

---

<div class="post-metadata">

**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\
**Post date:** [14 November 2022 15:53 UTC](https://community.breww.com/t/new-customer-reporting/1792/2 "2022-11-14T15:53:35Z")

</div>

That sounds like an interesting report!  
One possibility to build this report would be to start with the Sales (orders/invoices) **Raw data** explorer report, and add a field for **Customer** → **Created at**. Add any BrewwQL filters you might want, like orders from this year, for example (issue\_date \>= “01/01/2022”).  
Then you’ll need to export the data to Excel. In Excel, you could then simply group the data by this ‘created at’ date (grouping every month, two months, or whatever you need) and sum by order value. This would give you the total order value for customers created within each time frame, which you could then compare to the sum of all the order values.

NOTE: due to the way in which customers and leads are created behind the scenes, if a lead is converted to a customer, then **Customer** → **created at** date will be the date that the lead was created, not when it was converted.

I hope this helps!