Once you have confirmed an account sync between Google Ads and Google Analytics, and are using auto tagging for URLs, the Search Queries report will become a valuable data mining tool. This report is found within Google Analytics but is specific to the Google CPC traffic generated through Google Ads.
In Google Analytics, the Content Drilldown report rolls all of your pages up into the sub-directory which they belong and provides statistics on those specific sub-directories.
Data Studio from Google is an awesome data visualization tool. With its ever growing list of features there may be a few that have flown under your radar. One of those features is creating your own formulas which is what I am going to expand on.