@csrf
@foreach ($campaign_data as $key => $val) @endforeach
Industry Campaign Group Campaign Sub Group Campaign Data Total Pushed Total Submitted Total Sms Units Invalid Numbers DND Numbers Already Used Numbers Blacklisted Numbers Duplicate Numbers Exclude No Activity Numbers Exclude Operator Numbers Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA RCPA ROI % Spends Revenue ROI
{{$val['industry']}} {{$val['group_name']}} {{$val['sub_group_name']}} {{$val['campaign_data']}} {{$val['pushed_volume']}} {{$val['volume']}} {{$val['total_sms_unit']}} {{$val['invalid_count']}} {{$val['dnd_ndnd_count']}} {{$val['exclude_count']}} {{$val['blacklist_count']}} {{$val['duplicate_numbers_count']}} {{$val['exclude_no_activity_numbers']}} {{$val['exclude_operator_count']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}} {{$val['CPUC']}} {{$val['CPA']}} {{$val['required_cost']}} {{$val['ROIP']}} {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}}
@foreach($cityewise_data as $key => $val) @endforeach
Sr.No City name Clicks Whistle Actions
{{$key+1}} {{ucwords($val['city_name'])}} {{$val['clicks']}} {{$val['conversions']}}
@foreach($devisebased_data as $key => $val) @endforeach
Sr.No Device name Clicks Whistle Actions
{{$key+1}} {{ucwords($val['device_name'])}} {{$val['clicks']}} {{$val['conversions']}}
@foreach($OSbased_data as $key => $val) @endforeach
Sr.No OS name Clicks Whistle Actions
{{$key+1}} {{ucwords($val['os_name'])}} {{$val['clicks']}} {{$val['conversions']}}
@foreach($circlewise_data as $key => $val) @endforeach
Sr.No Circle Name Campaign Group Campaign Sub Group Total Submitted Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}} {{$val['name']}} {{$val['group_name']}} {{$val['sub_group_name']}} {{$val['volume']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}}% {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$circle_total['name']}} {{$circle_total['group_name']}} {{$circle_total['sub_group_name']}} {{$circle_total['volume']}} {{$circle_total['clicks']}} {{$circle_total['unique_clicks']}} {{$circle_total['converstions']}} {{$circle_total['CTRP']}}% {{$circle_total['CPUC']}} {{$circle_total['CPA']}} {{$circle_total['ROIP']}}% {{$circle_total['Spent']}} {{$circle_total['revenue']}} {{$circle_total['ROI']}} {{$circle_total['required_cost']}} {{$circle_total['CPC']}} {{$circle_total['VC']}}%
@foreach($operatorwise_data as $key => $val) @endforeach
Sr.No Operator Name Campaign Group Campaign Sub Group Total Submitted Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}} {{$val['name']}} {{$val['group_name']}} {{$val['sub_group_name']}} {{$val['volume']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}}% {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$operator_total['name']}} {{$operator_total['group_name']}} {{$operator_total['sub_group_name']}} {{$operator_total['volume']}} {{$operator_total['clicks']}} {{$operator_total['unique_clicks']}} {{$operator_total['converstions']}} {{$operator_total['CTRP']}}% {{$operator_total['CPUC']}} {{$operator_total['CPA']}} {{$operator_total['ROIP']}}% {{$operator_total['Spent']}} {{$operator_total['revenue']}} {{$operator_total['ROI']}} {{$operator_total['required_cost']}} {{$operator_total['CPC']}} {{$operator_total['VC']}}%
@foreach($content_data as $key => $val) {{-- --}} @endforeach
Sr.No Content Campaign Group Campaign Sub Group Total Submitted Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}}{{$val['name']}}{{str_replace('\\n', '', $val['name'])}} {{$val['group_name']}} {{$val['sub_group_name']}} {{$val['volume']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}}% {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$content_total['name']}} {{$content_total['group_name']}} {{$content_total['sub_group_name']}} {{$content_total['volume']}} {{$content_total['clicks']}} {{$content_total['unique_clicks']}} {{$content_total['converstions']}} {{$content_total['CTRP']}}% {{$content_total['CPUC']}} {{$content_total['CPA']}} {{$content_total['ROIP']}}% {{$content_total['Spent']}} {{$content_total['revenue']}} {{$content_total['ROI']}} {{$content_total['required_cost']}} {{$content_total['CPC']}} {{$content_total['VC']}}%
@foreach($launch_data as $key => $val) @endforeach
Sr.No Launch Id Launched on Campaign Type Campaign Data Clicker Data Type Campaign Group Campaign Sub Group Total Pushed Total Submitted Total Sms Units Invalid Numbers DND Numbers Already Used Numbers Blacklisted Numbers Duplicate Numbers Exclude No Activity Numbers Exclude Operator Numbers Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}} {{$val['launch_id']}} {{$val['launch_date']}} {{$val['campaign_through']}} {{$val['type']}} View Applied Filters {{$val['group_name']}} {{$val['sub_group_name']}} {{$val['pushed_volume']}} {{$val['volume']}} {{$val['total_sms_unit']}} {{$val['invalid_count']}} {{$val['dnd_ndnd_count']}} {{$val['exclude_count']}} {{$val['blacklist_count']}} {{$val['duplicate_numbers_count']}} {{$val['exclude_no_activity_numbers']}} {{$val['exclude_operator_count']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}}% {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$launch_total['launch_date']}} {{$launch_total['type']}} {{$launch_total['campaign_through']}} {{$launch_total['clicker_data']}} {{$launch_total['group_name']}} {{$launch_total['sub_group_name']}} {{$launch_total['pushed_volume']}} {{$launch_total['volume']}} {{$launch_total['total_sms_unit']}} {{$launch_total['invalid_count']}} {{$launch_total['dnd_ndnd_count']}} {{$launch_total['exclude_count']}} {{$launch_total['blacklist_count']}} {{$launch_total['duplicate_numbers_count']}} {{$launch_total['exclude_no_activity_numbers']}} {{$launch_total['exclude_operator_count']}} {{$launch_total['clicks']}} {{$launch_total['unique_clicks']}} {{$launch_total['converstions']}} {{$launch_total['CTRP']}}% {{$launch_total['CPUC']}} {{$launch_total['CPA']}} {{$launch_total['ROIP']}}% {{$launch_total['Spent']}} {{$launch_total['revenue']}} {{$launch_total['ROI']}} {{$launch_total['required_cost']}} {{$launch_total['CPC']}} {{$launch_total['VC']}}%
@foreach($type_data as $key => $val) @endforeach
Sr.No Campaign Data Total Pushed Total Submitted Invalid Numbers DND Numbers Already Used Numbers Blacklisted Numbers Duplicate Numbers Exclude No Activity Numbers Exclude Operator Numbers Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}} {{$val['campaign_data']}} {{$val['pushed_volume']}} {{$val['volume']}} {{$val['invalid_count']}} {{$val['dnd_ndnd_count']}} {{$val['exclude_count']}} {{$val['blacklist_count']}} {{$val['duplicate_numbers_count']}} {{$val['exclude_no_activity_numbers']}} {{$val['exclude_operator_count']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}} % {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$data_total['campaign_data']}} {{$data_total['pushed_volume']}} {{$data_total['volume']}} {{$data_total['invalid_count']}} {{$data_total['dnd_ndnd_count']}} {{$data_total['exclude_count']}} {{$data_total['blacklist_count']}} {{$data_total['duplicate_numbers_count']}} {{$data_total['exclude_no_activity_numbers']}} {{$data_total['exclude_operator_count']}} {{$data_total['clicks']}} {{$data_total['unique_clicks']}} {{$data_total['converstions']}} {{$data_total['CTRP']}}% {{$data_total['CPUC']}} {{$data_total['CPA']}} {{$data_total['ROIP']}}% {{$data_total['Spent']}} {{$data_total['revenue']}} {{$data_total['ROI']}} {{$data_total['required_cost']}} {{$data_total['CPC']}} {{$data_total['VC']}}%
@foreach($server_data as $key => $val) @endforeach
Sr.No Server Name Total Pushed Total Submitted Invalid Numbers DND Numbers Already Used Numbers Blacklisted Numbers Duplicate Numbers Exclude No Activity Numbers Exclude Operator Numbers Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}} {{$val['server_name']}} {{$val['pushed_volume']}} {{$val['volume']}} {{$val['invalid_count']}} {{$val['dnd_ndnd_count']}} {{$val['exclude_count']}} {{$val['blacklist_count']}} {{$val['duplicate_numbers_count']}} {{$val['exclude_no_activity_numbers']}} {{$val['exclude_operator_count']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}}% {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$server_total['server_name']}} {{$server_total['pushed_volume']}} {{$server_total['volume']}} {{$server_total['invalid_count']}} {{$server_total['dnd_ndnd_count']}} {{$server_total['exclude_count']}} {{$server_total['blacklist_count']}} {{$launch_total['duplicate_numbers_count']}} {{$launch_total['exclude_no_activity_numbers']}} {{$launch_total['exclude_operator_count']}} {{$server_total['clicks']}} {{$server_total['unique_clicks']}} {{$server_total['converstions']}} {{$server_total['CTRP']}}% {{$server_total['CPUC']}} {{$server_total['CPA']}} {{$server_total['ROIP']}}% {{$server_total['Spent']}} {{$server_total['revenue']}} {{$server_total['ROI']}} {{$server_total['required_cost']}} {{$server_total['CPC']}} {{$server_total['VC']}}%
@foreach($sender_data as $key => $val) @endforeach
Sr.No Sender Id Server Name Total Pushed Total Submitted Invalid Numbers DND Numbers Already Used Numbers Blacklisted Numbers Duplicate Numbers Exclude No Activity Numbers Exclude Operator Numbers Total Clicks Unique Clicks Whistle Actions CTR % CPUC CPA ROI % Spends Revenue ROI RCPA CPC Volume to Clicks %
{{$key+1}} {{$val['sender_name']}} {{$val['server_name']}} {{$val['pushed_volume']}} {{$val['volume']}} {{$val['invalid_count']}} {{$val['dnd_ndnd_count']}} {{$val['exclude_count']}} {{$val['blacklist_count']}} {{$val['duplicate_numbers_count']}} {{$val['exclude_no_activity_numbers']}} {{$val['exclude_operator_count']}} {{$val['clicks']}} {{$val['unique_clicks']}} {{$val['converstions']}} {{$val['CTRP']}}% {{$val['CPUC']}} {{$val['CPA']}} {{$val['ROIP']}}% {{$val['Spent']}} {{$val['revenue']}} {{$val['ROI']}} {{$val['required_cost']}} {{$val['CPC']}} {{$val['VC']}}%
{{$sender_total['sender_name']}} {{$sender_total['server_name']}} {{$sender_total['pushed_volume']}} {{$sender_total['volume']}} {{$sender_total['invalid_count']}} {{$sender_total['dnd_ndnd_count']}} {{$sender_total['exclude_count']}} {{$sender_total['blacklist_count']}} {{$sender_total['duplicate_numbers_count']}} {{$sender_total['exclude_no_activity_numbers']}} {{$sender_total['exclude_operator_count']}} {{$sender_total['clicks']}} {{$sender_total['unique_clicks']}} {{$sender_total['converstions']}} {{$sender_total['CTRP']}}% {{$sender_total['CPUC']}} {{$sender_total['CPA']}} {{$sender_total['ROIP']}}% {{$sender_total['Spent']}} {{$sender_total['revenue']}} {{$sender_total['ROI']}} {{$sender_total['required_cost']}} {{$sender_total['CPC']}} {{$sender_total['VC']}}%