Building a deal-tracking system that actually works when you're juggling multiple brand relationships

I realized a few months ago that I was basically flying blind on brand relationships. I’d close a deal, deliver content, get paid, and then… nothing. No way to know which brands were happy, which ones might come back, which ones I actually lost money on because rates were too low.

So I started building a simple tracking system—nothing fancy, just a spreadsheet at first. But it changed how I operate.

Here’s what I track: brand name, contact person, date of first contact, what they asked for, the rate we agreed on, actual time spent, delivery date, their feedback, and whether they’ve come back or are likely to.

What surprised me: I could actually see patterns. Some brands consistently wanted more revisions than expected. Some paid better. Some had longer sales cycles. And most importantly—I could see which relationships were worth investing time to nurture versus which ones were just one-offs.

The hard part isn’t tracking. The hard part is maintaining it without going crazy. I update it once a week, keep columns minimal, and only log enough info to remind me of context when they reach back out.

When a brand re-engages, I can pull up the last deal, remember what worked, and iterate. That saves me hours of back-and-forth and usually means better rates because I’m not renegotiating specs from scratch.

Has anyone else systematized this? What’s your system for managing multiple concurrent brand relationships without losing your mind?

Абсолютно нужный инструмент. Я вижу, что инфлюенсеры, которые это делают, занимают гораздо более сильную позицию в переговорах со вторым и третьим contact’ом с одним брендом.

Это тоже помогает с рекомендациями и связями. Если у тебя есть хорошие отношения с брендом А, то когда появляется бренд Б из той же вертикали, ты можешь говорить более уверенно, потому что знаешь, как работает этот рынок.

Мой совет: добавь в систему поле для “контактов в бренде” или “кто принимает решения”. Часто в бренде несколько людей, и если ты знаешь, кто действительно влияет на выбор, это очень ускоряет следующий раунд переговоров.

Это очень полезный инструмент для анализа профитабильности. Когда ты отслеживаешь actual time spent vs. rate agreed, ты начинаешь видеть, какие бренды тебе действительно выгодны, а какие только казались выгодными на первый взгляд.

Мой совет: добавь поле для “estimated hours” vs. “actual hours”. Это поможет тебе понять, где ты недооцениваешь complexity проекта. Например, если ты обычно оцениваешь проект в 8 часов, а он занимает 12—это систематическая проблема в estimations.

Также интересно отслеживать по категориям: какие бренды (по вертикали, бюджету, типу контента) обычно требуют больше ревизий? Это приводит к более точному pricing в будущем.

Один еще вопрос: как ты отслеживаешь время—на часах ведешь или постфактум оцениваешь?

Это звучит очень похоже на то, что нам нужно для управления партнерской сетью. Адаптируешь ли ты эту систему как-то под долгосрочные отношения, или это больше для одноразовых deal’ов?

This is exactly what we recommend to creators doing more than 5-10 deals per quarter. The system you’re describing is basically lightweight CRM, which scales way better than managing everything in your head.

Here’s what we add: a “next steps” column with automatic reminders. If a brand is likely to repeat, put a reminder to reach out 60 days before you expect their next campaign cycle. It’s passive follow-up that actually works.

We also encourage creators to think of this as a business asset—when you eventually want to sell partnership rights, consult, or bring on an agency, your data on historic brand relationships is incredibly valuable. Well-organized data tells the story of a professional operator.

One thing I’d flag: keep it simple. Too many columns and you stop updating it. We’ve seen creators abandon tracking systems because they got too complex. Start with 8-10 key fields and expand only if you need to.

How long do you usually wait before reaching out to a non-repeat brand? And have you seen any come back after months of inactivity?

Yes! I do something similar but I use a Google Sheet that syncs to my phone so I can actually update it on the go. Game-changer because when a brand reaches out, I can literally pull up the last conversation in 30 seconds.

Also tracking actual time vs. quoted time has been eye-opening. I realized I was underestimating how long revision rounds take. So now I build in buffer time and quote accordingly.

One thing I added: a “vibe check” column where I just put whether I want to work with them again. Sometimes a brand pays well but is exhausting to work with, and I’d rather say no to a second deal. Tracking this helps me be intentional about which relationships to nurture.

Also when you’re tracking this, you start seeing which brands are actually good partners (they pay on time, give clear feedback, don’t ask for excessive revisions) vs. which ones are just… annoying. Worth filtering for those soft factors early.

Do you also track payment terms? That’s been huge for me—knowing which brands pay upfront vs. 30 days out hugely impacts my cash flow.

What you’re describing is the foundation of relationship-based revenue forecasting. Once you have historical data, you can actually predict revenue based on seasonal patterns, repeat frequency, and average deal value per brand category.

Build it out further: segment your brand relationships by tier. Tier 1 might be repeat clients with $5k+ annual value. Tier 2, consistent repeat clients with lower value. Tier 3, one-time deals. This tells you where to invest relationship energy.

Second, use the data to forecast. If you have 8 Tier 1 brands that repeat 2-3x per year at $3k average, that’s a $48-72k baseline you can depend on. Everything else is upside. Suddenly your revenue becomes more predictable and plannable.

Third, track not just what happened but why. Document the factors that made a deal good or bad—communication style, brief clarity, brand reputation, etc. This becomes pattern recognition for identifying good vs. bad-fit clients early.

Question: once you’ve had your system running for a few months, will you have enough data to start segmenting brands by profitability and fit? That’s where the real optimization happens.