Google Ads Report - I can't see all the output bundles

[TFLS]

Hi! Make Community.

I tried to connect Google ads to get an automatic refresh of a Google sheet.

This is the entire scenario:

After I connected to the Google Ads account, I targeted the date range of my interest.

These are all the output bundles I got after I ran the scenario:

I’ve tried the array aggregator, selecting the metrics of my interest.

The results are all the metrics.

But here is the problem. I want to sum the values, for example, of all the conversions, but the array shows just one bundle with limited data, so I can’t use it to send the completed data.

I’m new to the automation industry, so I don’t know if that’s a trivial problem. If anyone could give me some advice I would be very grateful. Even for the scenario flow, if there is another way to set it, it would be great. Thanks again.

[kanito]

Hi,

Try adding a Router after the Array Aggregator and then adding as many Numeric Aggregators as many Google Ads Campaign metrics you need to SUM.

See Google Ads Campaign Reports

Best,
Riccardo

[Msquare_Automation]

Hi @TFLS

Array aggregator always shows only first bundle of output.

However, you do not need array aggregator here when you are using numeric aggregator. Remove array aggregator and map the desired value in numeric aggregator directly.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation