/**
* Get lead count by attribution column
*
* @param Array $landing_pages
* @param String $column
* @return Collection
*/
private static function getLeadCount($landing_pages, $column)
{
$medium = Attribution::select(DB::raw("IFNULL({$column}, 'None') AS label"), DB::raw("COUNT('id') AS total"))->whereIn('landing_page_id', $landing_pages)->groupBy($column)->orderBy('total', 'desc')->lists('total', 'label');
if (!$medium->isEmpty()) {
return $medium;
}
return collect();
}
