X Ads Connector to API

X Ads Endpoints

Documentation

10 X Ads endpoints you can import. Each lands in its own table in your warehouse.

• Accounts

  Advertising accounts — name, business, country, timezone, and approval status.

  12 fields

• Ad Performance

  Daily ad performance by placement — impressions, clicks, spend, engagements, and social actions.

  20 fieldsTime series

• Ad Performance by Country

  Daily ad performance broken down by country — impressions, clicks, spend, engagements, and social actions.

  21 fieldsTime series

• All Cards

  All card types with full creative details — type, title, destination URL, call to action, and media.

  28 fields

• Campaigns

  Your campaigns — status, budget optimization, daily and total budget, and currency.

  19 fields

• Cards

  Website and app cards — type, URI, and components.

  8 fields

• Line Items

  Line items within campaigns — bid strategy, goal, product type, budget, and schedule.

  33 fields

• Promoted Tweets

  Tweets promoted as ads — status, approval, and links to their tweets and line items.

  8 fields

• Targeting Locations

  Reference table of location IDs with names and country codes — join targeting_value with the country field in Ad Performance by Country.

  4 fields

• Tweets

  Original tweets used as ad creatives — text, type, language, engagement counts, and card URI.

  34 fields