PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);$_db->exec("SET search_path TO admin,public");
$_cp_count=(int)$_db->query("SELECT COUNT(*) FROM creative_performance")->fetchColumn();
$_sp_count=(int)$_db->query("SELECT COUNT(*) FROM subject_performance")->fetchColumn();
$_cr_active=(int)$_db->query("SELECT COUNT(*) FROM offer_creatives WHERE status='active'")->fetchColumn();
$_cr_total=(int)$_db->query("SELECT COUNT(*) FROM offer_creatives")->fetchColumn();
$_cp_cols=$_db->query("SELECT column_name FROM information_schema.columns WHERE table_schema='admin' AND table_name='creative_performance' ORDER BY ordinal_position")->fetchAll(PDO::FETCH_COLUMN);
$_sp_cols=$_db->query("SELECT column_name FROM information_schema.columns WHERE table_schema='admin' AND table_name='subject_performance' ORDER BY ordinal_position")->fetchAll(PDO::FETCH_COLUMN);
// Creative performance
$_cp=[];
try{
$select_cp='*';
if(in_array('creative_id',$_cp_cols)&&in_array('opens',$_cp_cols))$select_cp='creative_id,isp,opens,clicks,conversions,inbox_rate,score';
$_cp=$_db->query("SELECT $select_cp FROM creative_performance ORDER BY id DESC LIMIT 30")->fetchAll();
}catch(Exception $e){$_cp=[];}
// Subject performance
$_sp=[];
try{
$select_sp='*';
if(in_array('subject',$_sp_cols)&&in_array('open_rate',$_sp_cols))$select_sp='subject,open_rate,click_rate,sends,isp';
elseif(in_array('subject_line',$_sp_cols))$select_sp='subject_line as subject,open_rate,click_rate,total_sent as sends,isp_target as isp';
$_sp=$_db->query("SELECT $select_sp FROM subject_performance ORDER BY id DESC LIMIT 30")->fetchAll();
}catch(Exception $e){$_sp=[];}
$_bcp=[];
try{$_bcp=$_db->query("SELECT * FROM brain_creative_performance ORDER BY id DESC LIMIT 20")->fetchAll();}catch(Exception $e){}
?>
WEVADS - Creative Performance
📊 Creative Performance
A/B testing results, subject line performance, ISP-level creative analytics