In the same forecast table, I created different charts for each channel: Goog...

mr269565@gmail.

Creating a projection table forecast can give you a long-term view of potential performance, but using a forecast table can help you understand your progress toward the end of the current calendar month (or any custom date range for that matter). The table above is from a forecast table for one of my clients. Here's how the data breaks down: P7D: Performance over the past seven days.



MTD: Performance so far this month. Projected: Projected statistics for the remaining B2B Email List days of the month and performance to date, extrapolated from the last 7 days. The formula works like this: (P7D / 7 * Days Remaining in the Month) + MTD Statistics = Projected Performance If you want to understand this, here is a video showing how to set up a projection table. Granted, this doesn't guarantee where your performance will end up this month, but it can give you an educated guess about where you're headed based on recent events and the performance you've already seen for the month.





Be flexible If you’re putting together your forecasts, you might also start allocating your budget to different channels or campaign groups based on what the forecasts are telling you. That's great, but don't be set in stone. Inflexible budgets can hinder maximizing performance. You'll notice that my forecast table above includes more than just expenses. Other metrics such as clicks, conversions, and cost-per-conversion are also included. You can add any metrics you want to this formula based on what's important to you.