STUD.com
← Objectives

Build · Create · Analysis & Finance

Account-overlap matrix with a partner

A 3x3 overlap matrix showing how many accounts intersect across each funnel-stage pairing with a partner, with totals and the biggest cell flagged.

You receive: A reviewed account-mapping calculator + the passing test report, run on your account lists.

Part of Grow Partnerships

Opens soon

Cost25 credits
AcceptanceAutomated check against your inputs
ProtectionHeld until verified delivery

This objective is verified and ready. It opens soon, once sign-in and payments are live.

Deliverable interface

The exact vocabulary the automated check enforces: keys, tokens, entry points, and worked examples. Generated from the verification source.

{
 "constants": {
  "_AM_STAGES": [
   "prospects",
   "opportunities",
   "customers"
  ]
 },
 "entryName": "build_account_mapping_matrix",
 "expectNote": "expect is the comparison-space value (your return value goes through normalize first when one is published)",
 "hiddenCaseCount": 9,
 "hiddenCaseNames": [
  "cross_stage",
  "case_whitespace",
  "dup_no_inflate",
  "multi_population",
  "near_miss",
  "all_empty",
  "disjoint",
  "diagonal",
  "dense"
 ],
 "inputKeys": [
  "count",
  "mine",
  "normalize_ids",
  "partner"
 ],
 "normalizeSource": "def _am_normalize(r):\n    try:\n        cells = [{\"mine\": str(c[\"mine\"]), \"partner\": str(c[\"partner\"]), \"count\": int(c[\"count\"]),\n                  \"accounts\": [str(a) for a in c[\"accounts\"]]} for c in r[\"cells\"]]\n        return {\"stages\": [str(s) for s in r[\"stages\"]], \"cells\": cells,\n                \"row_totals\": {k: int(v) for k, v in r[\"row_totals\"].items()},\n                \"col_totals\": {k: int(v) for k, v in r[\"col_totals\"].items()},\n                \"grand_total\": int(r[\"grand_total\"]),\n                \"biggest_cell\": {\"mine\": str(r[\"biggest_cell\"][\"mine\"]), \"partner\": str(r[\"biggest_cell\"][\"partner\"]), \"count\": int(r[\"biggest_cell\"][\"count\"])}}\n    except Exception:\n        return repr(r)\n",
 "returnShapes": [
  [
   "biggest_cell",
   "cells",
   "col_totals",
   "grand_total",
   "row_totals",
   "stages"
  ]
 ],
 "signature": "def build_account_mapping_matrix(inp):",
 "submission": "python exposing the entry function; inp is one input object; graded on held-out cases",
 "tier": "calculator",
 "visibleCases": [
  {
   "expect": {
    "biggest_cell": {
     "count": 1,
     "mine": "customers",
     "partner": "customers"
    },
    "cells": [
     {
      "accounts": [],
      "count": 0,
      "mine": "prospects",
      "partner": "prospects"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "prospects",
      "partner": "opportunities"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "prospects",
      "partner": "customers"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "opportunities",
      "partner": "prospects"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "opportunities",
      "partner": "opportunities"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "opportunities",
      "partner": "customers"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "customers",
      "partner": "prospects"
     },
     {
      "accounts": [],
      "count": 0,
      "mine": "customers",
      "partner": "opportunities"
     },
     {
      "accounts": [
       "a4"
      ],
      "count": 1,
      "mine": "customers",
      "partner": "customers"
     }
    ],
    "col_totals": {
     "customers": 1,
     "opportunities": 0,
     "prospects": 0
    },
    "grand_total": 1,
    "row_totals": {
     "customers": 1,
     "opportunities": 0,
     "prospects": 0
    },
    "stages": [
     "prospects",
     "opportunities",
     "customers"
    ]
   },
   "input": {
    "mine": {
     "customers": [
      "a3",
      "a4"
     ],
     "opportunities": [
      "a2"
     ],
     "prospects": [
      "a1"
     ]
    },
    "partner": {
     "customers": [
      "a4",
      "b3"
     ],
     "opportunities": [
      "b2"
     ],
     "prospects": [
      "b1"
     ]
    }
   },
   "name": "simple_overlap"
  }
 ],
 "vocabulary": [
  "accounts",
  "biggest_cell",
  "cells",
  "col_totals",
  "count",
  "grand_total",
  "mine",
  "no",
  "normalize_ids",
  "partner",
  "row_totals",
  "stages",
  "yes"
 ]
}

Get early access to STUD the day it goes live.