I am trying to replicate the Ad Tab in Google Adwords, programmatically by querying the AD_PERFORMANCE_REPORT. I want to segment it by Campaign, Ad Group, Ad, Keyword which I know I can do by adding KeywordId into the ad_performance_report. However where can I query for a list of all the keywords and if they are a broad/exact match. Is there a better way then using the CRITERION_REPORT (which doesn't have ad) or using the KEYWORD_PERFORMANCE_REPORT which I would then have distinct, just to get the mapping?
Simply put, what is the best way to get the attribute data for keywordId?
Thanks!
P.S. I have searched the forum, and I saw this question was asked with no answer 4 years ago: