mongo query

query.json

db.tracker_lead.aggregate([
    {
        $group: {
            _id: {
                year: {
                    $year: "$created_at"
                },
                month: {
                    $month: "$created_at"
                },
                day: {
                    $dayOfMonth: "$created_at"
                },
                flow_id: "$flow.id",
                site_id: "$flow.site.id",
                offer_kind_id: "$flow.offer_kind.id",
                sub1: "$sub1",
                sub2: "$sub2",
                advertiser_id: "$advertiser_id"
            },
            click_count: {
                $sum: 0
            },
            conversion_count: {
                $sum: 1
            },
            approved_conversion_count: {
                $cond: {
                    if: {
                        $eq: ["$status", "confirm"]
                    },
                    then: 1,
                    else: 0
                }
            }
        }
    },
    {
        $limit: 100
    }
])