Data notes - click to read
- Home CO SP reports: 10/17/2026 to 11/15/2026.
- Sales / Purchases are Amazon default 7-day click attribution, including other products, not same-item sales.
- Recent conversions may update.
- Campaign report has 32 fewer impressions than the other four sources; each retains its original values.
- Values match their Amazon source reports.
- AdCanyon currently differs.
- Same-item source is available; organic differences require complete ASIN/day business and ad coverage.
- Negative matched ASIN/day differences floor at zero under the owner display rule; hover Organic for the dates.
- Missing rows remain unknown.
- Business order dates and ad-attribution dates may differ. Source receipts and coverage.
TW report receipts
Verified source files, original-byte archive and exact parsed date coverage. Five reviewed sources now feed HomeCO dashboards. Immutable originals and prior metric snapshots are retained.
Native SP metrics promoted
Sales / Purchases retain Amazon default Sponsored Products 7-day click attribution, including other products. Same-item / halo split comes from revised Advertised Product receipt #8; every source row reconciles. Organic uses same-item ASIN/day joins with negative differences floored at zero under the owner display rule. Missing joins stay unknown; reported account subtotals exclude them. Campaign impressions are 362,534 versus 362,566 in the other four promoted sources. No values are forced to match. No organic sales, business coverage, upload completion or SB/SD coverage is inferred.
Repeated overlapping files are separate immutable receipts, never summed together. Use the latest reviewed compatible source, not the sum of receipts. Missing rows do not prove zero activity.
11 placement classifications and 1 search term are blank in the Nov16 batch. Original blank values are preserved, never invented or dropped. The Hourly file covers Nov15 only; the other six cover Oct17-Nov15.
Source day comes from the CSV Date field. Report timezone is awaiting confirmation. Original download links were retrieved without Amazon sign-in or account API access.
Received source files · homeco
| Receipt | Report | Dates | Rows | Ad products | Cost | Source Sales | Status | Original |
|---|---|---|---|---|---|---|---|---|
| #8 | advertised_productAdvertised_Product_Daily_promoted_20261116.csv | 2026-10-17 to 2026-11-1530 distinct days | 1,242 | Sponsored Products | $3,560.60 | $7,436.60 | In dashboards · original retained | Original (owner sign-in required) |
| #7 | search_termsSearch_Term_Daily.csv | 2026-10-17 to 2026-11-1530 distinct days | 12,129 | Sponsored Products | $3,560.60 | $7,436.60 | In dashboards · original retained | Original (owner sign-in required) |
| #6 | advertised_productAdvertised_Product_Daily.csv | 2026-10-17 to 2026-11-1530 distinct days | 1,242 | Sponsored Products | $3,560.60 | $7,436.60 | Isolated source verified · not in dashboards | Original (owner sign-in required) |
| #5 | purchased_productPurchased_Product_Daily.csv | 2026-10-17 to 2026-11-1530 distinct days | 276 | Sponsored Products | — (not supplied) | $7,305.26 | Isolated source verified · not in dashboards | Original (owner sign-in required) |
| #4 | hourlyHourly.csv | 2026-11-15 to 2026-11-151 distinct days | 540 | Sponsored Products | $88.41 | $131.34 | Isolated source verified · not in dashboards | Original (owner sign-in required) |
| #3 | targetingTargeting_Daily.csv | 2026-10-17 to 2026-11-1530 distinct days | 10,796 | Sponsored Products | $3,560.60 | $7,436.60 | In dashboards · original retained | Original (owner sign-in required) |
| #2 | placementPlacement_Daily.csv | 2026-10-17 to 2026-11-1530 distinct days | 2,869 | Sponsored Products | $3,560.60 | $7,436.60 | In dashboards · original retained | Original (owner sign-in required) |
| #1 | campaignCampaign_Daily.csv | 2026-10-17 to 2026-11-1530 distinct days | 1,242 | Sponsored Products | $3,560.60 | $7,436.60 | In dashboards · original retained | Original (owner sign-in required) |
Provenance
Receipt #8 · advertised_product · received 2026-11-16 17:41:21.030029+00
Message 1a1e571d8ade8ae4
SHA-256 354404f3c9e52bc6212e4e7451f6a9c0f0501b0157d24d34f038bd9122f591ba
Parser tw-flexible-promoted-v2. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #7 · search_terms · received 2026-11-16 16:27:28.304218+00
Message 1a1e5284062e82a7
SHA-256 971ed82849a2425affcef4ad3bb4c7bccceb07f306459ed3bb30367b22ce0477
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #6 · advertised_product · received 2026-11-16 16:27:28.304218+00
Message 1a1e528103b17f79
SHA-256 0abad53265cdd4c201cbf0f4306c63bc666e47961c01e52e37fa33a5dc6e0456
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #5 · purchased_product · received 2026-11-16 16:27:28.304218+00
Message 1a1e5263000dec56
SHA-256 e8d128acd6880674228f6677f094c02a5a375e2c86e90ccb1a10596867c4b9b7
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #4 · hourly · received 2026-11-16 16:27:28.304218+00
Message 1a1e52524785f6dd
SHA-256 24ec48fa532683a676365158f314cfc28da5ce55f82eea5d341a67fd8c11686f
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #3 · targeting · received 2026-11-16 16:27:28.304218+00
Message 1a1e522b48ead2d2
SHA-256 df546185224851d457e46fbaf176230c6d6519bb0267a0cf316b3731b1a59093
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #2 · placement · received 2026-11-16 16:27:28.304218+00
Message 1a1e5240974d355f
SHA-256 e6d881ce541047fd1bab476978d86b8da670a08a07aa6a99019aac2262ae359e
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Receipt #1 · campaign · received 2026-11-16 16:27:28.304218+00
Message 1a1e51f4e12dab5d
SHA-256 d65d41e5bfaa4d4371ffc5d95d61ac176183fbc51f119034be5a32f9592e7aa4
Parser tw-flexible-v1. Source-defined Sales/Purchases. Attribution window and same-item vs halo not certified. Isolated source only, not legacy metric replacement.
Full bulk source archive
Receipt #1 · HomeCO_Bulk_Nov2-Nov15_2026_FULL.xlsx
24,601 data rows · Active source-only registry · no live settings changed
Declared reporting range in authenticated-channel delivery; workbook rows are configuration snapshots, Start Date is campaign start, not report coverage.
HomeCO ENTITY24B06F7QEF3NN delivery reference;601SPcampaign identities checked against existing HomeCO catalog
| Sheet | Rows | Type |
|---|---|---|
| Config | 29 | Technical / configuration |
| Sheet8 | 0 | Technical / configuration |
| Portfolios | 74 | Source records |
| RAS Campaigns | 0 | Technical / configuration |
| SP_COLUMN_IDS | 1 | Technical / configuration |
| Sponsored Brands Campaigns | 88 | Source records |
| SB Multi Ad Group Campaigns | 98 | Source records |
| Sponsored Display Campaigns | 715 | Source records |
| Sponsored Products Campaigns | 23,626 | Source records |
601 SP campaigns; 2 unique paused SB campaigns (two workbook representations retained), 48 paused SD campaigns. All original rows retained, no cross-tab double-counting. 15,498 existing shared target identities unchanged; 460 extra negative records preserved source-only. Two missing existing targets were already archived and are retained. Bids, states, budgets and metrics unchanged.
Legacy 24,155-row upload remains in history. Snapshot-backed registry rollback changes only the source pointer, never the original archive.
SHA-256 3ff352fd27b275872ccf266df1c597d3948fb15d49081f9bf7d5cb9a7588e586