/
Attribution
/
Web
/
Google Analytics

How to Integrate Campaignswell with Google Analytics (via BigQuery)

‍

Step 1. Set Up a Google Cloud BigQuery Project

  • Go to Google Cloud Console
  • Enter a name for your project and click “Create”
Set Up a Google Cloud BigQuery Project
  • Click the project dropdown menu (top navigation bar)
Click the project dropdown menu
  • Click “New Project”
Click “New Project”
  • Enter a name for your project and click “Create”
Enter a name for your project and click “Create”
  • After creation, select your new project from the dropdown
After creation, select your new project from the dropdown

Step 2. Enable the BigQuery API

  • In the Google Cloud Console, use the search bar to find “BigQuery API”
    • Step 2. Enable the BigQuery API
  • Click on the result, then click “Enable”
    • Click on the result, then click “Enable”

    Step 3. Link Google Analytics to BigQuery

  • Go to your Google Analytics Admin Panel.
  • Under the Property column, click “BigQuery Links”.
    • Step 3. Link Google Analytics to BigQuery
  • Click the “Link” button
    • Click the “Link” button
  • Choose the BigQuery project you just created
    • Choose the BigQuery project you just created
    In the linking setup, select all available checkboxes
  • In the linking setup, select all available checkboxes (e.g., streaming data, daily export)
  • Click Save to complete the link
    • Click Save to complete the link
    Your Google Analytics data will start appearing in BigQuery in about 24 hours
    Your Google Analytics data will start appearing in BigQuery in about 24 hours

    ‍

    Step 4. Give an access to Campaignswell

  • In Google Cloud Quick access panel select IAM and admin
    • Step 4. Give an access to Campaignswell
  • Select Grant access
    • Select Grant access
  • In New Principal section write an email, provided by Campaignswell and select an Owner role, click Save
    • In New Principal section write an email, provided by Campaignswell and select an Owner role, click Save

    ‍

    FAQ

    What to Do When You Hit GA4 Limits

    GA4 has a hard cap of 1,000,000 events/day per property. Once you hit it, data drops. Here's what to do.

    Reduce events exported to BigQuery

    Keep only the essential events in your GA4 → BigQuery export:

    • All cw_ events
    • first_visit
    • session_start
    • page_view

    How to configure:

    1. Go to BigQuery links
    2. Go to Configure data streams and events
    3. Exclude unnecessary streams, or specify events by name to exclude
    4. Apply and Save changes

    Other Solutions

    1. Split funnels across multiple GA4 properties One GA4 property per funnel. Keeps each property under the limit. Best long-term fix.

    2. Fork Amplitude → Campaignswell endpoint Send events to Campaignswell in parallel. Tracking continues even if GA4 is throttled. Contact your CSM to configure.

    3. Add UTM parameters to Stripe Pass utm_source, utm_medium, utm_campaign into Stripe metadata at checkout. Recommended regardless of GA4 limits — improves attribution across all paid channels.

    4. GA360 Removes the limit entirely. Starts at $50,000/year — enterprise only.

    Immediate workaround

    Disable all non-purchase events in GA4 to unblock data export. Temporary measure only — implement one of the solutions above in parallel.

    Questions? Contact your Campaignswell CSM.

    ‍

    ‍