# email program

**URL:** <https://community.hubspot.com/t/email-program/103850>\
**Category:** Email Marketing Tool\
**Tags:** professional\
**Created:** [April 1, 2024, 8:40pm UTC](https://community.hubspot.com/t/email-program/103850 "2024-04-01T20:40:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NBailliache](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nbailliache/32/102945_2.png) [@NBailliache](https://community.hubspot.com/u/NBailliache)\
**Post date:** [April 1, 2024, 8:40pm UTC](https://community.hubspot.com/t/email-program/103850/1 "2024-04-01T20:40:58Z")

</div>

Hello,

I have a newsletter i’m sending weekly with hubspot and I would like to create a rudimentary re ferral program. I have a startup I would rather not have to pay for an affiliate software.

I’m thinking super basic, So I need

- Unique ID for the person making a re ferral

- a way to record that a new user came from that re ferral

- a way to count how many re ferral (new email sign-up) a person generated

For each user, I was thinking using their Record ID as their unique identifier. I would add it to the email as a personalized token. I will create a landing page with a form that would record the Record ID as a hidden field on the form.

The question, is how can I create a custom field that track how many re ferrals a person made?

Any idea?

---

<div class="post-metadata">

**Author:** ![CHawkins](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chawkins/32/87643_2.png) [@CHawkins](https://community.hubspot.com/u/CHawkins)\
**Post date:** [April 1, 2024, 9:05pm UTC](https://community.hubspot.com/t/email-program/103850/2 "2024-04-01T21:05:59Z")

</div>

As you know, the challenge here is that the re ferral Code (I am assuming this will be a new custom property on a form) will live on the new, referred contact’s record, not the person who made the re ferral.  
One quick way to track this could be create a new table or pivot report to could the number of contacts by re ferral code, but you would have to manually transfer that data/knowledge to the person who made the re ferral.

 ![Screenshot 2024-04-01 at 4.53.07 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/3/33fb489c628de098d139910878869d4727188c66.png)

Alternatively, you can [use Contact-Contact associatations](https://knowledge.hubspot.com/records/associate-records#associate-records) which would probably get you closer to what you are invisioning.  
Out of the box, I can’t think of a way to associate these contacts automatically (In theory you could do this manually using the report I outlined above and then manually going into the records to associate them).  
There are also apps on the marketplace that could automatically set these associations I believe (Although I have never personally used them for this use case):

- [Associ8](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/associations-app-272901)
- [0CodeTools](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/1clicktools-1460496)

---

<div class="post-metadata">

**Author:** ![NBailliache](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nbailliache/32/102945_2.png) [@NBailliache](https://community.hubspot.com/u/NBailliache)\
**Post date:** [April 1, 2024, 11:53pm UTC](https://community.hubspot.com/t/email-program/103850/3 "2024-04-01T23:53:30Z")

</div>

Hey Casey, just to make sure I follow. when you say “new table or pivot report”, you mean doing an extraction of all data and then doing a pivot table on Excel?

thanks for sharing the app. I will look into those

---

<div class="post-metadata">

**Author:** ![CHawkins](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chawkins/32/87643_2.png) [@CHawkins](https://community.hubspot.com/u/CHawkins)\
**Post date:** [April 2, 2024, 12:27pm UTC](https://community.hubspot.com/t/email-program/103850/4 "2024-04-02T12:27:36Z")

</div>

Sorry, no. I mean a custom report in HubSpot.  
Here is a video walking through how I built the one I included in the screenshot: [https://drive.google.com/file/d/1Gt112eSgQBSDedXYnqpvi7npqZnKWr3E/view?usp=sharing](https://drive.google.com/file/d/1Gt112eSgQBSDedXYnqpvi7npqZnKWr3E/view?usp=sharing)