Facebook Insights Automation

Beginner Questions
1

:bullseye: What is your goal?

Hi everyone,

I’m working as a performance marketer and I want to automate weekly reporting from Facebook Ads using Make.

My goal is to:
– Pull campaign performance data (CTR, CPC, CPM, Spend, Leads)
– Send it to Google Sheets
– Use it as a simple reporting dashboard
– Run this automation once per week (every Friday)

:thinking: What is the problem?

I’ve already worked with Make for Facebook Lead Ads → Telegram automation, and I faced a big issue with credits consumption.

The system was checking data every 15 minutes and consuming a lot of credits even when there were no new leads.

Now I’m trying to build a reporting system using Facebook Insights, but I want to avoid the same problem.

My concerns:
– How to minimize credit usage when pulling Insights data
– Best way to structure scenario (Google Sheets + Insights)
– Whether using Add a Row is the right approach for weekly reporting
– How to avoid unnecessary operations

:test_tube: What have you tried so far?

– Created a scenario: Facebook Insights → Google Sheets (Add a Row)
– Planning to run it manually or once per week
– Limiting metrics to: CTR, CPC, CPM, Spend, Leads
– Avoiding frequent triggers (no 15-minute schedule)

:link: Create public scenario page

4

Hey there,

You can change the scenario scheduling to run only once a week at a designated time. Then you can also use the bulk action to add all the rows in the same call instead of adding them one by one.