@foreach ($crypto_news as $news) @php $slug = ltrim($news['data_slug'], '/'); $publishedAt = null; $icoItem = null; // 1️⃣ crypto_news $newsItem = DB::table('crypto_news') ->select('author_id', 'publishedAt','alias') ->where('alias', $slug) ->first(); if ($newsItem) { $publishedAt = $newsItem->publishedAt; $url='https://cryptodisplay.io/'.$slug; } else { // 2️⃣ crypto_coins_icos $icoItem = DB::table('crypto_coins_icos') ->select('author_id', 'created_at','ico_ido_type','slug') ->where('slug', $slug) ->first(); if ($icoItem) { $url=CommonHelper::getIcoUrl($icoItem); $publishedAt = $icoItem->created_at; } else { // 3️⃣ general_seo if ($slug === '') { $seoItem = DB::table('general_seo') ->select('created_at') ->where('type', 'home') ->first(); } else { $seoItem = DB::table('general_seo') ->select('created_at') ->where('type', $slug) ->first(); } if ($seoItem) { $publishedAt = $seoItem->created_at; $url='https://cryptodisplay.io/'.$slug; } } } @endphp @endforeach

Query	Date	Author Name	Clicks	Impressions	CTR	Position	Total Views (GA)	Total Users (GA)	Average Engagement Time (GA)	Bounce Rate
{{ $url ?? '-' }}	{{$news['gsc_date']}}	{{@$news['postAuthor']->dispaly_name??'Admin'}}	{{$news['click']}}	{{$news['impresion']}}	{{$news['ctr']}}	{{$news['position']}}	{{$news['total_view']}}	{{$news['total_users']}}	{{$news['avg_count']}}	-