I would like to retrieve all headlines and descriptions for specific Ad.
I have used this query
SELECT
ad_group_ad.ad.name, ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2, ad_group_ad.labels, ad_group_ad.status,
ad_group.name,
campaign.name, ad_group_ad.ad.app_ad.headlines, ad_group_ad.ad.local_ad.headlines, ad_group_ad.ad.responsive_display_ad.headlines, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.smart_campaign_ad.headlines, ad_group_ad.ad.video_responsive_ad.headlines, ad_group_ad.ad.video_responsive_ad.long_headlines, ad_group_ad.ad.app_ad.descriptions, campaign.primary_status, ad_group_ad.ad.call_ad.phone_number, ad_group_ad.ad.final_urls, ad_group_ad.ad.call_ad.headline1, ad_group_ad.ad.call_ad.headline2, ad_group_ad.ad.type, ad_group_ad.ad.expanded_dynamic_search_ad.description, ad_group_ad.ad.expanded_dynamic_search_ad.description2, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.expanded_text_ad.headline_part1, ad_group_ad.ad.expanded_text_ad.headline_part2, ad_group_ad.ad.expanded_text_ad.headline_part3, ad_group_ad.ad.expanded_text_ad.path1, ad_group_ad.ad.expanded_text_ad.path2, ad_group_ad.ad.app_engagement_ad.headlines, ad_group_ad.ad.app_pre_registration_ad.headlines, ad_group_ad.ad.discovery_multi_asset_ad.headlines, ad_group_ad.ad.discovery_video_responsive_ad.headlines, ad_group_ad.ad.discovery_video_responsive_ad.long_headlines FROM ad_group_ad WHERE ad_group_ad.status NOT IN ('REMOVED')
but headlines and description list are empty. On UI i can see for that specific AD all headlines and descriptions etc. What can i do to retrieve those infromation as they are on UI. Of course i would like to retrieve display path, final url and other fields which are on UI.