Meta Ads

Connect your Meta (Facebook & Instagram) ad accounts to Formula Bot and analyze spend, impressions, clicks, conversions, and ROAS with natural language.

Connect your Meta ad accounts to analyze Facebook & Instagram ad spend, performance, and conversions with natural language.

Prerequisites

  • A Meta ad account with campaign data
  • Access to the ad account through your Facebook account (or the Business Portfolio that owns it)

Setup Steps

1. Start the Connection

  1. Go to Connectors in the sidebar
  2. Click Add Connector
  3. Select Meta Ads

2. Authenticate with Facebook

  1. Click Connect with Facebook
  2. Sign in to your Facebook account
  3. Choose the Businesses you want to share
  4. Review the permissions and click Save

Formula Bot requests read-only access to your ads data. It never creates, edits, or pauses campaigns.

3. Select Your Ad Accounts

  1. Choose the ad accounts you want to analyze
  2. Click Save

4. Verify Connection

The connector status should show green. You can now use it in chats.

What Data is Available

Formula Bot can access all standard Meta Ads Insights fields:

Metrics

  • Spend, Impressions, Clicks
  • CTR, CPC, CPM
  • Reach, Frequency
  • Conversions (purchases, leads, and other actions)
  • Purchase value and ROAS

Levels & Breakdowns

  • Account, Campaign, Ad Set, and Ad level reporting
  • Daily, weekly, or monthly time series
  • Breakdowns by age, gender, country, region, device, and placement (Facebook vs Instagram)

Example Questions

Spend & Performance

  • "How much did we spend on Meta ads last month?"
  • "Show daily spend for the last 30 days"
  • "What's our average CPM and CTR by campaign?"

Campaign Analysis

  • "Which campaigns have the best ROAS?"
  • "Top 10 campaigns by spend this quarter"
  • "Compare this month vs last month by campaign"

Audience & Placement

  • "Break down performance by age and gender"
  • "Which countries convert best?"
  • "Facebook vs Instagram placement performance"

Conversions

  • "How many purchases did each campaign drive?"
  • "What's our cost per lead by ad set?"
  • "Show return on ad spend for the last 90 days"

Troubleshooting

Connection Failed

  • Ensure your Facebook account has access to the ad account
  • If the ad account belongs to a Business Portfolio, make sure you shared that Business during login
  • Try disconnecting and reconnecting

No Data Showing

  • Verify the date range includes periods with ad delivery
  • Check that the selected ad account is the one with campaigns
  • Broaden the query (remove filters or breakdowns) to confirm data exists

Token Expired

Meta access tokens last about 60 days and renew automatically while the connector is in use. If the connection expires:

  1. Go to Connectors
  2. Find the Meta Ads connector
  3. Click Reconnect

Best Practices

Date Ranges

Specify clear date ranges for accurate results:

  • "Last 30 days" instead of "recently"
  • "Q2 2026" instead of "last quarter"

Currency

Spend and revenue are reported in the ad account's currency.

Compare Periods

Formula Bot can compare time periods:

  • "Compare this month's spend to last month"
  • "Year over year ROAS comparison"

Next Steps