Tools I useNo. 46

A Simple Tracker for Your Links and Programs (Built With Claude)

Keep one spreadsheet with a row for each product: your link, your comment word, where links are allowed, your recommendation doc and how it pays. Add a second tab for sales as they come in. Claude can set it up with you in about ten minutes.

By Martha Krejci · 4 min read ·

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:

Leave passwords out

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

Copy this

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.

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

  1. When you join a program:

    Add the row before you close the tab. Future you will be so grateful.

  2. When a sale comes in:

    Add it to the second tab.

  3. 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.
&

Links are organized. Now the posts. Want those written for you every week?

My Checklist writes your week.

Your posts. Your emails. In your voice, in one list. You open it, check the boxes, and go live your life.

7-day free trial. Cancel anytime.

Keep going

Martha Krejci

Who wrote this

Martha Krejci spent five years in leadership at GoDaddy, supporting small business owners. She has worked from home with her family since 2016, and she teaches women to get paid to post in 30 minutes a day.