PROBLEM
STATEMENT
Our client was a marketing agency that handled Facebook campaigns for a number of companies. In order to continuously gauge how their campaigns were performing, they had to repeatedly look up various Facebook ad accounts under different business managers. This was a tedious task where most of the time was spent going back and forth. They wanted a singular dashboard where they can display all their data in one place and visualize it to extract business insights.
SOLUTION
This application integrated Facebook Ads API into client’s existing system saving ads reporting metrics e.g., spending, impressions, clicks, views, CTR, ROAS etc. into their SQL DB. This was done at the three different levels i.e., campaign, ad set and ad level along with filtering based on custom date/time ranges. This allowed our client to look up the reports of all their ad accounts in one place increasing their productivity and helping them make the right tweaks to their ads on the fly!
Input
Facebook Business Manager Access
Output
Ad reports’ data stored in SQL DB
Tools &
Technologies
Python (Requests)
MySQL
