BigQuery connection stateexecution: v1.1
Not connected in this tower
Query execution against
seesight-marketing-data is not wired in v1 -- this screen makes no BigQuery calls and shows no query results. It is informational only, sourced from docs/marketing/specs/ads-engine-integration.md. Live queries land in v1.1, once BigQuery credentials are provisioned for this app and a read-only query surface is added to the growth admin API or a dedicated warehouse API.Datasetsproject: seesight-marketing-data
| Dataset | Status | Note |
|---|---|---|
| analytics_298409639 | live | GA4 export |
| raw_google_ads | live | Ads transfer STALE since 2026-04-26 -- lost auth, needs re-authorization |
| raw_stripe | live | Stripe raw export |
| identity | not deployed | identity.person design ready, not yet deployed |
| capture | not deployed | capture-era tables, not yet deployed |
Deploy checklistidentity-graph deployment, from the integration spec
Rotate the Google Ads developer token in the API Center (an old copy is compromised in tracked source history).
Re-authorize the Google Ads BigQuery Data Transfer (stale since 2026-04-26).
Enable datamanager.googleapis.com and grant ADC project allowlisting/scope so Google conversion uploads can leave dry-run.
Update the Stripe CTE in identity_person.sql to read the new flat metadata keys (schema bridge) alongside the old nested shape.
Create the identity and capture datasets per the seesight-ads repo's gated deployment instructions.
Provision SHARE_LINK_SECRET when the share-token port ships.