I’m building a scenario that compares metrics for yesterdays Meta campaigns to the previous 14 days. This is my flow:
Module 4: Gets campaign ID’s and then filters by those that are live.
Module 14: Routes to either the 14 day or yesterday analysis
Module 15: Pulls yesterdays metrics
Module 16: Sets yesterdays metrics as variables
Module 21: Gets the variables from module 16.
Module 7: Pulls last 14 day average data from Meta
Module 12: Sets the variables from last 14 days and also yesterdays as follows:
The issue I believe I am facing (with my limited knowledge) is that Meta can only search and return data for 1 campaign ID at a time, so the scenario runs through 7 times for each campaign collecting the metrics.
Therefore the output of the final module (12) where we set all variables, ends up having 7 operations.
I believe I want to be able to have the data in an array, so that I can print a metrics table for each campaign in an email. Baring in mind that the number of campaigns might change so I cant set a hard value.
I’ve messed around with array aggregators and iterators etc but just cannot find a solution, I feel like it’s going to be something simple. I believe what I need to try and do is maybe delay the final step so it happens in one go once all 7 campaigns data is ready so that it can output the data as an array.
Any help would be greatly appreciated.