[{"_id":ObjectId("61e3b88d3f14fb87161651c7"),"campaign_id":955,"creative_id":1342,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":1},{"_id":ObjectId("61e3b8cd3f14fb87161651ef"),"campaign_id":955,"creative_id":1343,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":7070,"clicks":241},{"_id":ObjectId("61e3b8cd3f14fb87161651f2"),"campaign_id":955,"creative_id":1344,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":3474,"clicks":52},{"_id":ObjectId("61e3b8cd3f14fb87161651f4"),"campaign_id":955,"creative_id":1346,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":3595,"clicks":52},{"_id":ObjectId("61e3b8cd3f14fb87161651f6"),"campaign_id":955,"creative_id":1345,"date":ISODate("2022-01-16T00:00:00Z"),"__v":0,"views":3561,"clicks":227},{"_id":ObjectId("61e4b18a3f14fb871616d8b0"),"campaign_id":955,"creative_id":1343,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":9528,"clicks":104},{"_id":ObjectId("61e4b18a3f14fb871616d8b2"),"campaign_id":955,"creative_id":1345,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":4699,"clicks":100},{"_id":ObjectId("61e4b18a3f14fb871616d8b5"),"campaign_id":955,"creative_id":1346,"date":ISODate("2022-01-17T00:00:00Z"),"__v":0,"views":4759,"clicks":36},{"_id":ObjectId("61e4b18e3f14fb871616d8ca"),"campaign_id":955,"creative_id":1344,"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:{$addToSet:"$creative_id"},}},])