# DataContractGate contract catalog

> Ready-to-use data contracts for common client exports (Stripe, Shopify,
> QuickBooks, HubSpot, Salesforce, GA4, Square, Xero, and generic CSVs).
> Pick a source, fork the contract, and validate your client's file the same
> day. Vendor contracts are compatible with that vendor's documented schema;
> DataContractGate is not affiliated with or endorsed by any of them.
> The generic transactions CSV is an open spreadsheet column set, not a vendor.

Catalog index: https://app.datacontractgate.com/catalog

## Contracts

- [US Census Bureau — Public data](https://app.datacontractgate.com/catalog/acs-5year-2023-county): Compatible with the US Census Bureau American Community Survey 5-year API; not affiliated with the U.S. Census Bureau. County-level 2023 population and median household income in 2023 inflation-adjusted dollars. A raw Census API pull is strings, including numeric estimates and placeholder codes such as -666666666; B19013_001M is the margin of error and B19013_001MA is its text annotation.
- [Google Analytics 4 — Analytics](https://app.datacontractgate.com/catalog/ga4-audience-export): Outbound GA4 audience row at egress, for an ads partner or reverse ETL. Not affiliated with Google. Sample ids are fake.
- [Google Analytics 4 — Analytics](https://app.datacontractgate.com/catalog/ga4-events-raw): Raw GA4 BigQuery events row at ingest. Compatible with Google Analytics 4's documented BigQuery export; not affiliated with Google. Root of the GA4 events contract family.
- [Google Analytics 4 — Analytics](https://app.datacontractgate.com/catalog/ga4-events-staged): Cleaned GA4 event between stages: ISO event_date, lowercase platform, UTC event_at. Not affiliated with Google.
- [Google Analytics 4 — Analytics](https://app.datacontractgate.com/catalog/ga4-bigquery-events): GA4 BigQuery Export events — core scalar columns of the daily events_ table. Compatible with Google Analytics 4's documented BigQuery export schema; not affiliated with Google. Nested RECORD columns (event_params, user_properties, items) are omitted from this core contract.
- [Spreadsheet CSV — Spreadsheets](https://app.datacontractgate.com/catalog/generic-sheets-transactions-csv): Generic transactions / ledger CSV for spreadsheet, bank, and bookkeeping exports. Open column set (date, description, amount, currency) documented with the project; file syntax follows RFC 4180. Not a vendor schema.
- [HubSpot — CRM](https://app.datacontractgate.com/catalog/hubspot-contacts): HubSpot CRM contact — default properties from the Contacts API / export. Compatible with HubSpot's documented default contact properties; not affiliated with HubSpot. Lifecycle stages listed here are the defaults; newer accounts can define their own.
- [Stripe — Payments egress](https://app.datacontractgate.com/catalog/partner-payout-feed): Outbound partner payout feed. Egress gate before reverse ETL or a partner API. Derived from revenue_daily_mart. Not affiliated with Stripe.
- [Intuit QuickBooks Online — Accounting](https://app.datacontractgate.com/catalog/quickbooks-invoices): QuickBooks Online Invoice entity — core fields from the Accounting API. Compatible with Intuit's documented Invoice entity; not affiliated with Intuit or QuickBooks.
- [Stripe — Payments mart](https://app.datacontractgate.com/catalog/revenue-daily-mart): Daily revenue mart grain built from staged charges. Between-stages gate, kept alongside dbt, Great Expectations, or Soda. Derived from stripe_charges_staged. Not affiliated with Stripe.
- [Salesforce — CRM](https://app.datacontractgate.com/catalog/salesforce-account): Salesforce Account object — core standard fields from the Object Reference. Compatible with Salesforce's documented Account object; not affiliated with Salesforce.
- [Salesforce — CRM](https://app.datacontractgate.com/catalog/salesforce-opportunity): Salesforce Opportunity object — core standard fields from the Object Reference. Compatible with Salesforce's documented Opportunity object; not affiliated with Salesforce.
- [Shopify — Commerce](https://app.datacontractgate.com/catalog/shopify-fulfillment-notice): Outbound Shopify fulfillment notice at egress, for a warehouse or 3PL. Not affiliated with Shopify. Sample ids are fake.
- [Shopify — Commerce](https://app.datacontractgate.com/catalog/shopify-orders-raw): Raw Shopify orders CSV row at ingest. Compatible with Shopify's documented orders export; not affiliated with Shopify. Root of the Shopify orders contract family.
- [Shopify — Commerce](https://app.datacontractgate.com/catalog/shopify-orders-staged): Typed Shopify order between stages: money as a number and ordered_at in UTC. Not affiliated with Shopify.
- [Shopify — Commerce](https://app.datacontractgate.com/catalog/shopify-orders): Shopify orders CSV export — core columns from the Store admin Orders export. Compatible with Shopify's documented orders CSV; not affiliated with Shopify. Values are CSV strings; money columns are validated as decimal strings.
- [Square — Payments](https://app.datacontractgate.com/catalog/square-payments): Square Payment object — core fields from the Payments API. Compatible with Square's documented Payment object; not affiliated with Square.
- [Stripe — Payments ingest](https://app.datacontractgate.com/catalog/stripe-charges-raw): Raw Stripe Charge object at ingest. Compatible with Stripe's API Charge object; not affiliated with Stripe. Root of the Stripe charges contract family.
- [Stripe — Payments staging](https://app.datacontractgate.com/catalog/stripe-charges-staged): Cleaned Stripe charge row after the raw ingest transform. Between-stages gate. Derived from stripe_charges_raw. Not affiliated with Stripe.
- [Stripe — Payments](https://app.datacontractgate.com/catalog/stripe-charges): Stripe Charge object — core fields of an exported Stripe charge. Compatible with Stripe's API Charge object; not affiliated with Stripe.
- [Stripe — Payments](https://app.datacontractgate.com/catalog/stripe-customers): Stripe Customer object — core fields of an exported Stripe customer. Compatible with Stripe's API Customer object; not affiliated with Stripe.
- [Xero — Accounting](https://app.datacontractgate.com/catalog/xero-invoices): Xero Invoice — core fields from the Accounting API Invoices endpoint. Compatible with Xero's documented Invoice object; not affiliated with Xero. Date and DueDate match the raw JSON API (/Date(milliseconds+offset)/), not YYYY-MM-DD.
