report_by_campaign.rb

module V2
  class ReportByCampaign < BaseReport
    report 'campaign' do
      attach_to DailyEventAd, as: 'ads' do
        # We are using columns for resolving dynamic columns on rows
        columns COLUMNS

        # Fields Mapping is linking columns fields and row fields
        mapping AD_FIELDS

        filter promoted_app_id: ->(report) { { '$in' => report.app_ids } },
          campaign_id: ->(report) { { '$exists' => true, '$ne' => nil } }

        group_by :campaign_id

        column :campaign_name, :impressions_received, :installs_received,
          :clicks_received, :conv_rate, :clicks_thru_rate
      end
    end

    report 'day' do
      attach_to DailyEventAd, as: 'ads' do
        # We are using columns for resolving dynamic columns on rows
        columns COLUMNS

        # Fields Mapping is linking columns fields and row fields
        mapping AD_FIELDS

        filter promoted_app_id: ->(report) { { '$in' => report.app_ids } },
          campaign_id: ->(report) { { '$exists' => true, '$ne' => nil } }

        group_by :day, :campaign_id

        column :day, :impressions_received, :installs_received,
          :clicks_received, :conv_rate, :clicks_thru_rate
      end
    end
  end
end