BigQuery Integration
Noa Lembersky avatar
Written by Noa Lembersky
Updated over a week ago

In this article, you will learn how to connect BigQuery to Forwrd and how to use it as a source when creating a scoring model.

Introduction to this integration

Adding BigQuery to Forwrd makes it easy to analyze and score your leads and customers by matching historical data (i.e., engagement, firmographics, demographics) against a business objective, to ultimately predict who will convert and why.

Here are some examples of use cases:

  • Predict which leads will become MQLs

  • Predict which MQLs will become Opportunities

  • Predict which Opportunities will become Paying customer

  • Predict which Customers will Expand

  • Predict which Customers will Churn

In addition to BigQuery, you are encouraged to add more data sources to develop a holistic, unbiased scoring model that considers ALL relevant user touchpoints.

What you need to get started:

  • A account

  • A BigQuery account

Setting up the integration

The first step will be to give Forwrd permission to view the data in BigQuery

  1. Go into your Google Cloud account and into the 'IAM' tab. Under 'PERMISSIONS' choose 'VIEW BY PRINCIPALS' and then press 'GRANT ACCESS'.

    BigQuery 1b.png
  2. A window will pop up on the right side of the screen. In the 'Add Principals' section, Under 'New Principals' write: [email protected]

  3. In the 'Assign Roles' section:

    1. Under 'Role' #1 write: 'BigQuery Data Viewer'

    2. Under 'Role' #2 write: 'BigQuery User'

  4. Press SAVE.

    BigQuery 2b.png

Now let's add BigQuery as a source in Forwrd

  1. Enter the Forwrd app, and navigate to the 'sources' layer.

  2. Click 'New Source' and select BigQuery.

  3. Give your source a name that anyone accessing Forwrd can easily recognize.

  4. From there, log in to BigQuery like you normally would.

  5. Once done, BigQuery will appear as a source in your 'Sources' panel in Forwrd.

  6. Click the 'three dots' icon to see more functions you can perform with this source. For example, you can share this source with another team member who uses Forwrd and test the connection to this source.

Thanks for taking the time to review these instructions.

If you need further help setting things up, or if you’d like to see a personalized, in-depth demo of Forwrd –book a demo with us. We'd love to help!

Did this answer your question?