Instant BQML for Google Analytics 4 Properties Alpha

Launch an automated BigQuery machine learning model in minutes.

Fill in the fields below with details about your Google Cloud, BigQuery, and Google Analytics accounts. Upon completing all fields, click download to generate a customized JSON file. Upload the file to CRMint to automate your pipelines.

Take me to Instant BQML for Universal Analytics

  • Did you copy & paste the commands in More Details to the Cloud Shell Terminal, yet?
    Yes
    More details

    1. Go to https://console.cloud.google.com

    2. Select or create your project

    3. Click "Cloud Shell" button Cloud Project ID

    You are now ready to copy-paste these commands into the Cloud Shell Terminal:

    # Double check if a Cloud Project is selected.
    [ "$GOOGLE_CLOUD_PROJECT" == "" ] && echo -n 'Input a Cloud Project ID: ' && read project_id && gcloud config set project "$project_id"

    # Downgrade app-engine-python.
    sudo apt-get install google-cloud-sdk-app-engine-python=359.0.0-0

    # Install the command-line.
    bash <(curl -Ls https://raw.githubusercontent.com/instant-bqml/crmint/instant-bqml/scripts/install.sh) instant-bqml

    # Create a stage definition for your environment.
    crmint stages create

    # Re-run the setup in case new elements are needed.
    crmint cloud setup

    # Deploy the updated App Engine services.
    crmint cloud deploy
  • More details This is a Decision Tree regression model.
    Trained on last 12 months of data updated quarterly.
    Scores updated daily for visitors.
    This model contains the following features:
    • Device Category
    • Device Mobile Brand Name
    • Device Operating System
    • Device Browser
    • City
    • Metro
    • Traffic Source
    • Medium
    • Source
    All visitors are scored.
    The model output is a score between 0 and 1000.
    Higher scores denote higher likelihood.
  • Is the GA4 BigQuery Export located in the same Google Cloud Project as the CRMint application?
    Yes
    More details

    Your CRMint application can run in the same project as your GA4 BigQuery Export or a seperate project. Depending on the Cloud Project architecture, Instant BQML will notify you of specific permission requirements and alter queries to account for your specific Cloud Project architecture.
  • More details

    Cloud Project ID

    Your Cloud Project ID is a customizable unique identifier for your cloud project. Learn more about finding your Cloud Project ID here.
  • More details

    BigQuery Dataset ID

    For help identifying your BigQuery Dataset ID read more here.
  • More details

    BigQuery Dataset ID

    BigQuery datasets are stored in regional or multi-regional locations. For a full list of BigQuery dataset locations, please visit this link.
  • More details

    BigQuery Namespace

    Select a namespace for your Instant BQML output tables.
  • More details

    Google Analytics Measurement ID

    The Google Analytics Measurement ID can be found within Admin > Property Settings > Data Streams.
  • More details

    Google Analytics API Secret

    The Google Analytics API Secret can be found within Admin > Property Settings > Data Streams. Review the Help Center article for more details.
  • More details

    GA BigQuery Frequency

    The Google Analytics BigQuery export can be scheduled daily, streaming, or both. You make this selection when enabling your BigQuery Linking in Google Analytics. Review the Help Center article for more details.
  • Download Training Pipeline Download Prediction Pipeline