Reporting
Creator campaign reporting: KPIs, engagement rate, cost and ROI
Creator campaign reporting is not about the dashboard with the most numbers. A good report shows what has actually been measured, which metrics serve the campaign objective and which conclusions the data can support. Engagement rate, creator performance and ROI only mean something when the data source, the denominator and the cost and revenue scope are written down.
Short answer
Quick answer: what should a creator campaign report include?
A KOL or KOC campaign report should separate five layers: delivery, performance, cost, conversion and revenue, and data quality. Never turn a missing value into zero, always name the denominator behind an engagement rate, and do not call a ratio built on booking fees alone the campaign's ROI if other costs are left out.
- Delivery: who posted, post URL, publish date
- Performance: views, reach, impressions, engagement where available
- Cost: booking fee, product, commission and other included costs
- Conversion: clicks, orders, revenue when attribution is defined
- Data quality: source, capture time, missing metrics
1. What is a creator campaign report?
A creator campaign report brings together delivery, performance, cost and business results across the KOC, KOL and creator bookings in one campaign. It should answer four questions: what was delivered, which creators produced strong signals, where the money went, and which conclusions the data genuinely supports.
A report is not just a total views figure. If twenty creators were booked and twelve have posted, the reader needs to see delivery status before reading performance. If revenue is only tracked for the creators who had a coupon or affiliate link, the report must say so.
- Delivery
- Creator performance
- Campaign cost
- Conversion and revenue
- Data completeness
The workflow before reporting: the 7-stage KOC booking pipeline
2. Keep missing data separate from zero
Zero means the metric was measured and the result was zero. A dash, a null or a “not yet available” state means the team does not have the value. The two are never interchangeable.
Example: a creator has posted but has not sent insight screenshots. Impressions are “not available”, not zero. If the dashboard silently turns blanks into zeros, average impressions, engagement rates and every aggregate ratio drift downward.
- 0 = measured, and the result is zero
- — or null = not available or not entered yet
- N/A = the metric does not apply
- Never infer one metric from another without a defined rule
3. Choose KPIs that match the campaign objective
No single KPI set fits every creator campaign. Awareness, UGC production, traffic and conversion serve different goals, so the report has to prioritize different metrics.
Put a few primary KPIs tied to the objective at the top, then the diagnostic metrics below. Showing everything from likes to revenue at the same level tempts the team to optimize for whatever is easiest to collect rather than what matters.
- Awareness: reach, impressions, views where available
- Engagement: likes, comments, shares, saves, or total engagement as defined
- Traffic: clicks and landing sessions when tracked
- Conversion: orders, leads, revenue when attribution exists
- UGC production: assets completed, approval time, assets ready for reuse
4. Views, reach and impressions: what is the difference?
Views generally count how many times a video or post was watched, under each platform's own definition. Reach generally counts unique accounts that saw the content. Impressions generally count total times the content was displayed, so one person can create several.
Platforms define and display these metrics differently. When you combine TikTok, Facebook, Instagram and YouTube in one report, keep the original metric name and its platform rather than assuming a view on one platform equals a view on another.
- Views are not reach
- Reach is not impressions
- Do not rename metrics just to make the table look uniform
- Record the source platform and capture time
5. How should you calculate engagement rate?
Engagement rate has no single universal denominator. You can divide by followers, reach or impressions depending on the objective and the data you actually have, but the formula must be written on the dashboard or in your metric definitions.
The numerator needs a definition too. Some teams count likes, comments and shares; others add saves. Use one definition consistently within a report, and never compare rates calculated with different formulas.
- ER by followers = total engagements / followers × 100%
- ER by reach = total engagements / reach × 100%
- ER by impressions = total engagements / impressions × 100%
- State which interactions count as engagement
- Never mix denominators in one creator ranking
6. Compare creator performance in the right context
A creator with more followers does not automatically deliver better results. When comparing creators, look at audience size, content format, campaign objective and booking cost together.
A KOC with fewer views but a lower fee and more tracked orders may suit a conversion objective better. A larger KOL with high reach and no conversion tracking can still be the right choice for awareness. The report should make these trade-offs readable rather than produce a “top creators” table ranked on one metric.
- Audience size
- Format and platform
- Campaign objective
- Booking cost
- The performance metric that fits the objective
- Data completeness
7. Break campaign cost into layers
The creator fee is only one part of the cost. Depending on the model, a campaign may also include product samples, shipping, commission, paid amplification, production support, platform fees or agency fees.
Not every report needs every cost. But if cost feeds an efficiency or ROI figure, the report must state which costs are included. When the cost scope differs between campaigns, their results cannot be compared as if the formula were identical.
- Booking fee
- Product or sample cost, if in scope
- Shipping and fulfillment
- Affiliate commission
- Paid media or amplification
- Agency or production cost, if required
- Other recorded costs
8. Name every cost-efficiency formula
Cost metrics help compare distribution or conversion efficiency, but only when the denominator is measured consistently. If impressions are missing, CPM should not show zero, and it should not be quietly calculated from views instead.
Name metrics after the data they use: cost per view, cost per engagement, cost per click, cost per order. If “cost” includes only creator fees, label it, for example “booking-fee CPV”, or note the scope at report level.
- CPM = included cost / impressions × 1,000
- CPV = included cost / views
- CPE = included cost / engagements
- CPC = included cost / clicks
- CPO or CPA = included cost / orders or conversions
- Do not calculate when the denominator is zero or missing
9. Revenue and attribution need a named source
Revenue should only be attached to a creator or booking when the team knows where it came from: an affiliate link, a coupon code, a tracked landing page, TikTok Shop or Shopee affiliate data, or another defined attribution method. If the source is uncertain, call it “recorded attributed revenue”, not “total revenue from the creator”.
Attribution has limits. A viewer can watch creator content and buy later through another channel your system never connects to the creator. The report should separate revenue recorded under the current attribution rule from the creator's full business impact.
- Revenue source
- Attribution window, if defined
- Coupon, affiliate or UTM reference
- Direct versus assisted conversion, if your system tracks it
- No conclusions beyond what the tracking covers
10. How to calculate and label creator campaign ROI
A common ROI formula is (attributed revenue − included costs) / included costs × 100%. The result is only meaningful when the report states which attributed revenue and which included costs went into it.
If you divide revenue by creator booking fees alone, that is a revenue-to-booking-cost ratio, a useful internal indicator, but it is not net profit. Product cost, fulfillment, discounts, paid media and overhead may all still be outside the formula.
- Scoped ROI = (attributed revenue − included costs) / included costs × 100%
- Revenue-to-cost ratio = attributed revenue / included costs
- State the denominator
- Revenue is not profit
- Do not present booking-fee ROI as net profit
11. Aggregate campaign data without distorting it
Total views or total revenue can be summed when the metrics share a definition and scope. An average engagement rate, however, should not simply be the mean of each creator's rate, because exposure varies widely between creators.
For a campaign-level rate, it is usually safer to divide the summed numerator by the summed denominator, provided every record uses the same formula. Example: total engagements divided by total reach, counting only bookings with valid reach data. Show the coverage next to it, such as “8 of 10 bookings have reach data”, so readers know how much the figure rests on.
- Aggregate only metrics with the same definition
- Use summed numerator and denominator for campaign rates
- Show bookings with data out of total bookings
- Keep missing records out of the denominator instead of counting them as zero
- Split by platform when metrics are not compatible
12. Data freshness: when were the numbers captured?
Creator performance keeps changing after a post goes live. A screenshot taken after 24 hours and one taken after 30 days are not the same snapshot, and comparing them without a capture date misleads.
Choose capture points that suit the campaign, for example an early snapshot and a final snapshot, or at minimum record “captured at” for every number. This matters most when creators publish on different days.
- Actual publish date
- Metrics captured at
- Snapshot window
- Source: creator screenshot, platform export or manual entry
- Final or still updating
13. A creator campaign report table you can use today
At booking level, start with the columns below. Do not force every metric onto one screen; group them into Delivery, Performance, Cost and Conversion so readers can check each part.
At campaign summary level, aggregate only metrics with enough coverage and a clear definition. Show missing fields as missing instead of hiding them.
Example: a launch campaign with ten TikTok KOCs. The summary shows delivery first (how many have posted, with URLs), then views and engagement for posts with data, labeled with the capture date. Revenue appears only for the creators with affiliate links, with the note “attributed revenue, affiliate-tracked creators only”. ROI is shown as scoped ROI with its included costs listed underneath.
- Creator and booking
- Platform and post URL
- Publish date
- Views, reach, impressions
- Engagements and the ER formula used
- Clicks, orders, revenue if tracked
- Booking fee and other included costs
- Efficiency metrics
- Data source and capture time
- Missing-data status
14. Connect reporting to the booking workflow, and turn it into decisions
Reporting should not live in a sheet cut off from operations. Post URL, actual publish date, fee, deliverables and payment status already exist in the booking workflow; reuse them instead of asking the team to retype them. When a metric is missing, the report should create a next action with an owner: request insights from the creator, verify coupon data, add an invoice or check the post is still live.
A useful report leads to decisions: which creators to rebook or scale, which need more data before judging, which campaigns are spending inefficiently and what to track better next time. When the data cannot support a conclusion, say so. “Not enough data yet” is a valid result and far better than forcing a number into every cell.
- Reuse booking data instead of re-entering it
- Give every missing metric an owner and a due date
- Creators to rebook, scale or retest
- Campaigns needing cost, format or tracking changes
- Process fixes before the next campaign
Back to the 7-stage KOC booking pipelineSet reporting requirements up front in the creator brief
FAQ
Frequently asked questions
Which KPIs should a creator campaign report include?
Choose KPIs from the campaign objective. Awareness campaigns can prioritize reach, impressions or views; engagement campaigns can use interactions and engagement rate. Use clicks, orders or revenue only when attribution is clearly defined.
How do you calculate a KOL or KOC engagement rate?
Divide total engagements by followers, reach or impressions and multiply by 100%. There is no single correct denominator, so state which one you used and which interactions count as engagement, then apply it consistently.
Should blank cells in a report count as zero?
No. Zero means the metric was measured and the result was zero; a blank or null means the data is not available yet. Mixing the two distorts averages, rates and every aggregate figure.
How do you calculate creator campaign ROI?
A scoped formula is (attributed revenue − included costs) / included costs × 100%. State which revenue was attributed and which costs were included. If only booking fees are used, do not present the result as net profit.
Are views and impressions the same thing?
No. They measure different things, and each platform defines them in its own way. In cross-platform reports, keep the original metric name and source rather than treating them as equivalent.
Should creators be ranked by engagement rate alone?
No single metric fits every objective. Read creator performance together with audience size, format, campaign objective, booking cost, conversion data and how complete the data is.
