Data & coverage

Pulsy’s analysis is only as wide as the data behind it. Two kinds of data feed it, and they arrive very differently — which is the thing to internalize, because it sets what “Pulsy can see channel X” actually means.

Amazon — native

Amazon Ads data (Sponsored Products / Brands / Display, DSP, AMC) is ingested into the PULSEAD schema and surfaced through the six semantic analysts. This is the default, automatic path — see the data model for what’s covered and how current it is (refreshed nightly).

Off-Amazon — eight channels, via manual upload

Pulsy can also analyze off-Amazon advertising, across eight channels:

Meta · Google Search · Google P-MAX · Snapchat · Pinterest · TikTok · GA · Shopify

But this data is not pulled automatically. It lands through a deliberate manual pipeline (off-amazon-upload):

① Download a CSV from each channel's own dashboard
   ↓
② Submit it via a Google Form (pick the advertiser, attach the CSV)
   ↓
③ Apps Script parses it into a Google Sheet (Off_amazon_data tab)
   ↓
④ A once-daily job loads the sheet into Snowflake (~00:30 KST per the design)
   (raw landing table: OFF_AMAZON_PERFORMANCE_BY_MANUAL_UPLOAD)
   ↓
⑤ It splits by channel into the tables Pulsy queries:
     • ad media (Meta, Google ×2, Snapchat, Pinterest, TikTok) → DAILY_OFF_AMAZON_ADS_REPORT
     • GA, Shopify                                            → DTC_PERFORMANCE_REPORT

So when someone asks Pulsy about Meta or TikTok spend, it reads DAILY_OFF_AMAZON_ADS_REPORT; GA and Shopify live in DTC_PERFORMANCE_REPORT instead. Either way the honest internal picture is the same: it can answer — if someone uploaded that channel’s CSV. (The ad-media table is a dynamic table refreshed roughly every two hours once the daily load lands.)

What this means for an answer

• Off-Amazon coverage is opt-in per channel. A channel Pulsy “supports” only has data if its CSV was uploaded. An empty off-Amazon result usually means “not uploaded,” not “no spend.”
• Off-Amazon data lags by the upload + the daily load. It’s visible only after the once-daily load runs (the design targets ~00:30 KST), against whatever was submitted before then — so treat it as at least a day behind, more if uploads are irregular.
• Amazon is automatic; off-Amazon is manual. Don’t promise the same freshness or completeness for both. Amazon is the strong path; off-Amazon is best-effort and human-driven today.

All examples here use placeholders (Brand A, Campaign A) — never a real advertiser, in either locale.