Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.
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:
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:
Picked dates are approximate — the window can be off by up to a day at the edges.
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
Facebook
Google
LinkedIn
TikTok
Microsoft
Reddit
Taboola
AdRoll
Whop
ChatGPT Ads
X
Path segment facebook_ad_analytics. Metric date column metric_date_local (Locked, space timezone).Identity
Path segment taboola_ad_analytics. Metric date column metric_date_taboola (Locked, space timezone).Identity
Level
Cometly ID (Locked)
Platform ID (Optional)
Account
cometly_account_id
platform_account_id
Campaign
cometly_campaign_id
platform_campaign_id
Ad group
cometly_adgroup_id
platform_adgroup_id
Ad
cometly_ad_id
platform_ad_id
Campaign, ad-group, and ad IDs can be null on Taboola rows, so their platform IDs may come back null.Performance (all optional): spend, clicks, impressions.Timestamps (all optional): created_at, updated_at (last restated).
Path segment adroll_ad_analytics. Metric date column metric_date_adroll (Locked, space timezone).Identity
Level
Cometly ID (Locked)
Platform ID (Optional)
Account
cometly_account_id
platform_account_id
Campaign
cometly_campaign_id
platform_campaign_id
Ad group
cometly_adgroup_id
platform_adgroup_id
Ad
cometly_ad_id
platform_ad_id
Campaign, ad-group, and ad IDs can be null on AdRoll rows, so their platform IDs may come back null.Performance (all optional): spend, clicks, impressions.Conversions (all optional): conversions, click_throughs, view_throughs, revenue, click_revenue, view_revenue.Timestamps (all optional): created_at, updated_at (last restated).
Path segment whop_ad_analytics. Metric date column metric_date_whop (Locked, space timezone).Identity
Level
Cometly ID (Locked)
Platform ID (Optional)
Account
cometly_account_id
platform_account_id
Campaign
cometly_campaign_id
platform_campaign_id
Ad group
cometly_adgroup_id
platform_adgroup_id
Ad
cometly_ad_id
platform_ad_id
A Whop “account” is a Whop company (biz_xxx); that id is the platform_account_id and also doubles as the company_id required by Whop’s Conversions API.Performance (all optional): spend, clicks, impressions, reach.Results (all optional): whop_result_count, whop_result_label_key.Timestamps (all optional): created_at, updated_at (last restated).
Path segment chatgpt_ad_analytics. Metric date column metric_date_chatgpt (Locked, space timezone).Identity
Level
Cometly ID (Locked)
Platform ID (Optional)
Account
cometly_account_id
platform_account_id
Campaign
cometly_campaign_id
platform_campaign_id
Ad group
cometly_adgroup_id
platform_adgroup_id
Ad
cometly_ad_id
platform_ad_id
Platform ids are OpenAI’s string ids (cmpn_…, adgrp_…, ad_…). Spend is converted into the space currency; OpenAI reports it in the ad account’s currency and settles it 7 to 8 hours after the clicks, so recent days are restated by the morning backfills.Performance (all optional): spend, clicks, impressions.OpenAI attribution (all optional): platform_conversions, platform_attributed_sales (OpenAI’s own click-through plus view-through attribution for the ad, as its Ads Manager reports it; Cometly’s attributed conversions live in the event datasets).Timestamps (all optional): created_at, updated_at (last restated).
Path segment x_ad_analytics. Metric date column metric_date_x (Locked, ad-account timezone).Identity
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Cometly API Docs","colors":{"primary":"#0086FF","light":"#0086FF","dark":"#0086FF"},"logo":{"light":"https://mintcdn.com/cometly/hnuCBvleNSBDJAON/logo/light.svg?fit=max\u0026auto=format\u0026n=hnuCBvleNSBDJAON\u0026q=85\u0026s=1b725e99cd933554c9ab680583d1b779","dark":"https://mintcdn.com/cometly/hnuCBvleNSBDJAON/logo/dark.svg?fit=max\u0026auto=format\u0026n=hnuCBvleNSBDJAON\u0026q=85\u0026s=5b27a31c96508945608d23fa3394eafc"},"favicon":"https://mintcdn.com/cometly/hnuCBvleNSBDJAON/favicon.svg?fit=max\u0026auto=format\u0026n=hnuCBvleNSBDJAON\u0026q=85\u0026s=676feb9017410d273527df10995ef763","api":{"playground":{},"mdx":{"auth":{"method":"bearer"},"server":"https://app.cometly.com"}},"navbar":{"links":[{"href":"mailto:support@cometly.com","label":"Support"}],"primary":{"type":"button","label":"Dashboard","href":"https://app.cometly.com"}},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"cometly","hasAudioNarration":false,"actualSubdomain":"cometly","customDomains":["docs.cometly.com"],"gitSource":{"type":"github","owner":"cometly","repo":"app","deployBranch":"main","contentDirectory":"publicApiDocs/V1","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6aeccca749ba6b608729de3c","clientVersion":"0.0.4143","searchFilterCounts":[{"language":"default","tag":"MCP","count":58},{"language":"default","tag":"Tools","count":49},{"language":"default","tag":"API Reference","count":27},{"language":"default","tag":"Contacts","count":14},{"language":"default","tag":"Data Warehouse","count":13},{"language":"default","tag":"Events","count":12},{"language":"default","tag":"Get Started","count":9},{"language":"default","tag":"Companies","count":8},{"language":"default","tag":"Reports","count":8},{"language":"default","tag":"Concepts","count":7}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true,"deflection":{"enabled":true,"email":"support@cometly.com","showHelpButton":true}},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"data-warehouse/datasets/ad-analytics","slug":"/data-warehouse/datasets/ad-analytics","pageMetadata":{"title":"Ad analytics","description":"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.","href":"/data-warehouse/datasets/ad-analytics"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{Heading,Note,Tab,Table,Tabs,Warning}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!Tab)_missingMdxReference(`Tab`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tabs)_missingMdxReference(`Tabs`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`what-it-is`,children:`What it is`}),`\n`,_jsxs(_components.p,{children:[`Ad analytics is `,_jsx(_components.strong,{children:`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.`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Grain:`}),` one row per entity per day — the `,_jsx(_components.code,{children:`cometly_*_id`}),` columns plus the metric date.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Windowed on:`}),` the channel’s `,_jsx(_components.strong,{children:`metric date`}),` (a local calendar date — see below).`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Path segment:`}),` `,_jsx(_components.code,{children:`\u003cchannel>_ad_analytics`}),` (for example `,_jsx(_components.code,{children:`facebook_ad_analytics`}),`).`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`Each channel’s columns are listed in the tabs below.`}),`\n`,_jsx(Heading,{level:`3`,id:`identity-columns`,children:`Identity columns`}),`\n`,_jsx(_components.p,{children:`Every channel exposes its ad hierarchy as IDs only (never names). Each level carries:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`cometly_\u003clevel>_id`}),` — `,_jsx(_components.strong,{children:`Locked.`}),` Cometly’s internal ID; part of the grain and the key for joining to `,_jsx(_components.a,{href:`/data-warehouse/datasets/raw-touchpoints`,children:`Raw touchpoints`}),` and `,_jsx(_components.a,{href:`/data-warehouse/datasets/attributed-conversions`,children:`Attributed conversions`}),`.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`platform_\u003clevel>_id`}),` — `,_jsx(_components.strong,{children:`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.`]}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`The hierarchy levels differ by channel (for example LinkedIn uses campaign group → campaign → creative). Resolve names on your side from these IDs. See `,_jsx(_components.a,{href:`/data-warehouse/overview#column-conventions`,children:`Column conventions`}),`.`]}),`\n`,_jsx(Heading,{level:`3`,id:`dates-and-restatement`,children:`Dates and restatement`}),`\n`,_jsxs(_components.p,{children:[`Unlike every other dataset, ad analytics windows on a `,_jsx(_components.strong,{children:`local calendar date`}),`, not a UTC timestamp. Cometly matches your picked dates `,_jsx(_components.strong,{children:`literally`}),` against the channel’s metric date and makes `,_jsx(_components.strong,{children:`no timezone conversion`}),` — the same behavior as the ads manager. Which timezone that date is in depends on the channel:`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Metric date timezone`}),_jsx(_components.th,{children:`Channels`}),_jsx(_components.th,{children:`Effect`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Space timezone`})}),_jsx(_components.td,{children:`Facebook, LinkedIn, TikTok, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads`}),_jsx(_components.td,{children:`Picked dates match exactly.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Ad-account timezone`})}),_jsx(_components.td,{children:`Google, Microsoft, X`}),_jsx(_components.td,{children:`Picked dates are approximate — the window can be off by up to a day at the edges.`})]})]})]}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Recent days may still change.`}),` Ad platforms restate recent days’ numbers. A recurring run\nre-exports its full window with current values, so recent days converge across runs — but a day\nrestated `,_jsx(_components.em,{children:`after`}),` it leaves the window is not re-exported. For a full refresh, run a one-time export.`]})}),`\n`,_jsx(Note,{children:_jsxs(_components.p,{children:[`Hourly cadence is allowed (the tables refresh through the day, so hourly delivers the freshest\nrestatements) but its trailing window is capped at `,_jsx(_components.strong,{children:`7 days`}),` for ad-analytics datasets, versus 14\nfor other datasets. Daily (up to 90 days) and one-time are unchanged.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`columns-by-channel`,children:`Columns by channel`}),`\n`,_jsxs(Tabs,{children:[_jsxs(Tab,{title:`Facebook`,id:`facebook`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`facebook_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_local`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad set`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adset_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adset_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`delivery`}),`, `,_jsx(_components.code,{children:`amount_spent`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`link_clicks`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`video_view`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Reported conversions`}),` (all optional): `,_jsx(_components.code,{children:`reported_purchases`}),`, `,_jsx(_components.code,{children:`reported_leads`}),`, `,_jsx(_components.code,{children:`reported_add_to_cart`}),`, `,_jsx(_components.code,{children:`reported_initiate_checkout`}),`, `,_jsx(_components.code,{children:`reported_complete_registration`}),`, `,_jsx(_components.code,{children:`reported_contact`}),`, `,_jsx(_components.code,{children:`reported_schedule`}),`, `,_jsx(_components.code,{children:`reported_start_trial`}),`, `,_jsx(_components.code,{children:`reported_subscribe`}),`, `,_jsx(_components.code,{children:`reported_view_content`}),`, `,_jsx(_components.code,{children:`reported_search`}),`, `,_jsx(_components.code,{children:`reported_add_payment_info`}),`, `,_jsx(_components.code,{children:`reported_add_to_wishlist`}),`, `,_jsx(_components.code,{children:`reported_landing_page_view`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Reported value`}),` (all optional): `,_jsx(_components.code,{children:`reported_revenue`}),`, `,_jsx(_components.code,{children:`reported_leads_value`}),`, `,_jsx(_components.code,{children:`reported_add_to_cart_value`}),`, `,_jsx(_components.code,{children:`reported_initiate_checkout_value`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`Google`,id:`google`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`google_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_google`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, ad-account timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`ctr`}),`, `,_jsx(_components.code,{children:`interactions`}),`, `,_jsx(_components.code,{children:`interaction_rate`}),`, `,_jsx(_components.code,{children:`video_views`}),`, `,_jsx(_components.code,{children:`video_view_rate`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Averages`}),` (all optional): `,_jsx(_components.code,{children:`average_cpm`}),`, `,_jsx(_components.code,{children:`average_cpc`}),`, `,_jsx(_components.code,{children:`average_cost`}),`, `,_jsx(_components.code,{children:`average_cpe`}),`, `,_jsx(_components.code,{children:`average_cpv`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Conversions`}),` (all optional): `,_jsx(_components.code,{children:`conversions`}),`, `,_jsx(_components.code,{children:`all_conversions`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`LinkedIn`,id:`linkedin`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`linkedin_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_group_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_group_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Creative`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_creative_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_creative_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`cost`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`video_views`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Conversions \u0026 leads`}),` (all optional): `,_jsx(_components.code,{children:`conversions`}),`, `,_jsx(_components.code,{children:`conversion_value`}),`, `,_jsx(_components.code,{children:`leads`}),`, `,_jsx(_components.code,{children:`registrations`}),`, `,_jsx(_components.code,{children:`one_click_lead_form_opens`}),`, `,_jsx(_components.code,{children:`form_completion_rate`}),`, `,_jsx(_components.code,{children:`external_website_post_view_conversions`}),`, `,_jsx(_components.code,{children:`external_website_post_click_conversions`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`TikTok`,id:`tiktok`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`tiktok_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_local`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`amount_spent`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`clicks`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Reported conversions`}),` (all optional): `,_jsx(_components.code,{children:`reported_purchases`}),`, `,_jsx(_components.code,{children:`reported_revenue`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`Microsoft`,id:`microsoft`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`microsoft_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_microsoft`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, ad-account timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`video_views`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Conversions`}),` (all optional): `,_jsx(_components.code,{children:`conversions_qualified`}),`, `,_jsx(_components.code,{children:`view_through_conversions_qualified`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`Reddit`,id:`reddit`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`reddit_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_reddit`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`reddit_video_views`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Conversions`}),` (all optional): `,_jsx(_components.code,{children:`reddit_reported_roas`}),`, `,_jsx(_components.code,{children:`conversion_purchase_total_value`}),`, `,_jsx(_components.code,{children:`conversion_page_visit_view`}),`, `,_jsx(_components.code,{children:`conversion_sign_up_views`}),`, `,_jsx(_components.code,{children:`conversion_lead_views`}),`, `,_jsx(_components.code,{children:`conversion_purchase_views`}),`, `,_jsx(_components.code,{children:`conversion_page_visit_clicks`}),`, `,_jsx(_components.code,{children:`conversion_sign_up_clicks`}),`, `,_jsx(_components.code,{children:`conversion_lead_clicks`}),`, `,_jsx(_components.code,{children:`conversion_purchase_clicks`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`Taboola`,id:`taboola`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`taboola_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_taboola`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsx(_components.p,{children:`Campaign, ad-group, and ad IDs can be null on Taboola rows, so their platform IDs may come back null.`}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`AdRoll`,id:`adroll`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`adroll_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_adroll`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsx(_components.p,{children:`Campaign, ad-group, and ad IDs can be null on AdRoll rows, so their platform IDs may come back null.`}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Conversions`}),` (all optional): `,_jsx(_components.code,{children:`conversions`}),`, `,_jsx(_components.code,{children:`click_throughs`}),`, `,_jsx(_components.code,{children:`view_throughs`}),`, `,_jsx(_components.code,{children:`revenue`}),`, `,_jsx(_components.code,{children:`click_revenue`}),`, `,_jsx(_components.code,{children:`view_revenue`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`Whop`,id:`whop`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`whop_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_whop`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[`A Whop “account” is a Whop company (`,_jsx(_components.code,{children:`biz_xxx`}),`); that id is the `,_jsx(_components.code,{children:`platform_account_id`}),` and also doubles as the `,_jsx(_components.code,{children:`company_id`}),` required by Whop’s Conversions API.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`reach`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Results`}),` (all optional): `,_jsx(_components.code,{children:`whop_result_count`}),`, `,_jsx(_components.code,{children:`whop_result_label_key`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`ChatGPT Ads`,id:`chatgpt-ads`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`chatgpt_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_chatgpt`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, space timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[`Platform ids are OpenAI’s string ids (`,_jsx(_components.code,{children:`cmpn_…`}),`, `,_jsx(_components.code,{children:`adgrp_…`}),`, `,_jsx(_components.code,{children:`ad_…`}),`). Spend is converted into the space currency; OpenAI reports it in the ad account’s currency and settles it 7 to 8 hours after the clicks, so recent days are restated by the morning backfills.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`OpenAI attribution`}),` (all optional): `,_jsx(_components.code,{children:`platform_conversions`}),`, `,_jsx(_components.code,{children:`platform_attributed_sales`}),` (OpenAI’s own click-through plus view-through attribution for the ad, as its Ads Manager reports it; Cometly’s attributed conversions live in the event datasets).`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]}),_jsxs(Tab,{title:`X`,id:`x`,children:[_jsxs(_components.p,{children:[`Path segment `,_jsx(_components.code,{children:`x_ad_analytics`}),`. Metric date column `,_jsx(_components.code,{children:`metric_date_x`}),` (`,_jsx(_components.strong,{children:`Locked`}),`, ad-account timezone).`]}),_jsx(_components.p,{children:_jsx(_components.strong,{children:`Identity`})}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Level`}),_jsx(_components.th,{children:`Cometly ID (Locked)`}),_jsx(_components.th,{children:`Platform ID (Optional)`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Account`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_account_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_account_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Campaign`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_campaign_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_campaign_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad group`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_adgroup_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_adgroup_id`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ad`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`cometly_ad_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`platform_ad_id`})})]})]})]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Performance`}),` (all optional): `,_jsx(_components.code,{children:`spend`}),`, `,_jsx(_components.code,{children:`clicks`}),`, `,_jsx(_components.code,{children:`x_url_clicks`}),`, `,_jsx(_components.code,{children:`impressions`}),`, `,_jsx(_components.code,{children:`x_video_views`}),`, `,_jsx(_components.code,{children:`x_engagements`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Conversions`}),` (all optional): `,_jsx(_components.code,{children:`conversion_purchase_total_value`}),`, `,_jsx(_components.code,{children:`conversion_purchases`}),`, `,_jsx(_components.code,{children:`conversion_sign_ups`}),`, `,_jsx(_components.code,{children:`conversion_site_visits`}),`, `,_jsx(_components.code,{children:`conversion_downloads`}),`, `,_jsx(_components.code,{children:`conversion_custom`}),`.`]}),_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Timestamps`}),` (all optional): `,_jsx(_components.code,{children:`created_at`}),`, `,_jsx(_components.code,{children:`updated_at`}),` (last restated).`]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Ad analytics","description":"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.","href":"/data-warehouse/datasets/ad-analytics"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"What it is","slug":"what-it-is","depth":2,"children":[{"title":"Identity columns","slug":"identity-columns","depth":3,"children":[]},{"title":"Dates and restatement","slug":"dates-and-restatement","depth":3,"children":[]}]},{"title":"Columns by channel","slug":"columns-by-channel","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"cometly","siteName":"Cometly API Docs","title":"Ad analytics - Cometly API Docs","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-02T18:45:18.633Z","originalFileLocation":"data-warehouse/datasets/ad-analytics.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Cometly API Docs\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Ad analytics - Cometly API Docs\">\u003cmeta data-mint-head property=\"og:description\" content=\"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Cometly API Docs\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://cometly.mintlify.site/_mintlify/api/og/v2?division=Datasets\u0026amp;title=Ad+analytics\u0026amp;description=Daily+ad-performance+rows+per+channel+%E2%80%94+Facebook%2C+Google%2C+LinkedIn%2C+TikTok%2C+Microsoft%2C+Reddit%2C+Taboola%2C+AdRoll%2C+Whop%2C+ChatGPT+Ads%2C+and+X.\u0026amp;theme=4b81b0d192612debf11d7771\u0026amp;signature=a5eae36967befd5286c595795ac3337fc32008baf6b3e8aa945840944646ee6c\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Ad analytics - Cometly API Docs\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://cometly.mintlify.site/_mintlify/api/og/v2?division=Datasets\u0026amp;title=Ad+analytics\u0026amp;description=Daily+ad-performance+rows+per+channel+%E2%80%94+Facebook%2C+Google%2C+LinkedIn%2C+TikTok%2C+Microsoft%2C+Reddit%2C+Taboola%2C+AdRoll%2C+Whop%2C+ChatGPT+Ads%2C+and+X.\u0026amp;theme=4b81b0d192612debf11d7771\u0026amp;signature=a5eae36967befd5286c595795ac3337fc32008baf6b3e8aa945840944646ee6c\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/cometly/gMocZlOJ0QUZ28NI/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Cometly API Docs\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#0086FF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/data-warehouse/datasets/ad-analytics.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.cometly.com/#organization\",\"name\":\"Cometly API Docs\",\"url\":\"https://docs.cometly.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/cometly/hnuCBvleNSBDJAON/logo/light.svg?fit=max\u0026auto=format\u0026n=hnuCBvleNSBDJAON\u0026q=85\u0026s=1b725e99cd933554c9ab680583d1b779\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.cometly.com#website\",\"name\":\"Cometly API Docs\",\"url\":\"https://docs.cometly.com\",\"publisher\":{\"@id\":\"https://docs.cometly.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics#webpage\",\"url\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics\",\"name\":\"Ad analytics\",\"description\":\"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.\",\"dateModified\":\"2026-11-02T18:45:18.633Z\",\"isPartOf\":{\"@id\":\"https://docs.cometly.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Datasets\",\"item\":\"https://docs.cometly.com/data-warehouse/datasets/raw-touchpoints\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ad analytics\",\"item\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics#article\",\"headline\":\"Ad analytics\",\"name\":\"Ad analytics\",\"description\":\"Daily ad-performance rows per channel — Facebook, Google, LinkedIn, TikTok, Microsoft, Reddit, Taboola, AdRoll, Whop, ChatGPT Ads, and X.\",\"url\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics\",\"mainEntityOfPage\":{\"@id\":\"https://docs.cometly.com/data-warehouse/datasets/ad-analytics#webpage\"},\"dateModified\":\"2026-11-02T18:45:18.633Z\",\"publisher\":{\"@id\":\"https://docs.cometly.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.cometly.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Cometly API Docs\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Cometly API Docs\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/data-warehouse/datasets/ad-analytics.md","siteName":"Cometly API Docs","nav":{"global":null,"tabs":[{"tab":"API Reference","pages":[{"title":"API Reference","href":""}]},{"tab":"MCP","pages":[{"title":"MCP","href":"/mcp/overview"}]},{"tab":"Concepts","pages":[{"title":"Concepts","href":"/concepts/sending-data-to-cometly"}]},{"tab":"Data Warehouse","groups":[{"group":"Get Started","pages":[{"title":"Data Warehouse Exports","href":"/data-warehouse/overview"},{"title":"Set up an S3 destination","href":"/data-warehouse/s3-destination"},{"title":"Set up a Google Cloud Storage destination","href":"/data-warehouse/gcs-destination"},{"title":"Set up a Snowflake destination","href":"/data-warehouse/snowflake-destination"},{"title":"Set up a BigQuery destination","href":"/data-warehouse/bigquery-destination"},{"title":"Create an export","href":"/data-warehouse/create-export"}]},{"group":"Datasets","pages":[{"title":"Raw touchpoints","href":"/data-warehouse/datasets/raw-touchpoints"},{"title":"Raw conversions","href":"/data-warehouse/datasets/raw-conversions"},{"title":"Raw hits","href":"/data-warehouse/datasets/raw-hits"},{"title":"Attributed conversions","href":"/data-warehouse/datasets/attributed-conversions"},{"title":"Contacts","href":"/data-warehouse/datasets/contacts"},{"title":"Companies","description":"Every company created in the export window.","href":"/data-warehouse/datasets/companies"},{"title":"Ad analytics","href":"/data-warehouse/datasets/ad-analytics"}]}]}]},"basePath":"","title":"Ad analytics - Cometly API Docs","buildId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","deploymentId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","dynamics":[],"chunks":[]}