Click-through rate vs conversion rate: compare the same records
A reanalysis of 55,357 historical crowdfunding records shows what changes when you connect the click and investment flags, instead of reading their totals separately.
Original reanalysis of the public bettervest newsletter dataset released by Hornuf and Siemroth in 2023.
Abstract
A click rate and an outcome rate describe different actions. To understand their relationship, you need to check which records contain both. We reanalyzed 55,357 recipient–newsletter records from a German crowdfunding experiment published in 2023. Of 611 records with a project investment flag, 327 also had a newsletter-click flag: 53.52%. The other 284, or 46.48%, did not.
The result gives businesses and creators a concrete reason to examine the overlap behind a campaign report. It does not show that tracking failed or that email caused an investment. The released records do not establish the order of events or a shared measurement window. We show the complete four-way comparison, all ten newsletters, and a template for defining a business’s own linked measurement before interpreting a funnel.
Imagine a creator reviewing a workshop launch. One report shows newsletter clicks. Another shows registrations. Both totals are real, but placing them next to each other does not tell the creator how many registrations belong to the people who clicked.
The missing calculation is the overlap. It can be modest or large, and the two headline totals do not determine it. A public crowdfunding dataset lets us demonstrate that calculation using actual records, while keeping the practical question separate from claims the data cannot support.
Two totals need a connection

What is the difference between click-through rate and conversion rate?
A click-through rate reports clicks relative to a stated opportunity to click. A conversion rate reports a defined outcome relative to a stated base. The base might be ad impressions, delivered messages, visits, clickers or another eligible group, depending on the report. The useful comparison starts by naming both the action and its denominator.
For example, “registrations among people who clicked” asks a different question from “registrations among everyone sent a message.” A report can use either definition, but the label needs to tell the reader which one it means. A click is also different from a unique person who clicked; repeated events can change the total.
In this study, the common base is a recipient–newsletter record in the released dataset. We count whether that record contains a click flag and whether it contains an investment flag. We do not have a delivered-message denominator or a timestamped sequence, so we call these recorded rates and overlap shares.
That distinction is useful when a business decides whether to change its message, its offer or its measurement. Two separate totals cannot identify the point where an individual stopped. Linking eligible records is a step toward answering that question; establishing the order and timing of events is another.
What did the crowdfunding dataset measure?
Researchers Lars Hornuf and Christoph Siemroth worked with bettervest, a German debt crowdfunding platform. Their experiment compared different ways of describing ten investment projects in newsletters. The released dataset contains 55,357 recipient–newsletter records and 7,864 recipient codes. A recipient can appear in as many as ten newsletters.[1][2]
The authors recorded whether the recipient clicked a unique project link in a newsletter and whether that recipient invested a positive amount in the project. Each outcome is stored as a yes-or-no flag. An investment flag is not a count of transactions, a purchase value or a measure of completed ecommerce sales.
The original paper examines the effects of newsletter framing. Our reanalysis asks a different question: how much do the two recorded outcomes overlap for the same recipient and newsletter? We pool all three original treatment groups and retain the complete released sample. We do not re-estimate the framing effects.
These are historical records from a specific crowdfunding platform, released in 2023. The reviewed materials do not establish a common observation window or the order of clicks and investments. The study therefore supplies a measurement example, not a current email marketing conversion-rate benchmark.
How often did a click and an investment appear together?
A recorded click and investment appear together in 327 of the 55,357 records. Another 1,499 records have a click without an investment flag, 284 have an investment without a click flag, and 53,247 have neither. The table keeps all four possibilities visible.
Across the complete file, 1,826 records have a click flag, or 3.30%. A total of 611 have an investment flag, or 1.10%. Those are the two marginal rates. They say how common each flag is, but not how often the flags belong to the same records.
The complete click–investment overlap
All 55,357 recipient–newsletter records in the historical bettervest release, published in 2023.
| Recorded combination | Records | Share of all records |
|---|---|---|
| Click and investment | 327 | 0.59% |
| Click only | 1,499 | 2.71% |
| Investment only | 284 | 0.51% |
| Neither flag | 53,247 | 96.19% |
Among the 611 investment-flagged records, 327 also have a click flag. That is 53.52%; the remaining 46.48% have no recorded click. Turn the question around and the denominator changes: among the 1,826 click-flagged records, 327 also have an investment flag, or 17.91%.
Both percentages are correct because they answer different questions. The first starts with investment records and asks about clicks. The second starts with click records and asks about investments. Neither should be presented as the probability that a click led to a later investment.
The answer changes with the starting group
Historical source records: 611 investment flags and 1,826 click flags.
| Question | Matching records | Base records | Share of the stated base |
|---|---|---|---|
| Investment records with a click | 327 | 611 | 53.52% |
| Investment records without a click | 284 | 611 | 46.48% |
| Click records with an investment | 327 | 1,826 | 17.91% |
An investment-only record does not explain its own history. It could not tell us that a person bypassed the newsletter, that a tracker missed an event or that another channel caused the investment. Those explanations would require evidence about collection, timing and other activity that this release does not provide.
For a campaign owner, the immediate implication is narrower and practical: keep the matched count alongside the separate totals. When the business question concerns people who took both actions, that intersection is part of the answer. A ratio made from two unmatched totals is not a substitute.
Does the overlap look the same in every newsletter?
The overlap varies across the ten source newsletters. Among investment-flagged records, the share that also has a click flag ranges from 29.55% to 78.43%. We show every newsletter so that either endpoint cannot stand in for the complete study.
The newsletter numbers below are source codes, not a time sequence or a ranking. The smallest investment base is 31 records and the largest is 118. A large percentage on a small base should remain attached to that base when the result is quoted.
Both directions of overlap, with their bases
All ten historical newsletters; the underlying complete counts appear in the next table.
| Source newsletter | Click among investment records | Investment records | Investment among click records | Click records |
|---|---|---|---|---|
| Newsletter 1 | 78.43% | 51 | 12.08% | 331 |
| Newsletter 2 | 44.44% | 36 | 12.21% | 131 |
| Newsletter 3 | 35.29% | 34 | 6.70% | 179 |
| Newsletter 4 | 29.55% | 44 | 8.90% | 146 |
| Newsletter 5 | 41.27% | 63 | 15.95% | 163 |
| Newsletter 6 | 62.75% | 51 | 23.36% | 137 |
| Newsletter 7 | 61.29% | 31 | 14.07% | 135 |
| Newsletter 8 | 60.87% | 69 | 31.58% | 133 |
| Newsletter 9 | 50.00% | 118 | 31.38% | 188 |
| Newsletter 10 | 59.65% | 114 | 24.03% | 283 |
The full counts below make the comparison auditable. For any newsletter, add “both” and “investment only” to obtain its investment base. Add “both” and “click only” to obtain its click base. All four cells add to that newsletter’s total.
All four outcomes in every newsletter
All ten source newsletters, sorted by their native codes.
| Source newsletter | Both | Click only | Investment only | Neither | All records |
|---|---|---|---|---|---|
| Newsletter 1 | 40 | 291 | 11 | 5,238 | 5,580 |
| Newsletter 2 | 16 | 115 | 20 | 5,515 | 5,666 |
| Newsletter 3 | 12 | 167 | 22 | 5,325 | 5,526 |
| Newsletter 4 | 13 | 133 | 31 | 5,432 | 5,609 |
| Newsletter 5 | 26 | 137 | 37 | 5,377 | 5,577 |
| Newsletter 6 | 32 | 105 | 19 | 5,196 | 5,352 |
| Newsletter 7 | 19 | 116 | 12 | 5,101 | 5,248 |
| Newsletter 8 | 42 | 91 | 27 | 5,182 | 5,342 |
| Newsletter 9 | 59 | 129 | 59 | 5,182 | 5,429 |
| Newsletter 10 | 68 | 215 | 46 | 5,699 | 6,028 |
This variation does not identify the best newsletter creative. Projects differ, the same recipients can recur, and the new analysis pools the original treatment groups. There are no per-newsletter significance tests or claims that a particular project caused stronger overlap.
For a business with several campaigns, retain campaign detail alongside the combined report. If you are deciding how to change one campaign, start with its own row and counts. Keep the combined table when reporting across campaigns. Do not select a favorable campaign after seeing its result.
What changes when each recipient gets equal weight?
Our main comparison gives every recipient–newsletter record equal weight. A recipient represented in ten newsletters therefore contributes ten records, while someone represented once contributes one. That is appropriate for describing the released records, but it is not the only possible summary.
As a prespecified secondary comparison, we give each recipient code a total weight of one. Someone appearing in ten newsletters contributes one-tenth per record; someone appearing once contributes one. Each recipient code therefore contributes the same total weight. This does not make the sample representative of a country or market.
Under this weighting, 51.69% of the investment weight also carries a click flag, compared with 53.52% in the main analysis. The reverse share is 19.12%, compared with 17.91%. We retain both summaries; the secondary one is a different descriptive target, not a correction chosen because its result is preferable.
Two ways of weighting the same complete file
Primary: equal weight per recipient–newsletter record. Secondary: equal total weight per recipient code.
| Weighting | Click among investment | No click among investment | Investment among click | Recorded click rate | Recorded investment rate |
|---|---|---|---|---|---|
| Equal records (primary) | 53.52% | 46.48% | 17.91% | 3.30% | 1.10% |
| Equal recipient weight (secondary) | 51.69% | 48.31% | 19.12% | 4.02% | 1.49% |
The complete secondary table with equal recipient weight
Each of 7,864 recipient codes contributes a total weight of one across its source records.
| Recorded combination | Weighted total | Share of total recipient weight |
|---|---|---|
| Click and investment | 60.4079 | 0.77% |
| Click only | 255.5067 | 3.25% |
| Investment only | 56.4627 | 0.72% |
| Neither flag | 7,491.6226 | 95.26% |
The weighted cell totals include fractions because they add contributions such as one-half or one-tenth. They sum to 7,864, the number of recipient codes. They should not be described as fractional people or as counts of unique investors who took each action.[3]
A template for comparing clicks and outcomes in your own report
Before interpreting a campaign as a funnel, write a short measurement brief. The following ungated template is for planning your own reporting. It does not assume that this historical dataset used the same definitions, or that changing measurement will improve sales.
Decision: “We want to decide [message, offer or reporting decision] for [campaign].” Choose the decision before selecting a convenient rate.
Unit and base: “One row represents [recipient–campaign, visit or another supported unit]. Our eligible base is [definition]. Repeated events and repeated recipients are handled by [rule].” Keep a count of events separate from a count of identifiers.
Actions: “A click means [specific recorded event]. An outcome means [registration, qualified inquiry, completed purchase or another defined action].” Decide how cancellations, refunds, test events and duplicates will be treated.
Link and timing: “We connect records using [permitted identifier]. We observe clicks during [window] and outcomes during [window]. We can establish order using [available timestamps].” If a link or timestamp is unavailable, say so instead of filling the gap with an assumed journey.
Report: “We will show click only, outcome only, both and neither, plus the eligible base. Conditional percentages will name their denominator.” Keep unavailable or unlinked records visible as their own reporting issue, rather than silently calling them “neither.”
Use: “This report describes [observed relationship]. To claim [a campaign caused more outcomes], we would need [a suitable comparison design].” The overlap table itself does not supply that causal comparison.
Keep all four combinations visible

Define the same record
Name the eligible unit, actions, matching rule and windows.
Keep every combination
Show both actions, each action alone and neither; identify unmatched records separately.
Name the denominator
Say whether a percentage starts from all records, click records or outcome records.
A worked example: a creator reporting workshop registrations
Consider a fictional creator with 1,000 eligible recipient–campaign records. Suppose the creator’s defined windows and permitted matching process produce 80 records with a click, 30 with a registration, and 18 with both. These are invented teaching values, not another result from the crowdfunding data.
The complete table contains 18 with both, 62 with a click only, 12 with a registration only and 908 with neither. The click rate is 80 divided by 1,000, or 8%. The registration rate is 30 divided by 1,000, or 3%.
Among click-flagged records, 18 out of 80 also have a registration: 22.5%. Among registration-flagged records, 18 out of 30 also have a click: 60%. The creator can report all four numbers without implying that they measure the same thing.
The 12 registration-only records deserve a neutral description until the creator has evidence about their paths. Even when timestamps establish that a click preceded a registration, order alone does not prove that the newsletter caused it. The creator can use the table to specify the next question without treating it as a revenue-lift estimate.
A useful completed brief would say: “We are describing recorded registration overlap for this campaign and these windows. We will keep all four categories, show both conditional bases and separately report records we cannot match.” That is more actionable than a conversion-rate label whose denominator nobody can identify.
How did Influence IQ calculate the overlap?
We used the complete final Stata dataset from the authors’ version-one public release. Before calculating the joint outcomes, we checked the file identity, the seven required numeric fields, all 55,357 unique recipient–newsletter pairs, 7,864 recipient codes and ten newsletter codes. Both flags had to be present and coded exactly as zero or 100.[2]
We checked the three treatment-group counts and reproduced the paper’s rounded marginal click and investment percentages. No records were removed, imputed or deduplicated. We then counted all four combinations overall and within every newsletter, and calculated the same quantities using the fixed equal-recipient weighting.
Two independently written implementations produced identical counts and exact fractions. The downloadable package contains original calculation code, the method and all aggregate tables. It excludes raw records and recipient identifiers. Obtain the source file separately from the authors and retain their attribution.
We do not attach sampling confidence intervals to this enumeration of the released file. The counts are exact for those records, but that does not establish precision for a wider population. Shared recipients and projects would matter for generalization, which this study does not attempt.
The practical contribution is the complete recorded overlap and a clear way to ask the next measurement question. It complements, rather than replaces, the authors’ original experiment. For campaign decisions, define the outcome, base, matching rule and time window before deciding what a reported conversion rate means.
The CSV uses this page’s language. The package contains original code, English method documentation and aggregate results. Raw records and recipient identifiers are excluded; obtain the data separately from the authors’ public release.
Sources and notes
- Hornuf, Lars, and Christoph Siemroth (2023), A field experiment on attracting crowdfunders, Economics Letters 222, 110928. Sections 2–3 define the ten newsletters, observation unit and outcome flags; Tables 1–2 provide published cohort and marginal controls. The original study tests framing effects. Influence IQ’s new analysis describes joint recorded outcomes.
- Hornuf and Siemroth, version-one data release, April 17, 2023, DOI10.17632/9prftpkdfc.1, CC BY4.0. The analysis uses SubscriberNumber, NewsletterNumber, treatmentcontrol, treatmenteco, treatmentreturn, ClickPercent and InvestmentPercent. Identifying value labels and other fields are not used. Reviewed sources do not establish matched observation windows, event ordering or cancellation rules.
- For a recipient appearing in k source newsletters, each record receives a weight of 1/k in the secondary analysis. The primary analysis assigns a weight of 1 to each record. Both use the complete released sample. Source recipient codes support grouping; they do not independently certify unique natural persons. Fractions are calculated exactly before display rounding. All ten newsletter codes retain their native order without assigning chronology.
This English article is the source version. All language versions describe the same historical German crowdfunding records, not separate country or industry benchmarks.