Pipeline Setup

Connect your Google Ads and GA4 accounts to unlock every insight in ClickCatalyst

Finding Your Keys

You need two identifiers to unlock the pipeline:

1. Google Ads Customer ID

Open Google Ads. Top-right corner, next to your email — you'll see a 10-digit number formatted like 123-456-7890. That's your Customer ID.

2. GA4 Property ID

In Google Analytics, navigate to Admin → Property Settings → Property Details. Look for the numerical Property ID (e.g., 32455612). This is *not* the "G-" measurement ID used for tag installation.

Why both?

Google Ads tells the engine what you spent. GA4 tells it what happened after the click — conversions, bounces, revenue. Without both, the engine is flying blind and can't calculate true Return on Ad Spend.

Connection Methods: Manual vs. Discovery

There are two ways to connect your advertising accounts:

Manual Entry

Paste your Customer ID and Property ID, give the configuration a nickname (e.g., "Main Shop"), and hit Save. Best for single-account advertisers.

Discovery Mode

Click "Discover Accounts" and the engine scans your entire Google account hierarchy. It finds every Google Ads and GA4 account you have access to — clients, side projects, everything. This is the solution for agencies and multi-account managers.

The Hydration Phase

After you save a configuration, here's what happens behind the scenes:

1. Vault Creation

A private BigQuery dataset is provisioned exclusively for your account. Think of it as your dedicated analytical warehouse.

2. Historical Backfill (90 Days)

The engine doesn't just look at today. It pulls the last 90 days of campaign and analytics data to establish your performance baseline — what "normal" looks like before optimization begins.

3. Processing Time

Initial hydration takes 3–5 minutes. The engine is ingesting historical data, normalizing schemas, and wiring up the analytical pipelines. You'll see a progress indicator. After this, data syncs automatically every 24 hours.

Data Sovereignty & Deletion

You own your data. Here's how deletion works:

Surgical Purge

Delete one account configuration? The backend identifies and destroys every row tied to those Customer ID and Property ID combinations across all BigQuery tables. Not archived — deleted.

Total Vault Destruction

Delete your last remaining configuration? The engine drops the entire BigQuery dataset and revokes all OAuth tokens. No backups, no recovery. Your analytical footprint becomes zero.

We rent you the logic. You own the vault.

Troubleshooting Common Issues

"I can't connect my account"

You need Standard or Admin access to the Google Ads and GA4 accounts. Viewer-level permissions won't cut it — the API requires elevated access to pull reporting data.

"I see zeros everywhere"

If you just connected, give it up to an hour. The initial data sync can take 30–60 minutes depending on account size and API response times.

"My old data is missing"

The engine hydrates 90 days back from the connection date. Anything older than that window isn't included in the vault. If you need deeper history, contact support to discuss extended backfill options.

Technical FAQ

Q: Why do I need both a Google Ads ID and a GA4 ID?

Google Ads tracks what you spent — clicks, impressions, cost. GA4 tracks what happened after the click — conversions, bounces, revenue, engagement. The engine needs both to calculate real ROAS and identify where your funnel is losing money.

Q: Is my data shared with other ClickCatalyst users?

Never. Your BigQuery dataset is isolated with a unique hash derived from your account. Other users can't access it. We can't access it unless you explicitly grant support permission.

Q: Can I connect multiple Google Ads or GA4 accounts?

Yes. Use Discovery Mode to scan and connect all accounts in your Google hierarchy. This is designed for agencies and portfolio managers handling multiple client accounts.

Q: What happens if I disconnect an account?

All data tied to that account's Customer ID and Property ID is permanently purged from your BigQuery vault within seconds. The deletion is irreversible.

Q: How long does the initial setup take?

The hydration phase takes 3–5 minutes. After that, incremental data syncs happen automatically every 24 hours.

Q: Does ClickCatalyst support currencies other than USD?

Yes. The platform normalizes all currency values to your workspace's default currency using daily exchange rates. All dashboards, thresholds, and calculations adapt automatically — no manual conversion required.

Pipeline Setup | ClickCatalyst