# Making aggregation (SUM) on multi-array JSON

**URL:** <https://community.make.com/t/making-aggregation-sum-on-multi-array-json/75449>\
**Category:** Questions\
**Tags:** aggregators, get-map-function, arrays, mapping\
**Created:** [March 17, 2025, 5:30pm UTC](https://community.make.com/t/making-aggregation-sum-on-multi-array-json/75449 "2025-03-17T17:30:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Digitalni\_architekti](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@Digitalni\_architekti](https://community.make.com/u/Digitalni_architekti)\
**Post date:** [March 17, 2025, 5:30pm UTC](https://community.make.com/t/making-aggregation-sum-on-multi-array-json/75449/1 "2025-03-17T17:30:57Z")

</div>

Dear Community, could you please help me with aggregation in my scenario.

I am stuck with this input JSON, which in report, contains Array of campaigns statistics, which are then expanded in Arrray stats, where there are statistics per month.

I need to aggregate all data by month no matter the campaing to have an output table of the format:  
date - from report.stats.date  
impressions - sum aggregation of report.stats.impressions per all campagins  
conversions - sum aggregation of report.stats.conversions per all campagins  
etc.

from some reason i am not able to deal with the double array, through map functions or sums

Thank you so much for any help.

`[{ "statusMessage":"OK", "status":200, "report":[ { "endDate":null, "stats":[ { "date":202402, "conversions":0, "conversionValue":0, "totalMoney":10897, "clicks":26, "impressions":335 }, { "date":202403, "conversions":2, "conversionValue":184, "totalMoney":32886, "clicks":64, "impressions":876 }, { "date":202404, "conversions":2, "conversionValue":698, "totalMoney":22091, "clicks":46, "impressions":512 }, { "date":202405, "conversions":0, "conversionValue":0, "totalMoney":22439, "clicks":39, "impressions":359 }, { "date":202406, "conversions":1, "conversionValue":165, "totalMoney":18104, "clicks":37, "impressions":445 }, { "date":202407, "conversions":2, "conversionValue":418, "totalMoney":25875, "clicks":60, "impressions":635 }, { "date":202408, "conversions":5, "conversionValue":1012, "totalMoney":24797, "clicks":60, "impressions":635 }, { "date":202409, "conversions":6, "conversionValue":1999, "totalMoney":30724, "clicks":74, "impressions":650 }, { "date":202410, "conversions":0, "conversionValue":0, "totalMoney":27019, "clicks":72, "impressions":871 }, { "date":202411, "conversions":2, "conversionValue":343, "totalMoney":88326, "clicks":226, "impressions":2342 }, { "date":202412, "conversions":1, "conversionValue":400, "totalMoney":50007, "clicks":137, "impressions":1584 }, { "date":202501, "conversions":3, "conversionValue":489, "totalMoney":25291, "clicks":96, "impressions":1125 }, { "date":202502, "conversions":2, "conversionValue":971, "totalMoney":28698, "clicks":112, "impressions":1558 }, { "date":202503, "conversions":3, "conversionValue":1538, "totalMoney":19533, "clicks":58, "impressions":534 }], "id":4941061, "startDate":"20230630T00:00:00+0200" }, { "endDate":null, "stats":[{ "date":202402, "conversions":8, "conversionValue":2546, "totalMoney":184348, "clicks":690, "impressions":6924 }, { "date":202403, "conversions":27, "conversionValue":9120, "totalMoney":426155, "clicks":1482, "impressions":18262 }, { "date":202404, "conversions":18, "conversionValue":5411, "totalMoney":548498, "clicks":1182, "impressions":14557 }, { "date":202405, "conversions":27, "conversionValue":10008, "totalMoney":418106, "clicks":1122, "impressions":12982 }, { "date":202406, "conversions":21, "conversionValue":6922, "totalMoney":494788, "clicks":1276, "impressions":14464 }, { "date":202407, "conversions":15, "conversionValue":2881, "totalMoney":303874, "clicks":727, "impressions":8049 }], "id":4941062, "startDate":"20230713T00:00:00+0200" } ] } ]`

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [March 18, 2025, 7:53am UTC](https://community.make.com/t/making-aggregation-sum-on-multi-array-json/75449/2 "2025-03-18T07:53:20Z")

</div>

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of five modules:

 ![Screenshot_2025-03-18_150308](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/a/3aeb3b44f8ab270b39ef1d054d9a778cd420ffde.png)

This is just an example. Your final solution may or may not look like this depending on your requirements.

**Example Output:**

 ![Screenshot_2025-03-18_150301 (2)](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/2/226c34fdc07a16e9387635c9d8cde5ad12d0ba95.png)

[blueprint.json](https://community.make.com/uploads/short-url/xP1NbBqCB1L7KW4Y9gWDb2qJZIz.json) (6.9 KB)

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [June 16, 2025, 6:57am UTC](https://community.make.com/t/making-aggregation-sum-on-multi-array-json/75449/3 "2025-06-16T06:57:37Z")

</div>