Data to AI™ / ChatGPT/Facebook Ads

Facebook Ads to ChatGPT integration

Check budget pacing, audience efficiency and video performance in a ChatGPT conversation that reads your scheduled Meta ad data, with every lookup confirmed by you.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Facebook Ads data you already sync
  • SOC 2 Type II certified
Start Free
ChatGPT setup guide
ChatGPT
Connected to Dataddo

Which placements returned the most purchase value per dollar spent last month?

ChatGPT Answer · Facebook Ads

Instagram Reels returned 4.1 in purchase value per unit of spend, the best of the three, on about a third of the budget. Facebook Feed took the largest share at 3.2.

PlacementSpendPurchase RoasCtr
Instagram Reels Platform Position Device Ad Insights $8,4004.11.32%
Facebook Feed Platform Position Device Ad Insights $12,6003.21.05%
Instagram Stories Platform Position Device Ad Insights $5,2002.40.71%

Spend and Purchase Roas come from one placement breakdown the Facebook Ads API supports, not from separate exports matched by hand.

source
Facebook Ads · as of Mon 06:40 UTC
covers
1-30 Sep 2026
Example answer · fictional account and figures
Facebook Ads in ChatGPT

Questions ChatGPT can answer from your Facebook Ads data

Facebook Ads extracts paid performance from Meta ad accounts, from account down to ad level: spend, delivery, conversions and ROAS, broken down by placement, device, demographics or creative asset.

Mid-month budget pacing

Ask ChatGPT

Run data_status on the Facebook Ads flow, then list active campaigns from Campaigns Insights with Daily Budget, Budget Remaining and yesterday's Spend.

You approve each tool call as it runs, see that yesterday is already loaded, and move budget away from campaigns burning through their plan before the month is half over.

Audiences that do not pay back

Ask ChatGPT

In Age Gender Breakdowns Ad Insights, which Age and Gender groups took a growing share of Spend last month while Purchase Roas stayed flat?

ChatGPT spots segments that absorb budget without returning it, then drafts targeting notes in the same conversation for the next ad set review with the paid social team.

Video ad triage

Ask ChatGPT

Rank videos in Video Asset Ad Insights by Cost Per Thruplay and show which still hold viewers at Video P100 Watched Actions.

The answer separates cheap views from videos people actually finish, so the video team gets short, specific feedback on which openings and lengths to reuse.

Facebook Ads datasets you can use in ChatGPT →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

~25% OFF

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$13.99 /mo

per seat, billed monthly

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
With vs. without

Facebook Ads in ChatGPT, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Pacing data in the chat Someone downloads campaign budgets and spend from Ads Manager, uploads the file, and the pacing answer is only as recent as that upload. ChatGPT reads Campaigns Insights and Facebook Ads Insights from the scheduled flow, and data_status tells you when the last run finished. Pacing on current spend
Control over each lookup A pasted export shares every column and account at once, including data the question never needed. Developer mode asks you to confirm each tool call, and you can switch off Dataddo tools you do not want ChatGPT to use. You approve every query
Demographic accuracy A file that mixes age, gender and region breakdowns invites ChatGPT to add up distorted absolute values. Age Gender Breakdowns Ad Insights keeps one supported breakdown, and known_gaps flags what the data does not cover before you rely on it. Fewer misleading segment totals
Token consumption ChatGPT spends tokens exploring raw Facebook Ads columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers grounded in defined fields. In the Dataddo benchmark, 78.5% of questions were answered correctly, against 65.5% with plain CSV files. Better answers
Datasets

Facebook Ads datasets you can use in ChatGPT

The Facebook Ads datasets marketing teams use most, with their real field names. ChatGPT queries them by name through the Dataddo semantic layer.

List of curated datasets

Reporting date startdate_start
datetime
Reporting date stopdate_stop
datetime
Account IDaccount_id
string
Account nameaccount_name
string
Account currencyaccount_currency
string
Campaign IDcampaign_id
string
Campaign namecampaign_name
string
Created timecreated_time
string
Updated timeupdated_time
string
Campaign objectiveobjective
string
Campaign buying typebuying_type
string
Ad Set IDadset_id
string
Ad Set nameadset_name
string
Attribution settingattribution_setting
string
Optimization goaloptimization_goal
string
Ad IDad_id
string
Ad namead_name
string
Ageage
string
Gendergender
string
Regionregion
string
Countrycountry
string
DMAdma
string
Frequency valuefrequency_value
string
Publisher platformpublisher_platform
string
Device platformdevice_platform
string
Impression deviceimpression_device
string
Product IDproduct_id
string
Ad format assetad_format_asset
string
Body asset IDbody_asset_id
string
Body asset textbody_asset_text
string
Call to action asset IDcall_to_action_asset_id
string
Call to action asset namecall_to_action_asset_name
string
Description asset IDdescription_asset_id
string
Description asset textdescription_asset_text
string
Image asset IDimage_asset_id
string
Image asset hashimage_asset_hash
string
Image asset nameimage_asset_name
string
Image asset URLimage_asset_url
string
Link URL asset IDlink_url_asset_id
string
Link URL asset website URLlink_url_asset_website_url
string
Title asset IDtitle_asset_id
string
Title asset texttitle_asset_text
string
Video asset IDvideo_asset_id
string
Video asset thumbnail hashvideo_asset_thumbnail_hash
string
Video asset URLvideo_asset_url
string
Video asset video IDvideo_asset_video_id
string
Video asset video namevideo_asset_video_name
string
Place page IDplace_page_id
string
Platform positionplatform_position
string
Hourly aggregation by timehourly_stats_aggregated_by_advertiser_time_zone
string
Total clicksclicks
integer
Inline link clicksinline_link_clicks
integer
Inline post engagementinline_post_engagement
integer
Link clicks (count)actions_link_click
integer
Page likes (count)actions_like
integer
Post shares (count)actions_post
integer
Post comments (count)actions_comment
integer
Page engagement (count)actions_page_engagement
integer
Post engagement (count)actions_post_engagement
integer
Checkins (count)actions_checkin
integer
App uses (count)actions_app_use
integer
App installs (count)actions_app_install
integer
Photo view (count)actions_photo_view
integer
Post reaction (count)actions_post_reaction
integer
Event responses (count)actions_rsvp
integer
Credit Spends (count)actions_credit_spent
integer
Game plays (count)actions_gamesplays
integer
Landing page views (count)actions_landing_page_view
integer
Leads - Form (count)actions_leadgenother
integer
Mobile app installs (count)actions_mobile_app_install
integer
Offline conversion - purchase (count)actions_offline_conversionpurchase
integer
Offsite conversion - add to basket (count)actions_offsite_conversionfb_pixel_add_to_cart
integer
Offsite conversion - add to wishlist (count)actions_offsite_conversionfb_pixel_add_to_wishlist
integer
Mobile app - add to wishlist (count)actions_app_custom_eventfb_mobile_add_to_wishlist
integer
Offsite conversion - lead (count)actions_offsite_conversionfb_pixel_lead
integer
Offsite conversion - custom (count)actions_offsite_conversionfb_pixel_custom
integer
Offsite conversion - purchases (count)actions_offsite_conversionfb_pixel_purchase
integer
Offsite conversion - initiated checkouts (count)actions_offsite_conversionfb_pixel_initiate_checkout
integer
Offsite conversion - completed registrations (count)actions_offsite_conversionfb_pixel_complete_registration
integer
Mobile app - completed registrations (count)actions_app_custom_eventfb_mobile_complete_registration
integer
Offsite conversion - view content (count)actions_offsite_conversionfb_pixel_view_content
integer
Offsite conversion - adds payment info (count)actions_offsite_conversionfb_pixel_add_payment_info
integer
Mobile app - adds payment info (count)actions_app_custom_eventfb_mobile_add_payment_info
integer
Offsite conversion - searches (count)actions_offsite_conversionfb_pixel_search
integer
Onsite conversion - lead grouped (count)actions_onsite_conversionlead_grouped
integer
Onsite conversion - flow complete (count)actions_onsite_conversionflow_complete
integer
Onsite conversion - messaging conversation block (count)actions_onsite_conversionmessaging_block
integer
Onsite conversion - messaging conversation start (count)actions_onsite_conversionmessaging_conversation_started_7d
integer
Onsite conversion - messaging conversation new (count)actions_onsite_conversionmessaging_first_reply
integer
Onsite conversion - post save (count)actions_onsite_conversionpost_save
integer
Onsite conversion - purchase (count)actions_onsite_conversionpurchase
integer
Video views (count)actions_video_view
integer
App engagement (count)actions_app_engagement
integer
App story (count)actions_app_story
integer
Page story (count)actions_page_story
integer
Post story (count)actions_post_story
integer
Offsite conversion (count)actions_offsite_conversion
integer
Onsite conversion (count)actions_onsite_conversion
integer
App custom event (count)actions_app_custom_event
integer
Onsite web app event (count)actions_onsite_web_app_event
integer
Mobile app retention (count)actions_mobile_app_retention
integer
Mobile app ROAS (count)actions_mobile_app_roas
integer
Offsite engagement (count)actions_offsite_engagement
integer
Store visits with dwell (count)actions_store_visit_with_dwell
integer
Add to cart (count)actions_add_to_cart
integer
Mobile add to cart (count)actions_app_custom_eventfb_mobile_add_to_cart
integer
Onsite app - Add to cart (count)actions_onsite_app_add_to_cart
integer
Onsite web - Add to cart (count)actions_onsite_web_add_to_cart
integer
Complete registration (count)actions_complete_registration
integer
Purchaseactions_purchase
integer
Onsite app - Purchase (count)actions_onsite_app_purchase
integer
Onsite web - Purchase (count)actions_onsite_web_purchase
integer
Mobile app - Purchase (count)actions_app_custom_eventfb_mobile_purchase
integer
Search (count)actions_search
integer
View content (count)actions_view_content
integer
Onsite app - View content (count)actions_onsite_app_view_content
integer
Onsite web - View content (count)actions_onsite_web_view_content
integer
Initiate checkout (count)actions_initiate_checkout
integer
Mobile app - Initiate checkout (count)actions_app_custom_eventfb_mobile_initiated_checkout
integer
Add payment info (count)actions_add_payment_info
integer
Add to wishlist (count)actions_add_to_wishlist
integer
Leads (count)actions_lead
integer
All app installs (count)actions_omni_app_install
integer
All purchases (count)actions_omni_purchase
integer
All add to cart (count)actions_omni_add_to_cart
integer
All completed registrations (count)actions_omni_complete_registration
integer
All content views (count)actions_omni_view_content
integer
All searches (count)actions_omni_search
integer
All initiated checkouts (count)actions_omni_initiated_checkout
integer
All unlocked achievements (count)actions_omni_achievement_unlocked
integer
All app activations (count)actions_omni_activate_app
integer
All level achieved (count)actions_omni_level_achieved
integer
All rates (count)actions_omni_rate
integer
All spend credits (count)actions_omni_spend_credits
integer
All tutorial completions (count)actions_omni_tutorial_completion
integer
All custom actions (count)actions_omni_custom
integer
Trials started total (count)actions_start_trial_total
integer
Website trials started (count)actions_start_trial_website
integer
Mobile app trials started (count)actions_start_trial_mobile_app
integer
Offline trials started (count)actions_start_trial_offline
integer
Total Contacts (count)actions_contact_total
integer
Website Contacts (count)actions_contact_website
integer
Mobile App Contacts (count)actions_contact_mobile_app
integer
Offline Contacts (count)actions_contact_offline
integer
Total Location Searches (count)actions_find_location_total
integer
Website Location Searches (count)actions_find_location_website
integer
Mobile App Location Searches (count)actions_find_location_mobile_app
integer
Offline App Location Searches (count)actions_find_location_offline
integer
Products Customized Total (count)actions_customize_product_total
integer
Total clicks (unique)unique_clicks
integer
Inline link clicks (unique)unique_inline_link_clicks
integer
Link clicks (unique)unique_actions_link_click
integer
Page likes (unique)unique_actions_like
integer
Post shares (unique)unique_actions_post
integer
Post comments (unique)unique_actions_comment
integer
Post likes (unique)unique_actions_post_like
integer
Page engagement (unique)unique_actions_page_engagement
integer
Post engagement (unique)unique_actions_post_engagement
integer
Checkins (unique)unique_actions_checkin
integer
App uses (unique)unique_actions_app_use
integer
App installs (unique)unique_actions_app_install
integer
Photo view (unique)unique_actions_photo_view
integer
Post reaction (unique)unique_actions_post_reaction
integer
Event responses (unique)unique_actions_rsvp
integer
Credit Spends (unique)unique_actions_credit_spent
integer
Game plays (unique)unique_actions_gamesplays
integer
Landing page views (unique)unique_actions_landing_page_view
integer
Leads (Form) (unique)unique_actions_leadgenother
integer
Mobile app installs (unique)unique_actions_mobile_app_install
integer
Offsite conversion - add to basket (unique)unique_actions_offsite_conversionfb_pixel_add_to_cart
integer
Mobile app - add to cart (unique)unique_actions_app_custom_eventfb_mobile_add_to_cart
integer
Offsite conversion - add to wishlist (unique)unique_actions_offsite_conversionfb_pixel_add_to_wishlist
integer
Offsite conversion - lead (unique)unique_actions_offsite_conversionfb_pixel_lead
integer
Offsite conversion - custom (unique)unique_actions_offsite_conversionfb_pixel_custom
integer
Offsite conversion - purchases (unique)unique_actions_offsite_conversionfb_pixel_purchase
integer
Offsite conversion - initiated checkouts (unique)unique_actions_offsite_conversionfb_pixel_initiate_checkout
integer
Offsite conversion - completed registrations (unique)unique_actions_offsite_conversionfb_pixel_complete_registration
integer
Offsite conversion - view content (unique)unique_actions_offsite_conversionfb_pixel_view_content
integer
Video clicks to play (unique)unique_actions_video_play
integer
Video views (unique)unique_actions_video_view
integer
App engagement (unique)unique_actions_app_engagement
integer
App story (unique)unique_actions_app_story
integer
Page story (unique)unique_actions_page_story
integer
Post story (unique)unique_actions_post_story
integer
Offsite conversion (unique)unique_actions_offsite_conversion
integer
Onsite conversion (unique)unique_actions_onsite_conversion
integer
App custom event (unique)unique_actions_app_custom_event
integer
Onsite web app event (unique)unique_actions_onsite_web_app_event
integer
Mobile app retention (unique)unique_actions_mobile_app_retention
integer
Mobile app ROAS (unique)unique_actions_mobile_app_roas
integer
Offsite engagement (unique)unique_actions_offsite_engagement
integer
Store visits with dwell (unique)unique_actions_store_visit_with_dwell
integer
Add to cart (unique)unique_actions_add_to_cart
integer
Onsite app - Add to cart (unique)unique_actions_onsite_app_add_to_cart
integer
Onsite web - Add to cart (unique)unique_actions_onsite_web_add_to_cart
integer
Complete registration (unique)unique_actions_complete_registration
integer
Purchase (unique)unique_actions_purchase
integer
Onsite app - Purchase (unique)unique_actions_onsite_app_purchase
integer
Onsite web - Purchase (unique)unique_actions_onsite_web_purchase
integer
Search (unique)unique_actions_search
integer
View content (unique)unique_actions_view_content
integer
Onsite app - View content (unique)unique_actions_onsite_app_view_content
integer
Onsite web - View content (unique)unique_actions_onsite_web_view_content
integer
Initiate checkout (unique)unique_actions_initiate_checkout
integer
Mobile app - Initiate checkout (unique)unique_actions_app_custom_eventfb_mobile_initiated_checkout
integer
Add payment info (unique)unique_actions_add_payment_info
integer
Add to wishlist (unique)unique_actions_add_to_wishlist
integer
Lead (unique)unique_actions_lead
integer
All unique app installsunique_actions_omni_app_install
integer
All unique purchasesunique_actions_omni_purchase
integer
All unique add to cartunique_actions_omni_add_to_cart
integer
All unique completed registrationsunique_actions_omni_complete_registration
integer
All unique content viewsunique_actions_omni_view_content
integer
All unique searchesunique_actions_omni_search
integer
All unique initiated checkoutsunique_actions_omni_initiated_checkout
integer
All unique unlocked achievementsunique_actions_omni_achievement_unlocked
integer
All unique app activationsunique_actions_omni_activate_app
integer
All unique level achievedunique_actions_omni_level_achieved
integer
All unique ratesunique_actions_omni_rate
integer
All unique spend creditsunique_actions_omni_spend_credits
integer
All unique tutorial completionsunique_actions_omni_tutorial_completion
integer
All unique custom actionsunique_actions_omni_custom
integer
Total Contacts (unique)unique_actions_contact_total
integer
Website Contacts (unique)unique_actions_contact_website
integer
Mobile App Contacts (unique)unique_actions_contact_mobile_app
integer
Offline contacts (unique)unique_actions_contact_offline
integer
Total Location Searches (unique)unique_actions_find_location_total
integer
Website Location Searches (unique)unique_actions_find_location_website
integer
Mobile App Location Searches (unique)unique_actions_find_location_mobile_app
integer
Offline App Location Searches (unique)unique_actions_find_location_offline
integer
Outbound clicks (unique)unique_outbound_clicks_outbound_click
integer
Outbound Clicks CTR (unique)unique_outbound_clicks_ctr_outbound_click
float
App installs (value)action_values_app_install
integer
App uses (value)action_values_app_use
integer
Checkins (value)action_values_checkin
integer
Post comments (value)action_values_comment
integer
Credit Spends (value)action_values_credit_spent
integer
Post like (value)action_values_post_like
integer
Post engagement (value)action_values_post_engagement
integer
Game plays (value)action_values_gamesplays
integer
Landing page views (value)action_values_landing_page_view
integer
Leads - Form (value)action_values_leadgenother
integer
Page likes (value)action_values_like
integer
Link clicks (value)action_values_link_click
integer
Mobile app installs (value)action_values_mobile_app_install
integer
Leads (value)action_values_lead
integer
Offsite conversion - adds payment info (value)action_values_offsite_conversionfb_pixel_add_payment_info
integer
Mobile app - adds payment info (value)action_values_app_custom_eventfb_mobile_add_payment_info
integer
Offsite conversion - add to basket (value)action_values_offsite_conversionfb_pixel_add_to_cart
integer
Offsite conversion - adds to wishlist (value)action_values_offsite_conversionfb_pixel_add_to_wishlist
integer
Offsite conversion - completed registrations (value)action_values_offsite_conversionfb_pixel_complete_registration
integer
Mobile app - completed registrations (value)action_values_app_custom_eventfb_mobile_complete_registration
integer
Offsite conversion - custom (value)action_values_offsite_conversionfb_pixel_custom
integer
Offsite conversion - initiated checkouts (value)action_values_offsite_conversionfb_pixel_initiate_checkout
integer
Mobile app - initiated checkouts (value)action_values_app_custom_eventfb_mobile_initiated_checkout
integer
Offsite conversion - lead (value)action_values_offsite_conversionfb_pixel_lead
integer
Offsite conversion - purchases (value)action_values_offsite_conversionfb_pixel_purchase
integer
Offline conversion - purchase (value)action_values_offline_conversionpurchase
integer
Offsite conversion - searches (value)action_values_offsite_conversionfb_pixel_search
integer
Offsite conversion - view content (value)action_values_offsite_conversionfb_pixel_view_content
integer
On-site conversion - flow complete (value)action_values_onsite_conversionflow_complete
integer
On-site conversion - lead grouped (value)action_values_onsite_conversionlead_grouped
integer
On-site conversion - messaging conversation block (value)action_values_onsite_conversionmessaging_block
integer
On-site conversion - messaging conversation start (value)action_values_onsite_conversionmessaging_conversation_started_7d
integer
On-site conversion - messaging conversation new (value)action_values_onsite_conversionmessaging_first_reply
integer
On-site conversion - post save (value)action_values_onsite_conversionpost_save
integer
On-site conversion - purchase (value)action_values_onsite_conversionpurchase
integer
Photo view (value)action_values_photo_view
integer
Post shares (value)action_values_post
integer
Post reaction (value)action_values_post_reaction
integer
RSVP (value)action_values_rsvp
integer
Video views (value)action_values_video_view
integer
App engagement (value)action_values_app_engagement
integer
App story (value)action_values_app_story
integer
Page engagement (value)action_values_page_engagement
integer
Page story (value)action_values_page_story
integer
Post story (value)action_values_post_story
integer
Offsite conversion (value)action_values_offsite_conversion
integer
Onsite conversion (value)action_values_onsite_conversion
integer
App custom event (value)action_values_app_custom_event
integer
Onsite web app event (value)action_values_onsite_web_app_event
integer
Mobile app retention (value)action_values_mobile_app_retention
integer
Mobile app ROAS (value)action_values_mobile_app_roas
integer
Offsite engagement (value)action_values_offsite_engagement
integer
Store visits with dwell (value)action_values_store_visit_with_dwell
integer
Add to cart (value)action_values_add_to_cart
integer
Mobile add to cart (value)action_values_app_custom_eventfb_mobile_add_to_cart
integer
Onsite app - Add to cart (value)action_values_onsite_app_add_to_cart
integer
Onsite web - Add to cart (value)action_values_onsite_web_add_to_cart
integer
Complete registration (value)action_values_complete_registration
integer
Purchase (value)action_values_purchase
integer
Mobile app - Purchase (value)action_values_app_custom_eventfb_mobile_purchase
integer
Onsite app - Purchase (value)action_values_onsite_app_purchase
integer
Onsite web - Purchase (value)action_values_onsite_web_purchase
integer
Search (value)action_values_search
integer
View content (value)action_values_view_content
integer
Onsite app - View content (value)action_values_onsite_app_view_content
integer
Onsite web - View content (value)action_values_onsite_web_view_content
integer
Initiate checkout (value)action_values_initiate_checkout
integer
Add payment info (value)action_values_add_payment_info
integer
Add to wishlist (value)action_values_add_to_wishlist
integer
All app installs (value)action_values_omni_app_install
integer
All purchases value (value)action_values_omni_purchase
integer
All add to cart (value)action_values_omni_add_to_cart
integer
All completed registrations (value)action_values_omni_complete_registration
integer
All content views (value)action_values_omni_view_content
integer
All searches (value)action_values_omni_search
integer
All initiated checkouts (value)action_values_omni_initiated_checkout
integer
All unlocked achievements (value)action_values_omni_achievement_unlocked
integer
All app activations (value)action_values_omni_activate_app
integer
All level achieved (value)action_values_omni_level_achieved
integer
All rates (value)action_values_omni_rate
integer
All spend credits (value)action_values_omni_spend_credits
integer
All tutorial completions (value)action_values_omni_tutorial_completion
integer
All custom actions (value)action_values_omni_custom
integer
Trials started total (value)action_values_start_trial_total
integer
Website trials started (value)action_values_start_trial_website
integer
Mobile app trials started (value)action_values_start_trial_mobile_app
integer
Offline trials started (value)action_values_start_trial_offline
integer
Total Contacts (value)action_values_contact_total
integer
Website Contacts (value)action_values_contact_website
integer
Mobile App Contacts (value)action_values_contact_mobile_app
integer
Offline contacts (value)action_values_contact_offline
integer
Total Location Searches (value)action_values_find_location_total
integer
Website Location Searches (value)action_values_find_location_website
integer
Mobile App Location Searches (value)action_values_find_location_mobile_app
integer
Offline App Location Searches (value)action_values_find_location_offline
integer
Customized Product Total (value)action_values_customize_product_total
float
Mobile app - add to wishlist (value)action_values_app_custom_eventfb_mobile_add_to_wishlist:
float
Impressionsimpressions
integer
Full view impressionsfull_view_impressions
integer
Reachreach
integer
Frequencyfrequency
float
Full view reachfull_view_reach
float
Quality rankingquality_ranking
string
Engagement rate rankingengagement_rate_ranking
string
Conversion rate rankingconversion_rate_ranking
string
Instant experience clicks to openinstant_experience_clicks_to_open
float
Instant experience clicks to startinstant_experience_clicks_to_start
float
Instant experience outbound clicksinstant_experience_outbound_clicks
float
Canvas average view percentcanvas_avg_view_percent
float
Canvas average view timecanvas_avg_view_time
float
CTRctr
float
Unique CTRunique_ctr
float
Inline Link Click CTRinline_link_click_ctr
float
Outbound Clicks CTRoutbound_clicks_ctr_outbound_click
float
Spendspend
float
CPMcpm
float
CPCcpc
float
CPPcpp
float
Social Spendsocial_spend
float
Cost per inline link clickcost_per_inline_link_click
float
Cost per inline post engagementcost_per_inline_post_engagement
float
Cost per unique clickcost_per_unique_click
float
Cost per unique inline link clickcost_per_unique_inline_link_click
float
Cost per unique outbound clickcost_per_unique_outbound_click_outbound_click
float
Cost per outbound clickcost_per_outbound_click_outbound_click
float
Cost per app usecost_per_action_type_app_use
float
Cost per event responsecost_per_action_type_rsvp
float
Cost per app installcost_per_action_type_app_install
float
Cost per checkincost_per_action_type_checkin
float
Cost per post commentcost_per_action_type_comment
float
Cost per post likecost_per_action_type_post_likes
float
Cost per credit spendcost_per_action_type_credit_spent
float
Cost per link clickcost_per_action_type_link_click
float
Cost per page likecost_per_action_type_like
float
Cost per page mentioncost_per_action_type_mention
float
Cost per post sharescost_per_action_type_post
float
Cost per post dwellcost_per_action_type_dwell
float
Cost per page engagementcost_per_action_type_page_engagement
float
Cost per post engagementcost_per_action_type_post_engagement
float
Cost per landing page viewcost_per_action_type_landing_page_view
float
Cost per commerce add to basketcost_per_action_type_commerce_event_add_to_cart
float
Cost per commerce purchasecost_per_action_type_commerce_event_purchase
float
Cost per commerce message to buycost_per_action_type_commerce_event_message_to_buy
float
Cost per commerce product viewcost_per_action_type_commerce_event_view_content
float
Cost per offsite conversion - adds payment infocost_per_action_type_offsite_conversionfb_pixel_add_payment_info
integer
Cost per offsite conversion - adds to basketcost_per_action_type_offsite_conversionfb_pixel_add_to_cart
integer
Cost per offsite conversion - adds to wishlistcost_per_action_type_offsite_conversionfb_pixel_add_to_wishlist
integer
Cost per offsite conversion - completed registrationscost_per_action_type_offsite_conversionfb_pixel_complete_registration
integer
Cost per offsite conversion - customcost_per_action_type_offsite_conversionfb_pixel_custom
integer
Cost per offsite conversion - initiated checkoutscost_per_action_type_offsite_conversionfb_pixel_initiate_checkout
integer
Cost per offsite conversion - leadcost_per_action_type_offsite_conversionfb_pixel_lead
integer
Cost per offsite conversion - purchasescost_per_action_type_offsite_conversionfb_pixel_purchase
integer
Cost per offsite conversion - searchescost_per_action_type_offsite_conversionfb_pixel_search
integer
Cost per offsite conversion - view contentcost_per_action_type_offsite_conversionfb_pixel_view_content
integer
Cost per on-site conversion conversion - flow completecost_per_action_type_onsite_conversionflow_complete
integer
Cost per on-site conversion - messaging conversation blockcost_per_action_type_onsite_conversionmessaging_block
integer
Cost per on-site conversion - messaging conversation startcost_per_action_type_onsite_conversionmessaging_conversation_started_7d
integer
Cost per on-site conversion - messaging conversations newcost_per_action_type_onsite_conversionmessaging_first_reply
integer
Cost per on-site conversion - post savecost_per_action_type_onsite_conversionpost_save
integer
Cost per on-site conversion - purchasecost_per_action_type_onsite_conversionpurchase
integer
Cost per video clicks to playcost_per_action_type_video_play
float
Cost per video viewcost_per_action_type_video_view
float
Cost per app engagementcost_per_action_type_app_engagement
float
Cost per app storycost_per_action_type_app_story
float
Cost per page storycost_per_action_type_page_story
float
Cost per post storycost_per_action_type_post_story
float
Cost per offsite conversioncost_per_action_type_offsite_conversion
float
Cost per onsite conversioncost_per_action_type_onsite_conversion
float
Cost per app custom eventcost_per_action_type_app_custom_event
float
Cost per onsite web app eventcost_per_action_type_onsite_web_app_event
float
Cost per mobile app retentioncost_per_action_type_mobile_app_retention
float
Cost per mobile app ROAScost_per_action_type_mobile_app_roas
float
Cost per offsite engagementcost_per_action_type_offsite_engagement
float
Cost per store visits with dwellcost_per_action_type_store_visit_with_dwell
float
Cost per add to cartcost_per_action_type_add_to_cart
float
Cost per onsite app - Add to cartcost_per_action_type_onsite_app_add_to_cart
float
Cost per onsite web - Add to cartcost_per_action_type_onsite_web_add_to_cart
float
Cost per complete registrationcost_per_action_type_complete_registration
float
Cost per purchasecost_per_action_type_purchase
float
Cost per onsite app - Purchasecost_per_action_type_onsite_app_purchase
float
Cost per onsite web - Purchasecost_per_action_type_onsite_web_purchase
float
Cost per searchcost_per_action_type_search
float
Cost per view contentcost_per_action_type_view_content
float
Cost per onsite app - View contentcost_per_action_type_onsite_app_view_content
float
Cost per onsite web - View contentcost_per_action_type_onsite_web_view_content
float
Cost per initiate checkoutcost_per_action_type_initiate_checkout
float
Cost per add payment infocost_per_action_type_add_payment_info
float
Cost per add to wishlistcost_per_action_type_add_to_wishlist
float
Cost per leadcost_per_action_type_lead
float
Cost per All app installscost_per_action_type_omni_app_install
float
Cost per All app activationscost_per_action_type_omni_activate_app
float
Cost per All purchasescost_per_action_type_omni_purchase
float
Cost per All custom actionscost_per_action_type_omni_custom
float
Cost per thruplaycost_per_thruplay_video_view
float
Cost per contactcost_per_action_type_contact_total
float
Cost per website contactcost_per_action_type_contact_website
float
Cost per mobile app contactcost_per_action_type_contact_mobile_app
float
Cost per offline contactcost_per_action_type_contact_offline
float
Cost per location searchcost_per_action_type_find_location_total
float
Cost per website location searchcost_per_action_type_find_location_website
float
Cost per mobile app location searchcost_per_action_type_find_location_mobile_app
float
Cost per offline app location searchcost_per_action_type_find_location_offline
float
Cost per total customized productcost_per_action_type_customize_product_total
float
Cost per unique app activationcost_per_unique_action_type_omni_activate_app
float
Cost per unique landing page viewcost_per_unique_action_type_landing_page_view
float
ROAS link click (website)website_purchase_roas_link_click
float
ROAS like (website)website_purchase_roas_like
float
ROAS mention (website)website_purchase_roas_mention
float
ROAS post (website)website_purchase_roas_post
float
ROAS landing page view (website)website_purchase_roas_landing_page_view
float
ROAS comment (website)website_purchase_roas_comment
float
ROAS post reaction (website)website_purchase_roas_post_reaction
float
ROAS photo view (website)website_purchase_roas_photo_view
float
ROAS video view (website)website_purchase_roas_video_view
float
ROAS post engagement (website)website_purchase_roas_post_engagement
float
ROAS page enga (website)website_purchase_roas_page_engagement
float
ROAS post save (website)website_purchase_roas_onsite_conversionpost_save
float
ROAS FB pixel custom (website)website_purchase_roas_offsite_conversionfb_pixel_custom
float
ROAS FB pixel lead (website)website_purchase_roas_offsite_conversionfb_pixel_lead
float
ROAS FB pixel purchase (website)website_purchase_roas_offsite_conversionfb_pixel_purchase
float
ROAS All purchases (all)purchase_roas_omni_purchase
float
ROAS link click (all)purchase_roas_link_click
float
ROAS like (all)purchase_roas_like
float
ROAS post (all)purchase_roas_post
float
ROAS landing page view (all)purchase_roas_landing_page_view
float
ROAS comment (all)purchase_roas_comment
float
ROAS post reaction (all)purchase_roas_post_reaction
float
ROAS photo view (all)purchase_roas_photo_view
float
ROAS video view (all)purchase_roas_video_view
float
ROAS post engagement (all)purchase_roas_post_engagement
float
ROAS page enga (all)purchase_roas_page_engagement
float
ROAS post save (all)purchase_roas_onsite_conversionpost_save
float
ROAS FB pixel custom (all)purchase_roas_offsite_conversionfb_pixel_custom
float
ROAS FB pixel lead (all)purchase_roas_offsite_conversionfb_pixel_lead
float
Video 2 sec Continuous watchedvideo_continuous_2_sec_watched_actions_video_view
float
Video 30 sec watchedvideo_30_sec_watched_actions_video_view
float
Video average time watchedvideo_avg_time_watched_actions_video_view
float
Video 100% watchedvideo_p100_watched_actions_video_view
float
Video 25% watchedvideo_p25_watched_actions_video_view
float
Video 50% watchedvideo_p50_watched_actions_video_view
float
Video 75% watchedvideo_p75_watched_actions_video_view
float
Video 95% watchedvideo_p95_watched_actions_video_view
float
Video playedvideo_play_actions_video_view
float
FB Pixel Custom - Time on page at least 10 seconds (value)conversions_offsite_conversionfb_pixel_customTimeOnPageAtLeast10Seconds
integer
FB Pixel Custom - Buy Now Open (value)conversions_offsite_conversionfb_pixel_customBuyNowOpen
integer
FB Pixel Custom - Buy Now Retailer (value)conversions_offsite_conversionfb_pixel_customBuyNowRetailer
integer
FB Pixel Custom - Pages per session (value)conversions_offsite_conversionfb_pixel_customPagesPerSession
integer
FB Pixel Custom - Time on page (value)conversions_offsite_conversionfb_pixel_customTimeOnPage
integer
FB Pixel Custom - Time on page less than 10 (value)conversions_offsite_conversionfb_pixel_customTimeOnPageLessThan10
integer
Conversion trials started total (count)conversions_start_trial_total
integer
Conversion website trials started (count)conversions_start_trial_website
integer
Conversion mobile app trials started (count)conversions_start_trial_mobile_app
integer
Conversion offline trials started (count)conversions_start_trial_offline
integer
Conversion total appointments scheduled (count)conversions_schedule_total
integer
Conversion website appointments scheduled (count)conversions_schedule_website
integer
Conversion mobile app appointments scheduled (count)conversions_schedule_mobile_app
integer
Conversion offline app appointments scheduled (count)conversions_schedule_offline
integer
Conversion Contacts (count)conversions_contact_total
integer
Conversion Website Contacts (count)conversions_contact_website
integer
Conversion Mobile App Contacts (count)conversions_contact_mobile_app
integer
Conversion Offline Contacts (count)conversions_contact_offline
integer
Conversion Total Location Searches (count)conversions_find_location_total
integer
Conversion Website Location Searches (count)conversions_find_location_website
integer
Conversion Mobile App Location Searches (count)conversions_find_location_mobile_app
integer
Conversion Offline App Location Searches (count)conversions_find_location_offline
integer
Conversion Leads (count)conversions_lead
integer
Conversion Landing Page Views (count)conversions_landing_page_view
integer
Conversion Subscribe Website (count)conversions_subscribe_website
integer
Conversion Subscribe Total (count)conversions_subscribe_total
integer
Conversion Subscribe Mobile App (count)conversions_subscribe_mobile_app
integer
Conversion Total Submitted Applications (count)conversions_submit_application_total
integer
Conversion Website Submitted Applications (count)conversions_submit_application_website
integer
Conversion Mobile App Submitted Applications (count)conversions_submit_application_mobile_app
integer
Conversion Offline Submitted Applications (count)conversions_submit_application_offline
integer
Conversion Offline App Location Searches (count)conversions_submit_application_on_facebook
integer
Conversion Mobile App - add payment info (count)conversions_app_custom_eventfb_mobile_add_payment_info
integer
Conversion Mobile App - add to cart (count)conversions_app_custom_eventfb_mobile_add_to_cart
integer
Conversion Mobile App - initiated checkout (count)conversions_app_custom_eventfb_mobile_initiated_checkout
integer
Conversion Mobile App - Purchase (count)conversions_app_custom_eventfb_mobile_purchase
integer
Conversion Mobile App - completed registrations (count)conversions_app_custom_eventfb_mobile_complete_registration
integer
Conversion trials started total (value)conversion_values_start_trial_total
integer
Conversion website trials started (value)conversion_values_start_trial_website
integer
Conversion mobile app trials started (value)conversion_values_start_trial_mobile_app
integer
Conversion offline trials started (value)conversion_values_start_trial_offline
integer
Conversion total appointments scheduled (value)conversion_values_schedule_total
integer
Conversion website appointments scheduled (value)conversion_values_schedule_website
integer
Conversion mobile app appointments scheduled (value)conversion_values_schedule_mobile_app
integer
Conversion offline app appointments scheduled (value)conversion_values_schedule_offline
integer
Conversion Contacts (value)conversion_values_contact_total
integer
Conversion Website Contacts (value)conversion_values_contact_website
integer
Conversion Mobile App Contacts (value)conversion_values_contact_mobile_app
integer
Conversion Offline Contacts (value)conversion_values_contact_offline
integer
Conversion Total Location Searches (value)conversion_values_find_location_total
integer
Conversion Website Location Searches (value)conversion_values_find_location_website
integer
Conversion Mobile App Location Searches (value)conversion_values_find_location_mobile_app
integer
Conversion Offline App Location Searches (value)conversion_values_find_location_offline
integer
Conversion lead (value)conversion_values_lead
integer
Conversion landing page view (value)conversion_values_landing_page_view
integer
Conversion website subscription (value)conversion_values_subscribe_website
float
Conversion subscription total (value)conversion_values_subscribe_total
float
Conversion mobile app subscription (value)conversion_values_subscribe_mobile_app
float
Conversion Total Submitted Applications (value)conversion_values_submit_application_total
float
Conversion Website Submitted Applications (value)conversion_values_submit_application_website
float
Conversion Mobile App Submitted Applications (value)conversion_values_submit_application_mobile_app
float
Conversion Offline Submitted Applications (value)conversion_values_submit_application_offline
float
Conversion Offline Facebook Submitted Applications (value)conversion_values_submit_application_on_facebook
float
Conversion Customized Product Total (value)conversion_values_customize_product_total
float
Conversion Mobile App - add to wishlist (value)conversion_values_app_custom_eventfb_mobile_add_to_wishlist
float
Conversion Mobile App - add payment info (value)conversion_values_app_custom_eventfb_mobile_add_payment_info
float
Conversion Mobile App - add to cart (value)conversion_values_app_custom_eventfb_mobile_add_to_cart
float
Conversion Mobile App - checkout initiated (value)conversion_values_app_custom_eventfb_mobile_initiated_checkout
float
Conversion Mobile App - Purchase (value)conversion_values_app_custom_eventfb_mobile_purchase
float
Conversion Mobile App - completed registrations (value)conversion_values_app_custom_eventfb_mobile_complete_registration
float
Cost per conversion trials started totalcost_per_conversion_start_trial_total
float
Cost per conversion website trials startedcost_per_conversion_start_trial_website
float
Cost per conversion mobile app trials startedcost_per_conversion_start_trial_mobile_app
float
Cost per conversion offline trials startedcost_per_conversion_start_trial_offline
float
Cost per conversion total appointments scheduledcost_per_conversion_schedule_total
float
Cost per conversion website appointments scheduledcost_per_conversion_schedule_website
float
Cost per conversion mobile app appointments scheduledcost_per_conversion_schedule_mobile_app
float
Cost per conversion offline app appointments scheduledcost_per_conversion_schedule_offline
float
Cost per conversion contactcost_per_conversion_contact_total
integer
Cost per conversion website contactcost_per_conversion_contact_website
integer
Cost per conversion mobile app contactscost_per_conversion_contact_mobile_app
integer
Cost per conversion offline contactscost_per_conversion_contact_offline
integer
Cost per conversion total location searchescost_per_conversion_find_location_total
integer
Cost per conversion website location searchescost_per_conversion_find_location_website
integer
Cost per conversion mobile app location searchescost_per_conversion_find_location_mobile_app
integer
Cost per conversion offline app location searchescost_per_conversion_find_location_offline
integer
Cost per conversion leadcost_per_conversion_lead
integer
Cost per conversion landing page viewcost_per_conversion_landing_page_view
integer
Cost per website subscriptioncost_per_conversion_subscribe_website
float
Cost per subscriptioncost_per_conversion_subscribe_total
float
Cost per mobile app subscriptioncost_per_conversion_subscribe_mobile_app
float
Cost per Conversion Total Submitted Applicationscost_per_conversion_submit_application_total
float
Cost per Conversion Website Submitted Applicationscost_per_conversion_submit_application_website
float
Cost per Conversion Mobile App Submitted Applicationscost_per_conversion_submit_application_mobile_app
float
Cost per Conversion Offline Submitted Applicationscost_per_conversion_submit_application_offline
float
Cost per Conversion Facebook Submitted applicationscost_per_conversion_submit_application_on_facebook
float
Cost per estimated ad recallerscost_per_estimated_ad_recallers
float
Estimated ad recall rateestimated_ad_recall_rate
float
Estimated ad recallersestimated_ad_recallers
integer
Video thruplaysvideo_thruplay_watched_actions_video_view
integer
Outbound clicks (count)outbound_clicks_outbound_click
integer

Need a dataset, metric, or attribute you don't see?

Tell us what's missing and we'll add it to the connector.

Request it

Runs on your schedule with a relative date range that moves forward on every run. The Facebook Ads API returns up to 37 months of history, loaded in batches of up to 90 days.

Facebook Ads connector →
Benchmark

More right answers. Half the confident mistakes.

We asked 43 pre-registered questions of three real datasets - Google Search Console, HubSpot deals and Google Ads - and delivered the same rows to the same model in four ways. Only the data layer changed.

78.5%

of questions answered correctly - the best of the four delivery methods tested

2x

fewer confidently wrong answers - 14.0% of runs against 24.0% and 26.3%

2.8x

more correct answers on messy CRM data - better on 8 questions, worse on none

Answered correctly All 43 questions - higher is better
Wrong, but stated as fact Share of runs - lower is better

Same model, prompts and rows in every condition; 759 graded runs, ground truth frozen before any run. On Google Search Console alone, documented CSV files did as well as Data to AI™ - the advantage comes from messier data such as HubSpot deals.

Read the benchmark →
FAQ

Facebook Ads and ChatGPT: FAQ

How do I connect Facebook Ads to ChatGPT?

Sync Facebook Ads Insights, Campaigns Insights and Age Gender Breakdowns Ad Insights with a Dataddo source and attach them to a ChatGPT destination or AI Model. Switch on developer mode in ChatGPT, create the Dataddo Data Access app with https://headless.dataddo.com/mcp-data and OAuth, then select it from the + menu.

Which ChatGPT plans can read Facebook Ads data from Dataddo?

Pro, Plus, Business, Enterprise and Education, because the connection uses developer mode, which runs on ChatGPT web only. On Business and Enterprise an admin may need to allow it first.

Why does ChatGPT ask me to confirm each Facebook Ads lookup?

ChatGPT confirms every tool call in developer mode. You see each query against your ad data before it runs, and you can switch off Dataddo tools you do not want ChatGPT to use.

Can ChatGPT tell me if the Facebook Ads data is current?

Yes. Ask it to run data_status for freshness and known_gaps for anything the data does not cover. That is useful for pacing questions, where yesterday's Spend must already be in the flow.

Is this the same as uploading an Ads Manager export to ChatGPT?

No. An upload is a one-off file. Here Dataddo refreshes the Facebook Ads source on its schedule, and ChatGPT queries the current data by field name through the semantic layer.

Why do I get no data for some Facebook Ads breakdowns?

The Facebook Ads API does not allow every breakdown combination, so Dataddo only offers valid ones. If a supported combination is missing, contact the Dataddo Solutions team.

Can ChatGPT compare several Facebook ad accounts?

Yes, if they are in the extracted data. Multi-account extraction pulls the same datasets from every ad account you can access. Contact the Dataddo Solutions team to turn it on for your Facebook Ads source.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.

Start Free