# OpenAI Ads + Redshift > Integrate OpenAI Ads campaigns, ads, and conversions with Redshift using Erathos. Centralized, up-to-date advertising data ready for analysis. Source: https://www.erathos.com/en/pipelines/openai-ads-redshift Em português: https://www.erathos.com/pipelines/openai-ads-redshift Erathos consolidates OpenAI Ads data in Redshift, bringing campaigns, ad groups, ads, insights, conversions, and product feeds into your AWS data warehouse as structured tables. Performance metrics such as impressions, clicks, spend, and conversions become ready for large-scale analysis alongside the rest of your AWS stack, with table-level configuration and incremental syncs on insights tables keeping Redshift costs predictable. ## Data in your data warehouse in minutes ### OpenAI Ads connector ready to use Connect OpenAI Ads to Redshift in minutes with our native connector. Campaigns, ad groups, ads, insights, conversions, and product feeds synced automatically, with no code required. Authentication uses a bearer API key generated in Ads Manager, scoped to a single ad account. ### Total control over your OpenAI Ads pipelines Configure schedule, frequency, and sync type at the table level. Insights tables support incremental synchronization with an updated_at cursor, so only new or updated records are processed, keeping Redshift costs low and predictable. ### End-to-end observability Stop finding out about failures only when the business team complains. Every run is logged with runtime, processed rows, and error context. Automatic alerts via Slack, Discord, or email as soon as anything goes off track. ## Consolidating OpenAI Ads data in Redshift has never been easier Erathos is a data ingestion platform built for teams that need reliability, visibility, and control. With the OpenAI Ads connector, you can automatically move campaigns, ad groups, ads, insights, conversions, and product feeds into Redshift, with full observability into every run and zero maintenance. ## FAQ ### How do I connect OpenAI Ads to Redshift with Erathos? Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect their SaaS tools, such as OpenAI Ads, to their data warehouse without the maintenance cost of in-house pipelines or the opacity of traditional ETL tools. To connect, generate a bearer API key from Ads Manager under Settings, Integrations, API Keys, and paste it into the Token field on the Erathos platform. Each key is scoped to a single ad account, so generate it from the account whose data you want to sync. Our customers reduce pipeline maintenance by up to 80%. ### Which OpenAI Ads data does Erathos sync to Redshift? The connector syncs the full advertising structure and performance layer: ad account metadata, campaigns, ad groups, and ads, plus insights at the account, campaign, ad group, and ad levels with metrics such as impressions, clicks, spend, and conversions. It also covers conversion pixels, conversion events, and conversion insights, custom audiences and their operations, product feeds with uploads and product queries, bulk mutation jobs, lead sync subscriptions, and spend limit windows. ### How often does Erathos synchronize OpenAI Ads data to Redshift? You can configure sync frequency at the table level, from every 5 minutes up to once per day. Insights tables support full and incremental refresh, and incremental runs use an updated_at cursor, meaning only new or updated records are processed on each run. That keeps the pipeline efficient and Redshift costs predictable. ### What happens if a synchronization fails? Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full execution context, not just a generic 'job failed' message. Smart retries handle transient errors, and every run is logged so your team can debug in minutes, not hours. ### Is there a free trial period for the OpenAI Ads connector? Yes. Every Erathos connector includes a 14-day free trial. Connect OpenAI Ads to Redshift and start syncing immediately, no credit card required.