# Acme Cloud: data stack (fictional example of martech-context/stack.md)

This is the file the worked example reads first. It shows the fields the audit needs. A real one holds no secrets: no keys, tokens, passwords or connection strings.

## Business

- Acme Cloud sells self-serve and sales-assisted plans at example.com.
- Business time zone: America/New_York. Reporting currency: USD.
- FX: monthly average rates in `dbt_prod.fx_rates_monthly`; policy not yet written in decisions.md.

## Warehouse

- BigQuery, location US.
- Datasets: `analytics_123456789` (GA4 export, daily and streaming), `fivetran_google_ads`, `fivetran_facebook_ads`, `fivetran_linkedin_ads`, `fivetran_hubspot`, `fivetran_stripe`, `dbt_prod`, `dbt_prod_dbt_test__audit`.
- Audit access: the BigQuery remote MCP server with `execute_sql_readonly`; `execute_sql` and `cancel_job` denied in the client and by an IAM deny policy on tools that are not read-only. Data Viewer on the datasets above, Job User on the project, and a custom role with `bigquery.jobs.list` for Q23.

## Sources and connectors

- GA4: property 123456789, measurement ID G-XXXXXXXXXX, time zone America/New_York, currency USD, standard property. Owner: Analytics engineer.
- Google Ads: customer 123-456-7890 (stored as 1234567890), USD, time zone America/Los_Angeles. Conversion actions Trial started and Demo booked (primary, 90-day click windows), Pricing view (secondary). Auto-tagging on. Fivetran, Conversion Window Size 30. Owner: Paid media lead.
- Meta: ad account act_1234567890, USD, America/New_York. CompleteRegistration (trial) and Lead (demo). Fivetran Facebook Ads, prebuilt reports (9-day rollback). Owner: Paid media lead.
- LinkedIn: ad account 500000001, EUR. Demo request conversion. Fivetran LinkedIn Ads. Owner: not recorded.
- HubSpot: one portal, America/New_York. Hidden form fields gclid, gbraid, wbraid and ga_client_id. Fivetran, soft deletes on deals (`_fivetran_deleted`), no history mode. Owner: RevOps lead.
- Stripe: live account; customer metadata `acme_account_id` links to the CRM account. Fivetran. Owner: Finance lead.
- All Fivetran connections sync every 6 hours.
- Note: this account list was built from the accounts present in the warehouse, not from the platforms' own lists.

## Transformation

- dbt project `acme_marketing` on the dbt platform (Core engine 1.10), on BigQuery.
- Production job: nightly at 06:00 America/New_York with the "Run source freshness" checkbox ticked. A second job runs `dbt source freshness` and `dbt test` at 06:00 and 18:00.
- Critical models: `stg_ads__daily_spend`, `fct_paid_media_daily`, `fct_deals`, `mart_pipeline_by_source`, `fct_invoices`, `fct_qualified_demos`, `mart_sessions`.

## Outputs and activation

- Looker Studio dashboards: Paid media daily, Pipeline by source, Revenue by channel, Exec KPIs.
- Hightouch uploads qualified demos from `fct_qualified_demos` to Google Ads offline conversions daily at 07:00 America/New_York, on its own schedule.

## Owners (roles only)

- Paid media lead, RevOps lead, Analytics engineer, Finance lead, Marketing ops lead.
- Alerts go to a shared data-alerts channel. No backups named.