# Messaging Template Approval Tracker Worksheet (Excel Export) > Source: https://netray.co/tools/messaging-template-approval-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track every outbound message template from draft to approval, with owner, category, language and review turnaround. Exports to Excel. ## Category erp-operations ## Audience - Integration developer - Business analyst - Customer service lead ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Template name **Key:** name **Type:** text #### Business purpose **Key:** purpose **Type:** text #### Category **Key:** category **Type:** select **Options:** - Utility - Marketing - Authentication #### Language **Key:** language **Type:** select **Options:** - en - hi - es - pt_BR - ar - zh_CN - de - fr #### Owner **Key:** owner **Type:** text #### Submitted **Key:** submitted **Type:** date #### Status **Key:** status **Type:** select **Options:** - Draft - Submitted - Approved - Rejected - Paused #### Review days **Key:** review_days **Type:** number **Unit:** days #### Variables **Key:** variables **Type:** number #### Sent last 30 days **Key:** sent_30d **Type:** number #### Rework rounds **Key:** rework **Type:** number #### Effort score **Key:** effort **Type:** number **Expr:** review_days + rework * 2 **Format:** number **Rows:** #### po_approval_request **Purpose:** Ask buyer to approve PO **Category:** Utility **Language:** en **Owner:** Procurement IT **Submitted:** 2026-09-02 **Status:** Approved **Review days:** 1 **Variables:** 4 **Sent 30d:** 820 **Rework:** 0 #### shipment_delay_notice **Purpose:** Tell customer of ship delay **Category:** Utility **Language:** en **Owner:** Customer service **Submitted:** 2026-09-10 **Status:** Approved **Review days:** 2 **Variables:** 5 **Sent 30d:** 310 **Rework:** 1 #### otp_login_code **Purpose:** Portal one-time code **Category:** Authentication **Language:** en **Owner:** IT security **Submitted:** 2026-09-14 **Status:** Approved **Review days:** 1 **Variables:** 1 **Sent 30d:** 1450 **Rework:** 0 #### service_promo_offer **Purpose:** Maintenance contract offer **Category:** Marketing **Language:** en **Owner:** Sales ops **Submitted:** 2026-10-05 **Status:** Rejected **Review days:** 3 **Variables:** 2 **Sent 30d:** 0 **Rework:** 2 #### invoice_due_reminder_hi **Purpose:** Payment reminder in Hindi **Category:** Utility **Language:** hi **Owner:** Finance **Submitted:** 2026-10-12 **Status:** Submitted **Review days:** 0 **Variables:** 3 **Sent 30d:** 0 **Rework:** 0 **Totals:** #### Total sent last 30 days **Key:** sent_30d **Agg:** sum **Format:** integer #### Average review days **Key:** review_days **Agg:** avg **Format:** decimal #### Total rework rounds **Key:** rework **Agg:** sum **Format:** integer **Summary:** #### Rework rounds per template **Key:** rework_per_template **Expr:** sum_rework / count **Format:** decimal #### Average monthly volume per template **Key:** sent_per_template **Expr:** sum_sent_30d / count **Format:** integer **Notes:** Statuses and categories follow the WhatsApp Business Platform vocabulary at the time of writing. Check your account's current template rules before submitting. ## Content **Intro:** Once more than a handful of notification templates exist, nobody remembers which are approved, which were rejected and who owns them. This worksheet is a simple register you can edit in the browser and export to Excel. It shows review turnaround and rework so you can plan launches realistically. **Sections:** #### How to use the tracker **Body:** Add one row per template and language combination, because each language variant is reviewed separately. Record the owner, the category you chose, the submission date and the current status. Update the review days when the decision arrives and count each rejection and resubmission as a rework round. The effort score column combines review time and rework so you can see which template types are slow. Export to Excel for sharing, or paste the rows into your change calendar. #### Reading the numbers **Body:** Average review days tells you how far ahead of a launch to submit. Rework rounds per template tells you whether your drafting rules need work, for example variables placed at the start of a body or content that reads like marketing but is filed as utility. Monthly sent volume shows which templates matter most and which can be retired. Templates with zero volume for months are candidates for removal, which keeps the register honest. **Bullets:** - Plan launches around review time plus rework - Track category choices and any reclassification - Retire unused templates - Keep one owner per template #### Common mistakes **Body:** People file marketing content as utility to avoid higher pricing or opt-in rules, and then see rejections or category changes. Another mistake is changing approved template text in the ERP integration code without resubmitting. Keep the template name, language and body text in this register so developers and business owners work from the same source. Finally, avoid storing customer data in example values. Use fictional examples when submitting for review. **Cta:** If your templates are driven by ERP events, Netray can help map each template to a trigger, a data source and a role check inside your own environment. **Faq:** #### Do I need a row for each language? **Answer:** Yes. Each language version of a template is a separate item that is reviewed and approved on its own, so track them separately with the same name or a clear suffix. #### What does the effort score mean? **Answer:** It is review days plus two points per rework round. It is a rough ranking aid, not a platform metric. Use it to spot slow or repeatedly rejected templates. #### Can this be used for Teams or SMS templates? **Answer:** Yes as a general message register. Change the category and status options in your exported copy, since the categories shown follow WhatsApp conventions. #### How do I get the data into Excel? **Answer:** Use the export button on the tool. The columns, rows and computed effort score are included so you can sort and filter in Excel. ## Search terms whatsapp template approval tracker, message template tracker excel, whatsapp template status log, template message register, whatsapp business template list excel, notification template inventory --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json