Implement a script for working with the meta ads API

Bot Development, Python — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Develop a script that will automatically export data about advertising campaigns from Meta Ads (Facebook Ads) to Google Sheets using the META ADS API. The script should collect key metrics (CTR, CPA, CPC, CPM, Spend) with the ability to set a time interval and regularly update the data.

2. Functional Requirements

Data Retrieval from Meta Ads:
- Connecting to the Meta Ads advertising account via API.
- Exporting the following metrics:
  - CTR (Click-Through Rate)
  - CPA (Cost Per Action)
  - CPC (Cost Per Click)
  - CPM (Cost Per Mille)
  - Spend (expenses)
- The ability to specify a time range (e.g., the last 7 days or specific dates).
- Support for data levels:
  - Campaign
  - Ad Set
  - Ad.
- Data filtering:
  - By campaign name (e.g., campaigns with a specific word).
  - By campaign status (active/pause).
Writing Data to Google Sheets:
- Connecting to Google Sheets via API.
- Creating a new file or using an existing one.
- Writing data in tabular form:
  - The first row — metric headers.
  - The remaining rows — data on campaigns.
- Clearing the table before each new entry (optional).
Automation:
- Setting up a schedule for script execution (daily, weekly).

Proposals 6 Withdrawn 1 Discussions 3

Olksandr Kazarov

3 1

Projects 3
Rating -
Rating 449

Budget: 5600 UAH Deadline: 5 days

Good day!

I am ready to develop a script for automatic data export from Meta Ads to Google Sheets, taking into account all your requirements.

Script functionality:
Data retrieval from Meta Ads:

Connecting to the advertising account via the Meta Ads API.
Collecting key metrics:
CTR (Click-Through Rate),
CPA (Cost Per Action),
CPC (Cost Per Click),
CPM (Cost Per Mille),
Spend (expenses).
Setting the time range for data export (e.g., the last 7 days or a specific interval).
Data levels:
Campaign,
Ad Set,
Ad.
Data filtering:

By campaign names (e.g., including keywords).
By campaign status (active/paused).
Writing data to Google Sheets:

Connecting to Google Sheets via API.
Creating a new document or using an existing one.
Data formatting:
First row - metric headers.
Remaining rows - campaign data.
Option to clear the sheet before new entry.
Automation:

Setting up a schedule for script execution via Cron or other task schedulers (daily/weekly).
Technologies for implementation:
Python:
facebook_business library for working with the Meta Ads API.
gspread or google-api-python-client library for working with Google Sheets.
Automation:
Using Cron (on Linux) or Task Scheduler (on Windows) to run the script.
Why me?
Experience with the Meta Ads API and integration with Google Sheets.
Understanding of digital marketing tasks and key metrics.
Implementation of a secure and scalable solution.
I am ready to discuss details, timelines, and your additional wishes.

I look forward to collaborating!

Mykhailo Pavlov

60 0

Budget: 25000 UAH Deadline: 12 days

Good afternoon. I am ready to complete the task.
I have experience in implementing similar projects.
I write in Python and hold 2nd place on the platform.

I will develop a script for automatic data export about advertising campaigns
from Meta Ads to Google Sheets. The script will collect key metrics. You will be able to set the time interval and control the frequency of data updates.
I will create a user-friendly interface and optimize it.

My portfolio: Freelancehunt
Write to me, we will discuss the details and I will get started on the work.