Platform
ActiveCampaign
Adalyser
Adform
Adjust
AdRoll
AdsWizz
Adtraction Advertising
Airbnb Review
Airtable
Amazon Ads
Amazon DSP
Amazon Seller
Amazon Vendor Central
Amplitude
Apple Search Ads
AppsFlyer
App Store Connect
App Store Review
Awin
Bigcommerce
Bing Webmaster Tool
Bluesky
Booking Review
Branch
Braze
Brevo (ex SendInBlue)
CallRail
Capterra Review
ChartMogul
ChatGPT Ads
GEO
Comment Sold
Criteo
Facebook Ads (Meta Ads)
Facebook (Meta) Pages
Facebook Public Data
Facebook Review
Firebase Realtime Database
G2 Review
Glassdoor Review
Google Ad Manager
Google Ads
Google Analytics
Google Display & Video 360
Google Merchant Center
Google My Business
Google Page Speed
Google Play Review
Google Play Store
Google Search Console
Google Sheets
Hawk DSP
HubSpot
Impact
Indeed Review
Instagram
Instagram Public Data
JSON / CSV / XML
Klaviyo
Line Ads
LinkedIn Ads
LinkedIn Page
Magento
Mailchimp
MailerLite
Matomo
Microsoft (Bing) Ads
Mixpanel
Outbrain DSP
Outbrain
Pardot
Piano Analytics
Pinterest Ads
Pinterest Organic
Pipedrive
Piwik
PostHog
Prestashop
Profitwell
QuickBooks
Reddit Ads
RevenueCat
Shopify
Snapchat Ads
Spotify Ads
StackAdapt
Stripe
Taboola
Teads
The Trade Desk
TikTok Ads
TikTok GMV
TikTok Organic
TikTok Shop
Tripadvisor Review
Trustpilot Review
X / Twitter Ads
Vistar Media
WooCommerce
Xandr
Get Started

Introduction

Datasources and destinations

Fields listing for ChatGPT Ads

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

7 metrics107 dimensions

114 fields

All fields
FieldDetails
Ad — Created at
Ad creation Unix timestamp.
Field IDad/ad_created_at
DimensionNUMBER
Ad — Creative file ID
Creative asset file identifier.
Field IDad/creative_file_id
DimensionTEXT
Ad — Creative image URL
Creative image URL.
Field IDad/creative_image_url
DimensionURL
Ad — Creative type
OpenAI creative type.
Field IDad/creative_type
DimensionTEXT
Ad — Destination URL
Creative destination URL.
Field IDad/ad_destination_url
DimensionURL
Ad — ID
Ad identifier. Example: ad_501
Field IDad/ad_id
DimensionTEXT
Ad — Name
Internal ad name.
Field IDad/ad_name
DimensionTEXT
Ad — Review status
OpenAI ad review status.
Field IDad/ad_review_status
DimensionTEXT
Ad — Status
Ad delivery status.
Field IDad/ad_status
DimensionTEXT
Ad — Text
Customer-visible creative body text.
Field IDad/ad_text
DimensionTEXT
Ad — Title
Customer-visible creative title.
Field IDad/ad_title
DimensionTEXT
Ad — Updated at
Ad update Unix timestamp.
Field IDad/ad_updated_at
DimensionNUMBER
Ad account — Currency code
Account currency code. Example: USD
Field IDad_account/ad_account_currency_code
DimensionTEXT
Ad account — Daily budget
Daily budget in the account currency, converted from OpenAI micros when available.
Field IDad_account/ad_account_daily_budget
DimensionNUMBER
Ad account — Daily budget micros
Raw OpenAI daily budget in millionths of the account currency.
Field IDad_account/ad_account_daily_budget_micros
DimensionNUMBER
Ad account — ID
Ad account identifier. Example: act_123
Field IDad_account/ad_account_id
DimensionTEXT
Ad account — Lifetime budget
Lifetime budget in the account currency, converted from OpenAI micros when available.
Field IDad_account/ad_account_lifetime_budget
DimensionNUMBER
Ad account — Lifetime budget micros
Raw OpenAI lifetime budget in millionths of the account currency.
Field IDad_account/ad_account_lifetime_budget_micros
DimensionNUMBER
Ad account — Name
Ad account display name. Example: Acme Ads
Field IDad_account/ad_account_name
DimensionTEXT
Ad account — Preview URL
Account preview URL when returned.
Field IDad_account/ad_account_preview_url
DimensionURL
Ad account — Review status
Brand review status returned by OpenAI.
Field IDad_account/ad_account_review_status
DimensionTEXT
Ad account — Status
OpenAI ad account status.
Field IDad_account/ad_account_status
DimensionTEXT
Ad account — Timezone
Timezone configured on the ad account. Example: UTC
Field IDad_account/ad_account_timezone
DimensionTEXT
Ad account — URL
Advertiser website URL. Example: https://www.acme.example
Field IDad_account/ad_account_url
DimensionURL
Ad account currency code
The currency code of the ad account.
Field IDad_account_currency_code
DimensionTEXT
Ad account daily budget
The daily budget of the ad account in its configured currency.
Field IDad_account_daily_budget
DimensionNUMBER
Ad account ID
The unique identifier of the ad account.
Field IDad_account_id
DimensionTEXT
Ad account lifetime budget
The lifetime budget of the ad account in its configured currency.
Field IDad_account_lifetime_budget
DimensionNUMBER
Ad account name
The name of the ad account.
Field IDad_account_name
DimensionTEXT
Ad account URL
The URL of the ad account.
Field IDad_account_url
DimensionURL
Ad destination URL
The destination URL of the ad.
Field IDad_destination_url
DimensionURL
Ad group — Billing event type
OpenAI bidding billing event type.
Field IDad_group/bidding_config_billing_event_type
DimensionTEXT
Ad group — Context hints JSON
JSON-encoded context hints retained as configuration context.
Field IDad_group/context_hints_json
DimensionTEXT
Ad group — Created at
Ad group creation Unix timestamp.
Field IDad_group/ad_group_created_at
DimensionNUMBER
Ad group — Description
Ad group description.
Field IDad_group/ad_group_description
DimensionTEXT
Ad group — ID
Ad group identifier. Example: adgrp_301
Field IDad_group/ad_group_id
DimensionTEXT
Ad group — Maximum bid micros
OpenAI maximum bid in micros.
Field IDad_group/bidding_config_max_bid_micros
DimensionNUMBER
Ad group — Name
Ad group name.
Field IDad_group/ad_group_name
DimensionTEXT
Ad group — Status
Ad group delivery status.
Field IDad_group/ad_group_status
DimensionTEXT
Ad group — Updated at
Ad group update Unix timestamp.
Field IDad_group/ad_group_updated_at
DimensionNUMBER
Ad group description
The description of the ad group.
Field IDad_group_description
DimensionTEXT
Ad group ID
The unique identifier of the ad group.
Field IDad_group_id
DimensionTEXT
Ad group name
The name of the ad group.
Field IDad_group_name
DimensionTEXT
Ad group status
The status of the ad group.
Field IDad_group_status
DimensionTEXT
Ad ID
The unique identifier of the ad.
Field IDad_id
DimensionTEXT
Ad name
The name of the ad.
Field IDad_name
DimensionTEXT
Ad review status
The review status of the ad.
Field IDad_review_status
DimensionTEXT
Ad status
The status of the ad.
Field IDad_status
DimensionTEXT
Ad text
The text of the ad.
Field IDad_text
DimensionTEXT
Ad title
The title of the ad.
Field IDad_title
DimensionTEXT
Aggregation level
OpenAI entity level selected by the connector.
Field IDaggregation_level
DimensionTEXT
Campaign — Created at
Campaign creation Unix timestamp.
Field IDcampaign/campaign_created_at
DimensionNUMBER
Campaign — Daily budget
Campaign daily budget in the account currency when available.
Field IDcampaign/campaign_daily_budget
DimensionNUMBER
Campaign — Daily budget micros
Raw OpenAI campaign daily budget in micros when available.
Field IDcampaign/campaign_daily_budget_micros
DimensionNUMBER
Campaign — Description
Campaign description.
Field IDcampaign/campaign_description
DimensionTEXT
Campaign — End time
Campaign schedule end formatted as YYYY-MM-DD HH:MM:SS.
Field IDcampaign/campaign_end_time
DimensionYEAR_MONTH_DAY_SECOND
Campaign — Excluded targeting JSON
JSON-encoded excluded targeting countries retained as configuration context.
Field IDcampaign/targeting_excluded_country_codes_json
DimensionTEXT
Campaign — ID
Campaign identifier. Example: cmpn_101
Field IDcampaign/campaign_id
DimensionTEXT
Campaign — Included targeting JSON
JSON-encoded included targeting countries retained as configuration context.
Field IDcampaign/targeting_included_country_codes_json
DimensionTEXT
Campaign — Lifetime budget
Campaign lifetime budget in the account currency.
Field IDcampaign/campaign_lifetime_budget
DimensionNUMBER
Campaign — Lifetime budget micros
Raw OpenAI campaign lifetime budget in micros.
Field IDcampaign/campaign_lifetime_budget_micros
DimensionNUMBER
Campaign — Name
Campaign name.
Field IDcampaign/campaign_name
DimensionTEXT
Campaign — Start time
Campaign schedule start formatted as YYYY-MM-DD HH:MM:SS.
Field IDcampaign/campaign_start_time
DimensionYEAR_MONTH_DAY_SECOND
Campaign — Status
Campaign delivery status.
Field IDcampaign/campaign_status
DimensionTEXT
Campaign — Updated at
Campaign update Unix timestamp.
Field IDcampaign/campaign_updated_at
DimensionNUMBER
Campaign daily budget
The daily budget of the campaign in the account currency.
Field IDcampaign_daily_budget
DimensionNUMBER
Campaign description
The description of the campaign.
Field IDcampaign_description
DimensionTEXT
Campaign end time
The scheduled end time of the campaign.
Field IDcampaign_end_time
DimensionYEAR_MONTH_DAY_SECOND
Campaign ID
The unique identifier of the campaign.
Field IDcampaign_id
DimensionTEXT
Campaign lifetime budget
The lifetime budget of the campaign in the account currency.
Field IDcampaign_lifetime_budget
DimensionNUMBER
Campaign name
The name of the campaign.
Field IDcampaign_name
DimensionTEXT
Campaign start time
The scheduled start time of the campaign.
Field IDcampaign_start_time
DimensionYEAR_MONTH_DAY_SECOND
Campaign status
The status of the campaign.
Field IDcampaign_status
DimensionTEXT
Clicks
The total number of clicks on the ads.
Field IDclicks
MetricNUMBER
Conversions
The total number of click-through conversions attributed to the ads.
Field IDconversions
MetricNUMBER
Country name
The country of the reporting data as an ISO 3166-1 alpha-2 code.
Field IDcountry_name
DimensionCOUNTRY_CODE
CPC
Cost per click, recomputed after aggregation as spend divided by clicks.
Field IDcpc
MetricNUMBER
CPM
Cost per thousand impressions, recomputed after aggregation.
Field IDcpm
MetricNUMBER
CTR
Click-through rate, recomputed after aggregation as clicks divided by impressions.
Field IDctr
MetricPERCENT
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Device type
The device type of the reporting data.
Field IDdevice_type
DimensionTEXT
End time
End of the OpenAI reporting bucket as a Unix timestamp.
Field IDend_time
DimensionNUMBER
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Impressions
The total number of times the ads were displayed.
Field IDimpressions
MetricNUMBER
Insight row ID
Opaque OpenAI identifier for the insight row.
Field IDinsight_row_id
DimensionTEXT
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
OpenAI readable time
Flat readable_time value returned by OpenAI.
Field IDreadable_time
DimensionYEAR_MONTH_DAY_SECOND
Product availability
The availability of the product.
Field IDproduct_availability
DimensionTEXT
Product body
The body content of the product.
Field IDproduct_body
DimensionTEXT
Product brand
The brand of the product.
Field IDproduct_brand
DimensionTEXT
Product description
The description of the product.
Field IDproduct_description
DimensionTEXT
Product feed ID
The unique identifier of the product feed.
Field IDproduct_feed_id
DimensionTEXT
Product image URL
The image URL of the product.
Field IDproduct_image_url
DimensionURL
Product image URL (Google Sheets)
The product image URL alias published for Google Sheets compatibility.
Field IDproduct_image_url_gs
DimensionURL
Product item ID
The unique identifier of the product item.
Field IDproduct_item_id
DimensionTEXT
Product price
The price of the product.
Field IDproduct_price
DimensionNUMBER
Product seller name
The name of the product seller.
Field IDproduct_seller_name
DimensionTEXT
Product target URL
The target URL of the product.
Field IDproduct_target_url
DimensionURL
Product title
The title of the product.
Field IDproduct_title
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Reporting timezone
The timezone of the reporting data.
Field IDtimezone
DimensionTEXT
Spend
The total amount spent on the ads in the account currency.
Field IDspend
MetricNUMBER
Start time
Start of the OpenAI reporting bucket as a Unix timestamp.
Field IDstart_time
DimensionNUMBER
Time granularity
OpenAI time bucket selected by the connector.
Field IDtime_granularity
DimensionTEXT
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
View connector
AI

ChatGPT

Ask ChatGPT about your Marketing data.
View connector
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
View connector
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
View connector
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
View connector
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
View connector
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
View connector
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
View connector
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
View connector
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
View connector
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
View connector
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
View connector
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
View connector
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
View connector
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
View connector
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.
View connector
Introduction
Fields list
Destinations