{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["Lists","Start Here","1 Goals","2 Choose KPIs","3 Leading Lagging","4 Set Targets","5 KPI Tracker","6 Actions","7 Review Schedule","8 Reflection","KPI Examples","Summary"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,5]]}
[]
["MOBI KPI Workbook—Lists"]
["Review Frequency","KPI Type","Trend","Status","Priority","Effort"]
["Daily","Leading","Improving","On Track","High","Low"]
["Weekly","Lagging","Declining","Watch","Medium","Medium"]
["Monthly",null,"Flat","Off Track","Low","High"]
["Quarterly",null,"Needs Review","Not Started"]

{"sheet":"Start Here","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[0,0,0,3]]}
[]
["MOBI KPI Workbook—Step-by-Step Guide"]
["Use this workbook to identify, organize, and track the Key Performance Indicators (KPIs) that matter most to your business. Fill in the white cells. Review your KPIs regularly and update the tracker over time."]
["Step","What to Do","Workbook Tab","Tip"]
[1,"Write your top business goals.","1 Goals","Start with three to five goals."]
["2","Choose KPIs that measure progress toward each goal.","2 Choose KPIs","Choose numbers that are relevant, measurable, actionable, and time-based."]
["3","Decide whether each KPI is leading or lagging.","3 Leading Lagging","Use both types when possible."]
["4","Set realistic targets.","4 Set Targets","Targets should include a date."]
["5","Track results over time and look for trends.","5 KPI Tracker","Do not react to one number without context."]
["6","Record next actions when numbers improve, decline, or stay flat.","6 Actions","Every KPI should support a decision."]
["7","Create a review schedule and reflect on what changed.","7 Review Schedule / 8 Reflection","Consistency makes patterns easier to spot."]

{"sheet":"1 Goals","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[0,0,0,3]]}
[]
["MOBI KPI Workbook—Part 1: Identify Your Business Goals"]
["Start by writing down the most important goals for your business right now."]
[]
["Business Goal","Why This Goal Matters","Time Period","Notes"]
["Example: Increase monthly sales","More revenue will help cover expenses and support growth","Next 3 months"]

{"sheet":"2 Choose KPIs","index":3,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[0,0,0,5]]}
[]
["MOBI KPI Workbook—Part 2: Choose KPIs for Each Goal"]
["For each goal, choose 1-3 KPIs that show whether you are moving closer to that goal."]
[]
["Business Goal","KPI","KPI Definition","Data Source","Review Frequency","What Action Could This Help You Take?"]
["Example: Increase monthly sales","Monthly revenue","Total sales for the month","Sales report / POS / ecommerce platform","Monthly","Increase promotions, adjust pricing, or review product mix"]
["Example: Increase monthly sales","Sales conversion rate","Percentage of leads or visitors who become customers","Website, CRM, or sales report","Weekly","Improve website, sales process, or follow-up"]

{"sheet":"3 Leading Lagging","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[0,0,0,3]]}
[]
["MOBI KPI Workbook—Part 3: Leading and Lagging KPIs"]
["Leading KPIs can signal what may happen in the future. Lagging KPIs show what already happened."]
[]
["KPI","Leading or Lagging?","What This KPI Tells Me","Notes"]
["Example: Monthly revenue","Lagging","Shows how much the business sold during the month"]
["Example: Number of inquiries","Leading","May show whether future sales could increase or decrease"]

{"sheet":"4 Set Targets","index":5,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5],[0,0,0,5]]}
[]
["MOBI KPI Workbook—Part 4: Set Targets"]
["Set realistic targets for each KPI. A good target should include a number and a date."]
[]
["KPI","Current Number","Target Number","Target Date","Why This Target Matters","Status"]
["Example: Monthly revenue",18000,22000,"2026-08-31","Helps business move closer to profitability goal","Watch"]
["Example: New customers",25,35,"2026-08-31","More customers are needed to grow sales","Watch"]

{"sheet":"5 KPI Tracker","index":6,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,2,11],[0,0,0,11]]}
[]
["MOBI KPI Workbook—Part 5: KPI Tracking Sheet"]
["Track KPI results over time. Look for trends, not just individual numbers."]
[]
["KPI","Goal","Starting Number","Period 1","Period 2","Period 3","Period 4","Period 5","Latest Result","Change vs Start","Trend","Notes"]
["Example: Monthly revenue","Increase sales",18000,19200,20500,21000,null,null,{"$f":"IFERROR(LOOKUP(2,1/(D6:H6<>\"\"),D6:H6),\"\")","v":21000},{"$f":"IF(OR(C6=\"\",I6=\"\"),\"\",I6-C6)","v":3000},"Improving","Sales increased after email campaign"]
["Example: Customer complaints","Improve satisfaction",12,10,8,7,null,null,7,-5,"Improving","Faster response time may be helping"]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]

{"sheet":"6 Actions","index":7,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,0,1,6],[2,0,2,6],[0,0,0,6]]}
[]
["MOBI KPI Workbook—Part 6: What Action Should You Take?"]
["Tracking a KPI is only useful if it helps you make a decision."]
[]
["KPI","What Happened?","Possible Reason","Action I Will Take","When I Will Review Again? ","Priority","Effort"]
["Example: Website visits","Down 20% this month","Less social media posting and lower ad spend","Restart weekly posts and review ad budget","Next week","High","Medium"]
["Example: Average order value","Up from $65 to $78","Customers responded to product bundles","Continue promoting bundles","Next month","Medium","Low"]

{"sheet":"7 Review Schedule","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[0,0,0,2]]}
[]
["MOBI KPI Workbook—Part 7: Review Schedule"]
["Not every KPI needs to be reviewed every day. Choose a schedule that makes sense for your business."]
[]
["Review Frequency","Example KPIs","My KPIs to Review"]
["Daily","Cash balance, daily sales, orders, inventory, customer service issues"]
["Weekly","New leads, appointments, website traffic, sales conversion rate, marketing performance"]
["Monthly","Revenue, expenses, profit, cash flow, average order value, customer retention"]
["Quarterly","Long-term growth, pricing strategy, product or service performance, staffing needs"]
[]
["Frequency","Day or Date I Will Review Them","Notes"]

{"sheet":"8 Reflection","index":9,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[0,0,0,1]]}
[]
["MOBI KPI Workbook—Part 8: Reflection Questions"]
["Use these questions after you review your KPI results."]
[]
["Reflection Question","Your Answer"]
["Which KPI improved the most?"]
["Which KPI needs the most attention?"]
["What trend do I notice?"]
["What may have caused this trend?"]
["What action should I take next?"]
["Do I need to change, remove, or add any KPIs?"]
["What is my next review date?"]

{"sheet":"KPI Examples","index":10,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[0,0,0,1]]}
[]
["MOBI KPI Workbook—KPI Examples for Small Businesses"]
["Use these examples if you need help choosing KPIs."]
[]
["Business Goal","Possible KPIs"]
["Increase sales","Monthly revenue, number of orders, average order value, sales conversion rate"]
["Gain new customers","New customers, leads, inquiries, appointments booked, website visits"]
["Improve customer satisfaction","Customer reviews, complaints, returns, response time, customer satisfaction score"]
["Improve profitability","Gross margin, expenses, profit, cost per sale, average order value"]
["Improve retention","Repeat purchase rate, customer retention rate, customer lifetime value, rebooking rate"]
["Improve marketing","Email click rate, website traffic, ad cost per lead, conversion rate, campaign revenue"]
["Improve operations","Order fulfillment time, inventory levels, employee productivity, error rate"]
["Manage cash flow","Cash balance, accounts receivable, accounts payable, monthly expenses"]

{"sheet":"Summary","index":11,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[0,0,0,3]]}
[]
["MOBI KPI Workbook—KPI Summary"]
["This optional summary pulls from your tracker as you fill it in."]
[]
["Metric","Formula / Meaning","Value","Notes"]
["KPIs entered","Number of KPI rows with a KPI name",{"$f":"COUNTA('5 KPI Tracker'!A8:A31)","v":0},"Updates as you add KPIs."]
["KPIs improving","Rows marked Improving",{"$f":"COUNTIF('5 KPI Tracker'!K8:K31,\"Improving\")","v":0},"Use the Trend column on the tracker."]
["KPIs declining","Rows marked Declining",{"$f":"COUNTIF('5 KPI Tracker'!K8:K31,\"Declining\")","v":0},"Review actions for these first."]
["Actions listed","Number of action rows with an action",{"$f":"COUNTA('6 Actions'!D8:D26)","v":0},"Actions help turn data into decisions."]