Weekly Pipeline Health Check

From Data Points to a Strategic Dashboard

Throughout this course, you've been gathering data: prospects, outreach messages, replies, and booked calls. On its own, this data is just a collection of facts. The purpose of a weekly review is to transform these facts into insights. A well-structured report acts as a strategic dashboard for your one-person sales operation.

The benefits of this structured review are significant. It helps you monitor your progress, promptly identify issues, refine your approach, and ultimately make better decisions about where to invest your time and energy.

As the article highlights, this process allows you to move from simply working in your system (sending DMs) to working on your system (improving your process).

The Anatomy of Your Weekly Review

A powerful weekly review consists of two parts: the "what" (the numbers) and the "so what" (the analysis and action plan). You'll conduct this review inside Notion, creating a simple but effective command center.

Part 1: The Core Metrics (The "What")

First, you need to capture a snapshot of your performance for the week. The article "How to Manage Appointment Setters" provides the essential KPIs that managers use to evaluate performance. These are the same metrics you will use to evaluate yourself.

Your weekly report should track these four key numbers:

1. Outreach Volume: Total DMs sent this week.
2. Reply Rate: (Total Replies / Total DMs Sent) %.
3. Booked Call Rate: (Total Calls Booked / Total Replies) %. This measures your ability to convert a conversation into an appointment.
4. Follow-up Consistency: Percentage of due follow-ups completed. (For simplicity, you can start by tracking this as a "Yes/No" for the week: "Did I consistently clear my follow-up board?").

These numbers give you an objective, high-level view of your pipeline's health.

Part 2: The Analysis and Action Plan (The "So What")

Numbers alone don't lead to improvement. The next step is to interpret them by asking diagnostic questions. This is where you connect the data to specific causes and formulate an action plan.

The DM Tracker article provides an excellent framework for this, linking common problems to what the data shows and how to fix them.

Using this framework, your analysis will look something like this:

• Observation: "My outreach volume was high (45/day), but my reply rate was low (4%)."
• Diagnosis (from the table): The script is off or the targeting is wrong.
• Action Plan: "My A/B test showed Variant A (direct pitch) had a 2% reply rate, while Variant B (question-based) had a 6% reply rate. Next week, I will stop using Variant A and create a new test (Variant C) to try and beat Variant B's 6%."

This structured thinking process moves you from vague feelings ("I think it was a slow week") to specific, data-driven actions.

Building Your Weekly Report in Notion

Let's build a simple system in Notion to facilitate this weekly review. You will create a new, simple database dedicated to your weekly reports.

1. Create a "Weekly Reports" Database:

   • Create a new page in Notion and add a new "Table" database.
   • Properties:
     • Week Of: (Title property) - e.g., "Week of Oct 21, 2024"
     • Start Date: (Date property)
     • DMs Sent: (Number property)
     • Replies: (Number property)
     • Calls Booked: (Number property)
     • Reply Rate: (Formula property) - if(prop("DMs Sent") > 0, prop("Replies") / prop("DMs Sent"), 0)
     • Booking Rate: (Formula property) - if(prop("Replies") > 0, prop("Calls Booked") / prop("Replies"), 0)
     • A/B Test Winner: (Text property) - e.g., "Variant B (Question opener)"

2. Create a "Weekly Review Template":

   • In your new database, click the arrow next to "New" and create a "+ New template".
   • Inside the page of this template, create the following structure using headings:
     • ✅ Weekly Wins
       • What went particularly well this week? (e.g., A/B test result, a great conversation, hitting a goal)
     • 🔍 Challenges & Blockers
       • What was the biggest challenge? Where did I get stuck?
     • 💡 Insights & Learnings
       • What did I learn about my messaging, my target audience, or my process?
     • 🚀 Action Plan for Next Week
       • What is the #1 thing I will change or test next week based on my insights?

The video below, while demonstrating a full CRM build, shows how powerful different database views can be for analysis. Pay attention to how the creator uses views to see leads by source or stage, which is a similar analytical process to what you'll be doing.

Your 30-Minute Weekly CEO Meeting

Set aside 30 minutes at the same time each week (e.g., Friday afternoon) to conduct this review. Treat it as a non-negotiable meeting with yourself, the CEO of your outreach efforts.

• Minutes 0-10: Data Population. Open your main Notion outreach tracker. Filter for the past 7 days and count the total DMs, replies, and calls booked. Enter these numbers into a new entry in your "Weekly Reports" database.
• Minutes 10-25: Analysis & Reflection. Open the new weekly report page. Go through the template (Wins, Challenges, Insights) and fill it out based on the numbers and your experience during the week. Use the diagnostic table from the DM Tracker article to guide your thoughts.
• Minutes 25-30: Strategic Planning. Fill out the "Action Plan for Next Week" section. Define the one or two most important actions you will take. This could be launching a new A/B test, focusing on a different platform, or refining your qualification questions.

Conclusion and Course Wrap-Up

This lesson completes your toolkit. You have learned how to define your ideal client, find them across multiple platforms, engage them with value-first outreach, track your entire process in Notion, and now, how to create a weekly feedback loop to systematically improve your results.

Key Takeaways:

• A weekly report transforms raw data into strategic insights.
• It should be structured around core KPIs (the "what") and diagnostic analysis (the "so what").
• Use a simple Notion database and template to streamline the process.
• The goal of the review is to create a specific, data-driven action plan for the following week.

You now possess a complete, professional system for acquiring high-ticket DM setting clients. This data-driven, iterative approach is what distinguishes the top 1% of setters. The course is now complete, but your journey of refinement and optimization is just beginning. By consistently applying this weekly review process, you will ensure that your skills, strategies, and results continue to grow over time. Congratulations on completing this journey