Connect ChatGPT Ads to PostgreSQL

Add ChatGPT Ads using an API key created in Ads Manager, save your PostgreSQL connection details, and pair both systems in a datastream. The connector reads the ad account associated with the key and writes your selected fields to PostgreSQL.

You can select from 7 metrics and 107 dimensions, including spend, impressions, clicks, conversions, CTR, CPC, CPM, account details, campaign budgets, and ad group fields. Catchr lets you rename the selected columns and preview them before writing to PostgreSQL.

Yes. A PostgreSQL job can start with an available historical ChatGPT Ads fetch and continue on a recurring schedule. The supported history and frequency depend on the source API and your Catchr plan.

Choose a valid date dimension when configuring the PostgreSQL job. For each scheduled window, Catchr deletes and rewrites that period to reduce duplicate rows across overlapping loads.

PostgreSQL queries can summarize spend, impressions, clicks, conversions, CTR, CPC, and CPM by account, campaign, or ad group. Agencies and freelancers can expose these results through reusable views for dashboards and client reporting.

Yes. Connect an existing PostgreSQL database first. The Catchr job creates and populates the destination table you configure inside that database.

Yes. Create a separate datastream and job for each source, write each export to its own table, then combine the data downstream with SQL, views, or your BI tool.