We have migrated from the Google Adwords API to the Google Ads API and we found that we fewer ads than before in the ad_performance_report table.
After doing more investigation we found that we don't have any ads that CONTENT, YOUTUBE_SEARCH OR YOUTUBE_WATCH. We only have ads that are SEARCH and SEARCH_PARTNERS.
We used Stitch to help with the ingestion of this data into Redshift, both with the Adwords API and Google Ads API.
I would like to know if we are supposed to have all ad network types in the ad_performance_report table or if we need to get the rest of the data somewhere else. If not, can you tells us what could be the issue and what information you need please?