Building a simple Facebook insights report 7 days vs. 7 days + % difference

:bullseye: What is your goal?

I want to pull 2x data from a client’s Meta account (spend, purchases, cpa, roas, revenue) from last 7 days, compared to the 7 days before that (plus a parentheses with the % difference between the 2 weeks).

:thinking: What is the problem?

templates and communities are offering solutions that are only complicating my workflow even more (for someone who doesn’t know JSON, https etc.).

How do I actually pull data from arrays so I can start doing % calculations later in the flow (or other stuff)?
Currently, I only succeeded in pulling the data in my gmail module with a lot of tokens and coding (and that doesn’t seem optimal).

:test_tube: What have you tried so far?

I tried different Tool Set/Get variable, Iterator, Aggregator - searching community and tutorials but none of them address extracting array data from data the way it is set up in facebook insights

1 Like