[{"_id":ObjectId("5f98aeadbaf1ea001affe4c0"),"name":"Temp","campaigntype":3,"startdate":ISODate("2021-01-01T00:00:00.000Z"),"enddate":ISODate("2021-01-01T00:00:00.000Z"),"affiliatetag":"","promotedtitles":[{"primaryisbn":"9781453238431","promoprice":"1.99","countries":["US","CA","AU","GB"],"retailers":["ALL"],"dlp":"17.99","notes1":"History","notes2":"","sequence":1},{"primaryisbn":"9781504063562","promoprice":"1.99","countries":["US","CA"],"retailers":["ALL"],"dlp":"11.99","notes1":"Thrillers","notes2":"","sequence":2},{"primaryisbn":"9781497673984","promoprice":"0.99","countries":["US","CA"],"retailers":["ALL"],"dlp":"6.99","notes1":"Romantic Suspense","notes2":"","sequence":3},{"primaryisbn":"9780547526959","promoprice":"1.99","countries":["CA"],"retailers":["All"],"dlp":"17.99","notes1":"History","notes2":"","sequence":4},{"primaryisbn":"9781453274248","promoprice":"1.99","countries":["US"],"retailers":["All"],"dlp":"9.99","notes1":"Historical Fiction","notes2":"","sequence":5}],"active":true,"createdby":ObjectId("5d2e2755d3851f0012108a05")}]

db.collection.aggregate([{"$unwind":"$promotedtitles"},{"$match":{"promotedtitles.countries":{"$in":["US"]}}},{"$project":{"result":"$promotedtitles.primaryisbn"}},{"$group":{"_id":null,"isbns":{"$push":"$result"}}},{"$project":{"_id":0}}])