@extends('backend.layouts.app') @section('content')

Keywords-Overview : {{ ucwords($key_wordname) }}

Search Volume
Categories
@php // Group data by sector and calculate total categories per sector $groupedData = $key_ranking ->groupBy('sector_name') ->map(function ($group) { return [ 'total_categories' => $group->sum('total_categories'), 'data' => $group, ]; }) ->sortByDesc('total_categories') ->take(5); @endphp @if ($groupedData->count() > 0) @foreach ($groupedData as $sectorName => $sectorData) @php $group = $sectorData['data']; // Get original data for this sector $sectorLabels = $group->sortByDesc('total_categories')->pluck('cat_name')->take(5); $sectorCounts = $group ->sortByDesc('total_categories') ->pluck('average_rating') ->take(5); // Calculate total and average rating per keyword $keywordRatings = $group->groupBy('keyword_name')->map(function ($keywords) { $totalRating = $keywords->sum('rating'); // Sum of all ratings $maxPossibleRating = $keywords->count() * 5; // Assuming rating is out of 5 $averageRating = $maxPossibleRating > 0 ? round(($totalRating / $maxPossibleRating) * 5, 2) : 0; return [ 'total_rating' => $totalRating, 'average_rating' => $averageRating, ]; }); @endphp

{{ ucwords($sectorName) }}

@foreach ($keywordRatings as $keyword => $ratings)
@endforeach
11.2%
    @endforeach @endif

    Rating

    ({{ $overall_avg_rating }})

    Seller Adoption Rate

    {{ $percentage_usage }}%

    Search To Click Rate (CTR)

    {{ $click_rate }}%

    @endsection