LogoLogo
DoubleLoop homepagePrivacy policyContact support
  • General
    • Quickstart to Impact-Oriented Strategy
    • Roles
    • Build your First Proof-of-Concept
  • Map building
    • Map objects
  • Metrics
    • How to add metric data
    • Metric types
    • Control the stats on your strategy map
      • Weighted averages
    • Google Sheets integration
    • Amazon Redshift integration
    • BigQuery integration
    • CSV file upload
    • Google Analytics integration
    • Looker Action Hub integration
    • Looker API integration
    • Amplitude integration
    • Mixpanel integration
    • MySQL
    • PostgreSQL
    • Snowflake integration
    • Dedicated outbound IPs
    • Data segmentation
    • Bulk Importing Bookmarklet
  • Work
    • Jira app
    • Event fields
    • Asana integration
  • Share
    • Access settings for maps
    • Automated Slack reports
  • AI assistants
    • Company Map Generator (AI assistant)
  • Other
    • Privacy Policy
    • Terms of Use
    • Contact support
    • Security
Powered by GitBook
On this page

Was this helpful?

  1. Metrics
  2. Control the stats on your strategy map

Weighted averages

When a simple average won't suffice.

PreviousControl the stats on your strategy mapNextGoogle Sheets integration

Last updated 2 years ago

Was this helpful?

For a metric like conversion rate, a simple average over multiple days provides a misleading picture. For example, activity on the weekends is often much different than the weekdays. Here's how to do weighted averages in DoubleLoop so you can get an accurate sense of metric performance over time.

  1. Instead of sending a metric like conversion rate to DoubleLoop, send the numerator and the denominator as separate metrics. For example, create two separate metrics for transactions and sessions.

  2. Create a metric source in DoubleLoop I set "Calculated" as the source. This will allow you to select the numerator and denominator.

  3. Attach a metric to your calculated metric source.

  4. For the roll-up calculation for the metric, choose "Weighted average." When this option is selected, the map stats will divide the sum of the numerator values by the sum of the denominator values.

Creating a metric source where you can specify the numerator and denominator