meta_get_performance_cube
Performance grouped and crossed on any of: campaign, adset, country (the ad set's targeted countries; an ad set bought for several is one bucket, e.g.
read meta_get_performance_cube
Performance grouped and crossed on any of: campaign, adset, country (the ad set's targeted countries; an ad set bought for several is one bucket, e.g. AU+CA+GB+IE), ad (every copy of one ad name across ad sets — the creative published N times, summed), creative (the upload; a per-country localized file is its own upload), concept (the ad name's concept segment), and the stored Values angle, persona, awareness, offer, pain, format, hook, talent, visual. rows takes one axis or two (nested: e.g. ad → country splits each creative by ad set); column crosses them (angle × country). Each row: ads, distinct ad names, and metrics (spend, impressions, CPM, CTR, CPC, clicks, landing page views, leads, checkouts, registrations, purchases, ROAS, AOV, hook/hold and video retention rates, average watch time), and results / cost per result on the ads' goal — null with goal "mixed" when a cell mixes events. An ad with two Values on an axis counts under each; the total is never a sum of rows. From the daily warehouse, for a period.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
rows | campaign | adset | country | ad | creative | concept | angle | persona | awareness | offer | offer_type | pain | season | asset_type | format | hook | headline_tactic | talent | visual[] | Yes | |
column | campaign | adset | country | ad | creative | concept | angle | persona | awareness | offer | offer_type | pain | season | asset_type | format | hook | headline_tactic | talent | visual | No | |
campaignIds | string[] | No | Only these campaigns. |
limit | integer | No | Top rows by spend. |
period | 7d | 14d | 30d | this_week | last_week | No | Reporting window. 7d/14d/30d are the last N complete days, ending yesterday (as in Ads Manager); weeks are Monday-based, this_week runs to today. UTC. |
since | string | No | Custom window start, YYYY-MM-DD, UTC. Overrides period. The result's coverage says what the warehouse holds. |
until | string | No | Custom window end, YYYY-MM-DD, inclusive. Default today. |
get_cross_analysisread
Cross analysis inside ONE funnel: one Dimension (rows) or two against each other (rows × columns) — angle, persona, awareness, offer, pain, format, hook, talent, visual, copy, cta, language, market, landing, media.
get_strategy_rollupread
Spend, purchases, results and ROAS per Value of every creative Dimension (angle, persona, awareness, offer, pain, format, hook, talent, visual) and per persona × angle, for a period.