How to build PQL Scoring in BigQuery using Segment data

---

The Architecture: Headless Product Intelligence

To implement PQL Scoring effectively, you need to move beyond simple event tracking, interactive funnel analysis and siloed dashboards. By leveraging your existing BigQuery infrastructure, you can create a single source of truth for your GTM and Product teams.

---

The "Logic Gap": Why Manual Implementation is Hard

1. The 'Dark' Account Activity: Individual PQL scores often miss the bigger picture. If three different users from the same account are active, the account is ready for a demo, but your user-level SQL won't catch it. See why redefining B2B SaaS metrics is critical for account-level visibility.
2. Complex Velocity Calculations: Calculating 'usage velocity' (e.g., % increase in API calls week-over-week) requires complex window functions in BigQuery that are difficult to debug and maintain.
3. Feedback Loop Breakage: Sales needs to know why a lead is a PQL. Hard-coded SQL scores lack the metadata needed to provide context to the GTM team. Proper onboarding automation can bridge this gap.

---

Implementation: The BigQuery-Native Code

If you were to build this manually, your dbt model or SQL query in BigQuery might look like this:

/*
   Generic example for PQL Scoring
   Tailored for BigQuery architecture
*/

WITH raw_events AS (
    SELECT
        account_id,
        event_name,
        timestamp
    FROM `bigquery.raw_data.events`
    WHERE event_name IN ('trial_started', 'billing_limit_reached', 'premium_feature_used')
),

calculated_metrics AS (
    -- BigQuery-specific logic for PQL Scoring
    -- e.g., using specific window functions or time-travel
    SELECT
        account_id,
        COUNT(*) as signal_volume,
        DATE_TRUNC('day', timestamp) as metric_date
    FROM raw_events
    GROUP BY 1, 3
)

SELECT * FROM calculated_metrics;

---

The GrowthCues Advantage: Automate the Signal

While the code above provides a starting point, GrowthCues eliminates the need for manual SQL maintenance entirely. You can define PQL Scoring using our no-code Milestone Editor, and GrowthCues will automatically:

• Calculate the signal at the account level using your Segment data.
• Detect anomalies and behavioral shifts using robust statistical methods.
• Push actionable signals back into your BigQuery, where you can activate them directly into the tools your team uses (Slack, HubSpot, Salesforce).

GrowthCues acts as the Headless Intelligence Layer for your BigQuery. It connects directly to your Segment tables and automatically:

• Calculates PQL Scoring at the account level.
• Detects anomalies and behavioral shifts in real-time.
• Pushes actionable signals back into your warehouse, where you can activate them directly into the tools your team uses (Slack, HubSpot, Salesforce).

Deep Dive: The PQL Framework

Learn how to move beyond simple lead scoring. Read about Redefining B2B SaaS Metrics to focus on account-centric value.

Ready to turn your raw BigQuery data into revenue?

Join the Technical Preview