Dayparting analysis — which hours of which days are working for your spend, and when to pull back.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.
What this data model represents
Grain: one row perdate × ad_account × campaign × adset × ad × audience_hour.
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 | Values |
|---|---|---|
audience_hour | Integer | 0 (midnight–1am) … 23 (11pm–midnight) |
day_of_week | String | Derived from date — Monday, Tuesday, … Sunday |
Use it to answer
- Where are peak conversion hours vs. peak spend hours — and what’s the inefficiency?
- Which hours should I pause? Which should I bid up?
- How do hour × day-of-week patterns differ between weekdays and weekends?
- What time of day has the highest engagement for awareness campaigns?
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 & conversions | |
| Ad Spend | Sum of daily spend |
| Conversions | Sum of reported orders |
| 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 |
| Engagement | |
| Landing Page Views | Sum |
| Post Shares | Sum |
| Engagement Rate | Post Engagement ÷ Impressions × 100 |
| 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 |
Raw fields (for custom calculations)
Raw fields (for custom calculations)
This data model exposes:
ad_spend · clicks · impressions · reported_orders · inline_clicks · outbound_clicks · landing_page_views · add_to_cart · checkouts_initiated · view_content · post_share