The central hub for GoodDollar's analytics and data work. This repo contains the active codebases, SQL queries, documentation, and data dictionary maintained by the data team.
Data Team Lead: @thalescb | Questions / requests: open an issue
data-team/
├── projects/
│ ├── onchain-analytics/ # On-chain analytics system (dbt + HyperSync pipeline, BigQuery)
│ ├── antseed-analytics/ # Antseed AI Credits analytics dashboard
│ ├── dashboard-scripts/ # GoodDollar main dashboard (Google Apps Script)
│ ├── weekly-report/ # Weekly data report automation
│ └── automations/ # n8n automation flows (archived)
├── queries/
│ └── dune/ # Dune Analytics SQL queries
├── tools/
│ └── utm-builder/ # UTM link builder — live at gooddollar.github.io/data-team/utm-builder/
└── docs/
├── data-dictionary/ # Data dictionary and definitions
├── datasources/ # Data source documentation
├── subgraph/ # GoodDollar subgraph schemas
└── dashboards.md # Links to live dashboards
| Project | Description | Status |
|---|---|---|
| onchain-analytics | 3-layer BigQuery warehouse (Staging → Semantic → Marts) fed by HyperSync, with dbt transformations. Powers all on-chain dashboards and reporting. | Active |
| antseed-analytics | Analytics dashboard for the GoodDollar x AntSeed AI Credits integration. Visualizes G$ deposits, AI credit usage, and wallet activity from the Antseed Worker API. | Active |
| dashboard-scripts | Google Apps Script powering the GoodDollar main dashboard | Active (v6) |
| weekly-report | Weekly data report automation | Active |
- dbt Docs Site — browsable data catalog with model lineage, column descriptions, and business glossary (auto-published from
projects/onchain-analytics/gd_dbt/) - UTM Builder — browser-based tool for generating tracked campaign URLs. See the UTM naming standard for the full convention.
- docs/ — data dictionary, data source documentation, subgraph schemas
Need data analysis, a query, a dashboard, or any other data deliverable?
Fill out the template. The more detail you provide, the faster and more accurately it can be delivered.
See CONTRIBUTING.md for how to contribute.