Home / Connectors / Meta Ads
Connector

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.

7 datasets20 metric definitionsRead-onlyRefreshes daily5 cross-source metrics

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

DatasetWhat it holds
[Meta Ads] CampaignsCampaigns
12 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 performanceMeta 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 performanceAd set performance
14 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 performanceTop 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 frequencyPer 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 genderCampaign 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] PlacementsCampaign 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

MetricHow it is calculatedDated byNotes
Meta Ads spendSum of costdateMeta Ads spend in the ad account currency, by day.
Meta Ads impressionsSum of impressionsdateTimes Meta showed an ad (Facebook, Instagram, Messenger, Audience Network).
Meta Ads clicksSum of clicksdateLink clicks on Meta ads.
Meta Ads conversionsSum of conversionsdatePurchases as Meta counts them (the ad account's attribution setting).
Meta Ads conversion valueSum of conversion_valuedatePurchase value in the ad account currency.
Meta Ads leadsSum of leadsdateLeads as Meta counts them.
Meta Ads ROASMeta Ads conversion value ÷ Meta Ads spenddatePurchase value per unit of spend (2.5 = 2.50 back for 1.00 spent).
Meta Ads CPCMeta Ads spend ÷ Meta Ads clicksdateAverage cost per link click.
Meta Ads CTRMeta Ads clicks ÷ Meta Ads impressionsdateLink clicks per impression, as a decimal (0.01 = 1%).
Meta Ads CPAMeta Ads spend ÷ Meta Ads conversionsdateAverage cost per purchase.
Meta Ads 3-second playsSum of video_3s_playsdateTimes a video ad played for at least 3 seconds (Meta "video plays", the action type video_view).
Meta Ads ThruPlaysSum of thruplaysdateTimes a video ad played to 15 seconds, or to the end if shorter.
Meta Ads thousand impressionsSum of thousand_impressionsdateHelper: impressions divided by 1,000, the denominator of CPM.
Meta Ads hook rateMeta Ads 3-second plays ÷ Meta Ads impressionsdate3-second plays per impression, as a decimal (0.30 = 30%): how often the first seconds stop the scroll. Video ads only.
Meta Ads hold rateMeta Ads ThruPlays ÷ Meta Ads 3-second playsdateThruPlays per 3-second play, as a decimal (0.25 = 25%): how many people who started a video kept watching. Video ads only.
Meta Ads CPMMeta Ads spend ÷ Meta Ads thousand impressionsdateCost per 1,000 impressions.
Meta Ads cost per ThruPlayMeta Ads spend ÷ Meta Ads ThruPlaysdateSpend per ThruPlay. Video ads only.

[Meta Ads] Reach and frequency

MetricHow it is calculatedDated byNotes
Meta Ads monthly impressionsSum of impressionsmonthImpressions by campaign and month, next to reach.
Meta Ads monthly reachSum of reachmonthDistinct people reached in the month, by campaign. Not additive: do not add it across months or campaigns.
Meta Ads monthly frequencyMeta Ads monthly impressions ÷ Meta Ads monthly reachmonthAverage 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.

MetricHow it is calculatedNeedsNotes
Meta Ads nCACMeta Ads spend ÷ New customersShopify + Meta AdsMeta Ads spend per new customer: Meta Ads spend divided by New customers in the same period.
Meta Ads aMERNew customer net sales ÷ Meta Ads spendShopify + Meta AdsFirst-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 customersShopify + Meta Ads + Google AdsMeta Ads and Google Ads spend per new customer.
Blended aMERNew customer net sales ÷ (Meta Ads spend + Google Ads spend)Shopify + Meta Ads + Google AdsFirst-order net sales per paid ad dollar across Meta Ads and Google Ads.
Blended MERNet sales ÷ (Meta Ads spend + Google Ads spend)Shopify + Meta Ads + Google AdsMarketing 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.

Questions to ask

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?
No. The Meta Ads connector is read-only. Quiriz reads the data into datasets and never writes back to Meta Ads.
How often does the Meta Ads data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Meta Ads with other sources?
Yes. 5 cross-source metrics are added automatically when the other connector is there too. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.