WMC Pipeline

Manage Walmart Connect / Sam's Club advertising data: Supermetrics + Apps Script for WMC, PacVue API for Sam's spend.

Data coverage across all WMC clients. Click a client to see table-level detail.

No clients found in WMC Supabase. Use the Client setup tab to register a client.

Register client

Creates the WMC clients row. Optional Search / Display fields create client_connections using the exact Supermetrics Hub names. Add the optional ds_user UUID from the Query Builder so GAS direct API uses it (avoids QUERY_AUTH_UNAVAILABLE when Hub name alone is not accepted).

Optional. Must match Hub / sheet “Data source logins” exactly. Leave blank if no Search.

Optional. Leave blank if no Display.

Link Supermetrics connections (existing client)

If runDateRangeRepull logs 0 connections kept, add connection rows here. Use the same Hub names as in sheets. If the client row already exists, set ds_user UUIDs via paste or field — we update client_connections.ds_user_id for links that are already on file.

Found in the sheet URL: docs.google.com/spreadsheets/d/[THIS PART]/edit

1
Enable Batch Mode
Sets BACKFILL_MODE=true in Apps Script to prevent mid-run sheet clears.
2
Populate Backfill Chunk Rows
Creates the first date-range chunk per tab in SupermetricsQueries. After each "Refresh all" completes, click Sync this round & Advance to sync to Supabase, clear the sheet, and queue the next chunks (uses actual last row per tab — no estimates). Repeat until all chunks are done.
3
Refresh All Queries in Supermetrics
Open the Google Sheet and click Extensions → Supermetrics → Refresh all. Then click "I've clicked Refresh all" to start monitoring.
Open Sheet
Checking query status…
4
Sync All Data to Supabase
Runs monitorAndSync() — reads all accumulated sheet data and upserts to WMC Supabase.
5
Clean Up & Restore Weekly Schedule
Removes chunk rows from SupermetricsQueries, resets date range to Last week (Sun-Sat), and disables Batch Mode.
Activity Log
Ready. Fill in the form above and click Enable to begin.

Upload manual Walmart Connect Ad Center CSV exports to fill gaps when the Supermetrics pipeline is unavailable. Rows are transformed in your browser and upserted into the WMC tables. Batches are idempotent — a failed run can simply be re-run.

Must match the window the CSV was exported at.

Which Sam's advertiser account this export came from. Required for Sam's uploads.

The advertiser ID is required; the label is just an optional human name.

CSV file

Export the report at Daily granularity (one row per day).

Item-set files (one export per item set)

Required — carries dimensions + core columns.

All item sets merge client-side on (report_date, campaign_ext_id) before the write.

Only needed for clients with no display history (the CSV has campaign names, not ids). One campaign per line as Campaign Name <tab> campaign_id (or Campaign Name,campaign_id). Names must match the export exactly. Type defaults to NGD.

Progress
Activity Log
Ready. Select a client, report type, and file, then click Run import.

Pull Sam's Club Sponsored Search spend from PacVue (Product Ads, daily) into sams_* tables for every client with a registered Sam's PacVue advertiser account (Pipeline → CSV Backfill → Add account). Scheduled via Supabase pg_cron on the SERP project — not Apps Script / Sheets. Omni Dashboard → platform Sam's Club / Both visualizes spend.

Checking PacVue config…

Recent sync jobs
Created Status Range Profile Spend / rows Error
No jobs yet.