Compare Book Ad Reports Without Double-Counting Sales

Compare KDP and advertising reports by their definitions before comparing their totals. Do not add ad-attributed sales to all book sales as though they represent separate purchases. Preserve the original reports, align the book and period under review, and keep reported sales value separate from author earnings.

Define the question before collecting numbers

An author reviewing a campaign might want to know how much the advertising account spent, what activity the platform attributed to the ads, or whether the book project's overall finances improved. These are related questions, but one report does not automatically answer all of them. Write the intended decision above the worksheet before importing figures. This helps prevent an attractive number from becoming the answer to a different question.

For example, a campaign review might ask whether to continue a limited test under the existing budget. That decision needs the confirmed spend and relevant observations, along with uncertainty about the results. A review of the entire book's production costs has a broader scope. Combining both into a single unlabeled total can make it difficult to see which costs and outcomes actually informed the decision.

Preserve the definitions beside the figures

KDP explains that its account reports and Amazon Ads reports cover different activity: advertising reports attribute activity to ads, while KDP reports cover book activity regardless of how the purchase originated. Its guidance also identifies reporting and timing differences. Review the current definitions for the reports you actually use rather than assuming two columns with similar names measure the same event.

Save the report name, date range, download date, book identifier, marketplace, currency, and metric label with each value. Keep the original export unchanged and perform comparisons in a separate working sheet. If a column has a specialized definition, retain that definition or a link to the relevant explanation. A number copied without its context becomes harder to interpret when the review is repeated later.

Do not treat attributed activity as an additional sales channel

Suppose a hypothetical worksheet records twenty total book orders and an advertising report records eight attributed orders. Adding those figures and announcing twenty-eight orders would assume they describe separate sets of purchases. That assumption has not been established. The advertising figure is not automatically another channel to add on top of the book's total activity.

The reverse calculation also needs care. Subtracting eight from twenty and labeling the remainder as precisely measured organic orders can overlook differences in report scope or timing. Keep the original observations visible until you understand whether the figures are comparable. If a clean reconciliation is unavailable, describe that limitation rather than inventing a more detailed breakdown than the evidence supports.

Keep sales value and author earnings in different columns

A sales-value figure should not be relabeled as the author's available earnings. Read the report's definition and use the appropriate earnings record for a review of author income. The project worksheet should make the distinction visible even when the figures concern the same title. Otherwise, subtracting an advertising bill from a sales-value total can produce a misleading impression of what the author retained.

Use explicit column names such as reported sales value, reported royalties, confirmed advertising spend, and other confirmed campaign costs. Avoid a single ambiguous column labeled revenue when it contains different kinds of figures across rows. If you prepare an estimate for a decision, identify its assumptions and keep it separate from confirmed amounts. Do not let the spreadsheet's neat appearance conceal that some inputs remain uncertain.

Review differences without forcing the reports to match

When totals differ, investigate one dimension at a time. Confirm the edition, marketplace, reporting period, and currency before looking for a more complicated explanation. Check whether the reports were downloaded at different stages of reporting completion. Preserve notes about any platform-defined timing differences relevant to the comparison. The objective is to understand the discrepancy, not to adjust numbers until two systems display the same total.

Document unresolved differences with a narrow question. A note such as “confirm whether these rows cover the same paperback edition” is more useful than “reports are wrong.” If support is needed, provide the relevant report names and period through the appropriate account channel. Avoid sharing unnecessary customer or account information in a general project document while retaining enough context to investigate the issue.

Write a decision note that separates observation from explanation

Conclude the review with the observed activity, confirmed cost, remaining uncertainty, and the next bounded action. An increase in total book activity during a campaign is an observation. The claim that the campaign caused every additional purchase is a stronger explanation that the timing alone does not establish. Keep those statements distinct so future spending decisions are not built on an overstated result.

Save the decision note with the report snapshots used. A later review can then compare like questions and identify changes in the evidence. If the available information does not support expansion, the next action may be to improve measurement or resolve a report mismatch. Continuing a test should follow a deliberate decision about its purpose and limits, rather than a calculation that counts the same sales twice.