{"approved_testimonials_count":28,"as_of":"2026-09-04T17:25:11.044917+00:00","data_available":true,"distinct_callers_7d":44,"distinct_ips_7d":322,"distinct_platforms":3,"flags":{"callers_available":true,"platforms_available":true,"testimonials_available":true,"tool_calls_available":true},"note":"All counts are live reads from mcp_tool_calls, mcp_calls_identity + ai_testimonials. A value of 0 with its *_available flag false means no data / table unavailable \u2014 never a placeholder. platforms_30d counts EXTERNAL calls only; each row carries its unfiltered sibling and platforms_30d_excluded says what was removed.","ok":true,"platforms_30d":[{"calls":327,"calls_including_self_traffic":374,"platform":"claude"},{"calls":165,"calls_including_self_traffic":165,"platform":"anthropicapi"},{"calls":33,"calls_including_self_traffic":33,"platform":"chatgpt"},{"calls":33,"calls_including_self_traffic":33,"platform":"grok"},{"calls":1,"calls_including_self_traffic":1,"platform":"anthropictoolbox"}],"platforms_30d_excluded":{"basis":"mcp_calls_identity WHERE is_public_ip AND is_real_external, minus DECLARED operator self-traffic sessions (mcp_calls_deloop.self_traffic_session_prefixes). Declared, never inferred: the operator's client is byte-identical to a prospect's, and inventing a behavioural rule would delete real leads. calls_including_self_traffic is that same real-external population with our sessions added back \u2014 not an unfiltered total. A platform whose every call was ours is dropped from platforms_30d and named in platforms_removed_entirely: it is not an integrating platform, and naming it as one was the defect.","calls_removed":47,"platforms_removed_entirely":[],"self_traffic_session_prefixes":["21742a34","88e20dac","8c8e1d0d","b9677a81","diag"]},"source_columns":{"approved_testimonials_count":"COUNT(*) ai_testimonials WHERE approved = TRUE","distinct_callers_7d":"COUNT(DISTINCT agent_id) mcp_calls_identity (7d) WHERE is_public_ip AND is_real_external \u2014 canonical identity view; NEVER session_id (it rotates per MCP connection)","distinct_ips_7d":"COUNT(DISTINCT client_ip) mcp_calls_identity (7d) WHERE is_public_ip \u2014 all traffic incl. probes, secondary signal","distinct_platforms":"COUNT(DISTINCT recognized vendor) mcp_calls_identity (30d) WHERE is_public_ip AND is_real_external, minus declared operator self-traffic \u2014 was raw mcp_tool_calls with neither filter until 2026-09-03","tool_calls_30d":"COUNT(*) mcp_tool_calls WHERE created_at >= NOW()-30d","tool_calls_7d":"COUNT(*) mcp_tool_calls WHERE created_at >= NOW()-7d"},"tool_calls_30d":20474,"tool_calls_7d":5825}