How to Import Data from X Ads Source

Before proceeding, please make sure that:

You have created a CREDENTIALS: API Key, API Secret, Access Token, Access Token Secret.
You have set up OWOX Data Marts and created at least one storage in the Storages section.

X Ads Storage

Create the Data Mart

Click New Data Mart.
Enter a title and select the Storage.
Click Create Data Mart.

X Ads New Data Mart

Set Up the Connector

Select Connector as the input source type.
Click Set up connector and choose X Ads.
Fill in the required fields:
- Consumer Key (API Key) and Consumer Secret (API Secret) – available in the Consumer Keys section of your X Ads app.
- Access Token and Access Token Secret – available in the Authentication Tokens section of your X Ads app.
- Account ID – you can get this ID on https://ads.x.com and look at the URL of your account. For example, in this link: https://ads.x.com/campaign_form/18ce55in6wt/campaign/new the Account ID is: 18ce55in6wt
Leave all other fields as default and proceed to the next step.

X Ads Input Source

X Ads Fill Data

X Ads Account ID

Configure Data Import

Choose one of the available endpoints.
Select the required fields.
Specify the dataset where the data will be stored (or leave the default).
Click Finish, then Save and Publish Data Mart.

X Ads Publish Data Mart

Run the Data Mart

You now have two options for importing data from X Ads:

Option 1: Import Current Day’s Data

Choose Manual run → Incremental load to load data for the current day.

X Ads Import New Data

X Ads Incremental Load

ℹ️ If you click Incremental load again after a successful initial load,
the connector will import: Current day’s data, plus Additional days, based on the value in the Reimport Lookback Window field.

X Ads Reimport