[{"_id":ObjectId("61e3b88d3f14fb87161651c7"),"campaign_id":41,"creative_id":143,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":1},{"_id":ObjectId("61e3b8cd3f14fb87161651ef"),"campaign_id":41,"creative_id":143,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":7070,"clicks":241},{"_id":ObjectId("61e3b8cd3f14fb87161651f2"),"campaign_id":41,"creative_id":144,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":3474,"clicks":52},{"_id":ObjectId("61e3b8cd3f14fb87161651f4"),"campaign_id":41,"creative_id":146,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":3595,"clicks":52},{"_id":ObjectId("61e3b8cd3f14fb87161651f6"),"campaign_id":41,"creative_id":145,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":3561,"clicks":227},{"_id":ObjectId("61e4b18a3f14fb871616d8b0"),"campaign_id":41,"creative_id":143,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":9528,"clicks":104},{"_id":ObjectId("61e4b18a3f14fb871616d8b2"),"campaign_id":41,"creative_id":145,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":4699,"clicks":100},{"_id":ObjectId("61e4b18a3f14fb871616d8b5"),"campaign_id":41,"creative_id":146,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":4759,"clicks":36},{"_id":ObjectId("61e4b18e3f14fb871616d8ca"),"campaign_id":41,"creative_id":144,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":4822,"clicks":27}]

db.collection.aggregate([{"$sort":{"date":1}},{"$group":{"_id":{date:"$date",campaign:"$campaign_id",creative_id:"$creative_id"},views:{$sum:"$views"},clicks:{$sum:"$clicks"}}},{"$group":{"_id":{date:"$_id.date",campaign:"$_id.campaign"},data:{$push:{k:{"$toString":"$_id.creative_id"},v:{views:"$views",clicks:"$clicks"}}}}},{$project:{_id:1,creative:{"$arrayToObject":"$data"}}}])