How to build per-location metric ingestion across 10-15 sources per-location

The 4-skill bundle on the per-location-metric-ingestion agent

One agent. Four coordinated skills. The Ingest + Normalize + Reconcile + Audit bundle runs above the per-location POS + KDS + inventory + loyalty + workforce + DSP/ESP + analytics + review + SEO + social + field-service + payments + warehouse substrate and writes one canonical per-location per-metric per-period ingestion record.

Compliance overlay

Five anchors run per-location per-metric per-period before any metric distributes to downstream decision systems. The first anchor is operationally distinctive: per-location 10-15 source ingestion + source-of-truth + UCUM unit- conversion + IANA tz time-zone + ISO 4217 currency + per-source schema drift + per-source rate-limit + reconciliation cadence + per-source idempotent-retry converge on every per-location metric ingestion decision.

FAQ

What is per-location metric ingestion across 10-15 sources per-location — and what is the per-location-10-15-vendor-source-times-source-of-truth-times-UCUM-unit-conversion-times-ISO-4217-currency-times-IANA-tz-time-zone-times-per-source-schema-drift-times-reconciliation-cadence problem distinctive to this skill?

A multi-location operator with 50-300 locations ships per-location per-metric ingestion across 10-15 per-location vendor sources per location: per-location POS (Square + Toast + Clover + Shopify POS + Lightspeed + NCR Aloha + Oracle MICROS + TouchBistro + Revel + Upserve) + per-location KDS (Toast KDS + Square Kitchen Display + Oracle Symphony) + per-location inventory (NetSuite + Cin7 + Brightpearl + Stitch Labs + Linnworks + Veeqo + Skubana + Acumatica + Fishbowl) + per-location loyalty (Punchh + Paytronix + Thanx + Como + Eagle Eye + Annex Cloud) + per-location workforce + scheduling (ADP + Paychex + Gusto + Rippling + 7shifts + HotSchedules + Deputy + When I Work + Sling + Homebase) + per-location DSP/ESP (Mailchimp + Klaviyo + Iterable + Attentive + Postscript + Yotpo SMSBump + Customer.io + Braze) + per-location analytics (GA4 + Adobe Analytics + Mixpanel + Amplitude + Heap + Pendo) + per-location review (Birdeye + Reputation.com + Podium + GatherUp + ReviewTrackers + Yelp + Google Business Profile + Apple Maps + TripAdvisor) + per-location SEO (SimilarWeb + Semrush + Ahrefs + Moz + Sistrix) + per-location social (Hootsuite + Sprout Social + Buffer + Later + SOCi + Rallio) + per-location field-service (ServiceTitan + Jobber + Housecall Pro + FieldEdge + Service Fusion + Tradify) + per-location payments (Stripe + Adyen + Worldpay + Fiserv + Authorize.Net + Braintree). The four-skill bundle on the per-location-metric-ingestion agent — Ingest, Normalize, Reconcile, Audit — sits above the per-location POS + KDS + inventory + loyalty + workforce + DSP/ESP + analytics + review + SEO + social + field-service + payments + warehouse substrate and writes a per-location per-metric per-period canonical ingestion record. The operationally distinctive anchor: per-location per-metric ingestion across 10-15 per-location vendor sources + per-location source-of-truth identification (per-location per-metric authoritative-source + per-source SLA + per-source freshness-window + per-source last-known-correct + per-source verified-status + per-source human-validation) + per-location unit-conversion (per-currency conversion via ECB + IMF exchange rate + per-unit conversion via UCUM Unified Code for Units of Measure + per-location measurement system (US Customary vs Metric vs Imperial) + per-location tax-jurisdiction) + per-location time-zone normalization (per-location IANA tz database + per-location DST handling + per-location business-day calendar + per-location holiday calendar + per-location week-start convention + per-location fiscal-calendar) + per-location currency normalization (per-currency ISO 4217 + per-currency rate + per-currency precision + multi-currency portfolio aggregation) + per-metric per-source schema drift detection (per-source schema versioning + per-source schema evolution + breaking-change detection + per-source contract-test) + per-metric per-source rate-limit (Square 50 req/sec + Toast 100 req/min + Shopify 40 req/sec + per-source DPA + per-source ToS) + per-metric per-source reconciliation cadence (per-metric per-day + per-week + per-month + per-quarter + per-metric variance threshold) + per-metric per-source idempotent-retry semantics (exponential backoff + jitter + Conflict 409 + 429 + 503 + circuit breaker + dead-letter queue).

Why do Square + Toast + NetSuite + Punchh + ADP + Mailchimp + GA4 + Birdeye + SimilarWeb + Hootsuite + ServiceTitan + Stripe break at multi-location-10-15-source-per-location scale?

Each per-vendor system ships per-account flat metric-ingestion primitive at single-vendor single-location level. None coordinates per-location per-metric ingestion across 10-15 per-vendor sources + per-location source-of-truth identification + per-location UCUM unit-conversion + per-location IANA tz time-zone normalization + per-location ISO 4217 currency normalization + per-metric per-source schema drift detection + per-metric per-source rate-limit + per-metric per-source reconciliation cadence. None handles per-metric per-source idempotent-retry semantics (Conflict 409 dedup + 429 retry-after + 503 circuit-breaker + DLQ) at cross-vendor level. None gates against FDD Item 19 financial performance representations when per-location metric shared with franchisees + FINRA Rule 2210 when public-company per-location metric + SOX 302/404/906 + FASB ASC 280 + ASC 606 + ASC 842. None writes a per-location per-metric per-period WORM ingestion audit trail with regulatory-defense retention. The four-skill bundle Ingest + Normalize + Reconcile + Audit sits above the per-location POS + KDS + inventory + loyalty + workforce + DSP/ESP + analytics + review + SEO + social + field-service + payments + warehouse substrate — it does not replace it.

How does Ingest + Normalize work?

Ingest runs per-location per-source per-metric ingestion via per-vendor SDK + OAuth 2.0 + OIDC + SAML + API-key + mTLS + JWT + HMAC-SHA256 authentication + REST + GraphQL + SOAP + webhook + polling + file-export + SFTP + S3-bucket + JDBC + ODBC data-transport. Per-source DPA + per-API rate-limit + per-source ToS compliance. Per-source idempotent-retry semantics (exponential backoff + jitter + Conflict 409 dedup + 429 retry-after + 503 circuit-breaker + dead-letter queue). Per-source schema drift detection (per-source schema versioning + per-source schema evolution + breaking-change detection + per-source contract-test via Pact + Spring Cloud Contract). Normalize runs per-location per-metric normalization: per-location source-of-truth identification (per-location per-metric authoritative-source + per-source SLA + per-source freshness-window + per-source last-known-correct + per-source verified-status + per-source human-validation). Per-location unit-conversion (per-currency conversion via ECB + IMF exchange rate + per-unit conversion via UCUM Unified Code for Units of Measure + per-location measurement system (US Customary vs Metric vs Imperial) + per-location tax-jurisdiction). Per-location time-zone normalization (per-location IANA tz database time-zone + per-location DST handling + per-location business-day calendar + per-location holiday calendar + per-location week-start convention + per-location fiscal-calendar). Per-location currency normalization (per-currency ISO 4217 + per-currency rate + per-currency precision + multi-currency portfolio aggregation).

What does Reconcile + Audit do?

Reconcile runs per-location per-metric per-source reconciliation cadence: per-metric per-day reconciliation + per-week reconciliation + per-month reconciliation + per-quarter reconciliation + per-metric variance threshold (per-metric tolerance window + per-metric drift detection + per-metric anomaly via #608 per-location-per-cohort 2-sigma + multi-source consensus via per-source majority-vote + per-source weighted-average + per-source Bayesian posterior). Per-reconciliation severity classification: P0 source-of-truth gap (no authoritative source identifiable) + P1 multi-source variance > threshold 72-hour + P2 per-source schema-drift 7-day + P3 per-source rate-limit-exceeded 30-day + P4 docs-only. Gate runs 5 anchors per-location per-metric per-period before any metric distributes to downstream decision systems. (1) Per-location per-metric ingestion across 10-15 per-vendor sources + per-location source-of-truth identification + UCUM unit-conversion + IANA tz time-zone + ISO 4217 currency + per-metric per-source schema drift + per-metric per-source rate-limit + per-metric per-source reconciliation cadence + per-metric per-source idempotent-retry semantics. (2) FTC Section 5 + Pfizer 1972 + CFPB UDAAP + Lanham + USPTO + Robinson-Patman + FDD Item 19 financial performance representations when per-location metric shared with franchisees + 15-state franchise. (3) HIPAA + state mini-HIPAA + FINRA Rule 2210 + Rule 3110 + SEC Regulation FD + per-state professional licensing. (4) EU AI Act Article 50 transparency when AI-ML per-location metric routing + Article 13/14/15 + Annex III when AI-ML per-location metric drives operations + Article 6/27 FRIA + DSA + DMA + GDPR Article 6/7/22/28/30 + LGPD + DPDP + PIPEDA + Quebec Law 25 + CCPA + CPRA + 18-state. (5) WCAG 2.2 AA + ARIA + EAA + ADA Title III + Section 508 + SOX 302/404/906 + COSO + Exchange Act 13(b)(2) + FASB ASC 280 segment reporting + FASB ASC 606 revenue recognition + FASB ASC 842 leases + SEC Reg S-K. Audit writes a per-location per-metric per-period WORM ingestion record: per-location per-metric snapshot + per-source-of-truth identification + per-unit conversion result + per-time-zone normalization + per-currency normalization + per-source schema drift check + per-source rate-limit usage + per-source reconciliation cadence + per-anchor gate-pass + AI-ML provenance + EU AI Act FRIA. Retention: 7-year FTC + 7-year IRS + 7-year HIPAA + 7-year state bar + 6-year SEC + 3-year FINRA + 7-year SOX + GDPR Article 30 + EU AI Act Article 12 + SOC 2 CC7/CC8.

What does this skill connect to on the per-location-metric-ingestion agent and across the swarm?

On the per-location-metric-ingestion agent: per-location per-metric ingestion + per-source-of-truth + per-source reconciliation + per-source schema-drift. Across the swarm: per-location AI-calibrated forecasting (#600 DOWNSTREAM consumer of canonical per-location metric) + per-location per-cohort two-sigma anomaly detection (#608 DOWNSTREAM consumer of canonical per-location metric) + root-cause attribution sketch (#604 DOWNSTREAM consumer of per-location metric) + peer-cohort computation (#612 DOWNSTREAM consumer of per-location metric for feature-engineering) + per-location custom-system adapters (#611 same per-vendor SDK + OAuth + transport + Bulkhead/Circuit Breaker/Retry substrate) + integration-drift-monitor agent (#562 + #569 + #570 same per-source schema-drift substrate) + per-state-overlay-composer (#599 UPSTREAM canonical for FDD Item 19 + FINRA per-state) + real-time change-event emission (#603 UPSTREAM canonical for per-metric change-event) + per-field conflict-resolution policy (#607 same per-source authority hierarchy substrate). Commercial-pillar parent: /multi-location-metric-aggregation.

What does the 6-workstream pre-engagement-baseline reporting cycle look like for this skill?

Every two weeks during the Tier 3 Fractional CMO with AI Swarm engagement, six workstreams report against the pre-engagement baseline. Workstream 1: per-portfolio per-location per-metric per-period ingestion coverage — locations covered + per-location sources integrated + metrics ingested. Workstream 2: Ingest per-location per-source per-metric ingestion flow — per-vendor SDK + auth + transport + DPA + rate-limit + ToS compliance + per-source idempotent-retry + per-source schema drift detection absorbed. Workstream 3: Normalize per-location per-metric normalization flow — per-location source-of-truth + UCUM unit-conversion + IANA tz time-zone + ISO 4217 currency normalization. Workstream 4: Reconcile per-location per-metric per-source reconciliation cadence flow — per-day + per-week + per-month + per-quarter reconciliation + per-metric variance threshold + multi-source consensus. Workstream 5: Regulatory-defense audit coverage — per-location 10-15 source ingestion + source-of-truth + UCUM + ISO 4217 + IANA tz + schema drift + rate-limit + reconciliation cadence + EU AI Act Article 50 + FDD Item 19 + FINRA + SOX + FASB ASC 280/606/842. Workstream 6: FBC feedback-loop pattern-learning — per-location per-metric realized-vs-predicted ingestion + per-source schema-drift retrospective + per-source reconciliation variance retrospective.

Related reading

• Parent commercial pillar: multi-location metric aggregation
• Sibling build-pillar: per-location AI-calibrated forecasting (#600 DOWNSTREAM consumer of canonical per-location metric)
• Sibling build-pillar: per-location per-cohort two- sigma anomaly detection (#608 DOWNSTREAM consumer of canonical per-location metric)
• Sibling build-pillar: per-location custom-system adapters (#611 same per-vendor SDK + OAuth + transport substrate)
• Fractional CMO with AI Swarm
• AI Readiness Assessment