Skip to main content

​
What it is

Ad analytics is one dataset per channel — not a single unified dataset — because each channel’s daily-performance table has a different shape (different metrics, different metric-date column). Each row is one day of performance for one ad-hierarchy entity.
  • Grain: one row per entity per day — the cometly_*_id columns plus the metric date.
  • Windowed on: the channel’s metric date (a local calendar date — see below).
  • Path segment: <channel>_ad_analytics (for example facebook_ad_analytics).
Each channel’s columns are listed in the tabs below.

​
Identity columns

Every channel exposes its ad hierarchy as IDs only (never names). Each level carries:
  • cometly_<level>_id — Locked. Cometly’s internal ID; part of the grain and the key for joining to Raw touchpoints and Attributed conversions.
  • platform_<level>_id — Optional. The platform’s own ID. Selecting it joins that level’s entity table on demand, so the join cost is only paid when you want it. May be null.
The hierarchy levels differ by channel (for example LinkedIn uses campaign group → campaign → creative). Resolve names on your side from these IDs. See Column conventions.

​
Dates and restatement

Unlike every other dataset, ad analytics windows on a local calendar date, not a UTC timestamp. Cometly matches your picked dates literally against the channel’s metric date and makes no timezone conversion — the same behavior as the ads manager. Which timezone that date is in depends on the channel:
Recent days may still change. Ad platforms restate recent days’ numbers. A recurring run re-exports its full window with current values, so recent days converge across runs — but a day restated after it leaves the window is not re-exported. For a full refresh, run a one-time export.
Hourly cadence is allowed (the tables refresh through the day, so hourly delivers the freshest restatements) but its trailing window is capped at 7 days for ad-analytics datasets, versus 14 for other datasets. Daily (up to 90 days) and one-time are unchanged.

​
Columns by channel

Path segment facebook_ad_analytics. Metric date column metric_date_local (Locked, space timezone).IdentityPerformance (all optional): delivery, amount_spent, impressions, link_clicks, clicks, video_view.Reported conversions (all optional): reported_purchases, reported_leads, reported_add_to_cart, reported_initiate_checkout, reported_complete_registration, reported_contact, reported_schedule, reported_start_trial, reported_subscribe, reported_view_content, reported_search, reported_add_payment_info, reported_add_to_wishlist, reported_landing_page_view.Reported value (all optional): reported_revenue, reported_leads_value, reported_add_to_cart_value, reported_initiate_checkout_value.Timestamps (all optional): created_at, updated_at (last restated).