Spreadsheet: 701583d1603817944-if-cell-contains-text-value-then-copy-paste-choice-cells-from-that-row-booking-enquiry-log-updated-
Sheet: September 2020

Service Booking/Enquiry Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interactive Marketing Actions
Date | Customer | Name | Contact no | [NAME] | [NAME] no | Type of enquiry | Service Quote | Objections | Converted Quote | Date Booked | [NAME] | C &  D | MoT | Recall | WUW | Comments |  |  | Total Review/Actions
2020-01-01 00:00:00 |  | TEST | [PHONE] | [NAME] | 911TGH | Service Booking | Yes | To Expensive | No
2020-01-01 00:00:00 |  | TEST2 | [PHONE] | TEST2@TEST@.COM | 911TGI | Diagnosis | Yes |  | Yes | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | Total Aftersales DIRECT Enquiries
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Services
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechanical Repair
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diagnosis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warranty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Service Conversion
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Service quotations provided
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Services booked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Services not booked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Too expensive
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Availability
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Loan car
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Collection/Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SERVICE ENQUIRIES NOT CONVERTED, NOW WIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (COLUMN C) | REG NO (COLUMN F) | OBJECTIONS | DATE