Production Web Analytics

1 group of calculated metrics have references overlapping at or above the Jaccard similarity threshold (0.85). Near-duplicates produce subtly different numbers in different reports.

calculatedMetrics/cm_rev_per_visit_final, calculatedMetrics/cm_rev_per_visit_v2, calculatedMetrics/cm_rev_visit_linear, calculatedMetrics/cm_revenue_per_visit, calculatedMetrics/cm_revenue_visit_corrected, calculatedMetrics/cm_revpv_lasttouch, calculatedMetrics/cm_rpv_marketing

Designate one canonical metric per concept, document its choices, and deprecate the others by tagging them with a sunset date.

No prior snapshots of this implementation were detected alongside the input. Without snapshot history, configuration changes cannot be diffed, drift cannot be detected, and audit trails are unavailable for compliance review.

Establish a snapshot directory in version control and schedule regular runs of cja_auto_sdr / aa_auto_sdr to populate it.

No Solution Design Reference (SDR) document was supplied alongside this snapshot. Without an SDR, definitions live only in the platform UI, which makes peer review and onboarding harder and obscures the “why” behind component choices.

Generate the SDR via cja_auto_sdr / aa_auto_sdr and commit it alongside this snapshot. Suppress this rule via .sdr-grader.yaml if the SDR lives somewhere the grader cannot see.

60 references are broken — segments or calculated metrics point at component IDs that don't exist in this data view. Broken references are usually a symptom of components renamed or deleted without updating their consumers.

calc_metric calculatedMetrics/cm_revenue_per_visit -> missing metrics/revenue
calc_metric calculatedMetrics/cm_revenue_per_visit -> missing metrics/visits
calc_metric calculatedMetrics/cm_rev_per_visit_v2 -> missing metrics/revenue
calc_metric calculatedMetrics/cm_rev_per_visit_v2 -> missing metrics/visits
calc_metric calculatedMetrics/cm_revpv_lasttouch -> missing metrics/revenue
calc_metric calculatedMetrics/cm_revpv_lasttouch -> missing metrics/visits
calc_metric calculatedMetrics/cm_rev_visit_linear -> missing metrics/revenue
calc_metric calculatedMetrics/cm_rev_visit_linear -> missing metrics/visits
calc_metric calculatedMetrics/cm_revenue_visit_corrected -> missing metrics/revenue
calc_metric calculatedMetrics/cm_revenue_visit_corrected -> missing metrics/visits
calc_metric calculatedMetrics/cm_rpv_marketing -> missing metrics/revenue
calc_metric calculatedMetrics/cm_rpv_marketing -> missing metrics/visits
calc_metric calculatedMetrics/cm_rev_per_visit_final -> missing metrics/revenue
calc_metric calculatedMetrics/cm_rev_per_visit_final -> missing metrics/visits
calc_metric calculatedMetrics/cm_orders_per_visit -> missing metrics/orders
calc_metric calculatedMetrics/cm_orders_per_visit -> missing metrics/visits
calc_metric calculatedMetrics/cm_avg_order_value -> missing metrics/revenue
calc_metric calculatedMetrics/cm_avg_order_value -> missing metrics/orders
calc_metric calculatedMetrics/cm_bounce_rate_filtered -> missing metrics/bounces
calc_metric calculatedMetrics/cm_bounce_rate_filtered -> missing metrics/visits
calc_metric calculatedMetrics/cm_engagement_rate -> missing metrics/engaged
calc_metric calculatedMetrics/cm_engagement_rate -> missing metrics/visits
calc_metric calculatedMetrics/cm_signup_conversion -> missing metrics/signups
calc_metric calculatedMetrics/cm_signup_conversion -> missing metrics/visits
calc_metric calculatedMetrics/cm_paid_ratio -> missing metrics/paid_visits
calc_metric calculatedMetrics/cm_paid_ratio -> missing metrics/visits
calc_metric calculatedMetrics/cm_organic_share -> missing metrics/organic
calc_metric calculatedMetrics/cm_organic_share -> missing metrics/visits
calc_metric calculatedMetrics/cm_repeat_buyer_rate -> missing metrics/repeat
calc_metric calculatedMetrics/cm_repeat_buyer_rate -> missing metrics/buyers
calc_metric calculatedMetrics/cm_cart_to_order -> missing metrics/orders
calc_metric calculatedMetrics/cm_cart_to_order -> missing metrics/carts
calc_metric calculatedMetrics/cm_search_to_view -> missing metrics/views
calc_metric calculatedMetrics/cm_search_to_view -> missing metrics/searches
calc_metric calculatedMetrics/cm_video_completion -> missing metrics/completes
calc_metric calculatedMetrics/cm_video_completion -> missing metrics/starts
calc_metric calculatedMetrics/cm_email_ctr -> missing metrics/clicks
calc_metric calculatedMetrics/cm_email_ctr -> missing metrics/sends
calc_metric calculatedMetrics/cm_form_submit_rate -> missing metrics/submits
calc_metric calculatedMetrics/cm_form_submit_rate -> missing metrics/form_views
calc_metric calculatedMetrics/cm_promo_redemption -> missing metrics/redeems
calc_metric calculatedMetrics/cm_promo_redemption -> missing metrics/impressions
calc_metric calculatedMetrics/cm_help_resolution -> missing metrics/resolved
calc_metric calculatedMetrics/cm_help_resolution -> missing metrics/tickets
calc_metric calculatedMetrics/cm_pages_per_visit -> missing metrics/pageviews
calc_metric calculatedMetrics/cm_pages_per_visit -> missing metrics/visits
calc_metric calculatedMetrics/cm_active_user_rate -> missing metrics/active
calc_metric calculatedMetrics/cm_active_user_rate -> missing metrics/users
calc_metric calculatedMetrics/cm_returning_share -> missing metrics/returning
calc_metric calculatedMetrics/cm_returning_share -> missing metrics/users

… and 10 more (see JSON output)

Re-create the missing component, or update the segment / calculated metric to point at the current canonical equivalent.

60 calculated metric references are broken — the formula points at components, segments, or other calculated metrics that don't exist in this snapshot.

calculatedMetrics/cm_revenue_per_visit -> metrics/revenue
calculatedMetrics/cm_revenue_per_visit -> metrics/visits
calculatedMetrics/cm_rev_per_visit_v2 -> metrics/revenue
calculatedMetrics/cm_rev_per_visit_v2 -> metrics/visits
calculatedMetrics/cm_revpv_lasttouch -> metrics/revenue
calculatedMetrics/cm_revpv_lasttouch -> metrics/visits
calculatedMetrics/cm_rev_visit_linear -> metrics/revenue
calculatedMetrics/cm_rev_visit_linear -> metrics/visits
calculatedMetrics/cm_revenue_visit_corrected -> metrics/revenue
calculatedMetrics/cm_revenue_visit_corrected -> metrics/visits
calculatedMetrics/cm_rpv_marketing -> metrics/revenue
calculatedMetrics/cm_rpv_marketing -> metrics/visits
calculatedMetrics/cm_rev_per_visit_final -> metrics/revenue
calculatedMetrics/cm_rev_per_visit_final -> metrics/visits
calculatedMetrics/cm_orders_per_visit -> metrics/orders
calculatedMetrics/cm_orders_per_visit -> metrics/visits
calculatedMetrics/cm_avg_order_value -> metrics/revenue
calculatedMetrics/cm_avg_order_value -> metrics/orders
calculatedMetrics/cm_bounce_rate_filtered -> metrics/bounces
calculatedMetrics/cm_bounce_rate_filtered -> metrics/visits
calculatedMetrics/cm_engagement_rate -> metrics/engaged
calculatedMetrics/cm_engagement_rate -> metrics/visits
calculatedMetrics/cm_signup_conversion -> metrics/signups
calculatedMetrics/cm_signup_conversion -> metrics/visits
calculatedMetrics/cm_paid_ratio -> metrics/paid_visits
calculatedMetrics/cm_paid_ratio -> metrics/visits
calculatedMetrics/cm_organic_share -> metrics/organic
calculatedMetrics/cm_organic_share -> metrics/visits
calculatedMetrics/cm_repeat_buyer_rate -> metrics/repeat
calculatedMetrics/cm_repeat_buyer_rate -> metrics/buyers
calculatedMetrics/cm_cart_to_order -> metrics/orders
calculatedMetrics/cm_cart_to_order -> metrics/carts
calculatedMetrics/cm_search_to_view -> metrics/views
calculatedMetrics/cm_search_to_view -> metrics/searches
calculatedMetrics/cm_video_completion -> metrics/completes
calculatedMetrics/cm_video_completion -> metrics/starts
calculatedMetrics/cm_email_ctr -> metrics/clicks
calculatedMetrics/cm_email_ctr -> metrics/sends
calculatedMetrics/cm_form_submit_rate -> metrics/submits
calculatedMetrics/cm_form_submit_rate -> metrics/form_views
calculatedMetrics/cm_promo_redemption -> metrics/redeems
calculatedMetrics/cm_promo_redemption -> metrics/impressions
calculatedMetrics/cm_help_resolution -> metrics/resolved
calculatedMetrics/cm_help_resolution -> metrics/tickets
calculatedMetrics/cm_pages_per_visit -> metrics/pageviews
calculatedMetrics/cm_pages_per_visit -> metrics/visits
calculatedMetrics/cm_active_user_rate -> metrics/active
calculatedMetrics/cm_active_user_rate -> metrics/users
calculatedMetrics/cm_returning_share -> metrics/returning
calculatedMetrics/cm_returning_share -> metrics/users

… and 10 more (see JSON output)

Update the formula to reference the current canonical component or retire the calculated metric.

1 formula text appears verbatim on more than one calculated metric. Identical formulas are a red flag for accidental copy-paste rather than intentional duplication.

'revenue / visits': calculatedMetrics/cm_rev_per_visit_final, calculatedMetrics/cm_rev_per_visit_v2, calculatedMetrics/cm_rev_visit_linear, calculatedMetrics/cm_revenue_per_visit, calculatedMetrics/cm_revenue_visit_corrected, calculatedMetrics/cm_revpv_lasttouch, calculatedMetrics/cm_rpv_marketing

Pick one canonical metric, redirect consumers, and archive the duplicates.

120 dimensions in this data view have empty description fields. Descriptions are the primary way new analysts and AI agents understand what a component measures; missing descriptions force readers to infer intent from names alone, which is frequently wrong.

Dimensions: 120 of 203 missing (59%). The rubric threshold is 56%.

Generate the list of components missing descriptions via the data view API and populate them. Establish a CI check that fails new components added without descriptions.

3 segments mix container types (event / session / person) within a single definition. Mixed containers obscure intent and produce surprising population differences from segments that look superficially similar.

segments/seg_qualified_lead_v3  containers: event, session, person  depth: 8
segments/seg_high_intent_returning  containers: session, event  depth: 6
segments/seg_b2b_account_engaged  containers: event, session  depth: 6

Decompose the segment into composed sub-segments, one per container level, and combine them at the surface segment.

3 segments exceed the nesting depth threshold of 5. Deep nesting makes intent illegible — small definitional changes have unpredictable population effects.

segments/seg_qualified_lead_v3  depth: 8  containers: event, session, person
segments/seg_high_intent_returning  depth: 6  containers: session, event
segments/seg_b2b_account_engaged  depth: 6  containers: event, session

Decompose the segment into composed sub-segments named for what each layer captures.

30 calculated metrics have a complexity score above the rubric threshold of 22. High-complexity formulas are hard to review and easy to miscalibrate.

calculatedMetrics/cm_amer_share  complexity=47
calculatedMetrics/cm_emea_share  complexity=46
calculatedMetrics/cm_apac_share  complexity=45
calculatedMetrics/cm_loyalty_revenue  complexity=44
calculatedMetrics/cm_revenue_b2b  complexity=43
calculatedMetrics/cm_revenue_per_visit  complexity=42
calculatedMetrics/cm_rev_per_visit_v2  complexity=42
calculatedMetrics/cm_revpv_lasttouch  complexity=42
calculatedMetrics/cm_rev_visit_linear  complexity=42
calculatedMetrics/cm_revenue_visit_corrected  complexity=42
calculatedMetrics/cm_rpv_marketing  complexity=42
calculatedMetrics/cm_rev_per_visit_final  complexity=42
calculatedMetrics/cm_returning_share  complexity=42
calculatedMetrics/cm_active_user_rate  complexity=41
calculatedMetrics/cm_pages_per_visit  complexity=40
calculatedMetrics/cm_help_resolution  complexity=39
calculatedMetrics/cm_promo_redemption  complexity=38
calculatedMetrics/cm_form_submit_rate  complexity=37
calculatedMetrics/cm_email_ctr  complexity=36
calculatedMetrics/cm_video_completion  complexity=35
calculatedMetrics/cm_search_to_view  complexity=34
calculatedMetrics/cm_cart_to_order  complexity=33
calculatedMetrics/cm_repeat_buyer_rate  complexity=32
calculatedMetrics/cm_organic_share  complexity=31
calculatedMetrics/cm_paid_ratio  complexity=30
calculatedMetrics/cm_signup_conversion  complexity=29
calculatedMetrics/cm_engagement_rate  complexity=28
calculatedMetrics/cm_bounce_rate_filtered  complexity=27
calculatedMetrics/cm_avg_order_value  complexity=26
calculatedMetrics/cm_orders_per_visit  complexity=25

Decompose the metric into intermediate calculated metrics whose names describe what each step measures.

402 of 487 components (83%) have no tags. Tags are the cheapest way to keep schema browsing tractable as the data view grows; without them, finding components by purpose requires reading every name.

Adopt a small, documented tag taxonomy and apply it via the platform API.