Discount-Code & Affiliate Sales MasteryReporting, payouts and protecting integrity · Lesson 7 of 12

Reporting sales correctly: order IDs and proof

Article · 13 min · 8 min lecture

Video lecture

Reporting sales correctly: order IDs and proof

16 chapters · about 8 min · full transcript

Coming soon

Chapter 1 of 16

Reporting sales correctly

  • What a good report contains
  • Proof with privacy
  • Edge cases
  • A self-checking sales log

The narrated lecture is in production

Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.

Chapters

Why accurate reporting matters

When your earnings depend on reported sales, accuracy is everything. Brands and platforms pay out based on data they trust. Accurate, well-evidenced reporting gets you paid faster, builds your reputation, and qualifies you for better campaigns. Inaccurate reporting — even by mistake — can delay payment or trigger investigations.

What a good sales report includes

Follow the specific instructions in each Optimize All campaign brief. In general, a sale report should include:

  • Order ID / order number — the unique identifier from the brand's system.
  • Date and time of purchase.
  • Code or link used.
  • Order value (and currency).
  • Products purchased (if requested).
  • Proof — as specified in the brief, for example a platform-generated confirmation or a screenshot of the order confirmation shared by the buyer with their consent, with personal details redacted.

Protecting buyer privacy

Proof of sale often involves personal data. Handle it carefully:

  • Only collect what the campaign actually requires.
  • Ask the buyer's permission before using any screenshot they send you.
  • Redact names, addresses, phone numbers, emails and payment details unless the brief specifically requires and justifies them.
  • Store evidence securely and delete it when no longer needed.
  • Never post buyers' order details publicly.

Timing and deadlines

  • Submit reports within the campaign window and any reporting deadline.
  • Don't batch everything to the last day — mistakes are more likely.
  • Keep a running log as sales come in.

Handling edge cases

  • Duplicate reports: check your log before submitting; never report the same order twice.
  • Returns and cancellations: if you learn an order was cancelled, update or withdraw your report as instructed.
  • Orders outside eligibility: don't report orders from excluded regions or products.
  • Unclear cases: ask support before submitting rather than guessing.

A reporting checklist

  1. Is this a genuine purchase by a real customer?
  2. Was it made using my code/link within the campaign dates?
  3. Is it eligible under the brief (region, product, customer type)?
  4. Do I have the order ID and required proof, with personal data redacted?
  5. Have I checked it isn't a duplicate?
  6. Am I submitting before the deadline?

Worked example

Usman, a tech creator in Islamabad, receives messages from buyers saying they used his code. The campaign requires order IDs. He replies: "Thank you so much! If you're happy to, could you share the order number? Please don't send your address or phone — just the order number and date is fine." He logs each one, checks for duplicates, and submits them weekly. When one buyer later cancels, Usman updates his report. His payouts arrive without disputes, and the brand invites him to the next campaign.

Mistakes to avoid

  • Submitting estimates as confirmed sales.
  • Reporting orders you "think" came from you without evidence.
  • Editing screenshots — even to "tidy" them — beyond redacting personal data.
  • Collecting more personal data than needed.

Hands-on: a sales log that catches mistakes for you

Set up these columns in Google Sheets or Excel. The formulas flag duplicates, late submissions and ineligible orders before you submit.

order_id,order_date,code_or_link,order_value,currency,country,products,buyer_consent_proof,redacted,eligible_region,eligible_product,duplicate_check,submitted_on,status,notes
PK-100482,2026-09-03,HAMZA10,3600,PKR,PK,Headset X,yes (DM 03 Sep),yes,yes,yes,,2026-09-07,submitted,
PK-100511,2026-09-04,HAMZA10,7200,PKR,PK,Headset bundle,yes,yes,yes,no - bundle excluded,,,not submitted,excluded item
Duplicate check (Google Sheets, in duplicate_check, row 2):
=IF(COUNTIF($A:$A, A2)>1, "DUPLICATE", "")

Deadline warning (assume campaign reporting deadline in cell Z1):
=IF(AND(M2="", TODAY()>Z1-3), "SUBMIT NOW", "")

Ready to submit:
=IF(AND(J2="yes", K2="yes", I2="yes", L2=""), "READY", "CHECK")

A message template to request proof without over-collecting personal data:

Thank you so much for using my code! If you're happy to, could you send
just the order number and the date? Please don't send your address,
phone or payment details - I don't need them. Totally fine if you'd
rather not.

Redaction in practice

  • Crop or blur names, addresses, phone numbers, emails and payment details before storing a screenshot, unless the brief specifically requires and justifies them.
  • Use a simple blur or box tool; never alter the order number, date, value or anything else the platform verifies.
  • Store evidence in one restricted folder, named by order ID, and delete it when the campaign's dispute period ends.

Do and don't

Do log sales as they happen. Do redact personal data. Do update reports for cancellations.

Don't report duplicates or ineligible orders. Don't edit proof. Don't miss deadlines.

Key takeaways

  • Follow each campaign brief's reporting instructions exactly.
  • Include order ID, date, code, value and consented, redacted proof.
  • Log sales continuously, check for duplicates and update for cancellations.
  • Protect buyer privacy: collect minimal data and store it securely.

Check your understanding

Quick questions to lock in the lesson. They don’t count towards your certificate.

  1. A buyer sends a screenshot showing their full name, address and phone number. What should you do before submitting it?
  2. You discover that an order you reported has been cancelled. What should you do?
  3. Which should never be done to proof of sale?

Put it into practice

Create a sales log with columns for order ID, date, code/link, value, eligibility check, proof status and submission date.

Enrol for free to save your progress

Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.