Skip to main content

Meta Ads ingestion connector reference

Beta

The Meta Ads connector is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This article contains reference material for the Meta Ads ingestion connector in Databricks Lakeflow Connect.

Automatic data transformations

Databricks transforms Meta Ads data types to Delta-compatible data types as follows:

Meta Ads Type

Delta Type

string

String

int

Integer

long

Long

float

Float

double

Double

boolean

Boolean

datetime

Timestamp

date

Date

list

Array

map

Map

enum

String

Supported objects

The Meta Ads connector supports ingesting the following objects:

Object

Description

ads

Individual ads in your campaigns

ad_sets

Ad sets that group ads together with shared targeting, budget, and schedule settings

campaigns

Top-level campaign objects that contain ad sets

ad_images

Image assets used in ads

ad_insights

Performance metrics and analytics data for ads, ad sets, campaigns, or accounts

ad_creatives

Creative elements (images, videos, text) used in ads

custom_audiences

Custom audience definitions for targeting

ad_videos

Video assets used in ads

custom_conversions

Custom conversion event definitions

ad_insights configuration options

The ad_insights object supports additional configuration options for analyzing performance data.

Granularity levels

Specify the level at which to retrieve performance metrics:

  • account: Account-level metrics
  • campaign: Campaign-level metrics
  • ad_set: Ad set-level metrics
  • ad: Ad-level metrics (default)

Breakdown dimensions

Configure breakdown dimensions to segment performance data:

  • age: Age ranges
  • gender: Gender
  • country: Country
  • region: Geographic region
  • dma: Designated Market Area (US only)
  • device_platform: Device platform (mobile, desktop, etc.)
  • placement: Ad placement location
  • publisher_platform: Publisher platform (Facebook, Audience Network, etc.)
  • impression_device: Device type for impressions

Action breakdown dimensions

Configure action breakdown dimensions to analyze conversion actions:

  • action_type: Type of conversion action
  • action_destination: Destination of the conversion action
  • action_carousel_card_id: Carousel card identifier
  • action_carousel_card_name: Carousel card name
  • action_video_sound: Video sound setting
  • action_video_type: Video type

Time increment

The connector uses daily time increments. Hourly time increments aren't supported in Beta.

Attribution windows

The connector uses the following fixed attribution windows in Beta:

  • Click attribution window: 7 days
  • View attribution window: 1 day

API versions

The Meta Ads connector uses the Insights API. Databricks keeps the connector up to date with the latest stable API version.

Next steps