• Members 38 posts
    Dec. 4, 2023, 7:26 a.m.

    Sampling is an issue for me. I need the raw data. Please guide here.

  • Mod
    Dec. 4, 2023, 7:41 a.m.

    To pull your data from Google Analytics 4 to BigQuery:

    1. Create a Google-APIs-Console project.

    2. Enable BigQuery.

    3. Link BigQuery to a Google Analytics 4 property.

    Let’s take a detailed look at all the steps to pull data from GA4 to BigQuery.

    Step 1: Create a Google-APIs-Console project as the first step.
    To setup an APIs-Console project:

    Open the Google APIs Console and log in.
    Click on Select a project.
    Choose an existing project or start a new one.

    1.png

    Step 2: Activate BigQuery
    Visit the table of APIs.
    Select Library by clicking APIs & Services from the Navigation menu.

    2.png

    Select the BigQuery API option under Google Cloud APIs.

    3.png

    When a new page appears, click Enable.
    To your Cloud project, add a service account. Check that firebase-measurement@system.gserviceaccount.com is a project member with the editor-role assigned.
    Step 3: Connect Google Analytics 4 to BigQuery
    Enter your Google Analytics login information. The account should have Edit access to the Google Analytics 4 property you’re working with and Owner access to your BigQuery project.
    Go to the Admin section, and find the Analytics property you need to link to BigQuery.

    4.png

    Set BigQuery Linking on in the Property column.
    Click Link
    After clicking Link, Click to view the projects you have access to

    5.png

    Select a BigQuery project. Click Learn more to begin a new BigQuery project.
    Click Confirm after selecting your project.

    6.png

    Choose a location. (You cannot define this option if your project already contains a dataset for the Analytics property.)
    Choose Next.

    7.png

    Choose the data streams from which you wish to export the information.
    Check Add advertising identifiers for mobile app streams if you need to include them.
    Set the Frequency to Daily Export.
    Click Submit.

    8.png

    Within 24 hours, Google Analytics 4 data will appear in your BigQuery project.

    You will have all raw user behavior data in BigQuery. However, you must include cost data from advertising providers, data from CRM systems, call monitoring services, and mobile apps to do marketing analysis and identify your growth zones and weak points. The data should also be combined into a single dataset and made business-ready so marketers can quickly produce reports using BigQuery data.

    8.png

    PNG, 334.9 KB, uploaded by agkhy on Dec. 4, 2023.

    7.png

    PNG, 102.3 KB, uploaded by agkhy on Dec. 4, 2023.

    6.png

    PNG, 102.7 KB, uploaded by agkhy on Dec. 4, 2023.

    5.png

    PNG, 85.7 KB, uploaded by agkhy on Dec. 4, 2023.

    4.png

    PNG, 286.7 KB, uploaded by agkhy on Dec. 4, 2023.

    3.png

    PNG, 175.0 KB, uploaded by agkhy on Dec. 4, 2023.

    2.png

    PNG, 250.4 KB, uploaded by agkhy on Dec. 4, 2023.

    1.png

    PNG, 137.4 KB, uploaded by agkhy on Dec. 4, 2023.