Decode GA4

Analytics Areas

Website

• GA4
• Page Views
• Conversion: click to Marketplace
• UTM Links: click to Marketplace

Docs

• GA4
• Standard metrics only by page
• UTM Links: click to Marketplace

Marketplace

• Funnel by 7/30/365 day trailing window
• Viewed / Purchase Started/ Purchase Complete / Service Activated
• Manual CSV download (no API)

App

Users

• users federated table

Entitlements

• user_entitlements federated table

Subscriptions

• subscriptions federated table

Activity

Logs

• decode-ga4-public.USAGE_REPORTING_ext.decode_ga4_usage_logs table
• decode-ga4-public.USAGE_REPORTING_src.get_install_logs (start_date, end_date) table function
• decode-ga4-public.USAGE_REPORTING_src.get_run_logs (start_date, end_date) table function

Usage

• decode-ga4-public.USAGE_REPORTING_use.usage_report (start_date, end_date) table function
• decode-ga4-public.USAGE_REPORTING_use.usage_reporting_logs_success table
• decode-ga4-public.USAGE_REPORTING_use.usage_reporting_logs_fail table

Finance

Marketplace

• decode-ga4-public.marketplace_report.detailed_disbursement federated table
• decode-ga4-public.marketplace_report.incremental_insights federated table
• decode-ga4-public.marketplace_report.incremental_monthly_insights federated table

Revolut?

Content

Medium

• No API
• Potential for bot login to screenshot(!) daily stats

Linkedin

• No API

Substack?

• No API