Data sources
Company-wide uploads that get parsed once and allocated across all matching titles. Per-title data lives on each title's own dashboard.
Canva connection
Powers the per-title Canva folder gallery sync and the sell sheet builder. Connect once — the app then creates and reads designs on your behalf.
Checking…
Public catalog
Auto-generated from ONIX + the title registry, refreshed nightly. Shorten copy or approve it for publication in the catalog copy & approvals tool — nothing reaches the public page until it's checked off there.
When data comes in
Everything below refreshes on its own — nothing on this list needs an upload. Times are shown in your timezone.
| Source | Frequency | When |
|---|---|---|
| Ad performance — Meta, Reddit, Amazon & TikTok | Nightly API pull (rolling 7-day window, so a missed night backfills itself) | |
| Reviews & rankings — Amazon + Goodreads | Nightly | |
| Press, podcast & social mentions — Google News, Apple Podcasts, Bluesky & YouTube | Nightly scan (GitHub Action), merged to title pages | |
| New & updated titles — ONIX feed | Daily | |
| Linked Google docs — strategy, milestones, title budget & rights tracker | On page view, PLUS a nightly re-check of the budget & milestones sheets — so those numbers stay fresh (dashboard, author portal) even for titles nobody opened that day. The embeds always show the current doc; re-parses run only when content actually changed. The strategy doc re-analyzes on page view only (its analysis is only used there) | every dashboard view · sheets also |
| Point of Sale — Daily POS Activity & New_POS_Weekly (S&S SSRS) | Nightly GitHub Action pull, straight from the reporting portal (falls back to forwarding the reports by hand to [email protected] if the automated pull is ever down) |
Daily: —
Weekly: —
|
Emailed reports → [email protected]
|
On arrival (Bookscan & spend ledger typically come weekly) | parsed within ~1 min of forwarding |
| Uploads on this page | On upload | parsed immediately |
Company-wide spend report
Upload the Title Marketing Spend Report here — once, not per title. It's parsed a single time and automatically allocated to every title that has a matching row in the ledger. (You can also just forward the same file to [email protected] and skip this page entirely.)
Unclaimed spend
Checking…
Ad platforms — nightly API pull
Meta, Reddit, Amazon and TikTok campaign performance is pulled straight from each platform's API every night — no uploads, no emailed reports. New campaigns are matched to titles by name automatically; anything the matcher isn't confident about appears below for a one-time link, so no spend is ever silently misattributed.
Checking…
Amazon live sales — unmatched ASINs
Every hour Amazon reports real-time sales by ASIN, matched to a title by its tracked Amazon product. Amazon assigns a different ASIN per format (Hardcover, Paperback, Kindle, Audiobook) — if a title's tracked ASIN happens to point at the wrong format, that format's real sales land here instead, unmatched. A large total on one ASIN below is the tell: click through to Amazon and check which format it actually is.
Discount / pricing plans
Upload the discount/pricing plan spreadsheet here — once, not per title. It's parsed a single time and automatically allocated to every title with a matching row. (You can also forward the same file to [email protected] and skip this page entirely.)
Book Messaging
Upload the Book Messaging spreadsheet here — once, not per title. It's parsed a single time and applied to every matching title.
Amazon preorders
Upload the multi-title Amazon preorder report here — once, not per title. Both formats work: the AE print report (forwarded by Craig) and the CoreReports system download. It's parsed a single time and each title's preorder numbers are matched to its dashboard, where they show until Bookscan sales begin. (You can also forward the same file to [email protected] and skip this page entirely.)
Bookscan sales
Upload the weekly Bookscan POS export here — once, not per title. It's parsed a single time and allocated to every title with a matching row. (You can also forward the same file to [email protected] and skip this page entirely — you mentioned you'd like to do this weekly.)
Goodreads Giveaways
Upload the Goodreads Giveaways worksheet here — once, not per title. It's parsed a single time and each title's giveaway schedule is matched to its dashboard. Works with either version (831 Stories or AE) — upload both and each fills in its own titles. (You can also forward the worksheet to [email protected] and skip this page entirely.)