Compare weekly lead efficiency

{
  "label": "Supplied agency data"
}

{
  "label": "Compare weekly lead efficiency",
  "code": "\nfunction obj(value, keys, required = keys) {\n  if (!value || typeof value !== 'object' || Array.isArray(value)) throw new Error('Expected object');\n  if (Object.keys(value).some(key => !keys.includes(key))) throw new Error('Unknown input field');\n  if (required.some(key => !Object.hasOwn(value, key))) throw new Error('Missing required input field');\n  return value;\n}\nfunction text(value, name, max = 200, allowEmpty = false) {\n  if (typeof value !== 'string' || value.length > max || (!allowEmpty && !value.trim())) throw new Error('Invalid ' + name);\n  return value.trim();\n}\nfunction list(value, name, max = 500) {\n  if (!Array.isArray(value) || value.length > max) throw new Error('Invalid ' + name);\n  return value;\n}\nfunction int(value, name, min = 0, max = Number.MAX_SAFE_INTEGER) {\n  if (!Number.isSafeInteger(value) || value < min || value > max) throw new Error('Invalid ' + name);\n  return value;\n}\nfunction amount(value, name) {\n  if (!Number.isFinite(value) || value < 0 || value > 1000000000) throw new Error('Invalid ' + name);\n  return value;\n}\nfunction email(value) { return /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(value); }\nfunction day(value) {\n  if (typeof value !== 'string' || !/^\\d{4}-\\d{2}-\\d{2}$/.test(value)) throw new Error('Invalid calendar date');\n  const ms = Date.parse(value + 'T00:00:00Z');\n  if (!Number.isFinite(ms) || new Date(ms).toISOString().slice(0, 10) !== value) throw new Error('Invalid calendar date');\n  return ms;\n}\nfunction instant(value) {\n  if (typeof value !== 'string' || !/^\\d{4}-\\d{2}-\\d{2}T\\d{2}:\\d{2}:\\d{2}(\\.\\d{3})?Z$/.test(value)) throw new Error('Invalid UTC timestamp');\n  const ms = Date.parse(value);\n  const normalized = value.includes('.') ? value : value.replace('Z', '.000Z');\n  if (!Number.isFinite(ms) || new Date(ms).toISOString() !== normalized) throw new Error('Invalid UTC timestamp');\n  return ms;\n}\nfunction uniqueIds(items) {\n  const ids = items.map(item => text(item.id, 'item ID', 120));\n  if (new Set(ids).size !== ids.length) throw new Error('Duplicate item ID');\n  return ids;\n}\nfunction ratioBps(numerator, denominator) {\n  const n = BigInt(numerator) * 10000n;\n  const d = BigInt(denominator);\n  const quotient = n / d;\n  const floor = n < 0n && n % d !== 0n ? quotient - 1n : quotient;\n  const result = Number(floor);\n  if (!Number.isSafeInteger(result)) throw new Error('Unsafe calculated ratio');\n  return result;\n}\n\n\nconst x = obj(context.input, ['reportId','current','prior','alertDropBps']);\nconst reportId = text(x.reportId, 'report ID', 120);\nconst current = obj(x.current, ['spendMinor','leads']), prior = obj(x.prior, ['spendMinor','leads']);\nfor (const values of [current,prior]) { int(values.spendMinor, 'spend minor units'); int(values.leads, 'lead count'); }\nconst threshold = int(x.alertDropBps, 'drop threshold', 1, 10000);\nconst currentCostPerLeadMinor = current.leads ? Math.floor(current.spendMinor / current.leads) : null;\nconst priorCostPerLeadMinor = prior.leads ? Math.floor(prior.spendMinor / prior.leads) : null;\nconst leadChangeBps = prior.leads ? ratioBps(current.leads - prior.leads, prior.leads) : null;\nconst status = !current.leads || !prior.leads ? 'insufficient_data' : leadChangeBps <= -threshold ? 'decline' : 'within_threshold';\nreturn {reportId, currentCostPerLeadMinor, priorCostPerLeadMinor, leadChangeBps, status};\n",
  "outputVar": "result",
  "timeout": 1000,
  "memoryLimit": 16
}