Calculating Confidence Intervals for Google Ad Grants Keywords | CTR Statistical Analysis Nonprofits

Professor Nik Bear Brown explains how nonprofits can use Hoeffding and Wilson confidence intervals to tell whether a low-CTR keyword is genuinely underperforming or just short on data.

5:36 video4 min readWatch on YouTube

Google Ad Grants comes with a hard rule: every keyword in a nonprofit's account needs to maintain a 5% click-through rate, or risk the account being flagged. The problem is that a keyword shown 100 times and clicked 3 times has a 3% observed CTR, but that doesn't necessarily mean its true underlying rate is below 5%. With that small a sample, you could just be unlucky. Professor Nik Bear Brown walks through the statistics that actually answer the question of whether to remove a keyword or give it more time.

The core problem with small samples

An observed click-through rate is just an estimate, and estimates built on small numbers of impressions carry real uncertainty. A keyword that got 3 clicks out of 100 impressions has an observed rate of 3%, but the true rate, the rate you'd see if you ran that keyword for an enormous number of impressions, could plausibly be higher or lower. Removing a keyword based purely on a low observed rate from a small sample risks cutting something that would have performed fine given more data. The fix is to calculate a confidence interval around the observed rate rather than trusting the raw number by itself.

Two statistical methods, two different postures

The video introduces two approaches for calculating an upper confidence bound on the true CTR: the Hoeffding bound and the Wilson score interval. Hoeffding is described as assumption-light, meaning it makes fewer statistical assumptions about the underlying distribution, which makes it safer and wider, particularly useful for tiny sample sizes or extreme click-through rates. Wilson uses a normal approximation instead, and becomes tighter, meaning more precise, once the sample size reaches roughly 30 or more impressions. In practice, Wilson tends to be the more conservative of the two once there's enough data, producing a lower, tighter upper bound than Hoeffding does.

Walking through a real example

Using an interactive calculator built for this purpose, the video runs through concrete numbers: 33 clicks out of 789 impressions. Google's target CTR of 5% doesn't change; what changes is how confident you can be about whether a given keyword's true rate is above or below that target. With an alpha (confidence level) of 5%, meaning a 95% confidence bound, the Hoeffding calculation says it's still reasonably possible, with 95% confidence, that the true click-through rate could be as high as 8.54%. The Wilson calculation, more conservative, gives an upper bound around 5.52%. Since both upper bounds sit at or above the 5% target, the recommendation in both cases is to keep the keyword rather than remove it, because there's still a statistically reasonable chance its true rate clears the bar.

When the numbers say to cut a keyword

The video also demonstrates what a genuinely weak keyword looks like under the same math: a case poor enough that even the optimistic upper bound sits clearly below the 5% target, indicating a true click-through rate around 1%. In that scenario, both Hoeffding and Wilson agree the keyword should be removed, since even the most favorable statistically plausible estimate doesn't reach the required threshold. That's the actual decision rule being taught here: if the upper bound of your confidence interval is still below your target CTR, it's statistically reasonable to remove the keyword; if the upper bound clears the target, give it more time.

Sample size and how fast you can decide

How many impressions you need before you can confidently make a call depends heavily on how far the keyword's actual performance is from the 5% target. A keyword getting essentially no clicks can be flagged for removal after as few as 50 tries. A keyword hovering around 1% CTR takes longer, roughly 80 samples, to build reasonable evidence that it's genuinely underperforming. The closer a keyword's true rate sits to the 5% threshold itself, say a keyword actually performing at 4.8%, the more data is required to distinguish it statistically from the target, and the video notes that a keyword performing at 4.8% is unlikely to draw serious concern from Google in practice anyway, even though technically it doesn't meet the letter of the 5% rule.

A third metric worth knowing, and avoiding here

The calculator also includes a UCB, or upper confidence bound, score, which the video flags explicitly as not a confidence interval at all. UCB is a bandit-algorithm score, combining an estimate with an exploration bonus, and it's useful for choosing what to explore next when you have multiple options competing for attention, such as picking which channel to test. It is not the right tool for the keep-or-remove decision covered here, and is included mainly for theoretical completeness.

Key takeaways

  • Google Ad Grants requires a 5% click-through rate across all keywords, but small sample sizes make raw observed CTR unreliable on its own.
  • The Hoeffding bound is assumption-light and wider, better suited to small samples or extreme CTR values; the Wilson score interval is tighter once sample size passes roughly 30.
  • The decision rule: if the upper confidence bound on a keyword's true CTR is still below your 5% target, it's statistically reasonable to remove it; otherwise, keep it.
  • Very poorly performing keywords can be confidently flagged after as few as 50 impressions, while keywords near the 5% threshold require substantially more data to evaluate confidently.
  • UCB score is a bandit exploration score, not a confidence interval, and shouldn't be used for the keep-or-remove decision.

Try it yourself

Professor Brown built an interactive CTR confidence calculator, available on his site, where nonprofits can plug in their own click and impression numbers and see both the Hoeffding and Wilson bounds calculated automatically. A tool called Givealytics is also being developed to automate this analysis across a nonprofit's full keyword list, letting organizations download all their keywords and get keep-or-remove guidance without doing the math by hand.

Full transcript(auto-generated, with timestamps)

[0:00]It's Professor Bayer here. Um, I'm going to talk about how we calculate. So, what Google wants is all your keywords should have a five through clickthrough five click-through rate. But if you've just, you know, displayed the term 10 times or even 100 times, how do you know the true clickthrough rate is 5%. Maybe you got lucky or maybe you got unlucky. Fortunately, math can help us here. So we are going to calculate some confidence intervals and something called the UCB score. I have a little calculator here for you. So what this does is you put in the number of clicks you got and the number of impressions.

[0:36]So you would expect that you got three clicks from 100 impressions, your click-through rate is uh 3%. However, because this isn't that many impressions, it's possible within a reasonable range for your true um click-through rate to be 15% according to Huffing and 7% according to Wilson, which are two statistical tests. Wilson is typically more conservative than a Hoffingbound and better on smaller sample sizes. UCB is wildly optimistic. So I've included here mainly for theoretical purposes, but I would not recommend using that for this purpose. It's great for other purposes, particularly automatically choosing uh channels to go to if you have multiple choices. Um but the idea here

[1:24]Is you put in the number of clicks you got. Say 33 clicks off of a,000 impressions. And let's take a different number. How about uh 789? Target CTR. probably will never change if you're doing this for Google. Google wants all their nonprofits to have a fivey through click-through rate for all of their keywords and you're going to be monitoring those keywords throughout the whole process. If you allow too many low performing keywords, the MAD activate you or ban ban you. So, alpha means what confidence level you can think of this as a p value. So, alpha of 5% means 95% of the time given this and these are

[2:02]Optimistic. So, we expect it's reasonably possible at 95% chance that our true click-through rate is as high as 8.54%. With the Wilson, it's as high as 552%. And so, then it says keep it, keep it, keep it. However, if it were much worse, it would say to remove it. So, at this point, we're once it says remove it, because these are optimistic calculations, it's a very unlikely average. This is pretty close, but its true rate is almost certainly this is the highest possible. That's the most optimistic estimate of the clickthrough rate and Wilson is much more conservative. So, it's the true to clickthrough rate is around 1%. So, uh

[2:41]That said, I will automate these tools. You can go to this web page here and I'll put this web page in the link and play with it. This is mainly to get people to understand the math. What we'll do is we're going to we have a program called Givealytics and they're creating little tools for this because we have to create them for ourselves. Might as well share them with other nonprofits. But it'll allow you just to download all your keywords and then make decisions of whether to keep it or remove it. So in this case, if this were this poor, we would remove it. If it

[3:13]Were better than that, we would keep it. But this is a way of formally calculating a confidence interval in a in an optimistic way. Meaning what these percentages saying is it's reasonable. It's possible to get something as high as 8.5%. So you should still keep on trying even though the actual rate is 33 out of 789. And the same thing here for for for Wilson. It says both of them say keep it. Wilson is more conservative and so this will typically be lower than that. I have some details on the math here. For example, here another thing to point out here is if it's very poor, like

[3:56]You're not getting any clicks, you can remove it pretty quickly, like only after 50 tries. If you're getting a little bit 1%, it'll take you around 80 uh samples, 80 tries to get a reasonable evidence that this is poor. So the further away it is from 5%. The more confidently that is the fewer samples you need to say well it's not 5% it's not greater than 5%. As you see as it gets closer to 5% if it's like boarding there 4.8%. We may need a lot of samples but then again it's still close. So, if your actual rate is 4.78%. And Google has their 5% thing, I would

[4:37]Be surprised if if they give you a big deal off of something doing 4.8% rather than 5%. But to know whether it's truly 5%, you're going to need bigger numbers as it gets closer. If it's very poorly performing, you can get rid of them fairly quickly and you should. So, we will automate this tool here. This web page is for people just to understand and play with the math. So that's for my classes. So when I teach this math in classes, people can play play with it. This isn't a practical example of using statistics. The question is when should I remove the keyword? And here's the the statistics behind it.

[5:16]Uh the bound Wilson test or UCB which we won't go into because uh we'll use that in other aspects of our give expression. Okay, that's it. Uh share, ring, subscribe, whatever. Plac you later.

More videos

Humanitarians AI Lyrical Literacy Project