# Counting/Labelling Repeat Transactions

**URL:** <https://community.hubspot.com/t/counting-labelling-repeat-transactions/32423>\
**Category:** Reporting & Analytics\
**Tags:** workflows, object, contacts\
**Created:** [February 27, 2021, 6:50am UTC](https://community.hubspot.com/t/counting-labelling-repeat-transactions/32423 "2021-02-27T06:50:30Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![ataf](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ataf/32/76930_2.png) [@ataf](https://community.hubspot.com/u/ataf)\
**Post date:** [February 27, 2021, 2:05pm UTC](https://community.hubspot.com/t/counting-labelling-repeat-transactions/32423/3 "2021-02-27T14:05:29Z")

</div>

@karstenkoehler thanks a lot for such a detailed solution. The first two would have definitely worked if the _Associated Deals_ of contact were actually equal to the no. of transactions. My bad for not giving enough details, but we have a different prospecting pipeline and even in the transactional pipeline the deal has a chance of moving to the lost stage. An additional filter for only _closed-won_ deals would help do this job. I actually do these operations almost on a quarterly basis in sheets, but having it in HubSpot would help save a lot of time.  
Although this gave me an approach that I’m gonna try. I’m thinking of going for a deal-based workflow that triggers when the deal is moved to the _closed-won_ stage. The next step would be to check if the contact’s lifecycle is _customer_ and tag deals as first or repeat. Will have to be mindful of choosing the close date as after '_m __/d/yr__ ’_ threshold date\*.\* For deals before the threshold date, good old ‘export-sheets-import’ would do.  
The third workflow looks very promising and I think it should do the job. Gonna try it all out very soon and back here.  
Thanks again for the help!

---

_[View the full topic](https://community.hubspot.com/t/counting-labelling-repeat-transactions/32423)._
