Track Brand Deals From First Message to Payment: A Simple System

The simplest way to track brand deals is one spreadsheet with a row per deal and six stages: new, talking, agreed, delivered, invoiced and paid. Record a few numbers on every row, such as the offer, the agreed fee, key dates and campaign clicks, and within a few months you can see your win rate, your average deal value and how long brands take to pay. You don't need a CRM; you need the habit of updating one sheet every time a deal moves.

Key takeaways

• Give every brand enquiry a row, even the ones you turn down, so your numbers reflect reality.
• Six stages are enough: New, Talking, Agreed, Delivered, Invoiced, Paid, plus Lost for deals that don't happen.
• Track five numbers: response time, win rate, average deal value, days to payment and campaign clicks.
• Use a dedicated post or link per campaign so link taps can be counted separately, and keep the brand's own tracking link unchanged.
• Report results back in the format the brand asked for, on the date you promised, with screenshots and honest numbers.
• Your inbox holds the conversations; the sheet holds the status. Use both.

The six pipeline stages

A pipeline is just the list of steps every deal passes through. Naming the steps stops deals from going quiet without you noticing.

1. New. A brand has contacted you, or you've pitched them. Nothing is agreed yet.
2. Talking. You've replied and you're discussing deliverables, dates, usage rights and fee.
3. Agreed. The brief, fee and timeline are confirmed in writing, ideally an email or contract both sides have accepted.
4. Delivered. The content is live, approved or handed over, exactly as agreed.
5. Invoiced. You've sent an invoice with the agreed amount, payment terms and your bank or UPI details.
6. Paid. The money is in your account and matches the invoice.

Add one more outcome, Lost, for deals that end at any point: the brand went silent, the budget didn't match, or you declined. Note a short reason. Over time, those reasons tell you more than the wins.

A spreadsheet layout you can copy

Google Sheets, Excel, Airtable or Notion all work, and the next section compares them. A plain sheet is often the easiest to keep up, so start with these columns.

A few practical tips. Freeze the top row and the Brand column so they stay visible. Use a dropdown for Stage, so nobody types "Payed". Colour rows by stage, and sort by Go-live date every Monday. If a brand deducts tax at source or a fee, record the amount received separately from the fee and ask your accountant how to treat it.

Spreadsheet vs Notion vs Airtable: where to keep your tracker

The first three options can hold the columns above; the last two cover the start and the end of a deal. The facts come from each company's own pages, checked in October 2026. QKAP is our product, and it's included to show where an inbox fits, not as a tracker.

None of these picks up enquiries from your Instagram DMs or email by itself, so the habit of adding a row still matters more than the tool. For a full ranking of these and other brand deal tools, with the criteria we used, see the best brand deal management tools for solo creators.

The numbers worth tracking

You don't need dashboards. Five numbers, updated monthly, tell you whether your brand work is healthy. For the wider set of creator metrics, see the KPIs every affiliate creator should track.

• Response time: days between Date received and Date you replied. Slow replies lose deals that were yours to win.
• Win rate: deals that reached Agreed divided by deals that reached Talking. Use Talking, not New, so spam and obvious mismatches don't drag the number down.
• Average deal value: total paid fees divided by the number of paid deals. Track barter separately so it doesn't inflate the number. It's also the starting point for pricing your next brand deal.
• Days to payment: days between Invoice date and Date paid. This is the number that decides whether you can pay your own bills on time.
• Campaign clicks: link taps from the campaign's post or link, per deal. It's the one number on your side that brands can't see without you.

In a spreadsheet, a formula such as =COUNTIF(I:I,"Paid") counts paid deals in the Stage column, and =AVERAGEIF(I:I,"Paid",G:G) gives the average fee of paid deals. Adjust the column letters to match your sheet.

Measuring campaign clicks with short links and UTM tags

After a campaign, brands want to know what happened after people watched. Clicks are the clearest answer you can give from your side.

1. Ask the brand for their tracked link. Many brands give creators a link with UTM tags or a referral code. Use it exactly as given; changing it can break their reporting. Our guide to UTM parameters for creators explains what those tags do.
2. Give the campaign its own post. On QKAP, create a numbered post for the campaign and add the brand's link as a product or link. Product clicks and the post's click-through rate then show up per post in your analytics, separate from everything else.
3. Share the post's short link. Every QKAP post has a short link, and the copy options add a source tag for Instagram, X, YouTube, WhatsApp or Telegram, so you can see which platform sent the taps. Short links and QR codes covers the details.
4. Note promo code use if the brand shares it. Codes catch buyers who never click a link, but only the brand can see redemptions.
5. Record the numbers on the deal's row on the day you report, so your sheet keeps the history.

QKAP counts taps, not sales on the brand's site, so be clear about that in your report. Free shows the last 7 days of analytics, and Premium adds 30 and 90-day and custom ranges plus CSV export, which helps for campaigns that run longer; see pricing. For what each number means, read our link-in-bio analytics guide.

Reporting results back to brands

A short, honest report makes you easy to rebook. Send it on the date you agreed, usually a few days to a week after the content goes live.

• What went live: links to each post, reel and story, with dates.
• Platform numbers: views or reach, likes, comments, saves and shares from Instagram insights, as screenshots.
• Link taps: clicks on the campaign post or link from your QKAP analytics, with the date range.
• What you noticed: common questions in comments, what people asked in DMs, anything the brand could use.
• What's next: whether the content stays up, and any usage period you agreed.

Don't round up, cherry-pick a flattering date range or leave out a weak story. When your numbers line up with the brand's own data, you build the kind of trust that leads to repeat deals.

Using your inbox views alongside the sheet

The sheet tracks status; the inbox holds the conversation. If you use QKAP's inbox, which is on every plan, brands can send a Partnership, Sponsorship or Collab request from your page with their brand name, website, offer type (paid, gifted product or barter, affiliate or commission, or not decided) and budget, which maps straight onto your sheet's columns. Senders log in with a free QKAP account to write to you and read your replies.

• Star conversations for deals at Talking or Agreed, so active deals sit in one view.
• Archive deals that are Paid or Lost, so the inbox shows only open work.
• Mark unread anything you need to come back to after a shoot.
• Save quick replies for your rate card note, your media kit link and your invoice details. You can keep up to 10, and {name} fills in the sender's first name.
• Export to CSV when you want to check your sheet hasn't missed an enquiry.

The inbox doesn't connect to Instagram DMs or email, so deals that arrive there still need a row added by hand.

Frequently asked questions

What's a good win rate for brand deals?

There's no reliable public benchmark for creator brand-deal win rates, and it depends heavily on your niche, rates and how you count. Track your own rate month by month instead: if it falls after a price rise, you'll see it; if it rises after you improve your pitch, you'll see that too.

How do I chase late payments?

Send a polite reminder the day after the due date with the invoice number, amount and your payment details attached again. If there's no reply within a week, follow up with your contact and ask who in their accounts team handles payments. Agree payment terms in writing before you start, and keep every message in one thread.

Which metrics do brands want after a campaign?

Whatever the brief asked for comes first. Beyond that, brands commonly ask for views or reach, engagement, link taps and promo code use. Send screenshots alongside the numbers and state the date range.

Should I track barter and gifted deals?

Yes. Record the product's value in its own column, along with the deliverables you agreed. It shows how much of your time goes to unpaid work, and it helps when you decide which gifted offers to accept.

Do I need to invoice every brand deal?

Most brands and agencies need an invoice to release payment, so send one for every paid deal. As of October 2026, Zoho says its Zoho Invoice is free for Indian businesses and supports GST invoices; check with your accountant whether you need to register for GST.

Sources

Checked in October 2026. QKAP facts come from QKAP's own product.

• Notion, Brand Deal Tracker for Creators template: notion.com/templates/brand-deal-tracker-for-creators
• Notion pricing: notion.com/pricing
• Airtable plans: support.airtable.com/docs/airtable-plans
• Airtable pricing: airtable.com/pricing
• Zoho Invoice pricing (India): zoho.com/in/invoice/pricing