You joined a program in March. Somebody just asked for the link. You have no idea where it is.
Every woman who shares products hits this. Links in old emails, logins on sticky notes, a comment word you can't remember.
One simple tracker fixes all of it, and Claude can build it for you in ten minutes.
What to keep track of
One row for each thing you share. These are the columns worth having:
- The product.
- Your link. The whole thing, so you can copy it in two seconds.
- Your comment word. The one you use every time for that product.
- Where the link is allowed. Posts? Messages? Email? Each program has its own rule.
- Your doc. The link to the Google Doc that explains your recommendation, with your disclosure at the top.
- When and how they pay.
- Where you log in, and which email you used.
- The date you joined.
A tracker is for links and notes. Passwords belong in your phone's password keeper, never in a spreadsheet or a chat.
Have Claude build it
Make me a simple tracker for the products I recommend as an affiliate. One row per product. Columns: product, my link, my comment word, where links are allowed, the link to my recommendation doc, how and when they pay, where I log in and which email I used, and date joined.
Make it a table I can copy into a spreadsheet. Then ask me about my first product and fill in the first row with me.
Claude will ask you questions and fill in the row as you answer. Copy the table into Google Sheets, or whatever spreadsheet you already use, so it's on your phone too.
New to Claude? Start with your first 20 minutes.
Add a second tab for what comes in
Once sales start, keep a running list. It takes ten seconds per sale.
- The date.
- The product.
- What you earned.
- The date it was actually paid.
That list does two jobs. It shows you which product is working, and it's exactly what a tax person will ask you for.
While we're talking about the tax person
Commissions are income. A clean record from day one saves you a miserable weekend later.
My friend owns a tax strategy company, and they give my people extra free stuff. The first call is free. (Real talk, because I never want you to wonder: I earn if you work with them. And actually, that relationship is how I get to hand you this for free. Taking good care of you is the whole point.)
I'm no tax pro. Bring them your list and your questions.
Line it up with your number
If you've figured out your come-home number, your tracker tells you how close you are.
Add one line at the top: how many sales you need this month, and how many you've had. Here's how to find that number.
Keeping it up takes two minutes a week
- When you join a program:
Add the row before you close the tab. Future you will be so grateful.
- When a sale comes in:
Add it to the second tab.
- Every Friday:
Glance at it. Is there a product you haven't mentioned in a month? That's next week's Thursday post.
When somebody asks for a link
This is the moment it pays off. Open the tracker, copy the link to your doc, send.
Ten seconds, and she gets her answer while she's still interested. The rest of that conversation is in what to say back.
And if you don't have programs to track yet, here's how to find them for things you already buy.
Quick answers
How do I keep track of my affiliate links?
One spreadsheet, one row per product, with your link, comment word, the program's rules and how it pays.
Do I need special software?
No. A free spreadsheet is plenty. Claude can set up the columns for you.
Should I track my earnings too?
Yes, from the first sale. Date, product, amount and the date it was paid.
Is it safe to put my links in a spreadsheet?
Links, yes. Passwords, no. Keep those in a password keeper.
Your 30 minutes today
- Paste the prompt into Claude and build your tracker.
- Fill in a row for every program you've joined.
- Copy it into a spreadsheet you can open on your phone.