← Back to Blog
Quick answer

Give each creator post its own stable identifier and row. Track what ran and when. Save the cost, the response, the next step, and the age of the result.

A screenshot can prove a number. It cannot run a sound data system.

Start with the row, not the dashboard

Most creator reports look fine until someone asks a basic question. Which post drove the sign-ups? Were those views paid or organic? Was that result read after three days or 30? Did a blank mean zero, not ready, not shared, or not relevant?

If the team cannot answer, a nicer chart will not help. The source record is broken.

This is the operating standard we recommend at Creators Agency. It is not a law. It is not an official Interactive Advertising Bureau (IAB) standard. It is a practical way to keep the facts that a campaign team needs.

Free creator campaign data kit

The branded workbook has the six linked tabs, set values, example rows, and checks in this guide. All sample values are made up. Replace them before use.

Download the full workbook →

Need a system import? Download the flat comma-separated values (CSV) file or download the JavaScript Object Notation (JSON) Schema.

Use this base rule:

One activation row = one creator, on one platform, for one piece of content, with one first-live time.

That means:

  • One YouTube ad read in one video is one row.
  • A link in the video notes and a link in a pinned comment can share the post row. Each link still needs its own tracking row.
  • One Instagram Reel and three Stories are four rows when they have their own links, times, or results.
  • One podcast host read in four shows is four rows.
  • One organic TikTok that later runs as an ad has one organic row and at least one paid-flight row.

Do not put YouTube + Instagram + TikTok in one platform cell. Do not put three links in one URL cell. If two things can have a different date, fee, right, or result, they should not be trapped in one row.

Use six linked tabs

The workbook should work before the team buys new software. Quality assurance appears in a tab named QA.

TabOne row meansJob
Read MeOne rule or noteSets the row rule, set values, time zone, currency, owner, and last rule check.
ActivationsOne creator postHolds scope, dates, fees, rights, links, and state.
ResultsOne post at one report timeKeeps the early, main, and final reads.
Paid FlightsOne paid use periodKeeps ad spend, bought reach, ad rights, and spend caps apart.
Data DictionaryOne field ruleNames the type, owner, source, pace, math, and limits.
QAOne checkShows a pass, warning, or fix state for bad IDs, dates, joins, and values.

This layout is more useful than one giant sheet. It also maps to a database later.

Fields for the Activations tab

Identity and scope

FieldWhat it meansMain owner
campaign_idA stable key for the full campaign.Brand or lead agency.
activation_idA unique key for this post.Campaign operations.
brand and productSet names for the buyer and offer.Brand.
creator_idA stable creator key, not only a handle.Agency or brand.
platformOne set value, such as youtube.Campaign operations.
formatIntegration, full video, Reel, Story, host read, or another set type.Campaign operations.
angleThe main idea or use case being tested.Brand and creator.
primary_ctaThe main action the brand wants.Brand.

The angle field is easy to skip. Keep it. If a brand runs three posts with one creator, each post should teach the team something. The data must show what changed.

Dates and state

FieldWhat it meansRule
contracted_live_dateThe set date or start of the live window.Use a true date.
actual_live_atThe exact time the post went live.Save the time zone.
statusPlanned, making, sent, approved, live, done, or canceled.Use a set list.
content_urlThe main public or report URL.Test it after launch.
content_removed_atThe time of removal, if any.Do not erase the old row.
timezoneThe time zone for date rules.Set it before launch.

Do not put late June in a date field. That belongs in a note.

Cost and rights

FieldWhat it meansWhy it matters
creator_content_feeThe fee for the base post.Keeps the post cost clear.
paid_usage_feeThe fee for paid use or creator identity.Keeps the new right out of the base fee.
other_creator_feesA rush, extra edit, raw file, or other fee.Lets finance tie back to the deal.
currencyA three-letter code such as USD.Stops mixed money from adding as if it were one unit.
exclusivity_start and exclusivity_endThe category limit.Shows when the creator is blocked from rival work.
usage_start and usage_endThe allowed use term.Helps the media team stop or renew on time.
media_spend_capThe most paid spend allowed.Gives the right a clear limit.

Rights data belongs next to campaign data. If it lives only in a contract file, an ad team can miss the end date.

Keep a new Results row for each read

One post can have many report rows. It may have a one-day check, a seven-day read, a main read, and a later review. Do not let the new row erase the old one.

Field groupSave these factsKey rule
Result contextActivation ID, report ID, as-of time, result stage, rule, source, source file, and reporterA number without a source and age is not ready to compare.
Organic deliveryViews, impressions, reach, watch time, likes, comments, shares, and savesSave native measures and units. Do not force unlike platforms into one field.
TrafficTracked clicks, site visits, and the link ruleThe Urchin Tracking Module (UTM) guide shows how to name each link.
Business pathSign-up, account open, sale, funded account, and a quality checkThe brand must share the steps a creator cannot see.
RevenueAttributed revenue and, only when tested, added revenueDo not call tracked revenue added revenue.

The creator attribution window guide explains when to take each read. Save the rule with the result.

If clicks are weak but people who click buy, the post may need a better hook or call to action. If clicks are strong but sales are weak, check the page, offer, fit, and sign-up flow. The full path keeps the team from blaming the wrong part.

Use this row rule:

One paid-flight row = one activation, one ad account, one run window, one audience plan, and one spend cap.

Save the paid-flight ID, linked activation ID, ad platform, ad account, start and end, spend cap, actual spend, paid impressions, clicks, sales, and paid link name.

Do not add paid views to organic views and call the sum creator reach without the split. The paid media helped cause the paid result. The post fee and the media budget also do different jobs.

A sample that can pass a funnel check

Illustrative example: These values are made up. They show the shape of a sound record. They are not a rate or result benchmark.

FieldExample value
activation_idACT-EXAMPLE-YT-03
actual_live_at2026-07-08T14:00:00-05:00
report_as_of2026-08-07T23:59:59-05:00
result_stagemain
attribution_rule30-day click
organic_views124,000
tracked_clicks2,100
landing_sessions1,870
sign_ups620
account_opens280
funded_accounts96
incremental_revenuePENDING

The path moves in a sane order. There are 2,100 clicks, 1,870 site visits, 620 sign-ups, 280 account opens, and 96 funded accounts. A tool should flag a row where sign-ups are far above site visits. That may be valid due to cross-device use or a data rule. It still needs a note.

A blank is not a status

Use these set values in result fields:

  • 0: The team measured zero.
  • NA: The field does not fit this post.
  • UNAVAILABLE: The field fits, but the source does not give or share it.
  • PENDING: The result is not ready yet.
  • ERROR: A link, import, or source failed.

This rule stops a common error. It keeps a missing value from becoming a zero and making a good post look like a failed post.

Treat the data dictionary as part of the product

Each field needs a plain name, data type, unit, set values, source, main owner, review owner, update pace, math, limits, and last rule check.

Take engagement_rate. The name alone is not enough. Write the math:

engagement_rate = (likes + comments + shares + saves) / organic_views

Another team may use reach as the base. Both can be useful. They should not share one label with no note.

The JSON Schema in the free kit makes set values and field types clear for a system import. It also requires a named study method before a numeric added-revenue field can pass.

Name the owner of each fact

WorkMain ownerOther input
Campaign goal and main resultBrandAgency and creator ask questions.
Scope, fee, and rightsAgency or deal leadBrand and creator approve.
Post URL and live timeCreator or agencyCampaign team checks.
Organic platform dataCreatorAgency can gather and check.
Link recordBrand analytics or operationsAgency sends the exact link.
Site, sales, and user quality dataBrandAgency shares a safe view with the creator.
Paid media dataBrand media teamAgency checks the rights and cap.
File checksOne named data ownerEach source owner fixes errors.

One team should own the file. One person does not need to own each fact.

Creators should see as much useful result data as they want. Some want the full report. Some want a short view. Do not use a low need for detail as a reason to hide facts that can make the next post better.

Report on more than one clock

TimeWhat to updateWhy
Before launchIDs, scope, rights, fees, links, and source ownersFix setup while the team still can.
Within 24 hoursLive URL, time, ad label, and public link testProve the post and link work.
Early readReach, clicks, first steps, and errorsFix a live issue where possible.
Main readMain result through the set windowJudge the first result on the agreed basis.
Later readSlow steps, value, and late viewsLearn what the early read missed.
Month closeFees, paid spend, rights dates, and missing fieldsKeep the full program clean.

Do not call a slow sale a failure after two days. Do not wait 90 days to find a broken link.

Put hard checks in the workbook

Fix these rows

  • An activation ID is blank or used twice.
  • A live post has no URL or live time.
  • A report date is before the post date.
  • A rights end date is before its start date.
  • A money field has no currency.
  • A paid result has no paid-flight ID.
  • Actual ad spend is over the agreed cap.
  • An added result has no named test method.
  • A final report still has a blank or unexplained pending field.

Review these warnings

  • Counts rise as people move down the path.
  • Site visits are far above tracked clicks.
  • Paid impressions exist but paid spend is blank.
  • One link appears on two post IDs.
  • A result has no source file or report link.
  • A metric rule changed during the campaign.
  • A right ends in the next 14 days.

Some warnings will be valid. Ask for a note. Do not erase the row.

IAB work points the same way, but this is not that standard

IAB released Campaign Data Standards 1.0 as a proposed framework in May 2026. The first release covered core ad and goal taxonomies. IAB said a final version was due in the fourth quarter of 2026.

That work matters. It does not turn this schema into an IAB standard. This is a creator campaign record a team can use now. When IAB releases a final version, map the data dictionary and set values where that helps.

Use the record to make the next post better

Brands know the product and their own sales path. Creators know their audience. A useful report lets both sides bring that knowledge to the next post.

If a post does well, a new deal can use a fair base fee plus upside. If a post does poorly, the team can see if the issue was reach, the call to action, the page, the offer, or the fit.

The data should make the work smarter. It should not be saved for a rate fight.

A clean record also makes the brand result report, campaign post-mortem, lift test, and creator marketing mix model much easier to build.

Sources, limits, and update policy

This is a Creators Agency recommendation. It is not a final trade standard. Each brand must adjust the fields for its goal, privacy rules, source access, platform terms, and data stack. The example values in the guide and downloads are made up.

Sources checked July 22, 2026. Recheck this guide when IAB publishes a final campaign data standard or when platform fields change.

Frequently Asked Questions

What is the best influencer campaign reporting template?

It has one clear row rule, stable IDs, set field meanings, source owners, cost and rights data, organic and paid results, report age, and checks. A nice dashboard cannot replace those parts.

What should one activation row mean?

One activation row should mean one creator, on one platform, for one piece of content, with one first-live time. Add a new row when a post has its own link, live time, fee, rights, or result set.

Should creators get conversion data?

Yes, in a safe and useful form. Share the steps tied to the brand's goal. This helps the creator see if the issue was reach, clicks, sign-up, sales, or user quality.

Should paid and organic views be added together?

Keep them apart in the source tables. You can show a total, but show the split too. Paid and organic reach come from different work and cost.

What if a platform does not offer a metric?

Use UNAVAILABLE. Do not use zero. Save the platform's own measure, its source, and the rule used to read it.

Is a screenshot enough for creator reporting?

It can back up a point-in-time value. It does not give you stable IDs, field rules, clean joins, or updates. Save the value in the shared record and keep the screenshot as source proof.

Who should own the creator campaign master file?

The brand or lead agency will often own it. Name one accountable data owner. The creator may own organic source data while the brand owns site, sales, and paid media data.

Is this an official IAB creator data standard?

No. This is the operating standard Creators Agency recommends. The Interactive Advertising Bureau (IAB) released Campaign Data Standards 1.0 as a proposed framework in 2026. Teams should map this record to the final IAB version when it is released and when that map helps.

For brands

Build a record the brand and creator can both trust.

We help brands set up creator programs with clear scope, clean source data, and enough shared context to improve the next campaign.

See how we work with brands →