Campaings that have the same name appear many times

[hernesto vallegas]

Hello, in google ads api i'm executing a query to select my campaings but a specific campaign appears 3 times (they have the same name, but differents ids and status), i want those 3 to appear only one but time with their stats added. But i dont know how to do it

SELECT
campaign.id,
campaign.name,
campaign.status,
campaign.start_date,
campaign.end_date, 
metrics.clicks,
metrics.ctr,
metrics.impressions

FROM campaign

WHERE segments.date >= "'2023-01-01" AND segments.date <= "'2023-01-19'" 

using this image of google ads interface as reference, in yellow are how they appear in the query results, but i want it to appear only one time with the stats in red

Trying to add 'campaign.status != "REMOVED"' to the query only remove two of them, but it dont group them.

[Google Ads API Forum Advisor]

Hi Hernesto,

Thank you for reaching out to us.

For our team to further investigate and provide an appropriate recommendation to you, could you please provide us with the following information below:

• Complete API logs (request and response with request-id ) generated on your end
• Entire UI screenshot without cropping

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2iO85f:ref