Overview

Scoop connects directly to Meta Ads (Facebook and Instagram) to extract campaign performance data. Combine your ad spend, impressions, and conversions with data from other sources like Google Analytics, your CRM, or sales data for comprehensive marketing analysis.

AI-Assisted Setup

When connecting Meta Ads to Scoop, you can choose "Guide me with AI" for an intelligent, guided setup experience. Scoop offers pre-configured analysis templates that automatically select the right report type and fields for common use cases.

Available Analysis Templates

Example Questions You Can Answer

Campaign Performance:

• "What's our total ad spend this month by campaign?"
• "Which campaigns have the best click-through rates?"
• "How has our reach trended over the past quarter?"
• "What's our average CPM across campaigns?"

Ad Set Performance:

• "Which ad sets are delivering the best CPC?"
• "How do different targeting strategies compare?"
• "Which audiences are most engaged with our ads?"

Creative Performance:

• "Which ad creatives have the highest CTR?"
• "What's the cost per click for each ad?"
• "Which ads should we pause based on performance?"

Cost Efficiency:

• "Are we experiencing audience fatigue (high frequency)?"
• "What's our cost per person reached?"
• "Which campaigns give us the best bang for our buck?"

Link Clicks & Traffic:

• "What's our true cost per website visit?"
• "Which ads drive the most link clicks?"
• "How does link click CTR compare to overall CTR?"

Video Performance:

• "What percentage of viewers watch our videos to completion?"
• "Where do viewers drop off in our video ads?"
• "Which video creatives are most engaging?"

Understanding Meta Ads Data Structure

Meta Ads data is organized hierarchically:

• Ad Account → Contains all your advertising data
  • Campaigns → Top-level objectives (awareness, traffic, conversions)
    • Ad Sets → Targeting, placement, budget, schedule
      • Ads → The actual creative users see

Ad Insights is the primary object for performance analysis. It provides metrics (impressions, clicks, spend) aggregated daily across the hierarchy.

Tip: All insight templates include date_start for time-series analysis. You can ask questions like "show me weekly trends" or "compare this month to last month" with any template.

What You Can Extract

Available Fields

Campaign Fields

• Campaign ID, Name, Status
• Objective (awareness, conversions, etc.)
• Budget (daily/lifetime)
• Start/Stop times

Ad Set Fields

• Ad Set ID, Name, Status
• Optimization goal
• Bid strategy and amount
• Daily/lifetime budget

Ad Fields

• Ad ID, Name, Status
• Associated Campaign and Ad Set
• Created/Updated timestamps

Insights Metrics

Connecting to Meta Ads

Step 1: Start the Connection

1. Go to Datasets and click New Dataset
2. Select Application Report
3. Choose Meta Ads from the connector list

Step 2: Authorize with Meta

1. Click Connect to open Meta's authorization page
2. Log in to your Facebook account
3. Select the ad accounts you want Scoop to access
4. Click Allow to grant permissions

Step 3: Select Your Ad Account

After authorization, you'll see a list of your ad accounts. Select the account containing the data you want to analyze.

Step 4: Choose Report Type

Select what type of data to extract:

• Campaigns: Campaign-level data and settings
• Ad Sets: Ad set configuration and targeting
• Ads: Individual ad details
• Ad Insights: Performance metrics (most common choice)

Step 5: Select Fields

Choose which metrics and dimensions to include. For Ad Insights, common selections include:

• Date range dimensions (date_start, date_stop)
• Performance metrics (impressions, clicks, spend)
• Cost metrics (cpc, cpm, ctr)
• Conversion metrics (if configured in Meta)

Step 6: Set Date Range

Specify the time period for your data extraction. Meta stores historical data, so you can pull several months of performance data.

Step 7: Schedule and Finish

1. Name your dataset (e.g., "Meta Ads - Daily Performance")
2. Set a refresh schedule (daily is common for ad data)
3. Click Create to start the initial extraction

Best Practices

Combine with Other Marketing Data

Meta Ads data becomes more powerful when combined with:

• Google Analytics: See the full customer journey
• CRM data: Track leads to closed deals
• Revenue data: Calculate true ROAS

Track Performance Over Time

Set up daily syncs to build a historical record. Scoop's snapshot feature lets you track changes over time:

• Campaign budget changes
• Performance trends
• Seasonal patterns

Use Insights for Analysis

The Ad Insights report type is best for most analysis needs. It provides:

• Daily performance metrics
• Aggregated data across your selected dimensions
• The metrics you need for ROI calculations

Common Use Cases

Marketing ROI Analysis

Combine Meta spend with sales data to calculate true return on ad spend:

"Show me cost per acquisition by campaign for last quarter"

Campaign Comparison

Compare performance across campaigns:

"Compare CTR and CPC across all active campaigns"

Budget Optimization

Identify high-performing ad sets:

"Which ad sets have the lowest CPA this month?"

Creative Testing

Analyze ad creative performance:

"Compare conversion rates between video and image ads"

Troubleshooting

No Ad Accounts Appear

Cause: Your Facebook account may not have access to any ad accounts.

Solution:

• Log into business.facebook.com
• Go to Business Settings → Ad Accounts
• Ensure you're assigned to at least one ad account

Authorization Fails

Cause: Meta requires specific permissions.

Solution: Make sure you click "Allow" on all permission requests during the OAuth flow.

Data Not Updating

Cause: Meta's API has rate limits.

Solution: If you're extracting large amounts of data, Scoop automatically handles rate limits. Wait a few minutes and check again.

Related Resources

• Google Ads Integration - Combine with Google advertising
• Google Analytics Integration - Add website behavior data
• Blending Datasets - Combine Meta data with other sources

Troubleshooting

Ad Account Permissions

If you see "Account not found":

• Ensure your Ad Account ID includes the act_ prefix (e.g., act_1234567890).
• Verify your Facebook user has "Admin" or "Advertiser" access to the ad account.

Token Expiry

Meta security tokens expire every 60 days.

• Symptom: Data stops syncing.
• Fix: Go to Data Sources, find Meta, and click Reconnect to refresh your token.

Rate Limits

• Error 17: "Account Rate Limit". You are querying too much data too fast. Wait 10 minutes.