db={"collection":[{"principalCredits":[{"category":{"id":"director","text":"Directors"},"totalCredits":2,"credits":[{"name":{"id":"nm11813828","nameText":{"text":"Pippa Ehrlich"},"awardNominations":{"total":2,"edges":[{"node":{"id":"an1393007","isWinner":true,"award":{"id":"an1393007","year":2020,"text":"Green Warsaw Award","event":{"id":"ev0003786","text":"Millennium Docs Against Gravity"},"category":{"text":null}}}},{"node":{"id":"an1428940","isWinner":false,"award":{"id":"an1428940","year":2021,"text":"IDA Award","event":{"id":"ev0000351","text":"International Documentary Association"},"category":{"text":"Best Writing"}}}},]}},"category":{"id":"director","text":"Director"}},{"name":{"id":"nm1624755","nameText":{"text":"James Reed"},"awardNominations":{"total":3,"edges":[{"node":{"id":"an0694012","isWinner":true,"award":{"id":"an0694012","year":2015,"text":"Best of Festival","event":{"id":"ev0001486","text":"Jackson Wild Media Awards"},"category":{"text":"Best of Festival"}}}},{"node":{"id":"an0975779","isWinner":true,"award":{"id":"an0975779","year":2017,"text":"RTS West Television Award","event":{"id":"ev0000571","text":"Royal Television Society, UK"},"category":{"text":"Documentary"}}}},{"node":{"id":"an0975781","isWinner":true,"award":{"id":"an0975781","year":2015,"text":"Grand Teton Prize","event":{"id":"ev0001356","text":"Jackson Hole Film Festival"},"category":{"text":"Best in Festival"}}}}]}},"category":{"id":"director","text":"Director"}}]},{"category":{"id":"writer","text":"Writers"},"totalCredits":2,"credits":[{"name":{"id":"nm11813828","nameText":{"text":"Pippa Ehrlich"},"awardNominations":{"total":2,"edges":[{"node":{"id":"an1393007","isWinner":true,"award":{"id":"an1393007","year":2020,"text":"Green Warsaw Award","event":{"id":"ev0003786","text":"Millennium Docs Against Gravity"},"category":{"text":null}}}},{"node":{"id":"an1428940","isWinner":false,"award":{"id":"an1428940","year":2021,"text":"IDA Award","event":{"id":"ev0000351","text":"International Documentary Association"},"category":{"text":"Best Writing"}}}}]}},"category":{"id":"writer","text":"Writer"},},{"name":{"id":"nm1624755","nameText":{"text":"James Reed"},"awardNominations":{"total":0,"edges":[]}},"category":{"id":"writer","text":"Writer"},}]}]}],"eventsCollection":[{id:"ev0003786",importance:1},{id:"ev0000351",importance:2},{id:"ev0001486",importance:3},{id:"ev0000571",importance:4},{id:"ev0001356",importance:5},{id:"ev0003786",importance:6},{id:"ev0000351",importance:7},]}

db.collection.aggregate([{$addFields:{allEvents:{$reduce:{input:{$map:{input:"$principalCredits",in:{$map:{input:"$$this.credits",as:"credit",in:{$map:{input:"$$credit.name.awardNominations.edges",as:"edge",in:"$$edge.node.award.event.id"}}}}}},initialValue:[],in:{"$concatArrays":[{"$reduce":{input:"$$this",initialValue:[],in:{"$concatArrays":["$$this","$$value"]}}},"$$value"]}}}}},{"$lookup":{"from":"eventsCollection","localField":"allEvents","foreignField":"id","as":"matchingEvents"}},{$addFields:{principalCredits:{$map:{input:"$principalCredits",in:{$mergeObjects:["$$this",{credits:{$map:{input:"$$this.credits",as:"credit",in:{$mergeObjects:["$$credit",{name:{"$mergeObjects":["$$credit.name",{"awardNominations":{"$mergeObjects":["$$credit.name.awardNominations",{edges:{$map:{input:"$$credit.name.awardNominations.edges",as:"edge",in:{node:{$mergeObjects:["$$edge.node",{score:{"$multiply":[{$cond:["$$edge.node.isWinner",1.5,1.2]},{$first:{$map:{input:{$filter:{input:"$matchingEvents",as:"matchedEvent",cond:{$eq:["$$matchedEvent.id","$$edge.node.award.event.id"]}}},as:"matched",in:"$$matched.importance"}}}]}}]}}}}}]}}]}}]}}}}]}}}}},{$unset:["allEvents","matchingEvents"]}])