# "New customer" report

**URL:** <https://community.hubspot.com/t/new-customer-report/15721>\
**Category:** Dashboards & Reporting\
**Created:** [August 12, 2019, 8:47pm UTC](https://community.hubspot.com/t/new-customer-report/15721 "2019-08-12T20:47:11Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![sklein](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sklein/32/30597_2.png) [@sklein](https://community.hubspot.com/u/sklein)\
**Post date:** [August 12, 2019, 8:47pm UTC](https://community.hubspot.com/t/new-customer-report/15721/1 "2019-08-12T20:47:11Z")

</div>

Can anyone think of a way to ONLY show the first deal won by a new customer, without creating a new field saying “first deal” or similar? I’m trying to figure out the logic to include only the first deal closed per customer in a chart.

---

<div class="post-metadata">

**Author:** ![himanshurauthan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/himanshurauthan/32/53076_2.png) [@himanshurauthan](https://community.hubspot.com/u/himanshurauthan)\
**Post date:** [August 13, 2019, 4:12am UTC](https://community.hubspot.com/t/new-customer-report/15721/2 "2019-08-13T04:12:34Z")

</div>

Hello @sklein

You can use some of the contact properties for preparing a report. The properties are like:  
Became a Customer Date  
First Deal Created Date

These properties show up the dates for when a deal was created for the customer.

Thanks

---

<div class="post-metadata">

**Author:** ![sklein](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sklein/32/30597_2.png) [@sklein](https://community.hubspot.com/u/sklein)\
**Post date:** [August 13, 2019, 2:47pm UTC](https://community.hubspot.com/t/new-customer-report/15721/3 "2019-08-13T14:47:05Z")

</div>

This so helpful. Thank you as I didn’t even know this field existed.

Follow up question: I can’t seem to use this field on a chart? Ideally, I’d like to use Became a Customer Date on the X-axis, and a count of companies that became a customer in that period (month/quarter; however we group the date field) .

---

<div class="post-metadata">

**Author:** ![MikeLawson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mikelawson/32/41549_2.png) [@MikeLawson](https://community.hubspot.com/u/MikeLawson)\
**Post date:** [August 13, 2019, 3:13pm UTC](https://community.hubspot.com/t/new-customer-report/15721/4 "2019-08-13T15:13:26Z")

</div>

@sklein

You should be able to use that date to set up a chart. Here is what mine looks like!

 ![Screen Shot 2019-08-13 at 11.11.28 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/e/bee2206e0a35543e75ba5e59ec80b3c364879eb4.png)

What does yours say, is the field grayed out?

---

<div class="post-metadata">

**Author:** ![sklein](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sklein/32/30597_2.png) [@sklein](https://community.hubspot.com/u/sklein)\
**Post date:** [August 13, 2019, 4:23pm UTC](https://community.hubspot.com/t/new-customer-report/15721/5 "2019-08-13T16:23:04Z")

</div>

It was grayed out but then I used the same report in IE and it worked fine. (Genuinely, I likely just need to restart Chrome b/c I never use IE). Thanks!

---

<div class="post-metadata">

**Author:** ![sklein](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sklein/32/30597_2.png) [@sklein](https://community.hubspot.com/u/sklein)\
**Post date:** [August 13, 2019, 4:27pm UTC](https://community.hubspot.com/t/new-customer-report/15721/6 "2019-08-13T16:27:19Z")

</div>

How can I do this by COMPANY? Count of contacts works as designed but my org deals with multiple contacts from the same company, and I want to treat each COMPANY as a “new customer”; not the individual contacts.

As a simple example, If Hubspot is a customer of mine, and my buyer moves to a different role; I now I have a new contact at Hubspot to buy my services. The tool shouldn’t consider that a new customer, but it currently does if I only use “Count of Contacts” based on “became a customer date” because my new contact will be associated with the new deal with Hubspot.

---

<div class="post-metadata">

**Author:** ![MikeLawson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mikelawson/32/41549_2.png) [@MikeLawson](https://community.hubspot.com/u/MikeLawson)\
**Post date:** [August 13, 2019, 4:59pm UTC](https://community.hubspot.com/t/new-customer-report/15721/7 "2019-08-13T16:59:30Z")

</div>

@sklein

Thats a bit trickier, for some reason you can’t access the history tracking from properties on the company level.

I haven’t been able to produce this, best option may be to export a list of contacts that become customers in a given time period dump them to excel and run a unique on them.

Sorry I couldn’t be more helpful!
