Import Data from Facebook Ads

Use this guide to create a Facebook Ads Data Mart.

Before You Start

Check these items before you create the Data Mart:

You have set up OWOX Data Marts.
You have at least one OWOX storage.
You can access the target Facebook ad account.
You know the numeric Facebook Account ID.
You chose an authentication method in Credentials.

For storage setup, see Storage Management.

For a general connector walkthrough, see Connector-based Data Mart.

Create the Data Mart

Click New Data Mart.
Enter a title.
Select a storage.
Click Create Data Mart.

If you have no storage yet, click New Storage. You can create the storage now and configure it later.

OWOX Data Mart creation screen with title and storage fields

Set Up the Connector

Select Connector as the input source type.
Choose Facebook Ads.
Choose your authentication method.

For OAuth, click Continue with Facebook, then sign in with a Facebook user who can access the ad account. If the button does not appear, use the Access Token method.

For manual authentication, fill in these fields:

Access Token: paste the token from Credentials.
App ID: enter your Meta App ID.
App Secret: enter your Meta App Secret.

Then fill in Account IDs. Use numeric ad account IDs only, without the act_ prefix. You can find the ID in Meta Ads Manager under Account Overview. To import from multiple accounts, separate IDs with commas or semicolons. The authorized Facebook user must access every listed account.

Facebook Ads connector setup screen with OAuth and manual authentication options

Facebook Ads connector fields for access token, App ID, App Secret, and Account ID

Facebook Ads connector configuration screen after entering account credentials

Configure Data Import

Choose an endpoint.
Select fields, or keep the defaults.
Enter the target dataset.
Click Finish.
Click Publish & Run Data Mart.

OWOX writes the connector tables into this destination. Your storage sets the field label, such as Dataset for BigQuery or Database for Amazon Redshift. For your storage, see Supported Storages.

For spend, clicks, impressions, conversions, and ROAS, choose Ad Account Insights.

For endpoint details, see Endpoints and Fields.

If OWOX disables Publish & Run Data Mart, check the storage. OWOX cannot publish a Data Mart until the selected storage has valid settings. See Storage Management.

Configure Data Import screen with Facebook Ads endpoint, fields, and dataset settings

Run the Data Mart

You can run the Data Mart manually after setup. You can also schedule connector runs.

Incremental Load

Choose Manual run → Incremental load.

On the first incremental run, OWOX imports data from the first day of the previous month through today. After a successful incremental run, OWOX stores the last requested date. On later incremental runs, OWOX starts from that date minus Reimport Lookback Window. This lookback helps refresh recently changed Facebook Ads metrics.

Manual run menu showing the Incremental load option

Incremental load confirmation dialog for importing the current day's data

Reimport Lookback Window setting for additional days in incremental loads

Backfill

Choose Backfill (custom period) to import a specific date range.

Select Start Date.
Select End Date.
Click Run.

OWOX imports both the start date and the end date. If you leave End Date empty, OWOX uses today.

Backfill dialog with Start Date, End Date, and Run button

Check the Result

Open Run history. The run has finished when the status shows Success.

Run history tab showing a successful Facebook Ads import

You can query the imported tables in the dataset you selected. You can also send the data to a destination. See Destination Management and Google Sheets.

Troubleshooting

If a run fails, open Run history. Then match the Meta error with Troubleshooting.

For credential setup errors, see Credentials.

Support

Check Run history for the exact error.
Search Q&A.
Open an issue to report a bug.
Join the discussion forum.