Skip to content
OWOX Data Marts

How to Import Data from the Facebook Ads Source

To begin importing data from Facebook Ads, start by making a copy of one of the following templates:

Fill in the required information:

  • Account IDs
  • Fields
  • Destination Dataset ID (for Google BigQuery template)
  • Destination Location (for Google BigQuery template)

You can find your Account ID on the Account Overview page in Meta Ads Manager.

Facebook Account ID

Copy and paste the ID into the spreadsheet:

Account ID

Some fields are pre-filled by default.
To include additional fields, go to the Fields tab and check the boxes next to the fields you want to include.

Facebook Fields

If you’re using the Google BigQuery template, also provide:

  • Destination Dataset ID in the format: projectid.datasetid
  • Destination Location

ℹ️ If the specified dataset doesn’t exist, it will be created automatically.

Facebook Dataset

Open the menu: OWOX → Manage Credentials

Facebook Credentials

Enter your credentials obtained by following this guide: How to obtain the access token for the Facebook connector

Facebook Token

Now you have two options for importing data from Facebook Ads:

Option 1: Import Current Day’s Data

Choose OWOX → Import New Data to load data for the current day.

Facebook Import New Data

ℹ️ If you click Import New Data 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.

Facebook Reimport

Option 2: Manual Backfill for Specific Date Range

Choose Manual Backfill to load historical data for a custom time range.

Facebook Backfill

  1. Select the Start Date and End Date
  2. Click the Run Manual Backfill button

Facebook Run Backfill

The process is complete when the Log field shows the message:
“Import is finished”

Access Your Data:

  • In the Google Sheets template, the data will appear in new tabs labeled with the corresponding data types (e.g., ad-account, ad-campaign).

Facebook Import Success Sheets

  • In the Google BigQuery template, the data will be written to the dataset specified earlier.

Facebook Import Success

To import more data:

  1. Select the additional fields you need in the Fields tab.
  2. Go to OWOX → Import New Data or OWOX → Run Manual Backfill again.

If you encounter any issues:

  1. Check the “Logs” sheet for specific error messages
  2. Please visit Q&A first
  3. If you want to report a bug, please open an issue
  4. Join the discussion forum to ask questions or propose improvements