ROAS (Return on Ad Spend) Sheet #

The ROAS (Return on Ad Spend) sheet is a tool designed to help track and analyze the performance of your advertising campaigns. It allows you to input crucial data related to leads, deals, and revenue, which helps calculate key performance indicators (KPIs) such as closing percentage, average deal value, and average time to close a deal.

Here’s how the process works:

Order Sheet: A duplicate version of your order sheet is created, which serves as the foundation for the ROAS sheet. This duplicate sheet will have edit access and be segmented into tabs for each of your orders. The purpose of this sheet is to measure the ongoing performance of the leads delivered. You’ll know it’s the correct sheet if, at the top left corner, it’s labelled as “Your name” – ROAS Sheet

ROAS Sheet: The ROAS sheet will contain all leads mapped to a single tab called the “pipeline.” You will be given edit access to this sheet so you can input and update relevant information.  The tabs and a short summary of each is listed below.

For Mortgage:

• Deal Stage –  Is the lead open, won, lost?
• Contact Date – The date initial contact with the lead was made
• App date – The Date the client’s application was submitted
• Approval date – The approval date of the application
• Closed Date – The date in which the deal is finalized
• Revenue – The gross revenue generated by the deal
• Deal Type – Is it a private, A or B deal? What specific type of mortgage product did the client pursue (Debt consolidation, HELOC etc.)
• Lost Reason – If the deal was not won, this would be the most relevant reason (No contact, Stopped responding, Declined offer etc.)
• Notes – Any required additional context about the lead

For Life Insurance:

• Deal Stage –  Is the lead open, won, lost?
• Contact Date – The date initial contact with the lead was made
• App date – The Date the client’s application was submitted
• Approval date – The approval date of the application
• Closed Date – The date in which the deal is finalized
• Revenue – The gross revenue generated by the deal
• Deal Type – Is it a Whole life, Term life, Universal, Critical illness, Disability or Final expense
• Lost Reason – If the deal was not won, this would be the most relevant reason (No contact, Stopped responding, Declined offer etc.)
• Notes – Any required additional context about the lead

Editable Columns: The editable columns are within the pipeline tab. Starting on column V for the mortgage ROAS sheets and column Q on the life insurance ROAS sheet. You can fill in details listed above related to the leads and their performance.

FinanceVine ongoing analysis: Your account manager will manage the remaining tabs on your ROAS sheet. They will review the data you submit and use it to calculate your ROAS. Based on this information, they will generate monthly or quarterly reports, depending on the size of your orders (highlighting the ROI breakdown).

Example of an ROAS calculation:

What FinanceVine does with the data: FinanceVine will be utilizing the provided data to determine any patterns to optimize towards. Meaning, if we see that a certain inquiry type that is paying, often and/or faster then other types we will optimize the campaign potentially towards that.

1. Mortgage example: We see that all of our clients are making the most ROI on “cash for retirement” over a long period of time. We would optimize the search terms around this to improve the potential ROI overall.
2. Life Insurance example: We see that a lot of our broker partners are being paid on Term 10 policies over a few months. We would optimize the search terms around this to improve the potential ROI overall.

Data Updates: It’s important to continuously ensure that the ROAS sheet is kept up to date with the latest information. By regularly updating the sheet with accurate data, FinanceVine can provide you with the best ongoing service and insights into your campaign’s performance. By utilizing the ROAS sheet and providing accurate and timely information, you can make faster and better-informed decisions to improve your campaign’s performance and optimize your return on ad spend.

If you require access to your ROAS sheet please do not hesitate to email the helpdesk ([email protected])