Meta Ads connector: datasets and metric definitionsBeta
Bring in Facebook and Instagram campaign, ad set and ad performance, plus video hook and hold rate, reach and frequency, creative, and age, gender and placement breakdowns. Updates daily.
When you connect Meta Ads, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.
DatasetsMetric definitionsWorks withQuestionsFAQ
Datasets
| Dataset | What it holds |
|---|---|
| [Meta Ads] Campaigns | Campaigns12 columnscampaign_id, campaign_name, campaign_status, objective, buying_type, daily_budget, lifetime_budget, start_date, end_date, currency, account_id, account_name |
| [Meta Ads] Campaign performance | Meta campaign totals per day in the ad account time zone. clicks = link clicks; conversions and conversion_value = purchases; leads separate. Reach is not included because it cannot be added across days.17 columnsdate, campaign_id, campaign_name, platform, objective, account_name, impressions, thousand_impressions, clicks, all_clicks, cost, conversions, conversion_value, leads, video_3s_plays, thruplays, currency |
| [Meta Ads] Ad set performance | Ad set performance14 columnsdate, campaign_id, campaign_name, ad_set_id, ad_set_name, impressions, clicks, cost, conversions, conversion_value, leads, video_3s_plays, thruplays, currency |
| [Meta Ads] Ad performance | Top 2,000 ads per month by spend; smaller ads are left out, so totals here can be below [Meta Ads] Campaign performance.17 columnsmonth, campaign_name, ad_set_name, ad_id, ad_name, creative_name, thumbnail_url, impressions, reach, clicks, cost, conversions, conversion_value, leads, video_3s_plays, thruplays, currency |
| [Meta Ads] Reach and frequency | Per campaign per calendar month. Reach is distinct people in that month, so it cannot be added across months or campaigns; frequency = impressions / reach for the row.13 columnsmonth, campaign_id, campaign_name, objective, impressions, thousand_impressions, reach, frequency, clicks, cost, video_3s_plays, thruplays, currency |
| [Meta Ads] Age and gender | Campaign totals per month split by age bucket and gender, the breakdowns Meta reports. Conversions and conversion_value = purchases.11 columnsmonth, campaign_id, campaign_name, age, gender, impressions, clicks, cost, conversions, conversion_value, currency |
| [Meta Ads] Placements | Campaign totals per month split by platform (Facebook, Instagram, Audience Network, Messenger) and placement (feed, stories, reels...). Conversions and conversion_value = purchases.11 columnsmonth, campaign_id, campaign_name, platform, placement, impressions, clicks, cost, conversions, conversion_value, currency |
Metric definitions
Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.
[Meta Ads] Campaign performance
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Meta Ads spend | Sum of cost | date | Meta Ads spend in the ad account currency, by day. |
| Meta Ads impressions | Sum of impressions | date | Times Meta showed an ad (Facebook, Instagram, Messenger, Audience Network). |
| Meta Ads clicks | Sum of clicks | date | Link clicks on Meta ads. |
| Meta Ads conversions | Sum of conversions | date | Purchases as Meta counts them (the ad account's attribution setting). |
| Meta Ads conversion value | Sum of conversion_value | date | Purchase value in the ad account currency. |
| Meta Ads leads | Sum of leads | date | Leads as Meta counts them. |
| Meta Ads ROAS | Meta Ads conversion value ÷ Meta Ads spend | date | Purchase value per unit of spend (2.5 = 2.50 back for 1.00 spent). |
| Meta Ads CPC | Meta Ads spend ÷ Meta Ads clicks | date | Average cost per link click. |
| Meta Ads CTR | Meta Ads clicks ÷ Meta Ads impressions | date | Link clicks per impression, as a decimal (0.01 = 1%). |
| Meta Ads CPA | Meta Ads spend ÷ Meta Ads conversions | date | Average cost per purchase. |
| Meta Ads 3-second plays | Sum of video_3s_plays | date | Times a video ad played for at least 3 seconds (Meta "video plays", the action type video_view). |
| Meta Ads ThruPlays | Sum of thruplays | date | Times a video ad played to 15 seconds, or to the end if shorter. |
| Meta Ads thousand impressions | Sum of thousand_impressions | date | Helper: impressions divided by 1,000, the denominator of CPM. |
| Meta Ads hook rate | Meta Ads 3-second plays ÷ Meta Ads impressions | date | 3-second plays per impression, as a decimal (0.30 = 30%): how often the first seconds stop the scroll. Video ads only. |
| Meta Ads hold rate | Meta Ads ThruPlays ÷ Meta Ads 3-second plays | date | ThruPlays per 3-second play, as a decimal (0.25 = 25%): how many people who started a video kept watching. Video ads only. |
| Meta Ads CPM | Meta Ads spend ÷ Meta Ads thousand impressions | date | Cost per 1,000 impressions. |
| Meta Ads cost per ThruPlay | Meta Ads spend ÷ Meta Ads ThruPlays | date | Spend per ThruPlay. Video ads only. |
[Meta Ads] Reach and frequency
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Meta Ads monthly impressions | Sum of impressions | month | Impressions by campaign and month, next to reach. |
| Meta Ads monthly reach | Sum of reach | month | Distinct people reached in the month, by campaign. Not additive: do not add it across months or campaigns. |
| Meta Ads monthly frequency | Meta Ads monthly impressions ÷ Meta Ads monthly reach | month | Average times each reached person saw the ads in the month. Only right for one campaign and one month at a time. |
Works with other connectors
These metrics are added automatically when Meta Ads and the other connector are both connected. The rules they follow are on the connectors page.
| Metric | How it is calculated | Needs | Notes |
|---|---|---|---|
| Meta Ads nCAC | Meta Ads spend ÷ New customers | Shopify + Meta Ads | Meta Ads spend per new customer: Meta Ads spend divided by New customers in the same period. |
| Meta Ads aMER | New customer net sales ÷ Meta Ads spend | Shopify + Meta Ads | First-order net sales per Meta Ads dollar: New customer net sales divided by Meta Ads spend in the same period. |
| Blended nCAC | (Meta Ads spend + Google Ads spend) ÷ New customers | Shopify + Meta Ads + Google Ads | Meta Ads and Google Ads spend per new customer. |
| Blended aMER | New customer net sales ÷ (Meta Ads spend + Google Ads spend) | Shopify + Meta Ads + Google Ads | First-order net sales per paid ad dollar across Meta Ads and Google Ads. |
| Blended MER | Net sales ÷ (Meta Ads spend + Google Ads spend) | Shopify + Meta Ads + Google Ads | Marketing efficiency ratio: Shopify net sales per paid ad dollar across Meta Ads and Google Ads, in the same period. Net sales are Shopify's own, not what the platforms report. |
- Shopify + Meta Ads: New-customer cost and return on Meta. Meta Ads nCAC and aMER are added for you: Meta spend against Shopify’s new customers and their first-order net sales.
- Shopify + Meta Ads + Google Ads: Blended MER across ad platforms. With Meta and Google both connected, Blended nCAC, aMER and MER divide Shopify’s figures by the combined spend.
- Meta Ads + Google Ads: Meta against Google. ROAS by platform on the same basis, because the metric names line up across ad platforms. Read the guide.
- HubSpot + Google Ads + Meta Ads: Pipeline per ad dollar. HubSpot closed-won revenue against ad spend by month, as your own cross-source metric. Define it as your own metric.
Questions to ask
- How much did we spend on Meta Ads each month this year?
- Which Meta campaigns had the best ROAS last month?
- Which ad sets had the lowest cost per purchase in the last 30 days?
- Which Meta ads spent the most last month, and what did they return?
- What are the hook rate and hold rate of our video ads by campaign?
- What is the reach and frequency of each Meta campaign last month?
- How do age and gender groups compare on cost per purchase?
- Which placements (Feed, Stories, Reels) give the best ROAS?
Related guides
- Paid Media Reporting: ROAS, CPA and CPC on One Definition
- Meta Ads AI: Ask Your Ad Account Questions
- Meta Ads Dashboard: Spend, CPA and Creative
- Facebook Ads Report: A Monthly Meta Ads Report Template (2026)
Ask Meta Ads in plain words
Try the questions on sample data with no signup, then connect Meta Ads read-only and ask your own.
Try Quiriz free →Frequently asked questions
Does Quiriz change anything in Meta Ads?
How often does the Meta Ads data refresh?
Can I change how a metric is calculated?
Can I combine Meta Ads with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.