Skip to content
OWOX Data Marts

Connector-based Data Mart

Use a connector-based Data Mart when you want to collect data directly from a platform API like Facebook Ads, TikTok Ads, LinkedIn Ads or other available data sources (or your own custom connector) into any of the supported Data Storages.

You’ll need a data storage available for the data mart setup. Here is how to add a data storage

Step 1: Choose the platform

Section titled “Step 1: Choose the platform”

Click + New Data Mart.

Give it a friendly Title, e.g., Facebook Ads | Creatives.

Select the Data Storage from the list.

Click Create Data Mart.

Create Data Mart-1

In the Input Source panel, select Definition Type – Connector. Click Setup Connector.

Create Data Mart-2

Select the platform you want to connect to (e.g., Facebook Ads, TikTok Ads) from the list of available connectors and click Next (or add a custom connector code below).

Create Data Mart-3

Step 2: Configure parameters

Section titled “Step 2: Configure parameters”

Each connector has a set of required parameters. The most common ones include:

ParameterDescription
account_idID of the ad account or business you’re pulling data from
start_dateStart date for the data import
end_dateEnd date for the data import
reimport_lookback_windowHow many days of data to re-import during each run
max_fetching_daysMax days per API call to avoid rate limits
cleanup_to_keep_windowHow many days of data to keep before automatic cleanup

📌 Some connectors may have additional parameters — see their setup guides.

Some parameters use a fixed list of values. Choose these before moving to field selection, especially when the parameter changes the reporting grain. For example, TikTok Ads Data Level changes which fields are required for performance endpoints.

Create Data Mart 4

Step 3: Add Access Credentials

Section titled “Step 3: Add Access Credentials”

Each connector requires authentication. Here is how you can obtain the required credentials for each of the ad platforms:

Use the credentials screen to manage access per platform.

Copy a configuration from another Data Mart

Section titled “Copy a configuration from another Data Mart”

The Copy from… option reuses a connector configuration from another Data Mart, including its stored credentials.

Copying credentials requires Edit access to the source Data Mart. You have it in one of these cases:

  • You are a Project Admin.
  • You are a Technical User and a Technical Owner of the source Data Mart.
  • You are a Technical User, and the source Data Mart is Shared for maintenance.

Without this access, saving the Data Mart fails with this error:

You do not have permission to copy connector credentials from the source Data Mart.

To resolve it, choose one of these options:

  • Ask an owner of the source Data Mart to add you as a Technical Owner.
  • Ask them to turn on Shared for maintenance on the source Data Mart.
  • If you are a Business User, ask a Project Admin to change your role to Technical User.
  • Enter your own credentials instead of copying.

One more check applies when your role scope is Selected contexts only. You also need a context overlap with the source Data Mart. See Ownership and Sharing for the full access model.

Step 4: Customize export schema

Section titled “Step 4: Customize export schema”

Once the connector and parameters are set, click Next to select the node you want to import in this data mart.

Each connector includes one or more data nodes. For example, Facebook Ads has nodes like:

  • ad_accounts
  • ad_accounts/insights
  • ad_accounts/campaigns

👉 Create a separate Data Mart for each node you want to pull data from.

Next, click Select all or select just the fields you want to store in your data warehouse. Required unique-key fields stay selected because the connector needs them to merge data correctly. Some connectors adjust these required fields based on the parameters selected in the previous step.

Create Data Mart 5

Step 5: Set up the target in your storage

Section titled “Step 5: Set up the target in your storage”

Enter dataset name for your data storage (e.g., dataset name for BigQuery) where the connector can load the data. The dataset will be created automatically if it doesn’t exist.

The table name will be created automatically based on the selected node name, for example:
ad_account_adcreatives

Don’t forget to:

  • Click Save in the Data Setup tab
  • Publish the data mart
  • Run the Data Mart manually for the first time

Output Schema Auto-Generated

After the first run, you’ll see that the Output schema was generated automatically.

Each field includes:

  • Name
  • Data type
  • Join key metadata
  • Description

Next, you can add business-friendly names to improve usability later in BI tools as aliases.

Create Data Mart 7

💡 Tip: Add a description to the Data Mart itself so you always know what that is all about.

Create Data Mart 8

Also you can check the Run History tab for logs and results

Section titled “Step 6: Set Triggers (Optional but Recommended)”

You can automate the connector by setting a trigger to run it on a schedule.

  1. Go to the Triggers tab and click + Add Trigger
  2. Choose Trigger Type: Connector Run
  3. Set schedule:
    • Daily → choose time & timezone
    • Weekly → select days of the week, time & timezone
    • Monthly → select dates, time & timezone
    • Interval → e.g., every 15 minutes

What’s Next?

Section titled “What’s Next?”
  • Create reports using this Data Mart
  • Add a destination (Google Sheets, Data Studio, etc.)
  • Explore the data in the Output Schema tab
  • Share it with business users so they can build reports
Section titled “Related Links”