Funding region agreement - Token Terminal Docs

One row per funding venue, chain, funding confidence and region confidence, for wallets that venue funded. hit_rate is hits divided by wallets_with_region, null where the venue’s expected band is not known.

Columns

Column	Type	Description
`funding_venue_project_id`	STRING	Venue that funded the wallets in this row.
`chain_id`	STRING	Chain the wallets are on.
`chain_family`	STRING	Chain family the chain belongs to, from `dimensions.chains`.
`funding_confidence`	STRING	`high`, `medium` or `low`, the wallets’ funding confidence tier.
`region_confidence`	STRING	`high`, `medium` or `low`, or null where region has no signal.
`wallets`	INT64	Wallets funded by this venue, on this chain, at this funding confidence tier.
`wallets_with_region`	INT64	Of those, wallets with a non-null region.
`expected_band`	STRING	Region band this venue is expected to fall in. Null where the expectation is not known for this venue and chain family.
`hits`	INT64	Of `wallets_with_region`, wallets whose region matched `expected_band`.
`hit_rate`	FLOAT64	`hits` divided by `wallets_with_region`. Null where `expected_band` is null.

Sample queries

One venue's hit rate by chain
Hit rate across every venue, at high confidence
Venue name alongside the hit rate

hit_rate compares a venue’s wallets against its own expected band, so filtering to one venue reads how consistent it is across chains and confidence tiers.

select
    chain_id,
    funding_confidence,
    region_confidence,
    wallets_with_region,
    hit_rate
from `reports_accounts.funding_region_agreement`
where funding_venue_project_id = 'coinbase'
order by chain_id, funding_confidence

Summing hits and wallets_with_region before dividing avoids averaging an average across venues of very different sizes.

select
    funding_venue_project_id,
    sum(hits) as hits,
    sum(wallets_with_region) as wallets_with_region,
    safe_divide(sum(hits), sum(wallets_with_region)) as hit_rate
from `reports_accounts.funding_region_agreement`
where funding_confidence = 'high'
  and expected_band is not null
group by funding_venue_project_id
order by hit_rate desc

funding_venue_project_id joins dimensions.projects for the display name.

select
    projects.name,
    agreement.chain_id,
    agreement.funding_confidence,
    agreement.hit_rate
from `reports_accounts.funding_region_agreement` as agreement
join `dimensions.projects` as projects
    on agreement.funding_venue_project_id = projects.project_id
where agreement.expected_band is not null
order by agreement.hit_rate desc
limit 50