- AI Efficiency Hubb
- Posts
- Turn Your Facebook Ads Data into Smart Strategy With ChatGPT
Turn Your Facebook Ads Data into Smart Strategy With ChatGPT
You’ve seen the TikTok, now here’s the full step-by-step to actually do it. Grab your ad data, plug it into ChatGPT with this killer prompt, and walk away with insights that actually help you make better decisions. No analyst required.

Hey,
Saw something in my TikTok that caught your eye? Here’s the full breakdown so you can actually use it.
🔗 Missed the video? Watch it here
What You’ll Need
Access to your Facebook Ads Manager
At least 30 days' worth of data (90–180 days is even better)
A paid ChatGPT account (Plus or Pro)
This prompt (copy and paste it into ChatGPT)
Optional: a brew and 30 minutes to really dig in
Step-by-Step Instructions
Step 1: Grab Your Facebook Ads Data
Log in to Facebook Ads Manager and head to the Reports section.
Create a custom report using metrics like:
Impressions
Clicks
Click-through rate (CTR)
Cost per click (CPC)
Conversions
ROAS
Choose a time range (aim for 90–180 days if you’ve got it).
Run and export the report as a CSV or Excel file.
Make sure it includes campaign names, ad sets, and ad names – this helps ChatGPT make smarter suggestions.
Step 2: Put ChatGPT to Work
Open ChatGPT and start a new chat.
Upload your exported Facebook ad data file.
Paste in this prompt:
“You’re a seasoned Facebook Ads expert with a proven track record of optimising campaigns across a wide range of sectors. I’ll be sharing my ad performance data with you, and I’d like your professional evaluation and guidance. Please follow the structure below:
1. Data Summary
Give a brief overview of the core metrics provided — impressions, clicks, click-through rate (CTR), cost per click (CPC), conversions, conversion rate, and return on ad spend (ROAS).
2. Performance Breakdown
Identify which campaigns, ad sets, and individual ads are delivering the strongest results based on ROAS and conversion rate.
Highlight any noticeable trends or recurring patterns.
Call out anything unusual or unexpected in the data.
3. Audience Analysis
Review how different audience segments are performing (demographics, interests, behaviours).
Point out which groups are engaging well and which are underperforming.
4. Creative Review
Assess the results across various ad formats — static images, videos, carousels, etc.
Look for shared elements among the top performers.
Offer ideas for improving or reworking creatives that are not hitting the mark.
5. Optimisation Suggestions
Provide clear, actionable steps to improve campaign effectiveness.
Recommend how to adjust budget allocation based on what’s working.
Suggest any tweaks to bidding strategies or optimisation events.
6. Scaling Potential
Identify any campaigns or ad sets that could be scaled up profitably.
Share ideas for scaling without compromising efficiency or ROI.
7. Testing Recommendations
Propose 3 to 5 A/B test ideas grounded in the data to help boost performance.
8. Industry Context
If available, compare current performance to industry standards and note where improvements could be made.
9. Strategic Direction
Using your analysis, outline a focused 30-day plan to drive better results across the account.
Please keep your recommendations structured and easy to digest — bullet points are perfect where it makes sense.”
ChatGPT will start analysing your data. Look out for:
Which ads are smashing it
What’s dragging things down
Suggestions to fix or scale campaigns
🧠 Pro tip: Treat it like an actual conversation. Ask follow-up questions, challenge the suggestions, or ask it to dig deeper into specific areas.
Step 3: Use Facebook’s Built-In AI Tools
Set up Automated Rules in Ads Manager:
Pause ads if cost per result goes too high
Increase budget on top-performing ad sets
You can mix and match conditions for more control.
If you’ve got a product catalogue, test out Dynamic Ads to let Facebook automatically show the right products to the right people.
Step 4: Use AI for Ad Creation & Ideation
Use ChatGPT to whip up new copy ideas fast.
Use ChatGPT 4o NEW image generation to spark creative directions.
Combine human edits with AI suggestions to keep things on-brand.
Step 5: Use Reviews for Pain-Point Copy
Gather reviews (yours and competitors')
Paste into ChatGPT and ask it to:
Summarise key pain points
Write ad copy targeting those pain points
Give you headline and call-to-action options
Final Step
That’s it, you’re done. Gold star if you made it all the way here ⭐
If it worked, amazing. If you’ve hit a wall, give it five minutes and read through again – half the time it’s just something you’ve overlooked.
P.S. Want to do this more strategically?
If you’re figuring out how AI fits into your business long-term, we run something called the AI Efficiency Assessment. It’s a 90-minute session that gives you a tailored roadmap of what to automate, what to eliminate, so you’re crystal clear on what to do.
No pressure, just here if you’re ready to level things up.
👉 Learn more about the AI Efficiency Assessment
