Open clipping data
5 CSV files of clipping market data are free to reuse under CC BY 4.0, the current ones checked at 23:21 UTC on 5 Oct 2026.
ClipCPM Index
The index by campaign type and platform: the quartiles of live advertised rates per 1,000 views, realized pay on clipping campaigns, and what the index leaves out, one metric per row. The method is on the ClipCPM Index.
| Column | Type | Meaning |
|---|---|---|
checked_at | datetime | When the numbers were read, ISO 8601 in UTC. |
month | month | The month, yyyy-mm. The current month is the month to date, a closed month its close. |
method | text | The method version, clipcpm-v1, stated on the ClipCPM Index page. |
campaign_type | text | clipping, ugc, logo or music, or all. |
platform | text | tiktok, instagram, youtube, x or another platform, or all. |
metric | text | rate_p25_usd, rate_median_usd, rate_p75_usd (advertised rate per 1,000 views), realized_median_usd (budget spent per 1,000 tracked views), realized_rate_median_usd (advertised rate of the same campaigns), realized_share_median (spent per view over the campaign's own rate), live_read and excluded_{reason} (counts). |
campaigns | integer | Campaigns behind the value. |
value | number | The value. USD for a metric ending in _usd, a share from 0 for a share, a count otherwise. |
Boards by month
Each board's public campaigns active in the month and the quartiles of their advertised rates per 1,000 views, by the index method.
| Column | Type | Meaning |
|---|---|---|
checked_at | datetime | When the numbers were read, ISO 8601 in UTC. |
month | month | The month, yyyy-mm. The current month is the month to date, a closed month its close. |
method | text | The method version, clipcpm-v1, stated on the ClipCPM Index page. |
board | text | The board's name. |
board_slug | text | The board's id on ClippingAlpha, as in clippingalpha.com/boards/{board_slug}. |
campaigns | integer | Public campaigns on the board active in the month. |
index_campaigns | integer | Those of them in the index: a public rate per 1,000 views, none left out. |
rate_p25_usd | usd | Lower quartile of their rates per 1,000 views. Empty under 3 index campaigns. |
rate_median_usd | usd | Median of their rates per 1,000 views. Empty under 3 index campaigns. |
rate_p75_usd | usd | Upper quartile of their rates per 1,000 views. Empty under 3 index campaigns. |
Campaigns by month
One row per public campaign active in the month, with the facts its page shows. Regulated campaigns (gambling, prediction markets, crypto trading) are in, flagged. Per campaign rates, budgets and spend are not in the file.
| Column | Type | Meaning |
|---|---|---|
checked_at | datetime | When the numbers were read, ISO 8601 in UTC. |
month | month | The month, yyyy-mm. The current month is the month to date, a closed month its close. |
campaign_url | url | The campaign's page on ClippingAlpha. |
brand | text | The brand behind the campaign. |
campaign | text | The campaign's name, board tags such as [CLIPPING] taken out. |
round | integer | The round of the campaign on its page: a relaunch is round 2. |
campaign_type | text | clipping, ugc, logo or music. |
board | text | The board that lists it. A campaign on two boards is one row, under the board we read it from. |
pay_model | text | cpm, cpm_plus_flat, flat_per_post, pot_split (a CPM auction), contest or retainer. Empty when the board shows no pay model we can read. |
platforms | text | The platforms it pays on, separated by spaces. |
first_seen_at | datetime | When we first saw it on a board, UTC. |
ended_at | datetime | When the round ended, UTC. Empty while it is open. |
regulated | boolean | true for a regulated category (18+ label), else false. |
Launch baseline
The 27 Sep 2026 numbers the index launched with: realized pay and top clips by platform on Content Rewards, from our first full crawl.
| Column | Type | Meaning |
|---|---|---|
checked_at | date | The day of the crawl, 2026-09-27. |
board | text | The board the numbers are from. |
metric | text | realized_median_usd, advertised_median_usd, realized_share_median, top_clips and top_clips_share_{platform}. |
campaigns | integer | Campaigns behind the value. |
value | number | The value. USD for a metric ending in _usd, a share from 0 for a share, a count otherwise. |
License and credit
- License
- Every file is CC BY 4.0. Reuse it with credit to ClippingAlpha and a link to the page it came from.
- Updates
- The current month's files follow the live reading. A month's index and board files freeze when it closes, on the 1st. The baseline file is for September 2026.
- Not in the files
- Clipper handles, post links, members-only campaigns and details, and per campaign rates, budgets and spend, which join once the boards grant redistribution.
Common questions
Can I reuse the data?
Yes. All 5 files are CC BY 4.0, free to reuse with credit to ClippingAlpha and a link to the page they came from.
How often is the data updated?
The current month's files follow the live reading, checked at 23:21 UTC on 5 Oct 2026. A month's index and board files freeze when it closes, on the 1st.
What is in the campaigns file?
One row per public campaign active in the month, 912 campaigns for October 2026 so far, with its board, type, pay model and platforms. 110 regulated campaigns are in, flagged.
Is there personal data in the files?
No. None of the 5 files holds a clipper handle, a post link or a members-only detail.