Meta Ads - Concierca AI

What it is

Paid-social performance from Meta (Facebook/Instagram). One row per ad per day, keyed to the campaign / ad set / ad it came from, with the spend and delivery metrics for that day — impressions, clicks, conversions — and the derived efficiency ratios CTR and CPC. It is the daily grain you use to track ad spend and see which campaigns are working.

How it gets data

Populated by marketing agents and connectors (e.g. the Meta Ads connector); not part of the standard onboarding catalog. Each row carries an external_id dedup key, so re-syncing the same ad-day updates the row instead of duplicating it. Available to query once your workspace runs the relevant agents.

Fields

Field	Type	Description
`external_id`	text	Source id for the ad-day — the dedup/upsert key
`campaign`	text	Campaign name
`adset`	text	Ad set name
`ad_name`	text	Ad name
`spend`	currency	Amount spent on this ad on `date`
`impressions`	integer	Impressions delivered
`clicks`	integer	Clicks received
`conversions`	integer	Conversions attributed
`ctr`	number	Click-through rate
`cpc`	number	Cost per click
`date`	date	The day these metrics cover
`status`	text	Ad status (e.g. active, paused)

Also carries the system columns id, tenant_id, workspace_id (tenant isolation), created_at, and updated_at. They are managed automatically.

Query it

{
  "method": "tools/call",
  "params": {
    "name": "data_query",
    "arguments": {
      "view_slug": "meta_ads",
      "filters": { "status": "active" },
      "select_fields": ["campaign", "ad_name", "spend", "impressions", "clicks", "conversions", "date"],
      "sort_by": "date",
      "limit": 50
    }
  }
}

⌘I