db={"campaigns":[{"_id":{"$oid":"601d1e571d7f511667c292e0"},"url":"localhost:4200/","source":"Google 01.04.21","medium":"New Site","campaign":"Crown","website_id":1,"created_at":{"$date":"2021-02-05T10:30:47.606Z"},"updated_at":{"$date":"2021-02-05T10:30:47.606Z"},"__v":0,"visitor_id":"601cfd2fdb0f680d23ed8ed8"},{"_id":{"$oid":"5ff3b758c4bb1570b41a7d6e"},"url":"dentistnearme.affordabledentalnearme.com/tooth-crown-south-miami","source":"Google 01.04.21","medium":"New Site","campaign":"Crown","created_at":{"$date":"2021-01-05T00:48:24.808Z"},"updated_at":{"$date":"2021-01-05T00:48:24.808Z"},"__v":0,"website_id":1,"visitor_id":"5ff3b758c4bb1570b41a7d6d"},{"_id":{"$oid":"5ff47c94c4bb1570b41a7f9a"},"url":"dentistnearme.affordabledentalnearme.com/tooth-crown-south-miami","source":"Google 01.04.21","medium":"New Site","campaign":"Crown","created_at":{"$date":"2021-01-05T14:49:56.911Z"},"updated_at":{"$date":"2021-01-05T14:49:56.911Z"},"__v":0,"website_id":1,"visitor_id":"5ff47c94c4bb1570b41a7f99"}],"visitors":[{"_id":{"$oid":"601cec937c47cf078d2bcf64"},"uid":"00da3e75-3a1a-4bfe-b572-bd4930bba9fb","deviceInfo":{"device":"desktop","platform":"Mac OS X 10.15.7","browser":"Chrome 88.0.4324","useragent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.146 Safari/537.36","isRobot":false},"isOnline":0,"created_at":{"$date":"2021-02-05T06:58:27.283Z"},"updated_at":{"$date":"2021-02-05T08:09:06.392Z"},"__v":0,"currentPage":"Home Page","currentSection":"2-Banner","ip":"103.93.199.14","location":{"ip":"103.93.199.14","version":"IPv4","city":"Pune","region":"Maharashtra","region_code":"MH","country":"IN","country_name":"India","country_code":"IN","country_code_iso3":"IND","country_capital":"New Delhi","country_tld":".in","continent_code":"AS","in_eu":false,"postal":"411038","latitude":18.5196,"longitude":73.8554,"timezone":"Asia/Kolkata","utc_offset":"+0530","country_calling_code":"+91","currency":"INR","currency_name":"Rupee","languages":"en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc","country_area":3287590,"country_population":1352617328,"asn":"AS136355","org":"Suntech Sanchar Private Limited"}},{"_id":{"$oid":"601cfd2fdb0f680d23ed8ed8"},"uid":"af275c2a-321e-4470-bfbd-8e0cc9f2ab58","deviceInfo":{"device":"desktop","platform":"Mac OS X 10.15.7","browser":"Chrome 88.0.4324","useragent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.146 Safari/537.36","isRobot":false},"ip":"103.93.199.14","isOnline":0,"created_at":{"$date":"2021-02-05T08:09:19.980Z"},"updated_at":{"$date":"2021-02-05T11:03:07.344Z"},"__v":0,"location":{"ip":"103.93.199.14","version":"IPv4","city":"Pune","region":"Maharashtra","region_code":"MH","country":"IN","country_name":"India","country_code":"IN","country_code_iso3":"IND","country_capital":"New Delhi","country_tld":".in","continent_code":"AS","in_eu":false,"postal":"411038","latitude":18.5196,"longitude":73.8554,"timezone":"Asia/Kolkata","utc_offset":"+0530","country_calling_code":"+91","currency":"INR","currency_name":"Rupee","languages":"en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc","country_area":3287590,"country_population":1352617328,"asn":"AS136355","org":"Suntech Sanchar Private Limited"},"currentPage":"Home Page","currentSection":"6-Honor"},{"_id":{"$oid":"5fd7864ccdf28014a803109c"},"uid":"384f7c48-4f8c-4229-b457-67982d2a6b9b","deviceInfo":{"device":"desktop","platform":"Windows 10.0.0","browser":"Chrome 87.0.4280","useragent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36","isRobot":false},"ip":"174.48.143.196","isOnline":0,"created_at":{"$date":"2020-12-14T15:35:40.367Z"},"updated_at":{"$date":"2020-12-28T15:08:07.524Z"},"__v":0,"currentPage":"Home Page","currentSection":"1-TitleStrip","location":{"ip":"174.48.143.196","version":"IPv4","city":"Miami","region":"Florida","region_code":"FL","country":"US","country_name":"United States","country_code":"US","country_code_iso3":"USA","country_capital":"Washington","country_tld":".us","continent_code":"NA","in_eu":false,"postal":"33162","latitude":25.9289,"longitude":-80.1827,"timezone":"America/New_York","utc_offset":"-0500","country_calling_code":"+1","currency":"USD","currency_name":"Dollar","languages":"en-US,es-US,haw,fr","country_area":9629091,"country_population":327167434,"asn":"AS7922","org":"COMCAST-7922"}}]}

db.campaigns.aggregate([{$match:{website_id:1,$or:[{source:{$regex:"goo",$options:"i"}},{medium:{$regex:"goo",$options:"i"}},{campaign:{$regex:"goo",$options:"i"}}]}},{$addFields:{visitor_id:{$toObjectId:"$visitor_id"}}},{$lookup:{from:"visitors",localField:"visitor_id",foreignField:"_id",as:"visitors"}},{$unwind:{path:"$visitors"}},{$group:{_id:{source:"$source",medium:"$medium",campaign:"$campaign",postal:"$visitors.location.postal"},city:{$first:"$visitors.location.city"},count:{$sum:1}}},{$group:{_id:{source:"$_id.source",medium:"$_id.medium",campaign:"$_id.campaign"},visitors:{$push:{city:"$city",postal:"$_id.postal",count:"$count"}}}}])