gclid 90.9% · wbraid 7.3% · gbraid 1.1%. Meta, Reddit and X together: 8 sessions. Google search referrals: 86.
take-back-the-internet produced zero web purchases in nine months — confirmed today on four instruments that share no lineage. But the 527,284 "sessions" are Google ad taps on US phones, not readers: a few hundred people a month demonstrably saw the page. The campaign was bought and judged as awareness, by session count. It met that goal.
HTTP hits in MN's server tracker. 99% carry a Google click ID; 97% US; 25% in-app WebViews.
GA4 (consented, JS-side): 124 users in July, 25 in August. Four times fewer than its homepage coverage.
On the tracker, on GA4 same-session, on GA4 user-level over two months, and in the purchase stream.
Only fragment: Meta April €1,000. Google Ads cost lives in MN's Ads account. Not in the warehouse.
The zero survives every instrument that can see a purchase: MN's own tracker (0 thank-you pages from 228,188 raw sessions since April), Google Analytics same-session (0 of 164), Google Analytics user-level over two months (0 of 139 people ever bought, in any session — the homepage cohort converts at 2.06%), and the purchase stream itself (no 2026 purchase names this campaign; Brand-search and PMax campaigns are named, so attribution works).
What does not survive is the idea that 527,284 people read the page. MN bought roughly 460,000 YouTube and in-app ad taps on US phones for a campaign whose stated objective was awareness and whose reported KPI was session count. Ad taps are counted by a server tracker; most never become a rendered page in front of a person. The 09-02 framing — a magazine whose readers didn't buy — was wrong about the readers. Almost nobody who could buy ever saw it.
Every landing page on the site since 2025-12-01, ranked by sessions. The campaign sits at number two, and it is the only page at this scale with an empty revenue column.
| Landing page | Sessions | Transactions | Revenue |
|---|---|---|---|
| / | 1,366,975 | 12,791 | $248,742 |
| /take-back-the-internet | 527,152 | 0 | $0 |
| /offer | 300,041 | 3,683 | $75,536 |
| app/dashboard/devices | 103,035 | 214 | $3,544 |
| /vpn-pricing | 50,459 | 1,959 | $38,720 |
| app/dashboard/billing | 46,411 | 2,176 | $39,272 |
Sessions run from 8,756 to 115,032 a month. The sales row underneath never moves off zero, including in March when the page took 113,619 visits.
The 09-02 table is a copy of MN's server-side tracker. Everything below is outside that lineage, except the raw tracker itself, read directly.
| Instrument | Lineage | Window | Campaign sessions | Reached pricing | Purchases |
|---|---|---|---|---|---|
| vpn_web_sessions (09-02) | MN tracker, aggregated | 2025-12 → 2026-09 | 527,284 | 424 | 0 |
| MN tracker, raw events | server-side | 2026-04-07 → 09-03 | 228,188 | 107 | 0 thank-you |
| GA4 raw, same session | Google · JS · consented | 2026-07-06 → 09-02 | 164 | 1 | 0 |
| GA4 raw, user-level, any later session | Google · JS · consented | same | 139 people | 11 returned | 0 ever |
| Purchase stream · traffic_source | GA4 purchase events | 2026 | — | — | none name the campaign |
| Subscription sources | MN attribution view | 2026 | — | — | none name the campaign |
Controls on the same instruments: homepage GA4 same-session 3.4%; homepage GA4 user-level 2.06%; homepage Google-click-only sessions in the raw tracker 6.1% reach a thank-you page (97 of 1,594). The session-break explanation is dead — the user-level row follows people across sessions.
228,188 raw campaign-page sessions since April, decomposed.
gclid 90.9% · wbraid 7.3% · gbraid 1.1%. Meta, Reddit and X together: 8 sessions. Google search referrals: 86.
Referrer none 84%, youtube.com 11.5%, Google ad SDK 1.3%. User agents: mobile browser 70%, in-app WebView / Dalvik 25%, desktop 4%.
Top networks are T-Mobile, Comcast, AT&T, Verizon Wireless, Charter — real consumer devices, not datacentre bots.
That is the signature of YouTube and in-app video/display taps — which is what MN said it bought. GA4, which needs the page to render and the visitor to consent, saw 0.26% of these sessions against 1.1% of homepage sessions: the campaign traffic bounces before the page even finishes loading, four times more often than ordinary traffic.
Their own words, in order.
No deck line, Slack message or task ties the campaign to revenue, transactions or cost. The campaign met the KPI it was given. The KPI did not measure what the company needed.
Read live on 2026-09-02 and again today. The ask exists — it is one line inside a magazine.
The page opens on “TAKE BACK THE INTERNET.” over a dark hero, then runs The Restriction Feed — a dated news stream of censorship and surveillance headlines, updating through today — followed by a six-panel editorial essay (identity gating · blocking by default · surveillance by design · platform enforcement · infrastructure control · anonymity removal), each panel structured as the pitch, the drift and the reality check.
Between the feed and the essay sits the only commercial ask
on the page: “Be part of the resistance, quietly”, three product lines, and one
button — Get Mysterium VPN → /vpn-pricing. The link is correctly
targeted. It is one of thirty links on a page whose dominant content is journalism.
A blank in a summed column can mean “no rows” instead of “no sales”. So the claim was tested against a control before it was written down.
| Page class | Rows | Sessions | Rows with tx NOT NULL | Σ transactions |
|---|---|---|---|---|
| homepage (control) | 201,629 | 1,366,975 | 11,751 | 12,791 |
| all other pages | 612,433 | 1,510,735 | 14,340 | 14,176 |
| take-back campaign | 17,470 | 527,284 | 0 | 0 |
The transactions column populates whenever a conversion happens — the homepage proves the mechanism with 11,751 non-null rows out of 201,629. The campaign page has zero non-null rows out of 17,470. The instrument works; the page produced nothing for it to record.
87.7% of every session that landed here arrived on a tracked paid click. Paid traffic ran every month from January to August 2026.
| Channel | Type | Sessions | Transactions |
|---|---|---|---|
| Google Ads · gclid | paid | 373,772 | 0 |
| No paid click · not paid | unpaid | 64,749 | 0 |
| Google Ads (iOS) · wbraid | paid | 50,267 | 0 |
| Meta · fbclid | paid | 35,171 | 0 |
| Google Ads (iOS) · gbraid | paid | 2,396 | 0 |
| Reddit · rdt_cid | paid | 566 | 0 |
| X / Twitter · twclid | paid | 363 | 0 |
| Total | 87.7% paid | 527,284 | 0 |
Same window, same channels, two destinations. If the ads had simply bought bad traffic, the unpaid visitors would still convert. They don't.
Roughly two-thirds of all Google Ads traffic in 2026 — 426,435 sessions — was sent to a page that has never produced a sale, while the third sent elsewhere converts at 1.4%. That is a page-level result, and it rules out “the ads bought the wrong people” as the sole explanation.
Not a checkout that leaks. A journey that never begins.
Sessions here move toward pricing 108× less often than elsewhere. Arithmetically right; as a statement about readers, misleading — the denominator is ad taps (see Verified 09-03). Most of these sessions never became a rendered page. The ratio measures the traffic type, not the page.
Of the 35 blog pages inside the top 80 landing pages, zero are political-theme.
Eleven geo-unblocking how-tos: Snapchat location, YouTube ads, TikTok region, Hinge bans, Fortnite lobbies, Valorant servers, Tinder location.
Not one page on censorship, surveillance, speech or political access appears in the top 80 by organic traffic.
Median 204.23 GB traffic — the governed join of 2026-08-28. A heavy streamer, not the political-safety persona.
The people who arrive want to change their TikTok region. The NFL / streaming instinct in the August marketing deck is the evidenced one, and the site's own top organic pages already prove it. The September target-audience document points away from the customer the data shows.
From Slack (to 08-18), ClickUp (906 family tasks, zero hours tracked), eight 2026 decks and the warehouse. Labels: fact · MN claim · estimate · unknown.
Announced 2025-12-05 · LP live 2026-01-05 · ads 2026-01-07 → August (~8 months) · editorial 2025-12-23 → today, 533 posts.
Meta April €1,000 + a €100 test. Google Ads (~460k taps), Telegraph ×3, Standard.co.uk, i2Coalition: not in any captured source. The Ads cost column is the one ask.
1.9–3.1 person-years across 14 people, a daily core of five. Modelled from counted output (470 articles, 100 banners, 34 weeks of ad ops, 30 recaps); ClickUp logs 0 h.
| Work (count is a fact) | Count | Rate assumed | Hours |
|---|---|---|---|
| Editorial articles written, edited, uploaded | 470 | 3–5 h (AI-assisted) | 1,600–2,665 |
| Daily topic sourcing | ~180 days | 1 h/day | 180 |
| Post images (68 design tasks + heroes) | ~250 | 1–2 h | 250–500 |
| Weekly + monthly recaps, three formats | 30 | 4–6 h | 120–180 |
| Social distribution, daily | ~180 days | 1–2 h/day | 180–360 |
| Paid media set-up (56 to-dos) + weekly ops Jan–Aug | 56 + 34 wk | 2–3 h · 4–8 h/wk | 255–430 |
| Ad banners and size adaptations | ~100 | 2–3 h | 200–320 |
| LP build, CMS, GTM, later UI redo | — | — | 100–140 |
| Management and monthly reporting | 9 mo | 20–25% of a month | 290–360 |
| Partnerships arm (i2C, Telegraph, Standard, listicles) | — | — | 120–200 |
| Total | ≈ 3,300–5,300 |
Calibrated to MN's real payroll (public Sodra registry, fetched 08-16): MN Intelligence UAB — the consumer-VPN entity where marketing sits — pays €3,107 average gross to 13 staff (MN Technologijos, engineering, pays €6,365 to 12). With ~1.8% employer contributions over a ~166 h month that is ≈€19/h, so the campaign consumed ≈€63k–€101k of salary time (band €53k–€152k across the monthly spread and the chance some designers sit in the engineering entity). The LT ring's entire payroll is ≈€113k/month, so this programme spent roughly 0.6–0.9 months of whole-company payroll. Three of the original team left during the campaign (partnerships 02-24, SEO ~03, organic lead ~05).
The target was the traffic it bought.
"Non super technical person who is skeptical about internet restriction, government surveillance" — Slack, 2025-12-05.
| Initiative | When | Channel | Persona fit | Web result |
|---|---|---|---|---|
| Take-back page + awareness ads | Jan–Aug 2026 | Google (YouTube / in-app), Meta, X, Reddit | exact | 527k hits · 0 purchases |
| Editorial programme — 470 articles, Restriction Feed | Dec 2025 → | organic, social | exact — 135 surveillance/ID, 111 censorship, 102 same themes uncategorised, 40 breaches, 35 platform; only 17 touch VPN or privacy tools | 105k sessions · 0; per-post traffic down 20× (median 441 → 25) |
| Recaps + Substack "Cookies Disabled" | Apr 2026 → | Substack, FB, IG, X, TikTok | exact | 25 posts · ~1,000 subscribers · no revenue instrument |
| Reddit staff repost programme | Jan 27 → | Reddit organic | exact | unmeasured |
| i2Coalition / VPN Trust Initiative | Feb 2026 | credibility | exact | badge · fee unknown |
| Censorship Index 2026 research | Apr–Jun | digital PR (published on goproxies.com) | exact | VPN campaign task still backlog |
| /internet-freedom LP | Mar 2026 → | organic | exact | 185 sessions · 0 |
| Summer campaign "Borders belong on maps" + $2.99 | Jun 3 → Jul 15 | Google, Meta, Reddit, email, Standard.co.uk | hybrid | Reddit: 1 web purchase in July, all pages; task notes call it "outperforming by ROAS" — instrument conflict |
| Empire State trend burst "Not hiding, just refusing to be observed" | Jul 3–7 | Reddit, Meta | exact + travellers | CTR/CPC test only |
| Telegraph sponsored features ×3 + code VALUE26 | May–Jul | sponsored print/online | not this persona (travel) | code never appears in the captured coupon table (extract 04-28) |
| Nostalgia / nothing-to-prove LP "Your internet was supposed to feel free" | Aug 17 → | Reddit, Meta | exact | 4,246 sessions · 0 · India 704, Indonesia 167, Israel 127 vs US 1,018 |
| Reddit NG · CI · BJ · BG · GH campaigns ("online income interests") | Aug 2026 | not this persona; tier-3 one quarter after "Tier 3 is not the target" | Reddit 2026 total: 65k sessions · 2 purchases · $29 | |
| Q3-2026 positioning: Digital Protection · UK & Poland · MystNodes "Fight censorship" | Jun 2026 → | strategy | exact, escalated | — |
Not in the family, listed so nothing is missed: Black Friday 2025, the Valnet affiliate network (Aug), Fatjoe reviews (MystNodes), Omnisend retention mails, DeleteMe / WhiteBridge partnerships.
Reddit. MN optimises Reddit campaigns on "ROAS/conversions" in its own task notes; MN's tracker shows Reddit at
2 web purchases in all of 2026 and the nostalgia traffic landing in India, Indonesia and Israel. Either Reddit's pixel
counts app-store installs the tracker cannot see, or the optimisation runs on platform-reported conversions that never became
revenue. Test: Reddit Ads Manager August conversions vs purchase_events.
Three descriptions of the customer exist inside MN today. They do not describe the same person.
Slack #marketing, 2025-12-05: "Non super technical person who is skeptical about internet restriction, government surveillance … We do not know it is our perfect client, but it's the audience we'll be searching for." The September 2026 Target Audience (I) document writes the same person up: 17–50, US · EU · UK · AU, politics and world-news interests, reached on X, Reddit, YouTube, podcasts; pains = censorship & geoblocks, surveillance, platform control, unreliable information. No figure in it is computed from customer rows.
The governed account join (2026-08-28): modal paying cell is US × Apple × yearly, median 583 service days, median $128.92 net, 84.7% active in the last 90 days, median 204 GB/month of traffic — support-silent, telemetry-friction-heavy. Organic acquisition agrees: the top blog entry pages are TikTok region, Snapchat location, YouTube ads, Hinge bans, Fortnite lobbies (93k sessions); zero political-theme pages in the top 80.
The VPN ICP evidence board (3 Sep, a private working room) assessed fifteen candidate customers: eleven tie on weak evidence, none has candidate-level economics, and C12 "recently alarmed by exposure" is the research start by mechanical tie-break — research only, no launch. The stated persona maps onto C01b "blocked news and perspective seekers" and the privacy candidates: all at need weak · reach weak · economics none.
| Question | Stated persona (1) | Measured payer (2) |
|---|---|---|
| Why they want a VPN | Censorship, surveillance, being judged for opinions | Change a TikTok / Snapchat / Tinder region; watch what is geo-blocked; unblock a game lobby |
| Where they are found | X, Reddit, YouTube, podcasts, news apps | Google search (brand and generic VPN), Bing, affiliates; the app stores |
| What the site attracts | Zero political-theme pages in the top 80 organic entries | Eleven geo-unblock how-tos: 93,027 sessions |
| Tested at scale? | Yes — this campaign, nine months, 0 purchases | Yes — every purchase the paid book made in 2026 (Brand search, PMax, offer pages) |
| Tolerance for the product's current defects | Low: the 09-02 runtime tests recorded the client failing open (direct ISP address exposed within 3 s, 45 s window, no kill switch in that configuration) — disqualifying for a political-safety customer | High: survivable for a streaming customer |
The ICP board's honest status is "no winner yet." This campaign supplies the one large experiment the board did not have: the stated persona was given the site's second-biggest door, ~460,000 paid taps and 470 articles for nine months, and produced no purchase on any instrument. That does not close the persona; it prices it. It is a new-segment acquisition bet — to be costed as acquisition, not assumed as a description of the existing base — and it should be sequenced behind the protection-truth work the runtime tests call for, because it is the one customer for whom the current defects are disqualifying. The customer the data already shows is being acquired today, cheaply, by Brand search and offer pages; the question the ICP work still has to answer is whether that customer can be recognised before purchase.
The obvious objection to everything above is that something is broken — the tracking, Google Ads, the agency, the whole web funnel. It isn't. In the same account, the same months, the same table, MN's Google budget split two ways:
| Google Ads destination · 2026 YTD | Sessions | Transactions | Revenue | Conversion |
|---|---|---|---|---|
| take-back page | 426,425 | 0 | $0 | 0.000% |
| offer / deal / pricing pages | 213,985 | 2,931 | $62,996 | 1.370% |
| other pages | 5,061 | 157 | $4,056 | 3.103% |
Two-thirds of MN's 2026 Google clicks went to the page that returned nothing. The third that went to offer pages returned $63k. The tracking works, Google Ads works, and MN knows how to run a converting campaign — the variable is the destination and the message, nothing else.
Paid conversion by page group, 1 January – 31 August 2026.
| Page group | Sessions | Paid sessions | Transactions | Paid conv. | Revenue |
|---|---|---|---|---|---|
| Persona / awareness family take-back · 470 editorial articles · /internet-freedom · nothing-to-prove | 633,933 | 465,464 | 0 | 0.000% | $0 |
| Offer / deal / pricing pages | 427,361 | 370,428 | 5,537 | 1.082% | $116,797 |
| Homepage | 1,283,412 | 810,803 | 11,316 | 0.039% | $224,481 |
| Other blog — geo-unblock how-tos | 308,652 | 254 | 36 | — | $904 |
| Everything else — app, checkout, downloads | 505,153 | 8,450 | 7,070 | — | $134,761 |
The purchase stream even names the winners: "search — Brand — BE/CA/FI/DE/IT/NL/CH/NZ" (58 purchases), "search — Brand — FR" (39), "search — Brand — US" (22), "PMax — US (ROAS) web purchase" (15 across variants). Brand search and PMax sell. Awareness does not.
Had those 426,425 Google sessions been pointed at the offer pages instead, at the rate the same account achieved in the same months, they would have produced ≈5,800 transactions ≈ $125k. Assumption named: awareness-intent clicks would not convert like offer-intent clicks, so $125k is the ceiling; the floor is $0. The media spend itself is still unknown either way.
Origin, campaigns, cost ceiling, and share of every sale MN made in 2026.
Google Ads 2,931 · Microsoft 604 · Impact affiliate 421. Meta 25, Reddit 2.
3,402 of the 4,009 land on /offer.
GA4 names a campaign for 176 of 4,424 paid purchases. 73% of those are Brand search.
Company-wide; 24.8% of the web door. ~86% arrive with no paid click.
Paid-click purchases on offer / deal / pricing pages, 1 Jan – 31 Aug 2026 · $85,711 first-purchase revenue.
| Channel | Paid sessions | Purchases | Revenue | Share |
|---|---|---|---|---|
| Google Ads · gclid + gbraid | 196,092 | 2,931 | $62,995 | 73.1% |
| Microsoft Ads · msclkid | 9,284 | 604 | $9,856 | 15.1% |
| Impact affiliate · irclickid | 38,437 | 421 | $10,997 | 10.5% |
| Meta · fbclid | 45,396 | 25 | $1,099 | 0.6% |
| Omnisend email | 429 | 14 | $402 | 0.3% |
| CJ affiliate | 487 | 12 | $334 | 0.3% |
| Reddit · rdt_cid | 50,104 | 2 | $28 | 0.0% |
Read the bottom rows twice: on offer pages — pages whose whole job is to sell — Meta bought 45,396 sessions for 25 purchases and Reddit 50,104 for 2. Paid social fails on the selling pages too, not only on the awareness page. Note what this does not say: the take-back campaign itself was 92.2% Google Ads (426,435 of 462,535 paid sessions), 7.6% Meta, 0.2% Reddit and X. It was a Google buy with a small Meta tail — never a social campaign.
Marketing.purchase_events is the only surface carrying campaign names.
| 2026 purchases in GA4's purchase stream | Count | Share |
|---|---|---|
| carrying a paid medium — i.e. attributable to a campaign | 176 | 1.0% |
| (direct) | 10,399 | 59.9% |
| campaign name NULL | 6,029 | 34.7% |
| organic | 735 | 4.2% |
| referral | 28 | 0.2% |
| Total | 17,369 |
The session tracker sees 4,424 paid-click purchases in the same window. GA4 names a campaign for 176. ~96% of the paid book is invisible in the surface where campaign names live — so the take-back zero could not have been caught from the reporting in use: in that view the entire paid business looks like a couple of hundred sales a year.
Of the 176 that are named, 129 — 73% — are Brand search ("search – Brand – US / UK / FR / BE-CA-FI-DE-IT-NL-CH-NZ"): people typing Mysterium VPN into Google, i.e. demand the brand already created. The rest is generic VPN search and PMax. Not one named campaign is an awareness or persona campaign.
Denominator split by revenue_type so automatic renewals are not counted as sales marketing won.
| 2026 YTD denominator | Purchases | Revenue | Paid marketing's share |
|---|---|---|---|
| New purchases, company-wide | 32,733 | $613,601 | 13.5% · 15.6% of revenue |
| — of which on web gateways (Stripe · CoinGate · PayPal · Adyen) | 17,813 | $359,359 | 24.8% · 26.6% |
| — of which in the app stores (Apple · Google, no click id possible) | 14,920 | $254,242 | — |
| All acquisition (New + New/History + Winback) | 41,216 | $747,401 | 10.7% · 12.8% |
| Every purchase incl. recurring renewals | 80,460 | $1,282,892 | 5.5% · 7.5% |
All paid web marketing returned $95,599 of first-purchase revenue on 4,424 purchases — $21.61 per acquired purchase; Google Ads alone $67,051 / 3,088 = $21.71. If MN's blended Google CPA exceeds ~$21.71 it loses money at purchase one and depends on renewals to pay back. At the governed median LTV of $128.92/account those 4,424 acquisitions are worth ≈$570k over full life [rough], so a CPA up to ~$100 could still defend itself. Between $21 and $100 the answer flips on renewal rate — only the Ads cost column decides it.
Paid marketing's entire measurable contribution to MN in 2026 is $95,599 of first-purchase revenue. The take-back campaign consumed two-thirds of the Google Ads traffic in that same year and contributed $0 of it. And three-quarters of what paid marketing did earn came from Brand search — capturing demand the brand already had, not creating any.
Spend is still unknown. Its size can be bracketed; its source is a fact on the public record.
| take-back Google clicks · 426,435 | at €0.10 | at €0.25 | at €0.50 |
|---|---|---|---|
| Estimated media cost — market benchmarks, not MN data | €42.6k | €106.6k | €213.2k |
€0.10–0.50 is the ordinary band for YouTube / display / in-app inventory, and it brackets MN's own single disclosed target (Meta awareness at ~€2.50 CPM lands at €0.25–0.50 per click at 0.5–1% CTR). So the Google buy plausibly ran €40k–215k, central ≈€105k. For contrast the offer-page buy, with its expensive search slice, brackets to €120k–350k and returned $62,996 — on these benchmarks both halves of the account lose money at first purchase; take-back is simply the half that returned nothing at all. Every figure in this paragraph is an estimate and dies the moment the Ads cost column is read.
FY2025, both LT entities. Payroll is ≈€113k — so ≈€170k/month is non-payroll: node payouts, processor fees, ads, tools, intercompany.
Combined equity −€784k; liabilities €1.82M, which the filings and the all-hands corpus both read as group/intercompany funding.
All paid web marketing, first-purchase revenue, the whole of 2026 — against a media buy bracketed in the same order of magnitude.
MN buys ads out of funding — the ring runs at a loss carried by €1.82M of intercompany liabilities, as the 2023 all-hands stated: "majority of the expenses are covered from the allocated project budget … company capital." The spend line lives in Google Ads, outside the warehouse. The revenue line lives in the warehouse, outside Google Ads. No report in the company joins them — which is the same instrumentation gap that let a nine-month zero pass unremarked.
State them wherever the figures go. Two of them are load-bearing.
google_ads_campaign field is NULL); the raw tracker starts 2026-04-07, so January–March
rest on the aggregated copy alone.Both are MN-side asks. Neither changes the measured result.
What did Google Ads charge for ~460,000 taps, by month? Nothing in the warehouse, Slack, ClickUp or the decks carries it except one fragment — Meta, April, €1,000. Any total quoted before MN's Google Ads account is read is an estimate. The ask is one screenshot of the campaign cost column, by month.
Does MN pay for radsid? Sources eu.effic.pro,
us.effic.pro, us.macly.co, eu.bestteam.club,
eu.traff.world carry 1,592,984 sessions, 6 transactions, $0 — traffic-arbitrage
inventory, roughly 16% of all sessions in the file. Unrelated to this campaign, and bigger.
Batches C (09-02), D (09-03, eleven files) and E (09-03, four files); sha256 in the manifest. Aggregates only.
Written analyses: CONTEXT/2026-09-02-takeback-campaign-attribution-result.md ·
CONTEXT/2026-09-03-takeback-zero-verification.md · CONTEXT/2026-09-03-takeback-full-dossier.md.
traffic_source reads 75% (direct)/(none) and 24% null
on purchases — it cannot answer a source question. claude.vpn_web_sessions carries
landing_page, so the campaign is measurable by entry page instead, which is the
stronger instrument.
C1 · 2026-09-02T143230Z-C1-landing-pages-since-2025-12.csv
sha256 4292ef210a11dd504fdf887fd219bb7a4b98320a6aca82063dcbbf16c528c6f4
one row per landing_page, 2025-12-01 onward, top 80 by sessions
C2 · 2026-09-02T143230Z-C2-nullcontrol-takeback-vs-homepage.csv
sha256 5a975176082e9ceaa1d5e370690ecdc997234826fc459412f1b9cc26ee7365c0
one row per page class — the NULL-vs-zero control
C3 · 2026-09-02T143230Z-C3-takeback-monthly.csv
sha256 c41668f93669e40b9919bee2351d79fc08d9e217ebc58416ffdedcdef3984290
one row per calendar month, 2025-11 onward
C4 · 2026-09-02T145900Z-C4-takeback-by-channel.csv
sha256 3d2fbcc93d8a8d3595718a1293146591e26417cb5138af4338f58212798f337d
one row per channels_type on the campaign page
C5 · 2026-09-02T145900Z-C5-takeback-paid-monthly.csv
sha256 0c32df95d7e36ba84fa144fa0145cdf39d3c52650178fa9aca270e1bbf3dc278
one row per month, paid vs unpaid split
C6 · 2026-09-02T145900Z-C6-paid-split-samewindow.csv
sha256 cf95ead163d233b090e3a614276ecff47037375d6787114062b9b08c23554a27
channel × destination, same window 2026-01-01 → 2026-09-02
C7 · 2026-09-02T145900Z-C7-funnel-depth.csv
sha256 cda155f60268609cf910656d9309b9ceab0b9c686f8420065ea7a20a24121fe2
destination × funnel step
Files ~/Claude/Projects/Kairos/CONTEXT/warehouse/
Manifest CONTEXT/warehouse/MANIFEST.md § Batch C
Written analysis CONTEXT/2026-09-02-takeback-campaign-attribution-result.md
SELECT
CASE WHEN landing_page = 'https://www.mysteriumvpn.com/take-back-the-internet'
THEN 'take-back campaign'
WHEN landing_page = 'https://www.mysteriumvpn.com/'
THEN 'homepage (control)'
ELSE 'all other pages' END AS page_class,
COUNT(*) AS rows_,
SUM(no_sessions) AS sessions,
COUNTIF(transactions IS NULL) AS rows_tx_null,
COUNTIF(transactions IS NOT NULL) AS rows_tx_notnull,
COUNTIF(transactions > 0) AS rows_tx_positive,
COALESCE(SUM(transactions), 0) AS tx_sum,
ROUND(COALESCE(SUM(revenue), 0), 2) AS rev_sum
FROM `mysterium-bq.claude.vpn_web_sessions`
WHERE session_start_date >= '2025-12-01'
GROUP BY 1Frozen evidence page, dated 3 September 2026. Every figure was read from the named result files at build time. A later measurement supersedes this page with a newer dated one; it does not edit it.