
Hi Jackson,
Thanks for reaching out. With regards to your concern about getting campaign type, you can use the AdvertisingChannelType field in the Campaign Performance Report. Please find the below query.
SELECT CampaignId,AdvertisingChannelType FROM CAMPAIGN_PERFORMANCE_REPORT
Let me know if you have any questions.
Thanks,
Nirmita Patel Google Ads Team