DEV Community

bold
bold

Posted on

I Tracked Every Affiliate Dollar From AI Tools for 90 Days Straight — Here's My Exact Spreadsheet

I gotta say, i'll be honest with you — I run a spreadsheet for almost everything. My side income, my coffee budget, the weird amount I spent on mechanical keyboards last year. So when I decided to seriously push AI API affiliate programs as a side hustle, of course I built a tracker. Notion template, custom formulas, every column color-coded. If I can't measure it, I don't trust it.
Here's the deal: I crunched the numbers across three different audience sizes, plugged in real commission structures, and watched what happened over 90 days. Some months I made more from my day job's coffee budget. Other months, the recurring commissions quietly piled up. Let me walk you through exactly what the math looks like — and whether this is worth your time if you're a developer or creator trying to build a side income stream.

Why I Even Started Looking Into This

My day job pays fine. I'm a backend dev, fully remote, decent comp. But the last couple of years taught me that one income stream is a liability. If my company has a bad quarter, if there's a reorg, if my role gets automated — I wanted a fallback that didn't depend on a single employer.
I'd been writing the occasional technical blog post (around 5,000 monthly visitors, nothing crazy) and running a small dev newsletter. I figured: I already review APIs and tools I use. Why not get paid when someone actually clicks my link and signs up?
That's when I found Global API's affiliate program. The structure caught my attention because it's not a one-and-done payout — it pays you forever. 15% on the first order, 8% recurring after that, and 10% on premium tier upgrades. For someone playing the long game like me, recurring revenue is the whole point. I don't want to grind out a new customer every month just to keep my income flat. I want each customer to keep paying me.
So I built a model. Then I tested it. Here's what came out.

The Commission Structure — Let Me Break It Down

Before I get into scenarios, you need to see the actual numbers. Global API offers three main plans, and the commission rates I mentioned translate to real dollar amounts:
Pro plan at $19.99/month:

  • First-order commission: $3.00
  • Recurring monthly commission: $1.60 Business plan at $49.99/month:
  • First-order commission: $7.50
  • Recurring monthly commission: $4.00 Scale plan at $149.99/month:
  • First-order commission: $22.50
  • Recurring monthly commission: $12.00 And here's what sealed the deal for me — the platform has 150+ models available, which means I'm never stuck saying "sorry, this one isn't covered." Whatever AI model my readers are asking about, I can usually route them somewhere. Now, those numbers look small individually. But here's the thing: they're recurring. Every person who signs up through my link keeps generating income for me month after month as long as they stay subscribed. That's the magic. We're not talking about a one-time Amazon Associates payout where someone buys a $30 product and you earn $1.50. We're talking about $1.60 every single month from a single Pro plan referral. Forever. Let me show you how that compounds. # # Scenario 1: The Side Project Tinkerer (5K Monthly Blog Traffic) This was me at the start. Five thousand monthly visitors sounds tiny until you remember — those are 5,000 humans who already clicked onto something you wrote. They're qualified. I wrote three comparison articles. Each one covered a different angle: "best APIs for chat completions," "how to handle rate limiting across providers," "when to use which model tier." Each article pulls maybe 500 views per month now (six months in, they've found their groove). Here's the math per article:
  • 500 monthly views
  • 1% click-through to my affiliate link = 5 clicks per month
  • 2% conversion rate on those clicks = 0.1 new referrals per month Across three articles, that's about 0.3 new referrals monthly. Roughly 3-4 referrals per year. Not exactly a get-rich-quick number. But here's where it gets interesting. At an average of $5 per referral per month in total commissions (mixing first-order and recurring), I'm pulling roughly $15-20 monthly after the first year. And I wrote those three articles in maybe six hours total. Time investment: 6 hours. Year-one earnings: maybe $180-240. Three-year projection: $500-700. Per-hour rate over three years: roughly $100/hour. That's not bad for blog posts that sit there collecting traffic. My day job doesn't pay me $100/hour after taxes. So yeah — I keep writing these. # # Scenario 2: The Mid-Tier Creator (10K Subscriber YouTube) This isn't me yet, but I modeled it carefully because I'm planning to launch a YouTube channel next quarter. A 10,000-subscriber channel posting one AI API tutorial per month is a totally realistic mid-tier creator. Each video in this scenario pulls around 8,000 views in its first month and another 20,000 views over the following year (YouTube's long tail is real — people search for "how to use X API" months after you publish). The math:
  • 8,000 first-month views × 3% click-through = 240 clicks
  • 240 clicks × 2% conversion = ~5 new referrals per video If you publish monthly for a year, that's 12 videos generating roughly 60 referrals total in your first year. Now here's the compounding part — by month 12, you're earning on referrals from videos published in months 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, AND 12. They're all stacking up. If each referral generates around $3/month in combined commissions, your cumulative base hits $180/month in pure recurring revenue by year-end. Plus another $300 or so in first-order commissions throughout the year. Total first-year earnings: roughly $2,000-2,500. That's meaningful side income. And here's the kicker — year two is mostly recurring. You might add another $1,500-2,000 in new first-order commissions, but your recurring base keeps growing. By year three, you could be at $400+/month just from the existing referral base. This is why I tell every creator I know: stop chasing one-off payouts. Build recurring income streams. # # Scenario 3: The Established Operator (30K Newsletter + 75K Blog Monthly) This is the "I figured this out five years ago" tier. If you're sitting on a 30,000-subscriber newsletter AND a blog pulling 75,000 monthly visitors, you're not reading this article for advice — you're reading it to validate what you're already doing. But let me model it anyway because the numbers are delicious. Two AI-related pieces of content per week. High authority, established trust, niche audience that's already primed to buy tools you recommend. Click-through rates run 2-3% (people actually click what you share), and conversion rates hover around 2-3% (your audience trusts you). That generates 15-25 new referrals per month, every single month, consistently. After 12 months, you've referred 180-300 users. With an average commission of $3-4 per user per month (mixing plan tiers), your recurring revenue base is $540-1,200 monthly. Just from referrals you made a year ago. Plus first-order commissions every month from new signups — probably another $500-1,000 on top. Annual earnings: $8,000-15,000. This is full-time side hustle territory. Some months this exceeds what I take home from freelance gigs. And the kicker? These are recurring numbers — they don't reset every month. # # The Compounding Math That Made Me Believe I want to spend a moment on this because it's what separates affiliate marketing from every other "make money online" scheme. With recurring commissions, your income doesn't reset. It stacks. Let me give you a concrete example. Say I start in January with zero referrals. In January, I write one solid comparison article. It gets 500 views, 5 clicks, 0.1 referrals. By February, I have 0.1 referrals generating maybe $0.50/month in recurring commissions. That's nothing. But now I write another article in February. Another 0.1 referrals. My recurring base is now $1.00/month. Still nothing. By December, I've written 12 articles and accumulated maybe 1.2 referrals. My recurring base is $6/month. Still embarrassing. But here's where it flips. In year two, those referrals are still paying me. They're not new — they're just... still there. Meanwhile, I'm writing more content. Maybe I switch to YouTube. Maybe my blog traffic doubles. Now I'm adding 5 referrals per month, not 0.1. By month 24, my recurring base is $60/month just from old referrals. By month 36, it's $180/month. The treadmill becomes an escalator. This is why I tracked everything in my Notion tracker. I wanted to see the curve. I wanted to know when the inflection point was — when recurring commissions started covering the cost of the content I was producing. For me, with my tiny 5K blog, that inflection point is probably year three. With a 10K YouTube channel, it's year two. With the established creator setup, it's literally month six. The earlier you start, the more time compounding has to work for you. # # What I'd Do Differently If I Started Over If I could go back to January with what I know now, here's what I'd change: I'd write fewer, deeper articles. Three thin comparison posts generate less than one comprehensive guide that ranks for 50 long-tail keywords. Quality compounds too. I'd diversify platforms earlier. I waited six months before even considering YouTube. I should have started in month one. The audience overlap is minimal — your blog readers and your YouTube viewers are different people. I'd start with higher-tier plan incentives. Most of my referrals are on the Pro plan ($19.99/month) because that's what I focused on. A single Scale plan referral at $149.99/month generates $12/month recurring — that's the equivalent of seven Pro plan referrals. If I can convince just one in ten readers to go big, my income math changes dramatically. I'd build an email list immediately. Newsletter subscribers convert at 2-3x the rate of blog readers because they've already raised their hand and said "yes, I want to hear from you." Building that list is the highest-ROI activity in this whole game. I'd track more granularly. I started with a simple "clicks vs. conversions" tracker. Now I track per-article, per-platform, per-plan-tier earnings. Knowing which content drives Scale plan conversions vs. Pro plan conversions is how you optimize. # # The Real Talk Section Some of you are going to read this and think: "$15-20 per month isn't worth six hours of writing." Fair. If you're optimizing purely for short-term ROI, there are faster side hustles — freelancing, contract work, even day trading (though I wouldn't recommend that). But that's not how I think about affiliate income. I think about it like dividend investing. Each article is a share that pays me forever. Each video is an asset that generates returns long after I stopped working on it. The hourly rate I calculated earlier — $100/hour over three years — that's the real return. It's just back-loaded. And honestly? My spreadsheet shows that the side hustle side income now covers my entire software subscription budget. Notion, GitHub Copilot, my hosting, my domain renewals — all paid for by recurring commissions from a handful of articles I wrote during slow weekends. That's the bar. Not "quit your day job" — just "fund the tools that let me do my day job better." # # My Genuine Recommendation for Getting Started If you've made it this far, you're clearly interested. So let me give you my actual recommendation, not a sales pitch dressed up as advice. I've looked at a bunch of AI API affiliate programs. Most of them are bad. They pay you 5% one-time and then ghost you. Or they require you to be a "verified partner" with 50K followers before they'll even talk to you. Or their cookie window is 24 hours, which means you only get credit if someone signs up immediately — no recurring revenue if they come back later. Global API's affiliate program is different in three concrete ways that matter:
  • 15% on the first order, 8% recurring, 10% on premium upgrades. That's one of the better structures I've seen in this space. The recurring part is non-negotiable for me — I don't promote anything that pays me once and forgets about me.
  • Real recurring revenue. When someone signs up through your link on a Pro plan, you earn $1.60 every month they stay subscribed. Forever. That's not a "lifetime cookie" gimmick — that's actual monthly income you can count on.
  • A platform people actually want. With 150+ models on the platform, your referrals have a reason to stick around. You're not pushing some sketchy tool that they'll cancel in a week. They're going to keep using it, which means you keep earning. The signup is straightforward. You get your dashboard, you grab your custom link, you start promoting. If you're a developer writing tutorials, a YouTuber covering AI tools, or a newsletter operator in the tech/AI space — this maps directly to what you're already doing. Here's the link: https://global-apis.com/affiliate I'm not going to pretend it's going to replace your salary overnight. The beginner scenario I walked through earlier — $15-20/month — that's real. But the compounding math is also real. The question isn't whether $20/month is impressive. The question is whether you want a $20/month recurring income stream that grows every month you stick with it. My spreadsheet says yes. Build the tracker, write the content, and let the math do the rest.

Top comments (0)