OpenRights Entertainment Rights & Catalog Intelligence
Data Cleaning beginner

Validate Contract Metadata Before Filing

A 12-field checklist for validating a contract's metadata completeness before it lands in your register. Catch missing term dates, ambiguous territory grants, and orphan exhibits at ingest.

By OpenRights Team · · 7 min read
contractsdata cleaningchecklistvalidation
On this page

Contracts with missing metadata are the single biggest source of downstream pain in rights operations. A term without an end date means you can’t trigger expiry alerts. A territory grant that says “various” means you can’t answer an avails question without pulling the PDF. An MG with no recoupment schedule means royalty calcs have to be redone manually every quarter.

This tutorial is a 15-minute pre-filing checklist. Run it the moment a signed contract lands. Fix the gaps, then file. The cost of fixing a blank term-end field at ingest is five minutes; the cost two years later when you’re auditing a royalty statement is five hours.

The 12 Fields That Matter

Every contract should have these captured structurally (not just as free text):

  1. Licensor — full legal entity name, not a DBA.
  2. Licensee — ditto.
  3. Effective Date — when the grant starts, not when the contract was signed.
  4. Term End — a specific date or a formula (Effective + 7 years).
  5. Territory — a defined list, not “the world excluding certain countries.”
  6. Rights Granted — SVOD, AVOD, TVOD, Linear, Theatrical, etc., each listed separately.
  7. Exclusivity — per-right, per-territory. Don’t collapse.
  8. MG (if any) — amount, recoupment rate, recoupment basis.
  9. Royalty % — per-right if it varies.
  10. Holdbacks — what can’t happen during what window.
  11. Governing Law — jurisdiction for disputes.
  12. Termination Rights — who can walk, under what conditions.

Step 1: Open the Contract Metadata Audit

The matching template ships as a single-contract checklist form. Each row is a field; the Status column flags PRESENT / MISSING / AMBIGUOUS based on what you type in the Value column.

Step 2: Answer Each Field in Order

For every field, you’re looking for three outcomes:

  • Clean — a single unambiguous value. “US”, “2026-12-31”, “Fox Corp.”
  • Ambiguous — the contract says something but it’s not machine-readable. “Major English-speaking territories”, “7 years from availability” (when is availability?).
  • Missing — the contract is silent.

Ambiguous fields are the most dangerous. They look filled in until someone needs to act on them. Always resolve to a concrete value — escalate back to the business-affairs lead if needed, rather than filing an ambiguous row.

Step 3: Log the Ambiguities

Don’t just mark them AMBIGUOUS — write a one-line note about what interpretation you used. Two years from now, when a different person audits the contract, they need to know why “Major English-speaking territories” was recorded as {US, UK, CA, AU, NZ, IE} instead of some other interpretation.

Step 4: Upgrade to the Register

Once every field is PRESENT and unambiguous, add the row to your master Contract Register with Quality Score. The register calculates a completeness score so you can spot-check: if your audit says PRESENT on every field but the register score is below 100, one of your PRESENTs actually maps to a blank cell in the register schema.

Common Issues

  • Exhibits and schedules. Half the contract is in attachments. Capture which schedule each field came from in a “Source” column — some lawyers put territory grants in Exhibit A, others in the body.
  • Amendments. An amended term end date overrides the original. Record both, flag which is current.
  • MFN (“most favored nation”) clauses. These turn a contract from static metadata into a contract that changes when other contracts change. Flag MFN contracts with a dedicated tag; they can’t be set-and-forget.

Download the Template

The Contract Metadata Audit is the checklist. Pair it with the Contract Register with Quality Score to track audits across your whole portfolio.

OpenRights Weekly

Free templates, tutorials, and data quality tips. Every week.

Need help with your catalog data?

Share your challenge and we'll help — by email or callback. 100% free, no sales pitch. Part of our mission to help rights and catalog professionals.

Get Free Help