XLS Marketing Campaigns

Marketing CampaignsThis workbook supports the Marketing Campaigns topic at If a worksheet has gray and white cells, the white cells inside the gray area are inputs and the results will be displayed in a printable format in the white area of the sheet. If a worksheet is all white, then the inputs and printable report are the same. Some of the worksheets are linked to previous worksheets. Feel free to enter numbers into previous worksheet cell references if you haven't completed the previous sheets. Calculations and formulas aren't protected, so check blank cells in the report sheets before entering values. Some of the worksheets have tables with summary calculations at the end of the table. If you need to insert more rows, insert them in the middle of the data entry fields so the sum formulas capture the new fields. Some of the worksheets have hidden rows or columns for formula calculations and deleting them will modify some of the features. If you modify worksheets and wish to return to the original format, simply download a fresh copy from your account at .© Copyright Qlutch Marketing, Inc. 20186.9.aMarketing Campaign Quantitative GoalsThis worksheet will calculate how many marketing impressions or touches you need to reach your campaign goal, along with your total campaign conversion rate. This is the first metric required to calculate marketing ROI.ResultsCalculates the total number of impressions you'll need, the total number of responses and all of your conversion rates throughout the sales process.6.9.bCampaign Revenue / Profit ProjectionsThis worksheet is linked to 6.9.a and will calculate the revenue and profit projections for your campaign. This is step 2 to calculating your campaign's projected ROI.ResultsCalculates the total projected revenue and profit produced from your campaign.6.9.cMarketing Campaign Budget & ROI AnalysisThis worksheet is linked to 6.9.a and 6.9.b (but can also function alone) and will organize your marketing campaign budget, project your initial ROI, and allow you to input actual results to view your actual campaign ROI.ResultsCalculates your total budget, projected campaign ROI, and the maximum you can spend and still hit your ROI goal. Also matches your projections to your actual results.6.9.dMarketing Campaign Budget by MonthThis worksheet is linked to 6.9.c and is a report that organizes your marketing campaign budget by month.ResultsCalculates your total budget, projected campaign ROI, and the maximum you can spend and still hit your ROI goal. Also matches your projections to your actual results.6.9.eMarketing Campaign Media PlanThis worksheet outlines your campaign media projections: media to use, cost, impressions, response and converstion rate.ResultsCalculates your costs per impression, per response and per conversion.6.9.fCampaign ResultsMatches your campaign results to your original projections.ResultsCalculates your revenue, profit or value of customers resulting from your campaign.6.9.gAd Response Rate TrackingAllows you to track your media and response rates for future reference.ResultsAverages your response rates for specific measurements.6.9.hCampaign Variable Test MatrixAllows you to record results from an a/b test.ResultsCalculates your cost per success criteria for each ad.6.9.iImprove Campaign ResultsReview how improvements to specific campaign variables affect your campaign metrics and results.ResultsCalculates how improved conversion rates impact your campaign. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download