| Date | Consultant | Product | Solar Profit | Battery Profit | Total |
|---|
| Date & Time | Consultant | Lead Gen | Customer | State | Lead Source | Sold Price | Profit | Commission | Oversell | Finance |
|---|
| # | Consultant | Sales | Leads | Pres | 7d Trend | Streak | Momentum | W/W |
|---|
| Consultant | Leads | Sales | Pres. | No Ans. | Call Back | Reschedule | Cancels | Not Int. | Been Resched. | Conv. % |
|---|---|---|---|---|---|---|---|---|---|---|
In Google Sheets, click the CONSULTANT column header, then Ctrl+click the OUTCOME column. Press Ctrl+C then paste below.
| # | Consultant | Company | Open Solar ID | Client | State | Lead Gen | Product | Price | Payment | Finance Status | Pre-Approvals Status | Meter Change | Installation | Status | Install Date | Install Status | Finalisations | Payment Status | Payment Date |
|---|
| Date | Consultant | Client | Phone | Source | Outcome |
|---|
{firstName}
{surname}
{date}
{time}
{consultant}
{address}
{phone}
| # | Consultant | Company | Open Solar ID | Client | State | Lead Gen | Product | Price | Payment | Finance Status | Pre-Approvals Status | Meter Change | Installation | Status | Install Date | Install Status | Finalisations | Payment Status | Payment Date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| When | Who | Client | Field | Change |
|---|
| Loading... |
|---|
Search, edit customer records, and find duplicates
| Loading... |
|---|
{firstName} in the message to personalise it.
#gid= in the link to target a specific tab.{firstName} {phone} · Tip: add “Reply STOP to opt out.”{{consultantPhone}} on an outbound SMS, and the sender shown on the recipient's phone, are both picked from whichever brand the lead was booked under.
Leave a field blank to revert just that one to the system default; click Remove to clear the whole row.
| Consultant | Astra Solar | DC Solar | Actions | ||
|---|---|---|---|---|---|
| Number | Sender ID | Number | Sender ID | ||
| Loading consultants… | |||||
0412 345 678 or +61 412 345 678.
·
Sender ID: 3–11 alphanumeric characters, no spaces, e.g. ASTRASOLAR.
| First Name | Last Name | Phone | Address | Date Added | Added By | Actions | |
|---|---|---|---|---|---|---|---|
| No blacklist entries yet. | |||||||
| Detected | Removed | Source | Lead | Phone | Address | Matched On | Matched Entry | Removed By | |
|---|---|---|---|---|---|---|---|---|---|
| No removals yet. | |||||||||