SKU-level performance — which products are paying back, which are losing money in the catalog, and where the funnel breaks per SKU.Documentation Index
Fetch the complete documentation index at: https://docs.ocular.dev/llms.txt
Use this file to discover all available pages before exploring further.
Populated for catalog-based campaigns (Dynamic Product Ads, Advantage+ Catalog, Collection Ads with a product feed). Non-catalog campaigns won’t appear here — they live in the other data models.
What this data model represents
Grain: one row perdate × ad_account × campaign × adset × ad × product_id.
Metrics, grouped by category — every number you can compute on this data model. Expand below for examples in each.
Show sample metrics in each category
Show sample metrics in each category
Show sample dimensions in each category
Show sample dimensions in each category
Slice by
Unique to this data model:| Dimension | Type | Example values |
|---|---|---|
product_id | String | SKU-12345, PROD-67890 |
Use it to answer
- Which products have the highest ROAS — where should I increase promotion?
- Which products get clicks but don’t convert — pricing or landing page issue?
- Which products have CPA higher than their margin — candidates to exclude from the catalog?
- What does the View Content → Add to Cart → Checkout → Purchase funnel look like per SKU?
Available metrics
Everything you can compute on this data model. Need a metric not listed? See the Meta Ads metric availability matrix.| Metric | Formula |
|---|---|
| Spend & revenue | |
| Ad Spend | Sum of daily spend |
| Conversion Value | Sum of reported revenue |
| ROAS | Conversion Value ÷ Ad Spend |
| Conversions | Sum of reported orders |
| AOV | Conversion Value ÷ Conversions |
| Clicks & impressions | |
| Clicks (All) | Sum of clicks (inline + outbound) |
| Impressions | Sum of impressions |
| CTR (All) | Clicks ÷ Impressions × 100 |
| Outbound Clicks | Sum of clicks leading off Meta |
| Inline Clicks | Sum of on-platform engagement clicks |
| Cost efficiency | |
| CPC (All) | Ad Spend ÷ Clicks |
| CPM | Ad Spend ÷ Impressions × 1,000 |
| CPA | Ad Spend ÷ Conversions |
| Cost Per Outbound Click | Ad Spend ÷ Outbound Clicks |
| Revenue Per Link Click | Conversion Value ÷ Outbound Clicks |
| Engagement | |
| Landing Page Views | Sum |
| Post Engagement | Sum (reactions + comments + shares + clicks) |
| Post Shares | Sum |
| Cost Per Post Engagement | Ad Spend ÷ Post Engagements |
| Cost Per Inline Post Engagement | Ad Spend ÷ Inline Post Engagements |
| Conversion funnel | |
| View Content | Sum |
| Add to Cart | Sum |
| Checkouts Initiated | Sum |
| Add Payment Info | Sum |
Raw fields (for custom calculations)
Raw fields (for custom calculations)
This data model exposes:
ad_spend · clicks · impressions · reported_orders · reported_revenue · inline_clicks · outbound_clicks · landing_page_views · add_to_cart · checkouts_initiated · view_content · add_payment_info · post_engagement · post_share