Dynamically set date ranges in Facebook Insights to export cumulative data day-by-day

How To
1

Hi everyone :waving_hand:

I’ve built a scenario (see image below) that successfully exports campaign data from Meta into Monday.com subitems.

image
image1554×306 31.9 KB

Workflow overview:

  1. Monday.com → Lists items containing Campaign, Ad Set, or Ad IDs.

  2. Iterator → Loops through each ID.

  3. Set Variable → Defines which ID to use for Facebook Insights.

  4. Facebook Insights → Fetches campaign data.

  5. Set Multiple Variables → Formats the output for Monday.

  6. Monday.com → Creates subitems with the exported results.

Everything works fine, but here’s my challenge:

Goal
I want to export performance data in cumulative daily intervals.

  • Example: Campaign runs from Jan 1 – Jan 31.

  • I want 31 exports where:

    • Export 1 → Jan 1 → Jan 1

    • Export 2 → Jan 1 → Jan 2

    • Export 3 → Jan 1 → Jan 3

    • …and so on until Jan 1 → Jan 31.

This lets me analyze how results evolve over time (e.g., when performance shifts happen).

Context
I have an Ad Database in Monday where each ad has a start date and end date.
When I press an “Export” button, it triggers this Make scenario via webhook, passing those dates.

What I’m struggling with is:
How can I dynamically loop through each day between the start and end date, adjusting the Facebook Insights “time range” (or “date preset”) so that each iteration exports one cumulative range?

Any advice on how to set this up efficiently (without 30+ manual date modules) would be greatly appreciated! :folded_hands:

3

Hey Tobias,

the scenario will run daily I assume?

You can use the {{now}} tag to get today’s date and then use setDate() on it to change the day to the 1st of the month. So check for items between setDate({{now}};1) and {{now}} should give you the time slots you need.

4

It will only run when I click on a button column to activate a webhook from monday.com to make.com.

  1. I put in the timeline range from where I want it to start pulling data.
  2. I press on the webhook button.
  3. The make.com module will map the from date and the end date. It will start exporting Facebook data from day 1 to day 2, day 1 to dat 3 and so on until it reaches the end date. I do understand it will loop for example 30 times.
5

Ok so you want it to go from the first till today’s date?

Add a repeater then and set it to start from 1 and go until formatDate({{now}};D). Then you can have the start date be 1 and the end date be the value of the repeater.

So the first go will be 1 till 1, the second 1 till 2 and so on until 1 till today’s date.

1 Like
6

Almost!

image
image1008×280 22.7 KB

As shown in this image, the idea is that I have the campaign in the item with its respective campaign ID.

The end goal is that I put the timeline “Eksport tidslinje”. I can then press the button “Powermarketing” to send a webhook.

The output from the timeline will look like this:

Bundle 1Collection
ID timerange_mkwz9ttg
Value {“to”:“2025-10-11”,“from”:“2025-10-09”,“changed_at”:“2025-10-22T17:31:28.130Z”}

Parsed ValueCollection
To 2025-10-11
From 2025-10-09
Changed at October 22, 2025 7:31 PM

I tried trying your suggestion, but I might have to figure out how this repeater actually works:

image
image617×302 25.5 KB

So this is so far how I have gotten:

image
image1690×220 45.5 KB

7

Select the function from the menu instead, right now that’s a text string.

8

Thank you so much @Stoyan_Vatov!
I have marked your previous reply as the solution.

For anyone else reading this post, the image below is the final and working solution:

image
image587×312 24.4 KB

The Facebook Insight Module had the following values:

image
image405×415 17.9 KB