CTR Calculator
Compare observed and hypothetical click rates with explicit sampling uncertainty.
Try before you buy.
- Free preview: counts and a share of real result rows; complete calculations, assumptions and exports open with a pass.
- Locked until you unlock it: download and copy.
- Unlock: Premium pass, ₹799 for 30 days or ₹249 for 1 week, a one-time payment that never renews. Unlock: Premium pass, $19.99 for 30 days or $7.99 for 1 week, a one-time payment that never renews.
Ways to unlock shows how to get the full result.
Printing this result is locked in the free preview.
Computed rows and explicit assumptions
Locked in the free preview. Opens the ways to unlock this result.
Locked in the free preview. Batch runs unlock with a pass.
Locked in the free preview. Query results unlock with a pass.
About the CTR Calculator
Calculate click-through rate or solve clicks/impressions, compare multiple rows and show a 95% Wilson score interval for each whole-count scenario. Keep the requested algebraic rate beside the realized rate after rounding derived counts, and distinguish supplied observations from hypothetical targets.
The free preview shows counts and a share of your real rows. A Premium pass opens the complete calculations and reports; each result stays bound to its current input and assumptions.
How to use it
- Load the example, then replace it with your own CSV or TSV using the shown header. Leave only the field to solve blank where instructed.
- Read each row and its stated formula, assumptions and errors. All amounts must use one consistent currency and time window.
- Compare the complete rows with a pass, then copy or download CSV/TXT/report. Editing, reset, cancel and leaving invalidate the current result.
Examples
name,clicks,impressions,ctr_percent Observed,20,1000, Target,,1000,3 Small,0,10,
0 clicks in 10 impressions gives CTR 0% and a Wilson upper bound about 27.75%; this does not establish a permanently zero rate.
Method and official references
NIST: confidence limits for a binomial proportion describes the metric or channel reference. Fill exactly two of clicks, impressions and ctr_percent. Supplied observed counts must be whole numbers; clicks cannot exceed impressions.
What the result means
Wilson assumes independent binomial observations. A scenario interval is not observed evidence. Tracking errors, repeated users, selection bias and systematic measurement errors are separate from sampling uncertainty.
CTR formula
Google Ads click-through rate uses clicks ÷ impressions × 100. Wilson center = (p + z²/(2n))/(1 + z²/n); half-width = z × sqrt(p(1−p)/n + z²/(4n²))/(1 + z²/n), with z ≈ 1.95996 for 95% confidence.
Limitations
- Wilson assumes independent binomial observations. A scenario interval is not observed evidence. Tracking errors, repeated users, selection bias and systematic measurement errors are separate from sampling uncertainty.
- A maximum 1 MiB text batch protects local memory; it is not a plan or row-count quota. No URL is followed, no Analytics account is accessed, and no exchange rate or observed performance is invented.
Privacy
On this device; its files download once
Your URLs, table cells and assumptions stay on this device. Parsing never follows links. Every complete report export uses the current result gate.
Frequently asked questions
What do I get without a pass?
Without a pass, CTR Calculator shows counts and a share of real result rows; complete calculations, assumptions and exports open with a pass. Until you unlock it, the result can’t be downloaded or copied. A Premium or Ultimate pass, a one-time payment that never renews, unlocks the full result. The pricing page lists the passes and their prices.
How do I compare multiple rows?
Paste a CSV/TSV table with the shown header and one case per row. Tagged links instead use one URL per line. Invalid rows remain explicit and are not reported as calculated values.
Does this prove real campaign performance?
Wilson assumes independent binomial observations. A scenario interval is not observed evidence. Tracking errors, repeated users, selection bias and systematic measurement errors are separate from sampling uncertainty.
What can I copy without a pass?
Your own input stays available. The free preview shows counts and a share of computed rows; full calculations, reports and result exports open with the stated pass.