Multivariable Matching in Google Sheets - scanning for multiple values simultaneously and posting shared data

Question

I have two sheets from two different sources (Facebook Ads and Google Ads) and I want to match their data onto a third sheet. The data itself is different, but the identifiers are the same - campaign name, adset name, ad name, & date. Both sheets also have other data such as purchases & pageview data. The reason I'm doing this is because Facebook and Google report numbers differently, and I would like to compare their reporting.

Essentially, I want to scan through a row on my Facebook datasheet and grab the three names and one date. I then want to scan through every row in my Google datasheet until I find a row with the exact match for the three names & date. I then want to grab these three names, the date, the pageview data from FB, the pageview data from Google, and post this data onto a row in a third separate "comparison" sheet.

I tried VLOOKUP, but VLOOKUP forces you to pick one value as the key value. This won't work for me because I need multiple values to match across two different sheets. So I was wondering how to go about doing this.