When migrating this query from Adwords API "SELECT Criteria, CampaignId, Cost from GENDER_PERFORMANCE_REPORT" I have this query "SELECT ad_group_criterion.gender.type,
campaign.id, metrics.cost_micros FROM gender_view"
When executing both, I find out that for the Google Ads API, I'm having multiple lines for the same campaign.
Is there a way to change the Google Ads API query in order to have the sum of all costs by campaign for a specific gender?