Blog / Product Brand Operations
Track Creator Content Usage Rights and Expiry Dates
By Keyona Meeks, Founder, ReRev Labs · Oct 31, 2026 · 9 min read
The short answer: Give each piece of creator content one row: who made it, where you use it, when your rights start and end, and whether a written agreement exists. A formula then shows a status: Active, Expiring, Expired, Not started, No end date or No written agreement. A last column says what to do, such as take it down or renew. I tested the formulas in LibreOffice with made-up rows, not in Google Sheets. This sheet tracks dates. It does not tell you what your agreement allows, and nothing here is legal advice. Check with an attorney.
By the end of this post, you'll be able to:
- Set up a sheet that lists every creator asset with its usage window.
- See which content is expiring soon and which has expired.
- Spot assets with no written agreement or no end date.
- Know what to put in front of an attorney.
We sell operations builds for product brands, so weigh this post with that in mind. I am not an attorney. This post covers tracking only.
Why track usage rights at all?
Because the date a creator agreed to is easy to lose. A creator posts a video. You run it as an ad. Months later the agreement ends, and the ad is still running. Or there never was a written agreement, and nobody notices until a creator asks.
The sheet cannot fix a bad agreement. It makes sure a date in a good one does not slip by.
What does the law say about a written agreement?
I looked for an official source first. The U.S. Copyright Act, section 204(a), says: "A transfer of copyright ownership, other than by operation of law, is not valid unless an instrument of conveyance," and the text goes on to say that a note or memorandum of the transfer also qualifies and that it must be signed by the owner of the rights or a duly authorized agent. I read the official govinfo PDF as an excerpt, and it is the 2011 edition of the code. I could not confirm the current wording. Source: 17 U.S.C. 204, govinfo (2011 edition).
That section is about transfers of ownership. A permission to use content is a license, which is a different thing, and I did not research it. I am not an attorney. Whether your arrangement is a license or a transfer, what it covers, and whether it is valid is a question for your attorney and your agreement. The sheet below only asks one question: do you have a written agreement on file, yes or no.
What columns does the sheet need?
Make a tab named Rights with these headings in row 1:
| Column | Heading | What goes in it |
|---|---|---|
| A | Creator | Name or handle |
| B | Asset link | Link to the content |
| C | Where we use it | For example Paid ads, Website, Email, Organic social |
| D | Rights start | The date your agreement says use begins, blank if none |
| E | Rights end | The date it ends, blank if the agreement gives none |
| F | Written agreement? | Type Y if you hold a written agreement |
| G | Agreement ref | Link or file name of the agreement |
| H | Status | Formula |
| I | Days left | Formula |
| J | Action | Formula |
In N1 type Warn days before end and in N2 type 30. That is a setting and my starting number. Pick your own.
Enter dates exactly as your agreement states them. If the agreement says nothing about an end date, leave column E blank. The sheet will flag it. Do not guess one.
If one asset runs in two places, such as a website and paid ads, give it two rows. The terms can differ for each place.
Which formulas do the work?
In row 2:
H2: =IF(A2="","",IF(UPPER(F2)<>"Y","No written agreement",IF(AND(D2<>"",TODAY()<D2),"Not started",IF(E2="","No end date",IF(TODAY()>E2,"Expired",IF(E2-TODAY()<=$N$2,"Expiring","Active"))))))
I2: =IF(OR(H2="Active",H2="Expiring"),E2-TODAY(),"")
J2: =IF(H2="Expired","Take down: "&C2,IF(H2="Expiring","Renew or plan removal: "&C2,IF(OR(H2="No written agreement",H2="No end date"),"Check the agreement","")))Fill them down. The status checks in this order:
- No written agreement if column F is not Y. This comes first on purpose. Nothing else matters if you hold no agreement.
- Not started if today is before the start date.
- No end date if column E is blank.
- Expired if today is past the end date.
- Expiring if the end date is within your warn setting.
- Active for everything else.
TODAY() changes daily, so statuses update when the sheet is opened.
Sort or filter column H each Monday. Expired rows come first.
What did the test show?
I tested the formulas in LibreOffice with nine made-up rows dated around the day I ran it, using a warn setting of 30. A usage window with 200 days left showed Active and 200. A window ending in 20 days showed Expiring with the action to renew or plan removal. A window that ended two days ago showed Expired and the action to take it down. A row with no end date showed No end date. A row with an N in the agreement column showed No written agreement. A row starting in 10 days showed Not started. A window ending in exactly 30 days showed Expiring, and a lowercase y still counted as yes. A blank row stayed blank. I then changed the setting to 10, and the 20-day and 30-day rows moved to Active.
I did not test the formulas in Google Sheets.
Who acts on the flags?
A person. The sheet marks rows and names the action. Someone then takes the asset down, asks the creator about a renewal, or sends the agreement to your attorney. I did not build anything that emails creators or removes content, because a message to a creator or a take-down is a decision with consequences.
If you want a reminder email, decide who should get it. That is your call. Ask the people involved before you add anyone, and do not assume.
What should you take to your attorney?
Bring the agreement and the sheet. Ask the questions the sheet cannot answer:
- What exactly may we use, and where?
- Does the agreement give a start and an end, or neither?
- What happens to old posts when it ends?
- Can we edit the content, or add paid spend behind it?
- Do we need anything else in writing for creators who are minors or work through an agency?
Those are prompts for the conversation, not advice.
Where does an LLM fit in this?
An LLM can help with the messy part: reading a long agreement and pulling out the dates and the places of use into a list for you to enter. A person must check every date against the signed document before it goes in the sheet, because an LLM can misread a clause and sound sure. It should never decide what the agreement allows. The status, the day counts and the actions are plain rules, and they do the same thing every time. My stance: AI writes the code, plain automation runs it, and an LLM shows up only where the input is messy and a person checks the result. For other jobs worth automating next, see what to automate first, and for the thinking behind follow-ups, see the follow-up engine.
How do you test the sheet?
- Enter six made-up assets: one far from its end, one ending soon, one already ended, one with no end date, one with no written agreement, one that has not started.
- Check each status against a calendar and your warn setting.
- Confirm the Action column says what you expect.
- Change the warn setting and watch the flags move.
- Delete the test rows and keep the formulas.
Where this has limits
- Nothing here is legal advice. I am not an attorney. Check with an attorney.
- The law page was an excerpt. It was the 2011 edition, and it covers transfers, not licenses.
- The sheet knows only what you type. A wrong date gives a wrong status.
- It does not read your agreements. A person enters the dates from the signed document.
- The 30-day warning is my starting number.
- I did not use this on live agreements. The formulas were tested in LibreOffice with made-up data, not in Google Sheets.
- No ReRev prices and no promises about results.
If you want help turning this into a system that watches your creator content and flags what needs attention, see our AI operations service or tell us where your agreements live. Do not send creator agreements, contact details, passwords or login details.
Frequently asked questions
How do I track when creator content rights expire?
Keep one row per asset and place of use, with the start and end dates from the agreement. A formula can flag what is expiring.
What if my agreement has no end date?
Leave the end date blank. The sheet shows No end date so you can ask your attorney what that means.
Do I need a written agreement with a creator?
The Copyright Act section I quoted says a transfer of ownership needs a signed writing. Licenses are a different matter. Ask your attorney what your case needs.
Can the sheet email creators or take content down?
No. A person acts on each flag.
Is this legal advice?
No. I am not an attorney. Check with an attorney.
Will it work in Excel?
The functions are standard, but I tested it in LibreOffice, not Excel or Google Sheets.
Read next: The creator outreach tracker runs the step before this one: finding creators and following up until the content exists.