Is there a clever way to organize this controller?

dashboard_controller.rb

# Generates KPIs for each Month - Year 2016
#january kpis
camp_january_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 01).where('extract(year from scheduled_date) = ?', 2016)
camp_january_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 01).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
jan_o_2016 = camp_january_2016.pluck('unique_views').sum
jan_opens_2016 = jan_o_2016 + 0.0
jan_c_2016 = camp_january_2016.pluck('clicker').sum
jan_clicks_2016 = jan_c_2016 + 0.0
jan_v_2016 = camp_january_2016.pluck('sent').sum
jan_volume_2016 = jan_v + 0.0
jan_v_actifs_2016 = camp_january_actifs_2016.pluck('sent').sum
jan_volume_actifs_2016 = jan_v_actifs_2016 + 0.0
jan_to_2016 = camp_january_2016.pluck('turnover').sum
jan_turnover_2016 = jan_to_2016 + 0.0
jan_mg_2016 = camp_january_2016.pluck('margin').sum
jan_margin_2016 = jan_mg_2016 + 0.0
jan_mg_actifs_2016 = camp_january_actifs_2016.pluck('margin').sum
camp_january_margin_actifs_2016 = jan_mg_actifs_2016 + 0.0
jan_ct_2016 = camp_january_2016.pluck('cost').sum
jan_cost_2016 = jan_ct_2016 + 0.0

@jan_volume_2016 = jan_volume_2016
@jan_volume_actifs_2016 = jan_volume_actifs_2016
@jan_to_2016 = jan_turnover_2016
@jan_cost_2016 = jan_cost_2016
@jan_ecpm_actifs_2016 = (camp_january_margin_actifs_2016 / jan_volume_actifs_2016) * 1000
@jan_ecpm_2016 = (jan_margin_2016 / jan_volume_2016) * 1000
@jan_margin_2016 = jan_margin_2016

#january kpis A Boa do Dia
camp_january_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 01).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_january_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 01).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
jan_o_abd_2016 = camp_january_abd_2016.pluck('unique_views').sum
jan_opens_abd_2016 = jan_o_abd_2016 + 0.0
jan_c_abd_2016 = camp_january_abd_2016.pluck('clicker').sum
jan_clicks_abd_2016 = jan_c_abd_2016 + 0.0
jan_v_abd_2016 = camp_january_abd_2016.pluck('sent').sum
jan_volume_abd_2016 = jan_v_abd_2016 + 0.0
jan_v_actifs_abd_2016 = camp_january_actifs_abd_2016.pluck('sent').sum
jan_volume_actifs_abd_2016 = jan_v_actifs_abd_2016 + 0.0
jan_to_abd_2016 = camp_january_abd_2016.pluck('turnover').sum
jan_turnover_abd_2016 = jan_to_abd_2016 + 0.0
jan_mg_abd_2016 = camp_january_abd_2016.pluck('margin').sum
jan_margin_abd_2016 = jan_mg_abd_2016 + 0.0
jan_mg_actifs_abd_2016 = camp_january_actifs_abd_2016.pluck('margin').sum
camp_january_margin_actifs_abd_2016 = jan_mg_actifs_abd_2016 + 0.0
jan_ct_abd_2016 = camp_january_abd_2016.pluck('cost').sum
jan_cost_abd_2016 = jan_ct_abd_2016 + 0.0

@jan_volume_abd_2016 = jan_volume_abd_2016
@jan_volume_actifs_abd_2016 = jan_volume_actifs_abd_2016
@jan_to_abd_2016 = jan_turnover_abd_2016
@jan_cost_abd_2016 = jan_cost_abd_2016
@jan_ecpm_actifs_abd_2016 = (camp_january_margin_actifs_abd_2016 / jan_volume_actifs_abd_2016) * 1000
@jan_ecpm_abd_2016 = (jan_margin_abd_2016 / jan_volume_abd_2016) * 1000
@jan_margin_abd_2016 = jan_margin_abd_2016


#january kpis Aki Você Acha
camp_january_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 01).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_january_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 01).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
jan_o_ava_2016 = camp_january_ava_2016.pluck('unique_views').sum
jan_opens_ava_2016 = jan_o_ava_2016 + 0.0
jan_c_ava_2016 = camp_january_ava_2016.pluck('clicker').sum
jan_clicks_ava_2016 = jan_c_ava_2016 + 0.0
jan_v_ava_2016 = camp_january_ava_2016.pluck('sent').sum
jan_volume_ava_2016 = jan_v_ava_2016 + 0.0
jan_v_actifs_ava_2016 = camp_january_actifs_ava_2016.pluck('sent').sum
jan_volume_actifs_ava_2016 = jan_v_actifs_ava_2016 + 0.0
jan_to_ava_2016 = camp_january_ava_2016.pluck('turnover').sum
jan_turnover_ava_2016 = jan_to_ava_2016 + 0.0
jan_mg_ava_2016 = camp_january_ava_2016.pluck('margin').sum
jan_margin_ava_2016 = jan_mg_ava_2016 + 0.0
jan_mg_actifs_ava_2016 = camp_january_actifs_ava_2016.pluck('margin').sum
camp_january_margin_actifs_ava_2016 = jan_mg_actifs_ava_2016 + 0.0
jan_ct_ava_2016 = camp_january_ava_2016.pluck('cost').sum
jan_cost_ava_2016 = jan_ct_ava_2016 + 0.0

@jan_volume_ava_2016 = jan_volume_ava_2016
@jan_volume_actifs_ava_2016 = jan_volume_actifs_ava_2016
@jan_to_ava_2016 = jan_turnover_ava_2016
@jan_cost_ava_2016 = jan_cost_ava_2016
@jan_ecpm_actifs_ava_2016 = (camp_january_margin_actifs_ava_2016 / jan_volume_actifs_ava_2016) * 1000
@jan_ecpm_ava_2016 = (jan_margin_ava_2016 / jan_volume_ava_2016) * 1000
@jan_margin_ava_2016 = jan_margin_ava_2016

#february kpis
camp_february_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 02).where('extract(year from scheduled_date) = ?', 2016)
camp_february_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 02).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
feb_o_2016 = camp_february_2016.pluck('unique_views').sum
feb_opens_2016 = feb_o_2016 + 0.0
feb_c_2016 = camp_february_2016.pluck('clicker').sum
feb_clicks_2016 = feb_c_2016 + 0.0
feb_v_2016 = camp_february_2016.pluck('sent').sum
feb_volume_2016 = feb_v_2016 + 0.0
feb_v_actifs_2016 = camp_february_actifs_2016.pluck('sent').sum
feb_volume_actifs_2016 = feb_v_actifs_2016 + 0.0
feb_to_2016 = camp_february_2016.pluck('turnover').sum
feb_turnover_2016 = feb_to_2016 + 0.0
feb_mg_2016 = camp_february_2016.pluck('margin').sum
feb_margin_2016 = feb_mg_2016 + 0.0
feb_mg_actifs_2016 = camp_february_actifs_2016.pluck('margin').sum
camp_february_margin_actifs_2016 = feb_mg_actifs_2016 + 0.0
feb_ct_2016 = camp_february_2016.pluck('cost').sum
feb_cost_2016 = feb_ct_2016 + 0.0

@feb_volume_2016 = feb_volume_2016
@feb_volume_actifs_2016 = feb_volume_actifs_2016
@feb_to_2016 = feb_turnover_2016
@feb_cost_2016 = feb_cost_2016
@feb_ecpm_actifs_2016 = (camp_february_margin_actifs_2016 / feb_volume_actifs_2016) * 1000
@feb_ecpm_2016 = (feb_margin_2016 / feb_volume_2016) * 1000
@feb_margin_2016 = feb_margin_2016

#february kpis A Boa do Dia
camp_february_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 02).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_february_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 02).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
feb_o_abd_2016 = camp_february_abd_2016.pluck('unique_views').sum
feb_opens_abd_2016 = feb_o_abd_2016 + 0.0
feb_c_abd_2016 = camp_february_abd_2016.pluck('clicker').sum
feb_clicks_abd_2016 = feb_c_abd_2016 + 0.0
feb_v_abd_2016 = camp_february_abd_2016.pluck('sent').sum
feb_volume_abd_2016 = feb_v_abd_2016 + 0.0
feb_v_actifs_abd_2016 = camp_february_actifs_abd_2016.pluck('sent').sum
feb_volume_actifs_abd_2016 = feb_v_actifs_abd_2016 + 0.0
feb_to_abd_2016 = camp_february_abd_2016.pluck('turnover').sum
feb_turnover_abd_2016 = feb_to_abd_2016 + 0.0
feb_mg_abd_2016 = camp_february_abd_2016.pluck('margin').sum
feb_margin_abd_2016 = feb_mg_abd_2016 + 0.0
feb_mg_actifs_abd_2016 = camp_february_actifs_abd_2016.pluck('margin').sum
camp_february_margin_actifs_abd_2016 = feb_mg_actifs_abd_2016 + 0.0
feb_ct_abd_2016 = camp_february_abd_2016.pluck('cost').sum
feb_cost_abd_2016 = feb_ct_abd_2016 + 0.0

@feb_volume_abd_2016 = feb_volume_abd_2016
@feb_volume_actifs_abd_2016 = feb_volume_actifs_abd_2016
@feb_to_abd_2016 = feb_turnover_abd_2016
@feb_cost_abd_2016 = feb_cost_abd_2016
@feb_ecpm_actifs_abd_2016 = (camp_february_margin_actifs_abd_2016 / feb_volume_actifs_abd_2016) * 1000
@feb_ecpm_abd_2016 = (feb_margin_abd_2016 / feb_volume_abd_2016) * 1000
@feb_margin_abd_2016 = feb_margin_abd_2016


#february kpis Aki Você Acha
camp_february_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 02).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_february_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 02).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
feb_o_ava_2016 = camp_february_ava_2016.pluck('unique_views').sum
feb_opens_ava_2016 = feb_o_ava_2016 + 0.0
feb_c_ava_2016 = camp_february_ava_2016.pluck('clicker').sum
feb_clicks_ava_2016 = feb_c_ava_2016 + 0.0
feb_v_ava_2016 = camp_february_ava_2016.pluck('sent').sum
feb_volume_ava_2016 = feb_v_ava_2016 + 0.0
feb_v_actifs_ava_2016 = camp_february_actifs_ava_2016.pluck('sent').sum
feb_volume_actifs_ava_2016 = feb_v_actifs_ava_2016 + 0.0
feb_to_ava_2016 = camp_february_ava_2016.pluck('turnover').sum
feb_turnover_ava_2016 = feb_to_ava_2016 + 0.0
feb_mg_ava_2016 = camp_february_ava_2016.pluck('margin').sum
feb_margin_ava_2016 = feb_mg_ava_2016 + 0.0
feb_mg_actifs_ava_2016 = camp_february_actifs_ava_2016.pluck('margin').sum
camp_february_margin_actifs_ava_2016 = feb_mg_actifs_ava_2016 + 0.0
feb_ct_ava_2016 = camp_february_ava_2016.pluck('cost').sum
feb_cost_ava_2016 = feb_ct_ava_2016 + 0.0

@feb_volume_ava_2016 = feb_volume_ava_2016
@feb_volume_actifs_ava_2016 = feb_volume_actifs_ava_2016
@feb_to_ava_2016 = feb_turnover_ava_2016
@feb_cost_ava_2016 = feb_cost_ava_2016
@feb_ecpm_actifs_ava_2016 = (camp_february_margin_actifs_ava_2016 / feb_volume_actifs_ava_2016) * 1000
@feb_ecpm_ava_2016 = (feb_margin_ava_2016 / feb_volume_ava_2016) * 1000
@feb_margin_ava_2016 = feb_margin_ava_2016

#march kpis
camp_march_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 03).where('extract(year from scheduled_date) = ?', 2016)
camp_march_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 03).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
mar_o_2016 = camp_march_2016.pluck('unique_views').sum
mar_opens_2016 = mar_o_2016 + 0.0
mar_c_2016 = camp_march_2016.pluck('clicker').sum
mar_clicks_2016 = mar_c_2016 + 0.0
mar_v_2016 = camp_march_2016.pluck('sent').sum
mar_volume_2016 = mar_v_2016 + 0.0
mar_v_actifs_2016 = camp_march_actifs_2016.pluck('sent').sum
mar_volume_actifs_2016 = mar_v_actifs_2016 + 0.0
mar_to_2016 = camp_march_2016.pluck('turnover').sum
mar_turnover_2016 = mar_to_2016 + 0.0
mar_mg_2016 = camp_march_2016.pluck('margin').sum
mar_margin_2016 = mar_mg_2016 + 0.0
mar_mg_actifs_2016 = camp_march_actifs_2016.pluck('margin').sum
camp_march_margin_actifs_2016 = mar_mg_actifs_2016 + 0.0
mar_ct_2016 = camp_march_2016.pluck('cost').sum
mar_cost_2016 = mar_ct_2016 + 0.0

@mar_volume_2016 = mar_volume_2016
@mar_volume_actifs_2016 = mar_volume_actifs_2016
@mar_to_2016 = mar_turnover_2016
@mar_cost_2016 = mar_cost_2016
@mar_ecpm_actifs_2016 = (camp_march_margin_actifs_2016 / mar_volume_actifs_2016) * 1000
@mar_ecpm_2016 = (mar_margin_2016 / mar_volume_2016) * 1000
@mar_margin_2016 = mar_margin_2016

#march kpis A Boa do Dia
camp_march_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 03).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_march_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 03).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
mar_o_abd_2016 = camp_march_abd_2016.pluck('unique_views').sum
mar_opens_abd_2016 = mar_o_abd_2016 + 0.0
mar_c_abd_2016 = camp_march_abd_2016.pluck('clicker').sum
mar_clicks_abd_2016 = mar_c_abd_2016 + 0.0
mar_v_abd_2016 = camp_march_abd_2016.pluck('sent').sum
mar_volume_abd_2016 = mar_v_abd_2016 + 0.0
mar_v_actifs_abd_2016 = camp_march_actifs_abd_2016.pluck('sent').sum
mar_volume_actifs_abd_2016 = mar_v_actifs_abd_2016 + 0.0
mar_to_abd_2016 = camp_march_abd_2016.pluck('turnover').sum
mar_turnover_abd_2016 = mar_to_abd_2016 + 0.0
mar_mg_abd_2016 = camp_march_abd_2016.pluck('margin').sum
mar_margin_abd_2016 = mar_mg_abd_2016 + 0.0
mar_mg_actifs_abd_2016 = camp_march_actifs_abd_2016.pluck('margin').sum
camp_march_margin_actifs_abd_2016 = mar_mg_actifs_abd_2016 + 0.0
mar_ct_abd_2016 = camp_march_abd_2016.pluck('cost').sum
mar_cost_abd_2016 = mar_ct_abd_2016 + 0.0

@mar_volume_abd_2016 = mar_volume_abd_2016
@mar_volume_actifs_abd_2016 = mar_volume_actifs_abd_2016
@mar_to_abd_2016 = mar_turnover_abd_2016
@mar_cost_abd_2016 = mar_cost_abd_2016
@mar_ecpm_actifs_abd_2016 = (camp_march_margin_actifs_abd_2016 / mar_volume_actifs_abd_2016) * 1000
@mar_ecpm_abd_2016 = (mar_margin_abd_2016 / mar_volume_abd_2016) * 1000
@mar_margin_abd_2016 = mar_margin_abd_2016


#march kpis Aki Você Acha
camp_march_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 03).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_march_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 03).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
mar_o_ava_2016 = camp_march_ava_2016.pluck('unique_views').sum
mar_opens_ava_2016 = mar_o_ava_2016 + 0.0
mar_c_ava_2016 = camp_march_ava_2016.pluck('clicker').sum
mar_clicks_ava_2016 = mar_c_ava_2016 + 0.0
mar_v_ava_2016 = camp_march_ava_2016.pluck('sent').sum
mar_volume_ava_2016 = mar_v_ava_2016 + 0.0
mar_v_actifs_ava_2016 = camp_march_actifs_ava_2016.pluck('sent').sum
mar_volume_actifs_ava_2016 = mar_v_actifs_ava_2016 + 0.0
mar_to_ava_2016 = camp_march_ava_2016.pluck('turnover').sum
mar_turnover_ava_2016 = mar_to_ava_2016 + 0.0
mar_mg_ava_2016 = camp_march_ava_2016.pluck('margin').sum
mar_margin_ava_2016 = mar_mg_ava_2016 + 0.0
mar_mg_actifs_ava_2016 = camp_march_actifs_ava_2016.pluck('margin').sum
camp_march_margin_actifs_ava_2016 = mar_mg_actifs_ava_2016 + 0.0
mar_ct_ava_2016 = camp_march_ava_2016.pluck('cost').sum
mar_cost_ava_2016 = mar_ct_ava_2016 + 0.0

@mar_volume_ava_2016 = mar_volume_ava_2016
@mar_volume_actifs_ava_2016 = mar_volume_actifs_ava_2016
@mar_to_ava_2016 = mar_turnover_ava_2016
@mar_cost_ava_2016 = mar_cost_ava_2016
@mar_ecpm_actifs_ava_2016 = (camp_march_margin_actifs_ava_2016 / mar_volume_actifs_ava_2016) * 1000
@mar_ecpm_ava_2016 = (mar_margin_ava_2016 / mar_volume_ava_2016) * 1000
@mar_margin_ava_2016 = mar_margin_ava_2016

#april kpis
camp_april_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 04).where('extract(year from scheduled_date) = ?', 2016)
camp_april_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 04).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
apr_o_2016 = camp_april_2016.pluck('unique_views').sum
apr_opens_2016 = apr_o_2016 + 0.0
apr_c_2016 = camp_april_2016.pluck('clicker').sum
apr_clicks_2016 = apr_c_2016 + 0.0
apr_v_2016 = camp_april_2016.pluck('sent').sum
apr_volume_2016 = apr_v_2016 + 0.0
apr_v_actifs_2016 = camp_april_actifs_2016.pluck('sent').sum
apr_volume_actifs_2016 = apr_v_actifs_2016 + 0.0
apr_to_2016 = camp_april_2016.pluck('turnover').sum
apr_turnover_2016 = apr_to_2016 + 0.0
apr_mg_2016 = camp_april_2016.pluck('margin').sum
apr_margin_2016 = apr_mg_2016 + 0.0
apr_mg_actifs_2016 = camp_april_actifs_2016.pluck('margin').sum
camp_april_margin_actifs_2016 = apr_mg_actifs_2016 + 0.0
apr_ct_2016 = camp_april_2016.pluck('cost').sum
apr_cost_2016 = apr_ct_2016 + 0.0

@apr_volume_2016 = apr_volume_2016
@apr_volume_actifs_2016 = apr_volume_actifs_2016
@apr_to_2016 = apr_turnover_2016
@apr_cost_2016 = apr_cost_2016
@apr_ecpm_actifs_2016 = (camp_april_margin_actifs_2016 / apr_volume_actifs_2016) * 1000
@apr_ecpm_2016 = (apr_margin_2016 / apr_volume_2016) * 1000
@apr_margin_2016 = apr_margin_2016

#april kpis A Boa do Dia
camp_april_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 04).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_april_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 04).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
apr_o_abd_2016 = camp_april_abd_2016.pluck('unique_views').sum
apr_opens_abd_2016 = apr_o_abd_2016 + 0.0
apr_c_abd_2016 = camp_april_abd_2016.pluck('clicker').sum
apr_clicks_abd_2016 = apr_c_abd_2016 + 0.0
apr_v_abd_2016 = camp_april_abd_2016.pluck('sent').sum
apr_volume_abd_2016 = apr_v_abd_2016 + 0.0
apr_v_actifs_abd_2016 = camp_april_actifs_abd_2016.pluck('sent').sum
apr_volume_actifs_abd_2016 = apr_v_actifs_abd_2016 + 0.0
apr_to_abd_2016 = camp_april_abd_2016.pluck('turnover').sum
apr_turnover_abd_2016 = apr_to_abd_2016 + 0.0
apr_mg_abd_2016 = camp_april_abd_2016.pluck('margin').sum
apr_margin_abd_2016 = apr_mg_abd_2016 + 0.0
apr_mg_actifs_abd_2016 = camp_april_actifs_abd_2016.pluck('margin').sum
camp_april_margin_actifs_abd_2016 = apr_mg_actifs_abd_2016 + 0.0
apr_ct_abd_2016 = camp_april_abd_2016.pluck('cost').sum
apr_cost_abd_2016 = apr_ct_abd_2016 + 0.0

@apr_volume_abd_2016 = apr_volume_abd_2016
@apr_volume_actifs_abd_2016 = apr_volume_actifs_abd_2016
@apr_to_abd_2016 = apr_turnover_abd_2016
@apr_cost_abd_2016 = apr_cost_abd_2016
@apr_ecpm_actifs_abd_2016 = (camp_april_margin_actifs_abd_2016 / apr_volume_actifs_abd_2016) * 1000
@apr_ecpm_abd_2016 = (apr_margin_abd_2016 / apr_volume_abd_2016) * 1000
@apr_margin_abd_2016 = apr_margin_abd_2016


#april kpis Aki Você Acha
camp_april_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 04).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_april_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 04).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
apr_o_ava_2016 = camp_april_ava_2016.pluck('unique_views').sum
apr_opens_ava_2016 = apr_o_ava_2016 + 0.0
apr_c_ava_2016 = camp_april_ava_2016.pluck('clicker').sum
apr_clicks_ava_2016 = apr_c_ava_2016 + 0.0
apr_v_ava_2016 = camp_april_ava_2016.pluck('sent').sum
apr_volume_ava_2016 = apr_v_ava_2016 + 0.0
apr_v_actifs_ava_2016 = camp_april_actifs_ava_2016.pluck('sent').sum
apr_volume_actifs_ava_2016 = apr_v_actifs_ava_2016 + 0.0
apr_to_ava_2016 = camp_april_ava_2016.pluck('turnover').sum
apr_turnover_ava_2016 = apr_to_ava_2016 + 0.0
apr_mg_ava_2016 = camp_april_ava_2016.pluck('margin').sum
apr_margin_ava_2016 = apr_mg_ava_2016 + 0.0
apr_mg_actifs_ava_2016 = camp_april_actifs_ava_2016.pluck('margin').sum
camp_april_margin_actifs_ava_2016 = apr_mg_actifs_ava_2016 + 0.0
apr_ct_ava_2016 = camp_april_ava_2016.pluck('cost').sum
apr_cost_ava_2016 = apr_ct_ava_2016 + 0.0

@apr_volume_ava_2016 = apr_volume_ava_2016
@apr_volume_actifs_ava_2016 = apr_volume_actifs_ava_2016
@apr_to_ava_2016 = apr_turnover_ava_2016
@apr_cost_ava_2016 = apr_cost_ava_2016
@apr_ecpm_actifs_ava_2016 = (camp_april_margin_actifs_ava_2016 / apr_volume_actifs_ava_2016) * 1000
@apr_ecpm_ava_2016 = (apr_margin_ava_2016 / apr_volume_ava_2016) * 1000
@apr_margin_ava_2016 = apr_margin_ava_2016

#may kpis
camp_may_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 05).where('extract(year from scheduled_date) = ?', 2016)
camp_may_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 05).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
may_o_2016 = camp_may_2016.pluck('unique_views').sum
may_opens_2016 = may_o_2016 + 0.0
may_c_2016 = camp_may_2016.pluck('clicker').sum
may_clicks_2016 = may_c_2016 + 0.0
may_v_2016 = camp_may_2016.pluck('sent').sum
may_volume_2016 = may_v_2016 + 0.0
may_v_actifs_2016 = camp_may_actifs_2016.pluck('sent').sum
may_volume_actifs_2016 = may_v_actifs_2016 + 0.0
may_to_2016 = camp_may_2016.pluck('turnover').sum
may_turnover_2016 = may_to_2016 + 0.0
may_mg_2016 = camp_may_2016.pluck('margin').sum
may_margin_2016 = may_mg_2016 + 0.0
may_mg_actifs_2016 = camp_may_actifs_2016.pluck('margin').sum
camp_may_margin_actifs_2016 = may_mg_actifs_2016 + 0.0
may_ct_2016 = camp_may_2016.pluck('cost').sum
may_cost_2016 = may_ct_2016 + 0.0

@may_volume_2016 = may_volume_2016
@may_volume_actifs_2016 = may_volume_actifs_2016
@may_to_2016 = may_turnover_2016
@may_cost_2016 = may_cost_2016
@may_ecpm_actifs_2016 = (camp_may_margin_actifs_2016 / may_volume_actifs_2016) * 1000
@may_ecpm_2016 = (may_margin_2016 / may_volume_2016) * 1000
@may_margin_2016 = may_margin_2016

#may kpis A Boa do Dia
camp_may_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 05).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_may_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 05).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
may_o_abd_2016 = camp_may_abd_2016.pluck('unique_views').sum
may_opens_abd_2016 = may_o_abd_2016 + 0.0
may_c_abd_2016 = camp_may_abd_2016.pluck('clicker').sum
may_clicks_abd_2016 = may_c_abd_2016 + 0.0
may_v_abd_2016 = camp_may_abd_2016.pluck('sent').sum
may_volume_abd_2016 = may_v_abd_2016 + 0.0
may_v_actifs_abd_2016 = camp_may_actifs_abd_2016.pluck('sent').sum
may_volume_actifs_abd_2016 = may_v_actifs_abd_2016 + 0.0
may_to_abd_2016 = camp_may_abd_2016.pluck('turnover').sum
may_turnover_abd_2016 = may_to_abd_2016 + 0.0
may_mg_abd_2016 = camp_may_abd_2016.pluck('margin').sum
may_margin_abd_2016 = may_mg_abd_2016 + 0.0
may_mg_actifs_abd_2016 = camp_may_actifs_abd_2016.pluck('margin').sum
camp_may_margin_actifs_abd_2016 = may_mg_actifs_abd_2016_2016 + 0.0
may_ct_abd_2016 = camp_may_abd_2016.pluck('cost').sum
may_cost_abd_2016 = may_ct_abd_2016 + 0.0

@may_volume_abd_2016 = may_volume_abd_2016
@may_volume_actifs_abd_2016 = may_volume_actifs_abd_2016
@may_to_abd_2016 = may_turnover_abd_2016
@may_cost_abd_2016 = may_cost_abd_2016
@may_ecpm_actifs_abd_2016 = (camp_may_margin_actifs_abd_2016 / may_volume_actifs_abd_2016) * 1000
@may_ecpm_abd_2016 = (may_margin_abd_2016 / may_volume_abd_2016) * 1000
@may_margin_abd_2016 = may_margin_abd_2016


#may kpis Aki Você Acha
camp_may_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 05).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_may_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 05).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
may_o_ava_2016 = camp_may_ava_2016.pluck('unique_views').sum
may_opens_ava_2016 = may_o_ava_2016 + 0.0
may_c_ava_2016 = camp_may_ava_2016.pluck('clicker').sum
may_clicks_ava_2016 = may_c_ava_2016 + 0.0
may_v_ava_2016 = camp_may_ava_2016.pluck('sent').sum
may_volume_ava_2016 = may_v_ava_2016 + 0.0
may_v_actifs_ava_2016 = camp_may_actifs_ava_2016.pluck('sent').sum
may_volume_actifs_ava_2016 = may_v_actifs_ava_2016 + 0.0
may_to_ava_2016 = camp_may_ava_2016.pluck('turnover').sum
may_turnover_ava_2016 = may_to_ava_2016 + 0.0
may_mg_ava_2016 = camp_may_ava_2016.pluck('margin').sum
may_margin_ava_2016 = may_mg_ava_2016 + 0.0
may_mg_actifs_ava_2016 = camp_may_actifs_ava_2016.pluck('margin').sum
camp_may_margin_actifs_ava_2016 = may_mg_actifs_ava_2016 + 0.0
may_ct_ava_2016 = camp_may_ava_2016.pluck('cost').sum
may_cost_ava_2016 = may_ct_ava_2016 + 0.0

@may_volume_ava_2016 = may_volume_ava_2016
@may_volume_actifs_ava_2016 = may_volume_actifs_ava_2016
@may_to_ava_2016 = may_turnover_ava_2016
@may_cost_ava_2016 = may_cost_ava_2016
@may_ecpm_actifs_ava_2016 = (camp_may_margin_actifs_ava_2016 / may_volume_actifs_ava_2016) * 1000
@may_ecpm_ava_2016 = (may_margin_ava_2016 / may_volume_ava_2016) * 1000
@may_margin_ava_2016 = may_margin_ava_2016

#june kpis
camp_june_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 06).where('extract(year from scheduled_date) = ?', 2016)
camp_june_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 06).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
june_o_2016 = camp_june_2016.pluck('unique_views').sum
june_opens_2016 = june_o_2016 + 0.0
june_c_2016 = camp_june_2016.pluck('clicker').sum
june_clicks_2016 = june_c_2016 + 0.0
june_v_2016 = camp_june_2016.pluck('sent').sum
june_volume_2016 = june_v_2016 + 0.0
june_v_actifs_2016 = camp_june_actifs_2016.pluck('sent').sum
june_volume_actifs_2016 = june_v_actifs_2016 + 0.0
june_to_2016 = camp_june_2016.pluck('turnover').sum
june_turnover_2016 = june_to_2016 + 0.0
june_mg_2016 = camp_june_2016.pluck('margin').sum
june_margin_2016 = june_mg_2016 + 0.0
june_mg_actifs_2016 = camp_june_actifs_2016.pluck('margin').sum
camp_june_margin_actifs_2016 = june_mg_actifs_2016 + 0.0
june_ct_2016 = camp_june_2016.pluck('cost').sum
june_cost_2016 = june_ct_2016 + 0.0

@june_volume_2016 = june_volume_2016
@june_volume_actifs_2016 = june_volume_actifs_2016
@june_to_2016 = june_turnover_2016
@june_cost_2016 = june_cost_2016
@june_ecpm_actifs_2016 = (camp_june_margin_actifs_2016 / june_volume_actifs_2016) * 1000
@june_ecpm_2016 = (june_margin_2016 / june_volume_2016) * 1000
@june_margin_2016 = june_margin_2016

#june kpis A Boa do Dia
camp_june_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 06).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_june_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 06).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
june_o_abd_2016 = camp_june_abd_2016.pluck('unique_views').sum
june_opens_abd_2016 = june_o_abd_2016 + 0.0
june_c_abd_2016 = camp_june_abd_2016.pluck('clicker').sum
june_clicks_abd_2016 = june_c_abd_2016 + 0.0
june_v_abd_2016 = camp_june_abd_2016.pluck('sent').sum
june_volume_abd_2016 = june_v_abd_2016 + 0.0
june_v_actifs_abd_2016 = camp_june_actifs_abd_2016.pluck('sent').sum
june_volume_actifs_abd_2016 = june_v_actifs_abd_2016 + 0.0
june_to_abd_2016 = camp_june_abd_2016.pluck('turnover').sum
june_turnover_abd_2016 = june_to_abd_2016 + 0.0
june_mg_abd_2016 = camp_june_abd_2016.pluck('margin').sum
june_margin_abd_2016 = june_mg_abd_2016 + 0.0
june_mg_actifs_abd_2016 = camp_june_actifs_abd_2016.pluck('margin').sum
camp_june_margin_actifs_abd_2016 = june_mg_actifs_abd_2016 + 0.0
june_ct_abd_2016 = camp_june_abd_2016.pluck('cost').sum
june_cost_abd_2016 = june_ct_abd_2016 + 0.0

@june_volume_abd_2016 = june_volume_abd_2016
@june_volume_actifs_abd_2016 = june_volume_actifs_abd_2016
@june_to_abd_2016 = june_turnover_abd_2016
@june_cost_abd_2016 = june_cost_abd_2016
@june_ecpm_actifs_abd_2016 = (camp_june_margin_actifs_abd_2016 / june_volume_actifs_abd_2016) * 1000
@june_ecpm_abd_2016 = (june_margin_abd_2016 / june_volume_abd_2016) * 1000
@june_margin_abd_2016 = june_margin_abd_2016


#june kpis Aki Você Acha
camp_june_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 06).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_june_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 06).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
june_o_ava_2016 = camp_june_ava_2016.pluck('unique_views').sum
june_opens_ava_2016 = june_o_ava_2016 + 0.0
june_c_ava_2016 = camp_june_ava_2016.pluck('clicker').sum
june_clicks_ava_2016 = june_c_ava_2016 + 0.0
june_v_ava_2016 = camp_june_ava_2016.pluck('sent').sum
june_volume_ava_2016 = june_v_ava_2016 + 0.0
june_v_actifs_ava_2016 = camp_june_actifs_ava_2016.pluck('sent').sum
june_volume_actifs_ava_2016 = june_v_actifs_ava_2016 + 0.0
june_to_ava_2016 = camp_june_ava_2016.pluck('turnover').sum
june_turnover_ava_2016 = june_to_ava_2016 + 0.0
june_mg_ava_2016 = camp_june_ava_2016.pluck('margin').sum
june_margin_ava_2016 = june_mg_ava_2016 + 0.0
june_mg_actifs_ava_2016 = camp_june_actifs_ava_2016.pluck('margin').sum
camp_june_margin_actifs_ava_2016 = june_mg_actifs_ava_2016 + 0.0
june_ct_ava_2016 = camp_june_ava_2016.pluck('cost').sum
june_cost_ava_2016 = june_ct_ava_2016 + 0.0

@june_volume_ava_2016 = june_volume_ava_2016
@june_volume_actifs_ava_2016 = june_volume_actifs_ava_2016
@june_to_ava_2016 = june_turnover_ava_2016
@june_cost_ava_2016 = june_cost_ava_2016
@june_ecpm_actifs_ava_2016 = (camp_june_margin_actifs_ava_2016 / june_volume_actifs_ava_2016) * 1000
@june_ecpm_ava_2016 = (june_margin_ava_2016 / june_volume_ava_2016) * 1000
@june_margin_ava_2016 = june_margin_ava_2016

#july kpis
camp_july_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 07).where('extract(year from scheduled_date) = ?', 2016)
camp_july_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 07).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
july_o_2016 = camp_july_2016.pluck('unique_views').sum
july_opens_2016 = july_o_2016 + 0.0
july_c_2016 = camp_july_2016.pluck('clicker').sum
july_clicks_2016 = july_c_2016 + 0.0
july_v_2016 = camp_july_2016.pluck('sent').sum
july_volume_2016 = july_v_2016 + 0.0
july_v_actifs_2016 = camp_july_actifs_2016.pluck('sent').sum
july_volume_actifs_2016 = july_v_actifs_2016 + 0.0
july_to_2016 = camp_july_2016.pluck('turnover').sum
july_turnover_2016 = july_to_2016 + 0.0
july_mg_2016 = camp_july_2016.pluck('margin').sum
july_margin_2016 = july_mg_2016 + 0.0
july_mg_actifs_2016 = camp_july_actifs_2016.pluck('margin').sum
camp_july_margin_actifs_2016 = july_mg_actifs_2016 + 0.0
july_ct_2016 = camp_july_2016.pluck('cost').sum
july_cost_2016 = july_ct_2016 + 0.0

@july_volume_2016 = july_volume_2016
@july_volume_actifs_2016 = july_volume_actifs_2016
@july_to_2016 = july_turnover_2016
@july_cost_2016 = july_cost_2016
@july_ecpm_actifs_2016 = (camp_july_margin_actifs_2016 / july_volume_actifs_2016) * 1000
@july_ecpm_2016 = (july_margin_2016 / july_volume_2016) * 1000
@july_margin_2016 = july_margin_2016

#july kpis A Boa do Dia
camp_july_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 07).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_july_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 07).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
july_o_abd_2016 = camp_july_abd_2016.pluck('unique_views').sum
july_opens_abd_2016 = july_o_abd_2016 + 0.0
july_c_abd_2016 = camp_july_abd_2016.pluck('clicker').sum
july_clicks_abd_2016 = july_c_abd_2016 + 0.0
july_v_abd_2016 = camp_july_abd_2016.pluck('sent').sum
july_volume_abd_2016 = july_v_abd_2016 + 0.0
july_v_actifs_abd_2016 = camp_july_actifs_abd_2016.pluck('sent').sum
july_volume_actifs_abd_2016 = july_v_actifs_abd_2016 + 0.0
july_to_abd_2016 = camp_july_abd_2016.pluck('turnover').sum
july_turnover_abd_2016 = july_to_abd_2016 + 0.0
july_mg_abd_2016 = camp_july_abd_2016.pluck('margin').sum
july_margin_abd_2016 = july_mg_abd_2016 + 0.0
july_mg_actifs_abd_2016 = camp_july_actifs_abd_2016.pluck('margin').sum
camp_july_margin_actifs_abd_2016 = july_mg_actifs_abd_2016 + 0.0
july_ct_abd_2016 = camp_july_abd_2016.pluck('cost').sum
july_cost_abd_2016 = july_ct_abd_2016 + 0.0

@july_volume_abd_2016 = july_volume_abd_2016
@july_volume_actifs_abd_2016 = july_volume_actifs_abd_2016
@july_to_abd_2016 = july_turnover_abd_2016
@july_cost_abd_2016 = july_cost_abd_2016
@july_ecpm_actifs_abd_2016 = (camp_july_margin_actifs_abd_2016 / july_volume_actifs_abd_2016) * 1000
@july_ecpm_abd_2016 = (july_margin_abd_2016 / july_volume_abd_2016) * 1000
@july_margin_abd_2016 = july_margin_abd_2016


#july kpis Aki Você Acha
camp_july_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 07).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_july_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 07).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
july_o_ava_2016 = camp_july_ava_2016.pluck('unique_views').sum
july_opens_ava_2016 = july_o_ava_2016 + 0.0
july_c_ava_2016 = camp_july_ava_2016.pluck('clicker').sum
july_clicks_ava_2016 = july_c_ava_2016 + 0.0
july_v_ava_2016 = camp_july_ava_2016.pluck('sent').sum
july_volume_ava_2016 = july_v_ava_2016 + 0.0
july_v_actifs_ava_2016 = camp_july_actifs_ava_2016.pluck('sent').sum
july_volume_actifs_ava_2016 = july_v_actifs_ava_2016 + 0.0
july_to_ava_2016 = camp_july_ava_2016.pluck('turnover').sum
july_turnover_ava_2016 = july_to_ava_2016 + 0.0
july_mg_ava_2016 = camp_july_ava_2016.pluck('margin').sum
july_margin_ava_2016 = july_mg_ava_2016 + 0.0
july_mg_actifs_ava_2016 = camp_july_actifs_ava_2016.pluck('margin').sum
camp_july_margin_actifs_ava_2016 = july_mg_actifs_ava_2016 + 0.0
july_ct_ava_2016 = camp_july_ava_2016.pluck('cost').sum
july_cost_ava_2016 = july_ct_ava_2016 + 0.0

@july_volume_ava_2016 = july_volume_ava_2016
@july_volume_actifs_ava_2016 = july_volume_actifs_ava_2016
@july_to_ava_2016 = july_turnover_ava_2016
@july_cost_ava_2016 = july_cost_ava_2016
@july_ecpm_actifs_ava_2016 = (camp_july_margin_actifs_ava_2016 / july_volume_actifs_ava_2016) * 1000
@july_ecpm_ava_2016 = (july_margin_ava_2016 / july_volume_ava_2016) * 1000
@july_margin_ava_2016 = july_margin_ava_2016

#august kpis
camp_august_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 08).where('extract(year from scheduled_date) = ?', 2016)
camp_august_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 08).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
august_o_2016 = camp_august_2016.pluck('unique_views').sum
august_opens_2016 = august_o_2016 + 0.0
august_c_2016 = camp_august_2016.pluck('clicker').sum
august_clicks_2016 = august_c_2016 + 0.0
august_v_2016 = camp_august_2016.pluck('sent').sum
august_volume_2016 = august_v_2016 + 0.0
august_v_actifs_2016 = camp_august_actifs_2016.pluck('sent').sum
august_volume_actifs_2016 = august_v_actifs_2016 + 0.0
august_to_2016 = camp_august_2016.pluck('turnover').sum
august_turnover_2016 = august_to_2016 + 0.0
august_mg_2016 = camp_august_2016.pluck('margin').sum
august_margin_2016 = august_mg_2016 + 0.0
august_mg_actifs_2016 = camp_august_actifs_2016.pluck('margin').sum
camp_august_margin_actifs_2016 = august_mg_actifs_2016 + 0.0
august_ct_2016 = camp_august_2016.pluck('cost').sum
august_cost_2016 = august_ct_2016 + 0.0

@august_volume_2016 = august_volume_2016
@august_volume_actifs_2016 = august_volume_actifs_2016
@august_to_2016 = august_turnover_2016
@august_cost_2016 = august_cost_2016
@august_ecpm_actifs_2016 = (camp_august_margin_actifs_2016 / august_volume_actifs_2016) * 1000
@august_ecpm_2016 = (august_margin_2016 / august_volume_2016) * 1000
@august_margin_2016 = august_margin_2016

#august kpis A Boa do Dia
camp_august_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 08).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_august_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 08).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
august_o_abd_2016 = camp_august_abd_2016.pluck('unique_views').sum
august_opens_abd_2016 = august_o_abd_2016 + 0.0
august_c_abd_2016 = camp_august_abd_2016.pluck('clicker').sum
august_clicks_abd_2016 = august_c_abd_2016 + 0.0
august_v_abd_2016 = camp_august_abd_2016.pluck('sent').sum
august_volume_abd_2016 = august_v_abd_2016 + 0.0
august_v_actifs_abd_2016 = camp_august_actifs_abd_2016.pluck('sent').sum
august_volume_actifs_abd_2016 = august_v_actifs_abd_2016 + 0.0
august_to_abd_2016 = camp_august_abd_2016.pluck('turnover').sum
august_turnover_abd_2016 = august_to_abd_2016 + 0.0
august_mg_abd_2016 = camp_august_abd_2016.pluck('margin').sum
august_margin_abd_2016 = august_mg_abd_2016 + 0.0
august_mg_actifs_abd_2016 = camp_august_actifs_abd_2016.pluck('margin').sum
camp_august_margin_actifs_abd_2016 = august_mg_actifs_abd_2016 + 0.0
august_ct_abd_2016 = camp_august_abd_2016.pluck('cost').sum
august_cost_abd_2016 = august_ct_abd_2016 + 0.0

@august_volume_abd_2016 = august_volume_abd_2016
@august_volume_actifs_abd_2016 = august_volume_actifs_abd_2016
@august_to_abd_2016 = august_turnover_abd_2016
@august_cost_abd_2016 = august_cost_abd_2016
@august_ecpm_actifs_abd_2016 = (camp_august_margin_actifs_abd_2016 / august_volume_actifs_abd_2016) * 1000
@august_ecpm_abd_2016 = (august_margin_abd_2016 / august_volume_abd_2016) * 1000
@august_margin_abd_2016 = august_margin_abd_2016


#august kpis Aki Você Acha
camp_august_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 08).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_august_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 08).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
august_o_ava_2016 = camp_august_ava_2016.pluck('unique_views').sum
august_opens_ava_2016 = august_o_ava_2016 + 0.0
august_c_ava_2016 = camp_august_ava_2016.pluck('clicker').sum
august_clicks_ava_2016 = august_c_ava_2016 + 0.0
august_v_ava_2016 = camp_august_ava_2016.pluck('sent').sum
august_volume_ava_2016 = august_v_ava_2016 + 0.0
august_v_actifs_ava_2016 = camp_august_actifs_ava_2016.pluck('sent').sum
august_volume_actifs_ava_2016 = august_v_actifs_ava_2016 + 0.0
august_to_ava_2016 = camp_august_ava_2016.pluck('turnover').sum
august_turnover_ava_2016 = august_to_ava_2016 + 0.0
august_mg_ava_2016 = camp_august_ava_2016.pluck('margin').sum
august_margin_ava_2016 = august_mg_ava_2016 + 0.0
august_mg_actifs_ava_2016 = camp_august_actifs_ava_2016.pluck('margin').sum
camp_august_margin_actifs_ava_2016 = august_mg_actifs_ava_2016 + 0.0
august_ct_ava_2016 = camp_august_ava_2016.pluck('cost').sum
august_cost_ava_2016 = august_ct_ava_2016 + 0.0

@august_volume_ava_2016 = august_volume_ava_2016
@august_volume_actifs_ava_2016 = august_volume_actifs_ava_2016
@august_to_ava_2016 = august_turnover_ava_2016
@august_cost_ava_2016 = august_cost_ava_2016
@august_ecpm_actifs_ava_2016 = (camp_august_margin_actifs_ava_2016 / august_volume_actifs_ava_2016) * 1000
@august_ecpm_ava_2016 = (august_margin_ava_2016 / august_volume_ava_2016) * 1000
@august_margin_ava_2016 = august_margin_ava_2016

#september kpis
camp_september_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 09).where('extract(year from scheduled_date) = ?', 2016)
camp_september_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 09).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
september_o_2016 = camp_september_2016.pluck('unique_views').sum
september_opens_2016 = september_o_2016 + 0.0
september_c_2016 = camp_september_2016.pluck('clicker').sum
september_clicks_2016 = september_c_2016 + 0.0
september_v_2016 = camp_september_2016.pluck('sent').sum
september_volume_2016 = september_v_2016 + 0.0
september_v_actifs_2016 = camp_september_actifs_2016.pluck('sent').sum
september_volume_actifs_2016 = september_v_actifs_2016 + 0.0
september_to_2016 = camp_september_2016.pluck('turnover').sum
september_turnover_2016 = september_to_2016 + 0.0
september_mg_2016 = camp_september_2016.pluck('margin').sum
september_margin_2016 = september_mg_2016 + 0.0
september_mg_actifs_2016 = camp_september_actifs_2016.pluck('margin').sum
camp_september_margin_actifs_2016 = september_mg_actifs_2016 + 0.0
september_ct_2016 = camp_september_2016.pluck('cost').sum
september_cost_2016 = september_ct_2016 + 0.0

@september_volume_2016 = september_volume_2016
@september_volume_actifs_2016 = september_volume_actifs_2016
@september_to_2016 = september_turnover_2016
@september_cost_2016 = september_cost_2016
@september_ecpm_actifs_2016 = (camp_september_margin_actifs_2016 / september_volume_actifs_2016) * 1000
@september_ecpm_2016 = (september_margin_2016 / september_volume_2016) * 1000
@september_margin_2016 = september_margin_2016

#september kpis A Boa do Dia
camp_september_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 09).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_september_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 09).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
september_o_abd_2016 = camp_september_abd_2016.pluck('unique_views').sum
september_opens_abd_2016 = september_o_abd_2016 + 0.0
september_c_abd_2016 = camp_september_abd_2016.pluck('clicker').sum
september_clicks_abd_2016 = september_c_abd_2016 + 0.0
september_v_abd_2016 = camp_september_abd_2016.pluck('sent').sum
september_volume_abd_2016 = september_v_abd_2016 + 0.0
september_v_actifs_abd_2016 = camp_september_actifs_abd_2016.pluck('sent').sum
september_volume_actifs_abd_2016 = september_v_actifs_abd_2016 + 0.0
september_to_abd_2016 = camp_september_abd_2016.pluck('turnover').sum
september_turnover_abd_2016 = september_to_abd_2016 + 0.0
september_mg_abd_2016 = camp_september_abd_2016.pluck('margin').sum
september_margin_abd_2016 = september_mg_abd_2016 + 0.0
september_mg_actifs_abd_2016 = camp_september_actifs_abd_2016.pluck('margin').sum
camp_september_margin_actifs_abd_2016 = september_mg_actifs_abd_2016 + 0.0
september_ct_abd_2016 = camp_september_abd_2016.pluck('cost').sum
september_cost_abd_2016 = september_ct_abd_2016 + 0.0

@september_volume_abd_2016 = september_volume_abd_2016
@september_volume_actifs_abd_2016 = september_volume_actifs_abd_2016
@september_to_abd_2016 = september_turnover_abd_2016
@september_cost_abd_2016 = september_cost_abd_2016
@september_ecpm_actifs_abd_2016 = (camp_september_margin_actifs_abd_2016 / september_volume_actifs_abd_2016) * 1000
@september_ecpm_abd_2016 = (september_margin_abd_2016 / september_volume_abd_2016) * 1000
@september_margin_abd_2016 = september_margin_abd_2016


#september kpis Aki Você Acha
camp_september_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 09).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_september_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 09).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
september_o_ava_2016 = camp_september_ava_2016.pluck('unique_views').sum
september_opens_ava_2016 = september_o_ava_2016+ 0.0
september_c_ava_2016 = camp_september_ava_2016.pluck('clicker').sum
september_clicks_ava_2016 = september_c_ava_2016 + 0.0
september_v_ava_2016 = camp_september_ava_2016.pluck('sent').sum
september_volume_ava_2016 = september_v_ava_2016 + 0.0
september_v_actifs_ava_2016 = camp_september_actifs_ava_2016.pluck('sent').sum
september_volume_actifs_ava_2016 = september_v_actifs_ava_2016 + 0.0
september_to_ava_2016 = camp_september_ava_2016.pluck('turnover').sum
september_turnover_ava_2016 = september_to_ava_2016 + 0.0
september_mg_ava_2016 = camp_september_ava_2016.pluck('margin').sum
september_margin_ava_2016 = september_mg_ava_2016 + 0.0
september_mg_actifs_ava_2016 = camp_september_actifs_ava_2016.pluck('margin').sum
camp_september_margin_actifs_ava_2016 = september_mg_actifs_ava_2016 + 0.0
september_ct_ava_2016 = camp_september_ava_2016.pluck('cost').sum
september_cost_ava_2016 = september_ct_ava_2016 + 0.0

@september_volume_ava_2016 = september_volume_ava_2016
@september_volume_actifs_ava_2016 = september_volume_actifs_ava_2016
@september_to_ava_2016 = september_turnover_ava_2016
@september_cost_ava_2016 = september_cost_ava_2016
@september_ecpm_actifs_ava_2016 = (camp_september_margin_actifs_ava_2016 / september_volume_actifs_ava_2016) * 1000
@september_ecpm_ava_2016 = (september_margin_ava_2016 / september_volume_ava_2016) * 1000
@september_margin_ava_2016 = september_margin_ava_2016

#october kpis
camp_october_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 10).where('extract(year from scheduled_date) = ?', 2016)
camp_october_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 10).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
october_o_2016 = camp_october_2016.pluck('unique_views').sum
october_opens_2016 = october_o_2016 + 0.0
october_c_2016 = camp_october_2016.pluck('clicker').sum
october_clicks_2016 = october_c_2016 + 0.0
october_v_2016 = camp_october_2016.pluck('sent').sum
october_volume_2016 = october_v_2016 + 0.0
october_v_actifs_2016 = camp_october_actifs_2016.pluck('sent').sum
october_volume_actifs_2016 = october_v_actifs_2016 + 0.0
october_to_2016 = camp_october_2016.pluck('turnover').sum
october_turnover_2016 = october_to_2016 + 0.0
october_mg_2016 = camp_october_2016.pluck('margin').sum
october_margin_2016 = october_mg_2016 + 0.0
october_mg_actifs_2016 = camp_october_actifs_2016.pluck('margin').sum
camp_october_margin_actifs_2016 = october_mg_actifs_2016 + 0.0
october_ct_2016 = camp_october_2016.pluck('cost').sum
october_cost_2016 = october_ct_2016 + 0.0

@october_volume_2016 = october_volume_2016
@october_volume_actifs_2016 = october_volume_actifs_2016
@october_to_2016 = october_turnover_2016
@october_cost_2016 = october_cost_2016
@october_ecpm_actifs_2016 = (camp_october_margin_actifs_2016 / october_volume_actifs_2016) * 1000
@october_ecpm_2016 = (october_margin_2016 / october_volume_2016) * 1000
@october_margin_2016 = october_margin_2016

#october kpis A Boa do Dia
camp_october_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 10).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_october_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 10).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
october_o_abd_2016 = camp_october_abd_2016.pluck('unique_views').sum
october_opens_abd_2016 = october_o_abd_2016 + 0.0
october_c_abd_2016 = camp_october_abd_2016.pluck('clicker').sum
october_clicks_abd_2016 = october_c_abd_2016 + 0.0
october_v_abd_2016 = camp_october_abd_2016.pluck('sent').sum
october_volume_abd_2016 = october_v_abd_2016 + 0.0
october_v_actifs_abd_2016 = camp_october_actifs_abd_2016.pluck('sent').sum
october_volume_actifs_abd_2016 = october_v_actifs_abd_2016 + 0.0
october_to_abd_2016 = camp_october_abd_2016.pluck('turnover').sum
october_turnover_abd_2016 = october_to_abd_2016 + 0.0
october_mg_abd_2016 = camp_october_abd_2016.pluck('margin').sum
october_margin_abd_2016 = october_mg_abd_2016 + 0.0
october_mg_actifs_abd_2016 = camp_october_actifs_abd_2016.pluck('margin').sum
camp_october_margin_actifs_abd_2016 = october_mg_actifs_abd_2016 + 0.0
october_ct_abd_2016 = camp_october_abd_2016.pluck('cost').sum
october_cost_abd_2016 = october_ct_abd_2016 + 0.0

@october_volume_abd_2016 = october_volume_abd_2016
@october_volume_actifs_abd_2016 = october_volume_actifs_abd_2016
@october_to_abd_2016 = october_turnover_abd_2016
@october_cost_abd_2016 = october_cost_abd_2016
@october_ecpm_actifs_abd_2016 = (camp_october_margin_actifs_abd_2016 / october_volume_actifs_abd_2016) * 1000
@october_ecpm_abd_2016 = (october_margin_abd_2016 / october_volume_abd_2016) * 1000
@october_margin_abd_2016 = october_margin_abd_2016


#october kpis Aki Você Acha
camp_october_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 10).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_october_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 10).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
october_o_ava_2016 = camp_october_ava_2016.pluck('unique_views').sum
october_opens_ava_2016 = october_o_ava_2016 + 0.0
october_c_ava_2016 = camp_october_ava_2016.pluck('clicker').sum
october_clicks_ava_2016 = october_c_ava_2016 + 0.0
october_v_ava_2016 = camp_october_ava_2016.pluck('sent').sum
october_volume_ava_2016 = october_v_ava_2016 + 0.0
october_v_actifs_ava_2016 = camp_october_actifs_ava_2016.pluck('sent').sum
october_volume_actifs_ava_2016 = october_v_actifs_ava_2016 + 0.0
october_to_ava_2016 = camp_october_ava_2016.pluck('turnover').sum
october_turnover_ava_2016 = october_to_ava_2016 + 0.0
october_mg_ava_2016 = camp_october_ava_2016.pluck('margin').sum
october_margin_ava_2016 = october_mg_ava_2016 + 0.0
october_mg_actifs_ava_2016 = camp_october_actifs_ava_2016.pluck('margin').sum
camp_october_margin_actifs_ava_2016 = october_mg_actifs_ava + 0.0
october_ct_ava_2016 = camp_october_ava_2016.pluck('cost').sum
october_cost_ava_2016 = october_ct_ava_2016 + 0.0

@october_volume_ava_2016 = october_volume_ava_2016
@october_volume_actifs_ava_2016 = october_volume_actifs_ava_2016
@october_to_ava_2016 = october_turnover_ava_2016
@october_cost_ava_2016 = october_cost_ava_2016
@october_ecpm_actifs_ava_2016 = (camp_october_margin_actifs_ava_2016 / october_volume_actifs_ava_2016) * 1000
@october_ecpm_ava_2016 = (october_margin_ava_2016 / october_volume_ava_2016) * 1000
@october_margin_ava_2016 = october_margin_ava_2016

#november kpis
camp_november_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 11).where('extract(year from scheduled_date) = ?', 2016)
camp_november_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 11).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
november_o_2016 = camp_november_2016.pluck('unique_views').sum
november_opens_2016 = november_o_2016 + 0.0
november_c_2016 = camp_november_2016.pluck('clicker').sum
november_clicks_2016 = november_c_2016 + 0.0
november_v_2016 = camp_november_2016.pluck('sent').sum
november_volume_2016 = november_v_2016 + 0.0
november_v_actifs_2016 = camp_november_actifs_2016.pluck('sent').sum
november_volume_actifs_2016 = november_v_actifs_2016 + 0.0
november_to_2016 = camp_november_2016.pluck('turnover').sum
november_turnover_2016 = november_to_2016 + 0.0
november_mg_2016 = camp_november_2016.pluck('margin').sum
november_margin_2016 = november_mg_2016 + 0.0
november_mg_actifs_2016 = camp_november_actifs_2016.pluck('margin').sum
camp_november_margin_actifs_2016 = november_mg_actifs_2016 + 0.0
november_ct_2016 = camp_november_2016.pluck('cost').sum
november_cost_2016 = november_ct_2016 + 0.0

@november_volume_2016 = november_volume_2016
@november_volume_actifs_2016 = november_volume_actifs_2016
@november_to_2016 = november_turnover_2016
@november_cost_2016 = november_cost_2016
@november_ecpm_actifs_2016 = (camp_november_margin_actifs_2016 / november_volume_actifs_2016) * 1000
@november_ecpm_2016 = (november_margin_2016 / november_volume_2016) * 1000
@november_margin_2016 = november_margin_2016

#november kpis A Boa do Dia
camp_november_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 11).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_november_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 11).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
november_o_abd_2016 = camp_november_abd_2016.pluck('unique_views').sum
november_opens_abd_2016 = november_o_abd_2016 + 0.0
november_c_abd_2016 = camp_november_abd_2016.pluck('clicker').sum
november_clicks_abd_2016 = november_c_abd_2016 + 0.0
november_v_abd_2016 = camp_november_abd_2016.pluck('sent').sum
november_volume_abd_2016 = november_v_abd_2016 + 0.0
november_v_actifs_abd_2016 = camp_november_actifs_abd_2016.pluck('sent').sum
november_volume_actifs_abd_2016 = november_v_actifs_abd_2016 + 0.0
november_to_abd_2016 = camp_november_abd_2016.pluck('turnover').sum
november_turnover_abd_2016 = november_to_abd_2016 + 0.0
november_mg_abd_2016 = camp_november_abd_2016.pluck('margin').sum
november_margin_abd_2016 = november_mg_abd_2016 + 0.0
november_mg_actifs_abd_2016 = camp_november_actifs_abd_2016.pluck('margin').sum
camp_november_margin_actifs_abd_2016 = november_mg_actifs_abd_2016 + 0.0
november_ct_abd_2016 = camp_november_abd_2016.pluck('cost').sum
november_cost_abd_2016 = november_ct_abd_2016 + 0.0

@november_volume_abd_2016 = november_volume_abd_2016
@november_volume_actifs_abd_2016 = november_volume_actifs_abd_2016
@november_to_abd_2016 = november_turnover_abd_2016
@november_cost_abd_2016 = november_cost_abd_2016
@november_ecpm_actifs_abd_2016 = (camp_november_margin_actifs_abd_2016 / november_volume_actifs_abd_2016) * 1000
@november_ecpm_abd_2016 = (november_margin_abd_2016 / november_volume_abd_2016) * 1000
@november_margin_abd_2016 = november_margin_abd_2016


#november kpis Aki Você Acha
camp_november_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 11).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_november_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 11).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
november_o_ava_2016 = camp_november_ava_2016.pluck('unique_views').sum
november_opens_ava_2016 = november_o_ava_2016 + 0.0
november_c_ava_2016 = camp_november_ava_2016.pluck('clicker').sum
november_clicks_ava_2016 = november_c_ava_2016 + 0.0
november_v_ava_2016 = camp_november_ava_2016.pluck('sent').sum
november_volume_ava_2016 = november_v_ava_2016 + 0.0
november_v_actifs_ava_2016 = camp_november_actifs_ava_2016.pluck('sent').sum
november_volume_actifs_ava_2016 = november_v_actifs_ava_2016 + 0.0
november_to_ava_2016 = camp_november_ava_2016.pluck('turnover').sum
november_turnover_ava_2016 = november_to_ava_2016 + 0.0
november_mg_ava_2016 = camp_november_ava_2016.pluck('margin').sum
november_margin_ava_2016 = november_mg_ava_2016 + 0.0
november_mg_actifs_ava_2016 = camp_november_actifs_ava_2016.pluck('margin').sum
camp_november_margin_actifs_ava_2016 = november_mg_actifs_ava_2016 + 0.0
november_ct_ava_2016 = camp_november_ava_2016.pluck('cost').sum
november_cost_ava_2016 = november_ct_ava_2016 + 0.0

@november_volume_ava_2016 = november_volume_ava_2016
@november_volume_actifs_ava_2016 = november_volume_actifs_ava_2016
@november_to_ava_2016 = november_turnover_ava_2016
@november_cost_ava_2016 = november_cost_ava_2016
@november_ecpm_actifs_ava_2016 = (camp_november_margin_actifs_ava_2016 / november_volume_actifs_ava_2016) * 1000
@november_ecpm_ava_2016 = (november_margin_ava_2016 / november_volume_ava_2016) * 1000
@november_margin_ava_2016 = november_margin_ava_2016

#december kpis
camp_december_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 12).where('extract(year from scheduled_date) = ?', 2016)
camp_december_actifs_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 12).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs")
december_o_2016 = camp_december_2016.pluck('unique_views').sum
december_opens_2016 = december_o_2016 + 0.0
december_c_2016 = camp_december_2016.pluck('clicker').sum
december_clicks_2016 = december_c_2016 + 0.0
december_v_2016 = camp_december_2016.pluck('sent').sum
december_volume_2016 = december_v_2016 + 0.0
december_v_actifs_2016 = camp_december_actifs_2016.pluck('sent').sum
december_volume_actifs_2016 = december_v_actifs_2016 + 0.0
december_to_2016 = camp_december_2016.pluck('turnover').sum
december_turnover_2016 = december_to_2016 + 0.0
december_mg_2016 = camp_december_2016.pluck('margin').sum
december_margin_2016 = december_mg_2016 + 0.0
december_mg_actifs_2016 = camp_december_actifs_2016.pluck('margin').sum
camp_december_margin_actifs_2016 = december_mg_actifs_2016 + 0.0
december_ct_2016 = camp_december_2016.pluck('cost').sum
december_cost_2016 = december_ct_2016 + 0.0

@december_volume_2016 = december_volume_2016
@december_volume_actifs_2016 = december_volume_actifs_2016
@december_to_2016 = december_turnover_2016
@december_cost_2016 = december_cost_2016
@december_ecpm_actifs_2016 = (camp_december_margin_actifs_2016 / december_volume_actifs_2016) * 1000
@december_ecpm_2016 = (december_margin_2016 / december_volume_2016) * 1000
@december_margin_2016 = december_margin_2016

#december kpis A Boa do Dia
camp_december_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 12).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "ABD")
camp_december_actifs_abd_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 12).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "ABD")
december_o_abd_2016 = camp_december_abd_2016.pluck('unique_views').sum
december_opens_abd_2016 = december_o_abd_2016 + 0.0
december_c_abd_2016 = camp_december_abd_2016.pluck('clicker').sum
december_clicks_abd_2016 = december_c_abd_2016 + 0.0
december_v_abd_2016 = camp_december_abd_2016.pluck('sent').sum
december_volume_abd_2016 = december_v_abd_2016 + 0.0
december_v_actifs_abd_2016 = camp_december_actifs_abd_2016.pluck('sent').sum
december_volume_actifs_abd_2016 = december_v_actifs_abd_2016 + 0.0
december_to_abd_2016 = camp_december_abd_2016.pluck('turnover').sum
december_turnover_abd_2016 = december_to_abd_2016 + 0.0
december_mg_abd_2016 = camp_december_abd_2016.pluck('margin').sum
december_margin_abd_2016 = december_mg_abd_2016 + 0.0
december_mg_actifs_abd_2016 = camp_december_actifs_abd_2016.pluck('margin').sum
camp_december_margin_actifs_abd_2016 = december_mg_actifs_abd_2016 + 0.0
december_ct_abd_2016 = camp_december_abd_2016.pluck('cost').sum
december_cost_abd_2016 = december_ct_abd_2016 + 0.0

@december_volume_abd_2016 = december_volume_abd_2016
@december_volume_actifs_abd_2016 = december_volume_actifs_abd_2016
@december_to_abd_2016 = december_turnover_abd_2016
@december_cost_abd_2016 = december_cost_abd_2016
@december_ecpm_actifs_abd_2016 = (camp_december_margin_actifs_abd_2016 / december_volume_actifs_abd_2016) * 1000
@december_ecpm_abd_2016 = (december_margin_abd_2016 / december_volume_abd_2016) * 1000
@december_margin_abd_2016 = december_margin_abd_2016


#december kpis Aki Você Acha
camp_december_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 12).where('extract(year from scheduled_date) = ?', 2016).where("db_campaigns.sender like ?", "AVA")
camp_december_actifs_ava_2016 = DbCampaign.where('extract(month from scheduled_date) = ?', 12).where('extract(year from scheduled_date) = ?', 2016).where(:segment_2016 => "Actifs").where("db_campaigns.sender like ?", "AVA")
december_o_ava_2016 = camp_december_ava_2016.pluck('unique_views').sum
december_opens_ava_2016 = december_o_ava_2016 + 0.0
december_c_ava_2016 = camp_december_ava_2016.pluck('clicker').sum
december_clicks_ava_2016 = december_c_ava_2016 + 0.0
december_v_ava_2016 = camp_december_ava_2016.pluck('sent').sum
december_volume_ava_2016 = december_v_ava_2016 + 0.0
december_v_actifs_ava_2016 = camp_december_actifs_ava_2016.pluck('sent').sum
december_volume_actifs_ava_2016 = december_v_actifs_ava_2016 + 0.0
december_to_ava_2016 = camp_december_ava_2016.pluck('turnover').sum
december_turnover_ava_2016 = december_to_ava_2016+ 0.0
december_mg_ava_2016 = camp_december_ava_2016.pluck('margin').sum
december_margin_ava_2016 = december_mg_ava_2016 + 0.0
december_mg_actifs_ava_2016 = camp_december_actifs_ava_2016.pluck('margin').sum
camp_december_margin_actifs_ava_2016 = december_mg_actifs_ava_2016 + 0.0
december_ct_ava_2016 = camp_december_ava_2016.pluck('cost').sum
december_cost_ava_2016 = december_ct_ava_2016 + 0.0

@december_volume_ava_2016 = december_volume_ava_2016
@december_volume_actifs_ava_2016 = december_volume_actifs_ava_2016
@december_to_ava_2016 = december_turnover_ava_2016
@december_cost_ava_2016 = december_cost_ava_2016
@december_ecpm_actifs_ava_2016 = (camp_december_margin_actifs_ava_2016 / december_volume_actifs_ava_2016) * 1000
@december_ecpm_ava_2016 = (december_margin_ava_2016 / december_volume_ava_2016) * 1000
@december_margin_ava_2016 = december_margin_ava_2016