Daily Command

Get strategic marketing challenges for the brand. Uses real market data (market share, competitors, prescribers) and web research to identify specific, actionable challenges. Results are cached -- same challenges every time. Call this when the user asks about challenges, problems, issues, barriers, or difficulties the brand faces. Also use for what makes this drug unique, competitive differentiation, brand positioning challenges. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get all NDC codes for the brand drug: code, formulation, package size. Use for NDC codes, formulations, package sizes, NDC-11/NDC-10 formats, how many NDCs, what strengths are available, dosage forms. For volume/prescriber breakdown per NDC, use get_ndc_analysis instead. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Brand identity snapshot: name, generic name, therapeutic area, drug class, indication, lifecycle stage — for one advertiser/brand from ``list_accounts``.

Who writes the brand's prescriptions — bounded snapshot for the chat agent. Returns how prescribers split across segments in the loaded universe (counts only) plus how many NPI rows exist in the prescriber registry metadata. Does **not** enumerate every prescriber record (that payload can be millions of characters). Use when the user asks who prescribes the brand, who writes for the brand, brand prescriber mix, or prescriber composition. For ranked HCPs use get_top_prescribers or catalog tools; for one NPI use search_hcp_by_npi; for overlap totals use get_prescriber_stats. For audience export use audience_builder. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Supplementary per-subcampaign breakdown card with spend, impressions, clicks, CTR, CPM, and HCPs reached. Do NOT call this as the primary tool for performance analysis — use run_nlp_to_sql instead for live delivery + Rx stitched narratives with per-campaign GROUP BY. Only call this for a quick subcampaign lookup table after run_nlp_to_sql has already provided the main analysis. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Campaign lifecycle view: delivery + Rx + pacing by subcampaign for the active brand. Use when the user asks for a campaign "journey", flight-to-date story, how many doctors saw ads, prescription totals by tactic, or post-mortem for completed flights. Delegates to the same NLP-to-SQL pipeline as ``run_nlp_to_sql`` with a fixed multi-part analytical brief. ``campaign_focus`` — optional substring to narrow to one campaign name; leave empty to cover all campaigns on the loaded brand. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Supplementary UI performance card with KPI tiles, pillar summaries, and an 8-week trend chart. Do NOT call this as the primary tool for performance questions — use run_nlp_to_sql instead for live delivery + Rx stitched narratives. Only call this AFTER run_nlp_to_sql when the user specifically wants the UI performance card format. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get competitor information: tiered breakdown (direct, therapeutic alternatives, treatment pathway) with names, drug classes, prescriber counts, AND per-competitor Rx share and TRx from market share data. Use for competitor names, generic names, manufacturers, drug classes, mechanisms, tiers (tier 1/2/3), therapeutic alternatives, treatment pathway drugs, drugs in the same class on the market, how many competitors, who are the direct competitors, competitor NDC codes. Also use when asked about a specific competitor by name. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get data quality assessment: quality score, tier (gold/silver/bronze), field availability, evidence summary. Use for data reliability, data freshness, how current the data is, data methodology, data sources, field completeness, data quality score, is the data reliable, how was the data collected, data confidence level. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get comprehensive profile of dual writers -- HCPs who prescribe BOTH brand AND competitor drugs. Includes volume comparison vs brand-only prescribers, loyalty ratio, per-competitor loyalty breakdown (how many lean towards each competitor), top states, top specialties. Use for how many prescribers write both brand and competitors, dual writer analysis, are dual writers higher volume, loyalty ratio of shared prescribers, which states have the most dual writers, dual writer characteristics, brand loyalty among shared prescribers, which competitor do they lean towards. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get the active brand's campaign/subcampaign hierarchy with exact Snowflake IDs and human-readable names. Returns ONLY the currently active brand — not other brands under the advertiser. Call this when you need BRAND_ID, CAMPAIGN_ID, or SUBCAMPAIGN_ID for SQL queries or campaign analysis. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Cached KPI headline for one advertiser/brand: total campaigns, spend, impressions, HCPs reached, effective CPM. Quick cached check only — for live delivery + Rx data use ``run_nlp_to_sql`` instead, same as the chat agent's guidance.

Get geographic distribution (top states) of brand-related doctors/HCPs: state, HCP count, percentage. Quick state-level counts. Use for which state has the most prescribers/doctors/physicians, state-level summary, geographic breakdown, top states, regional distribution, where are the prescribers located. For DETAILED state drill-down with TRx/segments/cities, use get_geographic_deep_dive instead. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get all HCPCS/CPT procedure codes associated with the brand: code, frequency, patient count, prescriber count. Also includes validated codes with categories and relevance levels. Use for HCPCS/CPT code lookups, what a specific HCPCS code means/represents, code descriptions, ranking by frequency/patients/prescribers, validated codes, code categories (drug administration, monitoring, diagnostic, treatment, supportive care), how many HCPCS codes, which codes are most common, show only validated codes, reimbursement-related procedure codes. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get all ICD diagnosis codes associated with the brand: code, frequency, patient count, prescriber count. Also includes validated ICD codes with categories and relevance levels. Use for ICD code lookups, what a specific ICD code means/represents, code descriptions, ranking by frequency/patients/prescribers, validated vs unvalidated codes, relevance levels (high/medium/low), how many ICD codes, which codes are most common, ICD codes for the brand's indication, show only validated codes, show only high-relevance codes. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Brand vs. competitor market share for one advertiser/brand. ``view``: ``brand_vs_competitors`` (default), ``by_tier``, or ``vs_tier1_direct``.

Messaging/narrative framework for a marketing challenge. Empty ``challenge`` returns the catalog of available challenge keys.

Aggregate NDC-level prescribing data across all prescribers in a segment. segment can be 'brand' or any competitor drug name from the brand's panel. Returns per-NDC totals: TRx, patients, prescriber count, % of volume. Use for which NDC is most prescribed, formulation/strength breakdown, NDC volume split, which strength is preferred, product mix analysis. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get per-competitor prescriber overlap broken down by state/geography. Cross-references competitor NPI lists from prescriber_npis with the HCP universe DataFrame to show WHERE overlap prescribers are located. Returns per-competitor overlap counts by state, with loyalty direction per state. Use for: overlap by state, geographic breakdown of shared prescribers, which states have the most competitor overlap, overlap with a named competitor by state. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get campaign pacing data (spend summary). Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Patient-level aggregation across the HCP universe. Unlike TRx-focused tools, this provides patient counts, patients per prescriber, and patient share. group_by: "segment", "state", "taxonomy_code", "city" filter_segment: optional segment filter Use for how many patients are on the brand, patient share by state, average patients per prescriber, which specialty treats the most patients, patient volume analysis, patient vs TRx comparison. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Analyze prescriber concentration / Pareto distribution for a segment. Computes what % of Rx the top 10%, 20%, 50% of prescribers account for. segment can be 'brand' or a competitor name. Use this for questions like 'Do top 20% of prescribers account for 80% of Rx?' Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get prescriber details breakdown: total doctors/physicians/HCPs by analysis tier. Returns summary counts only, not individual prescriber records. Use for prescriber tier breakdown, analysis tiers, how prescribers are categorized, tier methodology, prescriber ranking system, segment priority. NOT for aggregate counts (use get_prescriber_stats) or NPI lookup (use search_hcp_by_npi). Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Brand-vs-competitor prescriber / patient overlap analyses. Args: view: One of: - `dual_writers` - NPIs writing both brand and any competitor - `lapsed` - high-volume competitor writers not writing brand - `tier1_overlap` - brand ↔ tier-1 prescriber overlap - `patient_overlap` - per-competitor patient overlap Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get AGGREGATE prescriber statistics for brand and competitors: prescriber count, total TRx (total prescriptions), total patients per group, plus overlap context showing how many brand prescribers also write for competitors. Use for how many doctors/physicians/HCPs/prescribers total, total Rx count, total patients, prescriber counts per competitor, brand vs competitor prescriber comparison, total TRx, total unique doctors. NOT for top-N ranking (use get_top_prescribers) or concentration/Pareto analysis (use get_prescriber_concentration). Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get prescription trend data (monthly TRx by NDC). Note: Rx data carries a 1-2 week lag from the claims pipeline. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get monthly prescription trends for the brand with per-NDC breakdown. Returns list of monthly data points. Use for how prescriptions changed over time, monthly trends, growth or decline, seasonal patterns, TRx over time, prescription volume history, time period covered, trend analysis, year-over-year comparison. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get therapeutic targeting codes (ICD-10, CPT, HCPCS) mapped to the brand's indication and therapeutic area. Includes categorized codes with relevance. Use for targeting setup, campaign activation codes, which ICD/CPT codes to target, POC trigger codes, therapeutic targeting. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get specialty/taxonomy distribution of brand-related HCPs: taxonomy code, description, HCP count, percentage. Also includes validated taxonomy codes used to build the same_specialty segment. Use for what taxonomy code X means, which specialty has the most HCPs, percentage of HCPs by specialty (e.g. cardiologists, endocrinologists, oncologists, neurologists, pulmonologists, internists, family medicine), specialty breakdown, taxonomy code lookups, what specialty is code 207RH0003X, top specialties, how many of a given specialty prescribe, specialty distribution, validated taxonomy codes, which specialties are relevant to this brand. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Get top HCPs ranked by composite hcp_rank_score (0-100). The rank score combines brand TRx, competitor TRx, ICD claims, HCPCS procedures, and geographic/taxonomy relevance into a single targeting priority score. Optionally filter by segment (brand_prescriber, competitor_prescriber, condition_treater, procedure_performer, same_specialty). Use for highest-potential targets, best HCPs to target, prioritized prescriber list, targeting recommendations, who should we focus on, highest opportunity HCPs. Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

Prescriber intelligence for the active brand. Args: view: One of: - `top_10` - Q7 (top-10 prescribers by volume) - `new_quarter` - Q12 (new prescribers in current quarter) - `switchers` - Q41 (tier-1 competitors stealing prescribers) - `expected` - Q8 (expected specialties for this brand) - `concentration`- Q11 (top-20% volume concentration) Requires advertiser_id/brand_id from list_accounts. IDs are for tool plumbing only — never display raw IDs to the user; refer to the brand/advertiser by name.

HCP universe summary: total HCPs by segment, total brand/competitor TRx and patients. Served from the brand-intel cache; returns an empty ``universe_summary`` with a note when nothing is cached yet for this brand — retry with ``run_nlp_to_sql`` for a live count in that case.

List the advertisers and brands the signed-in user can access. Call this FIRST to discover the ``advertiser_id`` and ``brand_id`` values you may pass to account-scoped tools. Returns only accounts the authenticated user is authorized for. Requires OAuth (MCP_OAUTH_ENABLED). ``advertiserId``/``brandId`` are opaque handles for chaining into other tools only — never display raw IDs to the user; always refer to advertisers and brands by their ``advertiserName``/``brandName``.

List saved audiences for one advertiser/brand the user can access. ``advertiser_id`` and ``brand_id`` MUST come from ``list_accounts`` — a pair the user is not authorized for is rejected. Read-only. IDs are for tool plumbing only — never display raw IDs to the user; refer to the advertiser/brand by the ``advertiserName``/``brandName`` included in the response, and audiences by their ``name``.

List the saved AI business rules for one advertiser/brand. ``advertiser_id``/``brand_id`` MUST come from ``list_accounts``. Read-only. Refer to rules by their name, not raw ids.

List Doceree's differentiation angles (route of administration, data, etc.).

Map a marketing challenge to the Doceree products that address it. Returns a challenge->product matrix with a short rationale per product. ``stage`` optionally narrows to a funnel stage (e.g. ``awareness``).

Project an audience size/breakdown for a targeting ``spec`` (read-only). ``advertiser_id``/``brand_id`` MUST come from ``list_accounts``. ``spec`` is the targeting definition (specializations, geography, code filters); resolve valid codes via the catalog/taxonomy data first. Does NOT save anything — it only projects the demographic reach.

Live analytics for one advertiser/brand: NLP question -> Snowflake SQL -> narrative. ``advertiser_id``/``brand_id`` MUST come from ``list_accounts``. Same pipeline as the chat agent's ``run_nlp_to_sql`` — narrative, sample rows, chart artifact, pacing facts when available. Brand/subcampaign ids are already resolved to names inside the pipeline output — never surface any remaining raw ObjectId to the user, refer to entities by name.

Search Doceree's product and solution catalog. Returns a JSON object with a ``products`` list (compact summaries) and a ``count``. Pass a marketing challenge or funnel need as ``query`` to filter; an empty or non-matching query returns the full catalog.