To analyze adds and create a recommendation based on the analysis.
The objective of this project is to analyze historical Facebook ad performance data for a local dental clinic to determine the mathematical "winning formula" for maximum audience engagement. By transitioning from vanity metrics (raw reach) to calculated engagement rates, this project provides actionable, data-driven copywriting and visual strategies to optimize future ad spend.
This analysis was conducted using Python as the primary analytical tool, leveraging industry-standard data science libraries to process and evaluate the dataset:
- Data Ingestion: The raw dataset was extracted dynamically from a live cloud database using the Google Sheets API via the
gspreadlibrary. - Data Processing & Feature Engineering: Using the Pandas library, the data was cleaned (handling missing values and string-to-numeric conversions). To standardize ad performance regardless of budget or total impressions, a new target metric—Engagement Rate (%) (calculated as [Engagement ÷ Reach] × 100)—was engineered.
- Statistical Analysis: Exploratory Data Analysis (EDA) was applied to the dataset. Specifically, Categorical Aggregation and Central Tendency Analysis (Mean) were utilized via Pandas'
groupbyfunction. This allowed us to calculate and rank the average Engagement Rate across various independent categorical variables (Topic Type, Facial Expressions, CTA, and Hooks). - Data Visualization: Seaborn and Matplotlib were utilized to generate comparative bar plots, translating the categorical mean calculations into clear visual hierarchies to identify high-performing psychological and marketing patterns.
By cross-referencing visual elements, topics, and copywriting text, a clear psychological pattern emerged about what dental patients actually interact with online.
- The Doctor hurts engagement: Ads without the doctor present received nearly double the engagement of ads featuring the doctor.
- Perfect smiles are ignored: When human faces are used, "Smiling" was the worst-performing expression. Audiences actively ignored generic stock photos. Instead, faces showing "In Pain or Concerned" performed exceptionally well because they trigger empathy and relatability.
- Text over faces: The absolute highest engagement came from posts with no human faces at all. These were highly visual, text-based graphics (like polls or quizzes).
- Interactive over Informative: While clinical professionals often prefer sharing "Informative" facts, this was the lowest-performing topic. Audiences scroll past posts that feel like a textbook.
- The Winners: The top-performing topics were "Interactive" (asking the audience to participate) and "Employee Spotlight" (humanizing the staff, building behind-the-scenes trust).
- The Hook: The "Four U's" (Urgent, Unique, Useful, Ultra-specific) was the undisputed champion for starting a caption, severely beating the traditional "FAB" (Features, Advantages, Benefits) sales pitch.
- The CTA (Call to Action): Passive CTAs like "Read Caption," "Visit Us," or leaving it blank killed engagement. The #1 CTA was "Type Something", which perfectly aligns with our finding that "Interactive" posts perform best.
Based on the integrated data, the clinic should use the following blueprint for its next marketing campaigns to guarantee higher engagement and lower cost-per-click:
Recommendation 1: Run Text-Based Interactive Ads Since "Interactive" topics, "No Faces", and "Type Something" CTAs all ranked #1, combine them.
- Execution: Post a simple graphic. Ask a question like, "Which of these 3 teeth whitening myths do you think is actually true?"
- Caption: Start with a 4 U's Hook: "Want brighter teeth for the weekend? Don't fall for these internet trends." End the caption with the #1 CTA: "Type your guess (1, 2, or 3) in the comments below!"
Recommendation 2: The "Problem/Solution" Patient Ad Since "In Pain/Concerned" faces perform best, lean into the PAS (Problem, Agitate, Solution) copywriting framework.
- Execution: Use a relatable photo of an everyday person holding their jaw in pain (no perfect smiles).
- Caption: "Sudden toothache keeping you awake? (Problem). Ignoring it can lead to expensive root canals (Agitate). Come See Us Today for emergency pain relief (Solution/Winning CTA)."
Recommendation 3: Build Trust with Staff, Not the Doctor Since ads without the doctor perform better, but people still want a human connection, pivot to the Employee Spotlight topic.
- Execution: Post candid photos of the hygienists or front desk staff. People are often intimidated by the Dentist; showing friendly, relatable support staff breaks down that barrier and builds local community trust.