BigQuery & Integration

Every event with:
├── Event name
├── Event timestamp
├── User pseudo ID
├── All event parameters
├── User properties
├── Device info
├── Geo info
├── Traffic source
└── E-commerce data (if applicable)

□ Google Cloud project
□ BigQuery enabled in project
□ Billing account (free tier available)
□ GA4 property admin access

1. Create Google Cloud project (console.cloud.google.com)
2. Enable BigQuery API
3. In GA4: Admin → Product links → BigQuery links
4. Click "Link"
5. Select Cloud project
6. Choose export options:
   ├── Daily export
   ├── Streaming export (or both)
   └── Region for data storage
7. Click "Submit"

project.dataset.events_YYYYMMDD (daily tables)
project.dataset.events_intraday_YYYYMMDD (streaming)

Example table name:
my-project.analytics_123456789.events_20250115

Free tier includes:
├── 10 GB storage free
├── 1 TB queries/month free
└── No charge until exceeded

Typical costs (if exceeded):
├── Storage: $0.02/GB/month
├── Queries: $5/TB processed
└── Streaming inserts: $0.01/200MB

SELECT
  event_name,
  COUNT(*) as event_count
FROM
  \`project.dataset.events_*\`
WHERE
  _TABLE_SUFFIX BETWEEN '20250101' AND '20250131'
GROUP BY
  event_name
ORDER BY
  event_count DESC

-- Get page_location from page_view events
SELECT
  event_timestamp,
  (SELECT value.string_value
   FROM UNNEST(event_params)
   WHERE key = 'page_location') as page_location
FROM
  \`project.dataset.events_*\`
WHERE
  event_name = 'page_view'
  AND _TABLE_SUFFIX = '20250115'

SELECT
  COUNT(DISTINCT user_pseudo_id) as users,
  COUNT(DISTINCT CONCAT(user_pseudo_id,
    CAST((SELECT value.int_value FROM UNNEST(event_params)
    WHERE key = 'ga_session_id') AS STRING))) as sessions
FROM \`project.dataset.events_*\`
WHERE _TABLE_SUFFIX BETWEEN '20250101' AND '20250131'

WITH sessions AS (
  SELECT
    CONCAT(user_pseudo_id,
      CAST((SELECT value.int_value FROM UNNEST(event_params)
      WHERE key = 'ga_session_id') AS STRING)) as session_id,
    MAX(IF(event_name = 'purchase', 1, 0)) as converted
  FROM \`project.dataset.events_*\`
  WHERE _TABLE_SUFFIX BETWEEN '20250101' AND '20250131'
  GROUP BY session_id
)
SELECT
  COUNT(*) as total_sessions,
  SUM(converted) as conversions,
  ROUND(SUM(converted) / COUNT(*) * 100, 2) as conversion_rate
FROM sessions

□ Always filter by _TABLE_SUFFIX to limit scans
□ Use UNNEST for nested parameters
□ Create views for common queries
□ Schedule queries for regular reports
□ Use partitioned tables for large datasets

When GA4 + Google Ads are linked:
├── Import conversions to Google Ads
├── View Google Ads data in GA4
├── Export audiences for remarketing
├── Enable auto-tagging
└── Access Google Ads campaigns in reports

GA4: Admin → Product links → Google Ads links → Link

Configure:
├── Select Google Ads account(s)
├── Enable auto-tagging (recommended)
├── Enable personalized advertising
└── Submit

Auto-tagging adds gclid parameter to URLs:
yoursite.com/?gclid=ABC123xyz

Benefits:
├── Accurate campaign attribution
├── Links clicks to conversions
├── Enables detailed Google Ads reports
└── Required for conversion import

In Google Ads:
Tools → Conversions → New → Import → Google Analytics 4

Select:
├── GA4 property
├── Key events to import
├── Primary vs secondary status

Combined data shows:
├── Organic queries (from GSC)
├── Landing pages with clicks + impressions
├── Position data in GA4 reports
└── Full organic search funnel

Admin → Product links → Search Console links → Link

Requirements:
├── Same Google account for both
├── Verified Search Console property
├── GA4 property admin access

Reports → Acquisition → Acquisition overview → View Google organic search

Or:

Reports → Search Console → Queries/Pages

Use cases:
├── Custom dashboards
├── Automated reporting
├── Data pipelines
├── Integrations

Authentication:
├── Service account (server-to-server)
├── OAuth 2.0 (user-based)

// Server-side event example
const payload = {
  client_id: 'user_123',
  events: [{
    name: 'purchase',
    params: {
      transaction_id: 'T12345',
      value: 99.99,
      currency: 'USD'
    }
  }]
};

fetch(\`https://www.google-analytics.com/mp/collect?measurement_id=G-XXXXX&api_secret=YOUR_SECRET\`, {
  method: 'POST',
  body: JSON.stringify(payload)
});

Admin → Data Streams → Select stream → Measurement Protocol API secrets → Create

## For API/Measurement Protocol

□ Always test in DebugView first
□ Include client_id for user association
□ Use timestamp_micros for historical events
□ Validate payload structure before sending
□ Monitor Events report for delivery confirmation
□ Keep API secrets secure (never client-side)