, add | 1 | , 2 | , ..., 10 | as the first in each row (static numbers 1 through 10).
- Example structure for key_impact_factors:
| Count | Key Factor |
|---|
| 1 | Factor one |
...
| 10 | Factor ten |
Apply the same pattern (Count as column 1, numbered 1–10) to corrective_steps and ten_areas_of_impact_on_operations tables.
"name" : Leave as is, since it's the subject of your analysis.
"category" : Leave as is.
"variable" : Leave as is.
"definition" : Definition This is the definition of the {Efficiency Category}. Keep the definition to under 300 characters.
"value" : Current Value Leave as is.
"key_impact_factors" : Efficiency Impact Factors 10 key factors that impact the efficiency of {Efficiency Category}. If fewer than 10 apply logically, fill remaining with "N/A". Order most to least impactful by revenue potential. Your output will be in HTML format: Key Factors That Impact {Efficiency Category}
"top_performers" : Based on {Efficiency Category}, these are the actions, metrics, benchmarks, points of view (as it may apply) to {Efficiency Category}. This is how top performers in the industry consider, manage and deal with issues, constraints and impacts pertaining to {Efficiency Category}. Keep to 200-300 words. Do NOT include any word count at the end of the content (remove any "(xxx words)" phrase if present in drafts).
"value_tiers" : Growth Tiers Use conservative, industry-based assumptions. As it pertains to {Efficiency Category}, output value tiers if applicable (e.g., industry standard at revenue levels $1M, $1M–$5M and >$5M). If not applicable, output "Not applicable".
"red_flag_trigger" : Red Flag Triggers What is the normal, healthy and ideal range for {Efficiency Category} as a value, level, percent or scenario. Identify the point where {Efficiency Category} is out of range and triggers a "red flag". Example: <3% or >12% of revenue.
"default_value" : If "value" is NOT given, then assign a default value that is in line with normal levels for {Efficiency Category}. For example: 5% of annual revenue.
"is_red_flag_triggered" : "is_red_flag_triggered" :
Determine whether the current state of {Efficiency Category} has crossed into a red-flag (unhealthy/inefficient) condition. - Use the value from the "value" field IF it is provided and is a numeric/quantifiable value (not "Leave as is." or text-only).
- If "value" is NOT provided (or is "Leave as is."), use the "default_value" instead. Compare that number/value against the exact condition(s) described in the "red_flag_trigger" field (e.g., "<3%", ">12% of revenue", "outside 4–8%", "more than 15 days", etc.). If the current value MEETS or EXCEEDS the red-flag condition (i.e., the inefficiency threshold IS triggered), output a brief explanation (80–150 words) of the most likely reasons this red flag was triggered, based on common plumbing industry patterns for {Efficiency Category}. Phrase it constructively, e.g., "This level suggests potential issues such as..., which often stem from...". If the current value does NOT meet the red-flag condition (i.e., the metric is within the healthy/normal range), output exactly this string and nothing else: "You're doing great here!" Output must be plain text (no HTML headings or tables in this field). - Keep tone professional, encouraging, and diagnostic — never alarming.
"other_areas_impacted" : Business Areas Impacted From the list provided under "List of Variables:", select a MAXIMUM of 10 other areas of the business that are impacted by {Efficiency Category} and output in a single comma-separated string. Base on the variable name and "definition" for clarification. If an existing list is provided, verify it against the "List of Variables:" (remove any not in the list, add/complete to top 10 if incomplete). Rank by most impactful. Output only the comma-separated list.
"impact_of_10_percent_variance" : Calculate a conservative percentage impact of a 10% variance in {Efficiency Category} on overall revenue (e.g., 0.05 for 5% based on industry norms and net margins 10-20%). Use sources for basis.
"impact_on_revenue" : Impact on Revenue Assume annual revenue of {annual_revenue_plumbing_industry} (default $1,000,000 if not provided) and multiply by the value of "impact_of_10_percent_variance" and output as a dollar value. Example: $3,256.
"corrective_steps" : Corrective Steps Based EXACTLY, and in the same order as defined in "key_impact_factors", provide a brief explanation of corrective steps to improve efficiencies and/or reduce inefficiencies, for EACH factor. Your output will be in HTML as follows: Corrective Steps | Inefficiency | Corrective Steps |
|---|
"order_of_implementation" : Order of Implementation Based on "corrective_steps", describe the steps that need to be taken to reduce inefficiencies in the logical order they need to be implemented, since all business areas are interconnected. For example: If the inefficiency is poor response rates in marketing, then tracking response rates precedes creating more ads. Keep the output to between 150 and 250 words. Do NOT include any word count at the end of the content (remove any "(xxx words)" phrase if present in drafts). For readability and logical flow, break the paragraph into multiple short tags where natural topic or step transitions occur (typically 2–5 paragraphs total). Do not use bullet lists or numbered lists — only tags.
"caution_re_implementation" : Cautions About Implementation Where "key_impact_factors" were identified, and "corrective_steps" were defined, there are important considerations when it comes to implementations of "corrective_steps", such as things to keep in mind and consider. Provide a summary of important considerations when starting an implementation program to improve efficiencies and/or reduce inefficiencies. Keep to 150-250 words. Do NOT include any word count at the end of the content (remove any "(xxx words)" phrase if present in drafts). For readability and logical flow, break the paragraph into multiple short tags where natural topic or step transitions occur (typically 2–5 paragraphs total). Do not use bullet lists or numbered lists — only tags.
"ten_areas_of_impact_on_operations" : Impact on Operations How inefficiencies in {Efficiency Category} impact other business areas. Provide 10 ways inefficiencies in {Efficiency Category} impact other business areas (if fewer, fill with "N/A"). Your output will be in HTML as follows: Areas of Impact on Operations | Source of Inefficiency | Impact on Operations |
|---|
"potential_revenue_impact_of_10_percent_improvement" : Potential Revenue Impact of 10% Efficiency Change Potential revenue leakage and the effect of even a 10% efficiency improvement in {Efficiency Category}. Multiply "impact_of_10_percent_variance" by {annual_revenue_plumbing_industry} (default $1,000,000 if not provided) and output dollar value. Example: $3,450.
"extended_summary_of_analysis" : Comprehensive Summary Provide an extended summary of your analysis, by summarizing key points from sections in the following order: "red_flag_trigger", "other_areas_impacted", "impact_on_revenue", "corrective_steps", "order_of_implementation", "caution_re_implementation", "key_impact_factors", "ten_areas_of_impact_on_operations", "potential_revenue_impact_of_10_percent_improvement". Keep to 300-500 words. For readability and logical flow, break the summary into multiple short tags where natural topic or section transitions occur (typically 4–8 paragraphs total). Do not use bullet lists, numbered lists, or subheadings — only tags.
"table_of_contents" : Table of Contents
"notes" : Leave as is. To be added later.
Business Elements To be Analyzed for: {Efficiency Category} = {annual_marketing_spend_plumbing_industry} (in the plumbing industry in the US)
name = Annual Marketing Spend
category = Marketing
variable = {annual_marketing_spend_plumbing_industry}
definition = Your output
value = Leave as is.
top_performers = Your output
value_tiers = Your output
red_flag_trigger = Your output
default_value = 5% of annual revenue
is_red_flag_triggered = Your output
other_areas_impacted = Your output
impact_on_revenue = Your output
corrective_steps = Your output
order_of_implementation = Your output
caution_re_implementation = Your output
key_impact_factors = Your output
ten_areas_of_impact_on_operations = Your output
potential_revenue_impact_of_10_percent_improvement = Your output
extended_summary_of_analysis = Your output
table_of_contents = Your output
notes = Leave as is. To be added later.
Output **only** the following, with **absolutely nothing** else before, after, or around it:
A single, complete, valid JSON object containing all the fields listed in the prompt (e.g., {"name": "Annual Marketing Spend", "category": "Marketing", "definition": "...", ...}).
Rules you MUST follow exactly:
- The output must be **pure JSON only** — no markdown fences (no ```json), no , no explanations, no greetings, no timestamps, no additional text whatsoever.
- The JSON must be fully valid and parseable.
- Use proper JSON string escaping:
- \" for any double quotes inside strings
- \\ for any backslashes inside strings
- \n for intentional newlines (but keep strings single-line where possible to minimize size)
- No other unescaped special characters
- For fields containing embedded HTML (key_impact_factors, corrective_steps, ten_areas_of_impact_on_operations, etc.):
- Embed the full HTML as a string value
- Escape it correctly as JSON (e.g., \" for quotes inside HTML attributes)
- Example correct embedding:
"key_impact_factors": "10 Key Factors That Impact {Efficiency Category}| Key Factor |
|---|
| Example Factor | ...
"
- Do NOT wrap the JSON in any code block, pre, code tags, or comments.
- Do NOT add trailing commas, comments, or invalid syntax.
- If a field is marked "Leave as is.", output its exact provided value (e.g., "Leave as is.").
Your entire response must consist **solely** of the opening { ... } closing } of the JSON object — nothing more.
Example of exact output format you must produce:
```json
{
"name": "Annual Marketing Spend",
"category": "Marketing",
"definition": "The total annual expenditure on marketing activities...",
"value": "Leave as is.",
...
"key_impact_factors": "10 Key Factors...",
...
}
List of Variables:
Variables To Update for "other_areas_impacted":
-------------------------------------------
Category:Marketing
Annual Inbound Leads
Average Cost Per Lead
Annual Marketing Spend
Lead Conversion Rate
Lead to Booking Rate
CAC Ratio to Lifetime Value
Customer Lifetime Value
Customer Acquisition Cost
Category: Sales
Closing Ratio In Home Sales Calls
Average Billable Hours Per Job
Average Gross Profit Per Job
Average Invoice
Average Revenue Per Sale
New Installs vs Repairs in Percent
Category: Customer Service
Percentage of Service Callbacks
Average Customer Satisfaction Score
Net Promoter Score
Average Online Review Rating
Dispatch Rate in Percent
Dispatch Delays Post Request
Average Hours Lead to Technician Arrival
CSR and Call Center Labor Cost in Percent
Average Cost to Book Service Call
Category: Finance & Accounting
Annual Revenue
Year Over Year Growth Rate
Annual Gross Revenue Prior Year
Net Profit
Net Profit Increase
Net Profit Margin
Gross Profit Margin
Gross Margin of Total Revenue
Seller's Discretionary Earnings (SDE)
Annual Operating Cash Flow
Annual Operating Expense As Percent of Revenue
Annual Cost of Goods Sold As Percent of Revenue
Operating Expenses As Percent of Revenue
Operating Costs As Percent of Revenue
Variable Costs As Percent of Revenue
Variable Costs of Revenue in Percent
Annual Fixed Costs
Annual Interest Paid on Debt
Revenue Leakage
Revenue Lift
Accounts Receivable Annual Average Balance
Average Number of Days Unpaid Invoices
Average Days to Collect Receivables
Accounts Receivable Turnover Ratio
Accounts Payable
Average Number of Days to Pay Suppliers
Inventory Spend Wastage
Average Value of Inventory
Inventory Book Value
Annual Inventory Turnover
Total Value of All Assets
Fixed Assets As Percent of Total Assets
Total Liabilities
Owner Equity
Annual Break Even Point
Cash Conversion Cycle
Average Cash Reserves
Operational Cash Reserves in Days
Working Capital
Working Capital Ratio
Current Ratio
Quick Ratio
Return on Assets
Return on Equity
Interest Coverage Ratio
Annual Revenue Required to Cover Costs
Business Valuation Multiple
Revenue Distribution Across Departments
Installations Revenue As Percent
Revenue Per Branch
Blended Gross Margin Across Departments
Gross Margin Service Department
Gross Margin Installs and Replacement
Operating Expenses Per Department As Percent
Departmental Contribution Margin
Revenue Spend on Fleet Vehicles
Field Technician Labor Cost in Percent
EBIDTA
Annual Net Income
Department Net Profit Margin
Accounts Receivable
Tax Rate
Depreciation of Fixed Assets
Debt to Equity Ratio
Service Department Revenue As Percent
Category: Operations
Recruitment Pipeline Strength
Percent of Technician Time Spent on Technical Labor
First Fix Rate
Job Count Per Day Per Technician
Technician Time Spent on Billable Hours
Overtime Hours Spent on Operations
Number of Technicians
Number of Install Technicians
Total Billable Technician Hours in Percent
Billable Hours Per Technician
Revenue Per Field Technician
Technician Efficiency
Technician Idle Time
Operational Efficiency Score
Inefficiency Baseline Per Factor
Compound Improvements Multiplier Efficiency
Revenue Spend on Non-Field Labor
Average Markup of Supplies
Annual Spend on Warranty Claims
Callback Cost Per Incident
Annual Warranty Claims in Percent
Safety Incident Rate
Energy Efficiency Reduction As Percent
Annual Recurring Revenue
Recurring Revenue in Percent
Annual Maintenance Contracts Count
Average Annual Revenue Per Maintenance Contract
Maintenance Contract Renewals in Percent
Average Customer Retention in Years
Customer Retention Rate in Percent
Category: Management
Number of Years As Owner
Weekly Hours Spent By Owner in Field
Owner Time Spend Field vs Strategic
Owner Workweek Hours
Number of Full Time Operations Managers
Annual Base Salary Operations Manager
Revenue Target Before Hiring Operations Manager
Maximum Number of Owner Managed Technicians
Owner Compensation As Percent of Revenue
Employee Count
Employee Turnover Rate
Technician Turnover Rate
Average Annual Training Hours Per Employee
Training Cost Per Hour
Training ROI
Employee Satisfaction Score
Recruitment Cost Per Hire
Average Days to Hire
Hiring Sources Breakdown
Applicants Per Technician Job
Average Performance Score of New Hires
Average Revenue Per Employee
Annual Revenue Per Full Time Employee
Category: Admin
Business Name
Client Name
Business Address
Percent of Revenue on Lease and Utilities
Percent of Revenue on Software and Tech Support
Insurance Costs As Percent of Gross Revenue
Timely Vendor Order Delivery in Percent |