Hello Team,
Please find the marketing and sales team performance report for {{ $startDate }} to {{ $endDate }}.
@if(empty($reportData['branches']))No report data available for this date range.
@else @foreach($reportData['branches'] as $branch)| Date | Ad Spent | Queries (Marketing) | Enquiries | Valid Inquiries | Ad Cost/Valid Inquiry | Bookings | Margin | Avg Margin/Booking | Avg Cost/Booking | Avg Cost/Enquiry |
|---|---|---|---|---|---|---|---|---|---|---|
| {{ $row['date'] }} | {{ $row['total_ad_spent'] }} | {{ $row['queries_from_marketing'] ?? 0 }} | {{ $row['total_enquiries'] }} | {{ $row['valid_inquiries'] ?? 0 }} | {{ $row['avg_cost_per_valid_inquiry'] ?? '0.00' }} | {{ $row['total_bookings'] }} | {{ $row['total_margin'] }} | {{ $row['avg_margin_per_booking'] }} | {{ $row['avg_cost_per_booking'] }} | {{ $row['avg_cost_per_enquiry'] }} |
| Total | {{ $branch['total']['total_ad_spent'] }} | {{ $branch['total']['queries_from_marketing'] ?? 0 }} | {{ $branch['total']['total_enquiries'] }} | {{ $branch['total']['valid_inquiries'] ?? 0 }} | {{ $branch['total']['avg_cost_per_valid_inquiry'] ?? '0.00' }} | {{ $branch['total']['total_bookings'] }} | {{ $branch['total']['total_margin'] }} | {{ $branch['total']['avg_margin_per_booking'] }} | {{ $branch['total']['avg_cost_per_booking'] }} | {{ $branch['total']['avg_cost_per_enquiry'] }} |
| Total Ad Spent | {{ $reportData['grand_total']['total_ad_spent'] }} |
| Queries from Marketing | {{ $reportData['grand_total']['queries_from_marketing'] ?? 0 }} |
| Total Enquiries | {{ $reportData['grand_total']['total_enquiries'] }} |
| Valid Inquiries | {{ $reportData['grand_total']['valid_inquiries'] ?? 0 }} |
| Ad Cost per Valid Inquiry | {{ $reportData['grand_total']['avg_cost_per_valid_inquiry'] ?? '0.00' }} |
| Total Bookings | {{ $reportData['grand_total']['total_bookings'] }} |
| Total Margin | {{ $reportData['grand_total']['total_margin'] }} |
| Avg Margin per Booking | {{ $reportData['grand_total']['avg_margin_per_booking'] }} |
| Avg Cost per Booking | {{ $reportData['grand_total']['avg_cost_per_booking'] }} |
| Avg Cost per Enquiry | {{ $reportData['grand_total']['avg_cost_per_enquiry'] }} |