Sum of Numeric Aggregator Outputs for multiple Operations

[stoesselleon]

Hello Together,

I was looking to aggregate some values of my operations so i in the end can write them into a single google sheet cell, without having to have a get + update module for every single line. This would end up in over 1000 api calls to google sheets and the seems not very perfomant.

This is my current State. I get Objects from Google Ads Campaign and want to basically have the sum of a all clicks on keyword level.

As you can see in this Screenshot, my Numeric Aggregator works fine for each operation and comes up with an sum of all single bundles.

My Goal is to get this result outputs of the 24 Operations together into one single value.

I tried to chain another numeric aggregator, but wasn’t successful.

Best regards,
Leon

[ManishMandot]

Hello @stoesselleon
welcome to the make community!

Could you please provide us with the blueprint of the scenario? It will help us solve the problem in the right way.

[stoesselleon]

Yes, of course! @Manish_GrowwStacks
Marketing AI.json (132.4 KB)
Here is a blueprint of this scenario.

[samliew]

This looks similar to what this user was trying to do: Filtering an array based on multiple conditions, without iterator and filter? - #5 by make.beginner

Iterate - filter - aggregate for each set of data, OR you can run some JavaScript custom code to do it all in a single operation.

You gotta show us the rest of the scenario to see where the 24 bundles are coming from. Try to reduce that to a single bundle (array) first.

[stoesselleon]

Hi @samliew
Yeah thats pretty much what i want to do. The Full Scenario Exported can be found in my first response to Manish.

Can you point me out on how to get my bundles into one single array? Is there a module for that cause?

Best regards!

[samliew]

The scenario export does not show where the 24 bundles are coming from.

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

[stoesselleon]

@samliew

Great Input! I came to the conclusion, that i will need to strip down my modules to always operate with 1 bundle / operations.

In order to do that i will need to get more profound working with arrays. For example i have this array of collections.

How would I now get to have an array of campaign ids avaialable in the next module.

I have experimented around with the map() function combined with the toArray() function but I either end up with an array of object Objects or just on single campaign id.

[samliew]

That’s what the built-in function map does.

e.g.:

{{ map(array; campaign.id) }}

For more information, see

Links

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← DON’T SKIP THIS!
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks