X Ads

X Ads

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

Learn more
PostHog Wizard hedgehog

Connect X Ads to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Configuration

OptionTypeRequired
X Ads accountoauthYes
Ad accountoauth-account-selectYes

Linking X Ads to PostHog

  1. Go to the Data pipeline page in PostHog
  2. Click New source and select X Ads
  3. Fill in the required configuration fields
  4. Click Next, select the tables you want to sync, and then press Import

Supported tables

TableDescriptionSync methodIncremental fieldPrimary key
campaigns

An X advertising campaign containing line items and funded by a funding instrument.

Full refresh—id
line_items

An ad group within an X campaign, with its objective, targeting, and bid settings.

Full refresh—id
promoted_tweets

An association between an X Post and the line item that promotes it.

Full refresh—id
funding_instruments

A payment or credit arrangement funding X advertising campaigns.

Full refresh—id
media_creatives

A media creative associated with an X advertising line item.

Full refresh—id
campaign_stats

Daily unsegmented X advertising metrics for a campaign, separated by placement.

Incremental, Full refreshdateentity_id, date, placement
line_item_stats

Daily unsegmented X advertising metrics for a line item, separated by placement.

Incremental, Full refreshdateentity_id, date, placement