KDP Ads Manager vs Spreadsheet: A Weekly Reconciliation Workflow for Author Ad Data
InteliAds Team
KDP Ads
You export last week's Sponsored Products data, paste it into a sheet, and the numbers disagree with what the ads screen showed and with your KDP royalty report. This is the real question behind kdp ads manager vs spreadsheet: not which tool is better, but which one owns each number and how you check the rest. This guide gives you a repeatable weekly reconciliation routine for author ad data.
Short answer: A spreadsheet is flexible and fully auditable, but every figure depends on your exports and your formulas. A KDP ads manager reduces the copying and keeps campaign, keyword and royalty data in one place, though it does not make ad-attributed sales and royalties the same thing. Use the ads source for spend, clicks and attributed sales, and the KDP source for royalties and KENP. Reconcile the two once a week against fixed rules, and treat small gaps as expected. See the KDP ads guide for background on how the campaigns themselves work.
Why the two data sources rarely match on the first pass
Amazon Ads and KDP report different things. Ads reports show attributed sales: orders Amazon credits to an ad click within an attribution window. KDP reports show royalties: what you earn after the list price, delivery costs and royalty tier are applied, across all sources including organic sales. The datasets overlap in sales activity but report different measures, and they do not provide an order-by-order join for this workflow. Do not equate a royalty total with attributed sales.
Timing adds a second layer. Ad reports can be revised after the first pull as attribution settles, and KDP reports can show orders and royalties on different schedules. A sheet filled on Monday may legitimately differ from the same sheet refreshed on Friday.
Both approaches have trade-offs worth naming before you pick one:
- Data freshness: a sheet is only as current as your last export. A manager that pulls through Amazon Ads OAuth, and through KDP Sync when linked, removes the manual export step, but it still reflects what Amazon has reported so far.
- Auditability: a sheet shows every formula and pasted row, so you can trace any figure. In a manager you audit by comparing its totals to the source reports.
- Manual effort: sheets need exports, cleaning and formula upkeep across every account. This effort grows with each added book or account.
- Control: a sheet only records. Changes still happen in the console, unless a tool also lets you act on the data.
Set up a reconciliation sheet before you export anything
Build the structure first so each export has a place to land. Keep one row per campaign per week, and separate columns by who owns the number. If a column has no clear owner, it will cause an argument with yourself in three weeks.
Here is a field ownership checklist. The hypothetical week below shows what each field might hold: a campaign with $48.60 spend, 74 clicks, $212.00 attributed sales, and $96.40 KDP royalties for the same title and week. These figures are invented for illustration only.
| Sheet field | Owning source | Hypothetical week value | Reconciliation check |
|---|---|---|---|
| Spend | Amazon Ads campaign report | $48.60 | Row total should equal the report footer total for the same dates |
| Clicks | Amazon Ads campaign report | 74 | Compare against the console total, allowing for later revisions |
| Attributed sales | Amazon Ads campaign report | $212.00 | Never compare directly to royalties |
| ACOS | Calculated: spend divided by attributed sales | 22.9% | Recompute yourself, do not paste the rounded figure |
| KDP royalties | KDP sales report | $96.40 | Check the currency and the date range match your ads week |
| KENP pages read | KDP KENP report | 1,850 pages | Keep separate from royalties until you apply the rate for that month |
| Profit after ads | Calculated: royalties minus ad spend | $47.80 | Mark it as an estimate until both sources settle |
Bid-desk tip: store ACOS as a formula, not a pasted value. Pasted percentages hide rounding and make later reconciliation harder.
Add two housekeeping columns: export date and status (draft, reconciled, revised). They tell you later which rows you can trust.
Pulling the right reports: campaign, targeting, and royalty data
Pull three report types for the same date range, and write that range in the sheet before you download anything. Mixed date ranges are the most common cause of a gap that looks like an error but is only a calendar mismatch.
- Campaign report: spend, clicks and attributed sales per Sponsored Products campaign. This anchors your weekly totals.
- Targeting report: keyword and target rows with their own spend. Sum them and compare to the campaign total. If they differ, note it rather than forcing them to match.
- KDP royalty and KENP data: royalties by title and marketplace, plus pages read. Keep each marketplace in its own currency until you convert deliberately.
If you link KDP Sync in InteliAds, royalties, orders, KENP and pricing are imported alongside the ads data, and profit is shown as royalties minus ad spend. That saves the copy-and-paste step, but you still decide how to read the figure. Ad-attributed sales and KDP royalties remain separate numbers, and the tool does not match individual ad orders to individual royalty lines.
Whichever way you pull, keep the raw export untouched in its own tab or file. Do your cleaning in a copy so you can always return to what Amazon actually gave you. For the broader setup, see Amazon Ads for KDP authors.
KDP ads manager vs spreadsheet: deciding which source wins for each number
Settle the question field by field rather than tool by tool. Spend, clicks and attributed sales come from Amazon Ads. Royalties and KENP come from KDP. Profit is your own calculation from the two. A sheet or a manager only changes how those inputs reach you and how much work it takes to check them.
A sheet suits one or two accounts, a small number of campaigns, and anyone who wants to inspect every formula. A manager earns its place when exports, multiple accounts or hourly checking become the bottleneck. InteliAds, for example, supports user-written IF/THEN rules that run on an hourly schedule, with a Dry Run to preview the changes before they apply. That is control a spreadsheet cannot give you, since a sheet cannot change a bid. BidBot is a separate feature that produces bid recommendations, and it is not part of reconciliation. You can compare InteliAds pricing against the hours you spend on exports.
Use this table when your two sources disagree:
| Disagreement you see | Source to trust first | Action to take |
|---|---|---|
| Sheet spend is lower than the console total | Amazon Ads campaign report | Confirm the date range and time zone, then re-export the campaign report and compare the footer total to your row sum |
| Ad sales are far higher than KDP royalties | Both, since they measure different things | Do not force a match. Compare royalties to spend for profit, and keep attributed sales as a separate efficiency signal |
| Targeting rows add up to less than the campaign total | Campaign report | Record the difference in a notes column and check whether the targeting export used the same dates and filters |
| This week's figures changed after you reconciled | The most recent export | Re-export, overwrite the row, set status to revised, and log the export date |
| KENP reads appear with no matching ad orders | KDP KENP report | Leave them out of ad-attributed sales and add them to the royalty side only when you apply the monthly rate |
| Two accounts use different currencies | Each account's own report | Keep a column per currency, convert only at the final profit step, and record the rate you used |
Whichever source you trust, set a weekly rule for what you will act on. Pause or bid changes should come from figures you have reconciled, not from a first-pass pull that may still be revised. When you want to test that workflow without the exports, you can create an InteliAds account, or browse more KDP ads guides for related routines.
The time required depends on your catalog, accounts and report revisions. Use the following timed blocks as a planning example, not a guaranteed completion time. The routine below assumes you keep a Sponsored Products export and a KDP royalty report side by side, whether you do that in a sheet or in a tool. For wider context, see the KDP ads guide.
A 30-minute weekly routine, step by step
Pick one fixed day, preferably several days after the week closes, so late attribution and report revisions have settled. Record the export timestamp on every pull, because it is the first thing you will need when two numbers disagree.
- Minutes 0 to 5: Export the campaign-level report from the Amazon Ads console for the exact Monday-to-Sunday range. Note the date range, time zone and pull time in the sheet header.
- Minutes 5 to 10: Compare the export's total spend with the total shown on screen for the same range. If they differ, re-export before touching anything else.
- Minutes 10 to 15: Pull royalties, units and Kindle Unlimited pages read from your KDP reports for the same week. Keep them in a separate block from ad data.
- Minutes 15 to 22: Calculate ACOS per campaign from ad data only, then calculate account-level profit as royalties minus ad spend. Label that profit figure as a blended number.
- Minutes 22 to 28: Flag campaigns with spend and no attributed orders, and campaigns where ACOS sits well above your break-even for that book.
- Minutes 28 to 30: Write one decision per flagged campaign (pause, lower bid, wait another week) and a recheck date.
Field ownership checklist
Most reconciliation errors come from typing a number into a column that belongs to a different source. Decide ownership once, and never override it by hand.
Where InteliAds fits in the routine
InteliAds is a KDP Sponsored Products manager that connects through Amazon Ads OAuth. When KDP Sync is linked, it imports royalties, orders, KENP and pricing, and shows profit as royalties minus ad spend. It does not match individual ad orders to individual royalty orders, so the blended-number caveat above still applies.
Compared with a sheet, the difference is mostly manual effort and auditability: less pasting, and a consistent place to see campaign and keyword performance across accounts. Freshness is not a guarantee in either approach, because both depend on what Amazon has published at the time of the pull.
- Rules: you write IF/THEN rules yourself, and they run on an hourly schedule.
- Dry Run: it previews the changes a rule would make before anything is applied.
- BidBot: it is separate from Rules and offers bid recommendations, with live automation depending on the modes and limits you enable.
- Control: review modes and safeguards before enabling live automation. A spreadsheet records decisions but does not itself apply bids.
Worked example: reconciling a week where spend and sales don't line up
This is a fresh hypothetical for one author with three Sponsored Products campaigns. The numbers are illustrative, not benchmarks.
On Wednesday, the export for Monday to Sunday shows spend of $63.40: $31.10 on Campaign A, $19.80 on Campaign B and $12.50 on Campaign C. The console screen shows $66.25 for the same range, a gap of $2.85 or about 4.5%. Attributed sales in the export are $184.00, so the account-level ACOS from ad data is about 34.5%.
- Re-export first. Thursday's pull returns $66.25, so the earlier file was simply taken before the last day's spend had loaded. Overwrite the sheet and log the new pull time.
- Recompute ACOS. $66.25 divided by $184.00 is about 36.0%. Use this figure, not the first one.
- Add the KDP block. KDP shows $97.30 in royalties for 29 units, and 1,800 KENP pages. At an assumed illustrative rate of $0.0045 per page, that is about $8.10 more. Use the actual rate from your own KDP reports.
- Calculate blended profit. Royalties of $97.30 minus ad spend of $66.25 is $31.05. Adding the KENP estimate gives roughly $39.15 only if that $97.30 explicitly excludes Kindle Unlimited earnings. If the KDP total already includes them, adding $8.10 again would double-count it.
- Read it carefully. The $184.00 is attributed sales revenue. The $97.30 is your royalty share across all sources, including organic. They are different measures and cannot be treated as the same orders.
The decision is then narrow. Campaign C spent $12.50 with no attributed orders, so it goes on the recheck list rather than being judged on one week. Evaluate Campaigns A and B on their own attributed performance and margin assumptions. A positive catalog-wide blended figure cannot establish that either campaign is profitable.
FAQ
Q: Why does the sales figure in my ads dashboard differ from my KDP royalty reports for the same week? A: They measure different things. Ads dashboards report attributed sales revenue within an attribution window, while KDP reports your royalty share on units sold, including organic sales. The two totals cannot be matched order by order.
Q: How long should I wait before reconciling a week, given attribution delays and report revisions? A: Waiting several days after the week closes is a sensible habit, since late orders and revisions can still arrive. Re-pull the prior week once during the next routine and note any change. Treat the first pull as provisional.
Q: Which columns do I actually need in a weekly ad-tracking spreadsheet, and which can I skip? A: Keep campaign, spend, clicks, attributed sales, attributed orders, royalties, KENP pages, series role, decision and recheck date. Skip impressions-level detail and daily breakdowns unless you are diagnosing a specific campaign.
Q: How do I account for Kindle Unlimited page reads when calculating profit from ad spend? A: Record KENP pages as their own column and convert them to an estimate using the rate stated in your KDP reports. Add that estimate only if the royalty total excludes Kindle Unlimited earnings. If the total already includes them, do not add the estimate again.
Q: What should I do when a campaign's spend in the export doesn't match the total I see on screen? A: Check that the date range and time zone are identical, then re-export, since the first file may predate the latest data. If the gap persists, log both values with timestamps and use the later export.
Q: How much discrepancy between the two sources is normal enough to ignore? A: There is no official threshold. Small spend gaps that disappear after a re-export are usually timing. Ad-to-royalty gaps are expected by design, so compare trends across weeks, not exact totals.
Q: Should I keep one master sheet or a new tab for each week? A: One master sheet with a week column is easier to filter and chart. Keep a raw-paste tab for exports so you can audit any figure back to its source file and pull time.
Q: How do I handle ads that drive sales of other books in my series when reconciling? A: Tag each book with its series role and track series-level royalties next to campaign spend. Do not assign follow-on royalties to a specific campaign, because the data does not link them. Use series totals as additional context, not proof that a particular campaign caused follow-on revenue.
The honest answer to kdp ads manager vs spreadsheet is that a spreadsheet gives you full control and a clear audit trail at the cost of weekly manual effort, while a manager reduces the pasting but cannot make ad sales and royalties the same thing. Whichever you choose, keep the field ownership rules and the blended-profit caveat. You can See InteliAds plans or Create an account; Essential has no trial. Review live automation settings before enabling them. For related reading, see Amazon Ads for KDP authors and more KDP ads guides.
See InteliAds plans: compare Essential, Pro, and Publisher (Essential has no trial; Pro and Publisher include a 7-day trial). InteliAds is a Sponsored Products manager for KDP authors: royalty-aware profit when KDP Sync is linked, user-written IF/THEN rules with dry run, and targeting filters for keywords, product targets, and search terms. Create an account.
Related reading
- BidBot automated bidding for KDP ads
- Royalty profit vs ACOS: the number KDP authors should check before changing bids
- When to pause a KDP Sponsored Products keyword instead of raising the bid
- Placement Modifiers KDP Sponsored Products: When to Change Them and When to Leave Them Alone
- KDP Hourly Ad Rules vs Weekly Bid Checks: Where Weekend Spend Leaks and How to Test It