Collect Facebook Ads Data into AWS Athena

Own your Facebook Ads data in AWS Athena with OWOX Data Marts. Collect granular, analytics-ready Facebook Ads data into Athena, control schema and refresh logic, and reuse the data across BI tools and AI Insights.

Step 1: Create an AWS Athena Data Storage

Start by connecting AWS Athena as your data storage in OWOX Data Marts.

Choose the AWS Region where Athena runs
Provide an S3 Output Bucket for query results
Add AWS Access Key ID and Secret Access Key for an IAM user with Athena and S3 access

Athena becomes your query layer for Facebook Ads data stored and managed in your AWS environment.

Step 1: Create an AWS Athena Data Storage

Connect AWS Athena

Step 2: Create a Facebook Ads Data Mart

Create a new Data Mart and choose Connector as the definition type.

Select Facebook Ads as the data source
Authorize access to your Facebook Ads account
No API coding or engineering required

This defines what Facebook Ads data you collect.

Add Facebook Ads

Request a demo

Step 3: Select Fields & Configure Data Import

Choose exactly which Facebook Ads data you want to land in AWS Athena.

Select the needed Facebook Ads API endpoint exactly as it appears in the platform API
Pick required fields like impressions, clicks, spend, conversions, and campaign dimensions
Set the destination database/table settings, or keep the defaults

Click Finish, then Publish Data Mart.

Step 3: Select Fields & Configure Data Import

Choose Fields

Step 4: Run & Schedule Facebook Ads Data Collection

Once published, decide how to import data into your storage.

Incremental load to pull the current day’s data
Backfill (custom period) to load historical Facebook Ads data for a specific date range
Track every run in Run History and confirm “Success”

Set a schedule to keep Athena datasets continuously updated.

Run First Import

Request a demo