You can now integrate BigQuery with Profit.co and modernize your smart analytics warehouse by creating key results and perform check-ins instantly.

Step 1:

  • Go to Settings → Integrations → User Level Connectors
User-Level-Connectors

Step 2:

  • Enable the BigQuery toggle in the User Level Connectors.
bigquery
  • After enabling it at the firm level,
enable-bigquery

Step 3:

  • Go to Preferences → Integrations.
integration

Step 4:

  • In Integrations manage your BigQuery.
manage-bigquery
  • Click on the + icon to login to your BigQuery.
sign in to bigquery

Step 5:

  • Enter your connection name and click Sign In to BigQuery.
Sign-in-bigquery
  • Enter your email address and click Next.
Sign-in-bigquery
  • Enter your password and click Next.
sign-in bigquery-password
  • Select Allow for the access.
confirm-choice
  • After getting connected,
bigquery-connection

Step 6:

  • Create Key Result using Form.
using-form
  • Note: We can use only numeric as the value & we can select only two KPI. They are Increase & Decrease KPI.
  • Let’s create the Key Result using Increase KPI.
increase-KPI
  • Select the KPI and add it.
select-KPI
  • Enable the toggle for Auto Update.
choose-connection
  • After enabling it, choose the connection as BigQuery.
choose-bigquery
  • After connecting to the BigQuery select the Project name .
please-choose
  • After that select the path of the value in the database and click Run.
boquery-sql
  • After entering the values for Column and Row you’ll be getting the Current Value. Finally, click on the Add button.
connect-bigquery-sql
  • Manually add From value and To value as your target and click Next.
set-kr-value
  • Select the Target Date for the Key result.
set-target-value
  • Complete the remaining process and click Create.

Step 7:

  • After creating it you’ll be getting the Key Result as shown below..
increase-no-of-kpi
  • While updating the Key result i.e. check-in process you’ll be getting the current value of the Row and Column.
check-in-increase
  • If you check-in you’ll be redirected to the review page. Finally, you can Update it.
check-in
  • After Updation, you’ll be getting changes in the Key Result.
okr-from