Table: facebookmarketing_customaudiences

This table shows data for Facebook Marketing Custom Audiences.

https://developers.facebook.com/docs/marketing-api/reference/custom-audience#Reading (opens in a new tab)

The primary key for this table is id.

Columns

NameType
_cq_source_nameutf8
_cq_sync_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
account_idutf8
approximate_count_lower_boundint64
approximate_count_upper_boundint64
customer_file_sourceutf8
data_sourcejson
data_source_typesutf8
datafile_custom_audience_uploading_statusutf8
delete_timeint64
delivery_statusjson
descriptionutf8
excluded_custom_audiencesjson
household_audienceint64
id (PK)utf8
included_custom_audiencesjson
is_householdbool
is_snapshotbool
is_value_basedbool
lookalike_audience_idslist<item: utf8, nullable>
lookalike_specjson
nameutf8
operation_statusjson
opt_out_linkutf8
owner_businessjson
page_deletion_marked_delete_timeint64
permission_for_actionsjson
pixel_idutf8
regulated_audience_specjson
retention_daysint64
rev_share_policy_idint64
ruleutf8
rule_aggregationutf8
rule_v2utf8
seed_audienceint64
sharing_statusjson
subtypeutf8
time_content_updatedint64
time_createdint64
time_updatedint64