Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Facebook API Data Model

Navigation: Catalog: V32 > Schemas > Schema: Marketing > Tables

OwnedAdAccountsByBusiness

Contents Previous Home Next More

Name: OwnedAdAccountsByBusiness

Catalog: V32

Schema: Marketing

Parameters: business_id

Parameters

Name

Data Type

Required

Default Value

Documentation

business_id

decimal

 

Business ID.

 

Table Columns

Name

Data Type

Label

Required

Documentation

account_id

decimal

itgen_facebook_account_id

The ID of the ad account.

account_status

int32

itgen_facebook_account_status

Status of the account: 1 = ACTIVE, 2 = DISABLED, 3 = UNSETTLED, 7 = PENDING_RISK_REVIEW, 8 = PENDING_SETTLEMENT, 9 = IN_GRACE_PERIOD, 100 = PENDING_CLOSURE, 101 = CLOSED, 201 = ANY_ACTIVE, 202 = ANY_CLOSED.

age

double

itgen_facebook_age

Amount of time the ad account has been open, in days.

agency_client_declaration_agency_representing_client

int32

itgen_facebook_agency_client_declaration_agency_representing_client

Whether this account is for an agency representing a client.

agency_client_declaration_client_based_in_france

int32

itgen_facebook_agency_client_declaration_client_based_in_france

Whether the client is based in France.

agency_client_declaration_client_city

string

itgen_facebook_agency_client_declaration_client_city

Client's city.

agency_client_declaration_client_country_code

string

itgen_facebook_agency_client_declaration_client_country_code

Client's country code.

agency_client_declaration_client_email_address

string

itgen_facebook_agency_client_declaration_client_email_address

Client's email address.

agency_client_declaration_client_name

string

itgen_facebook_agency_client_declaration_client_name

Name of the client.

agency_client_declaration_client_postal_code

string

itgen_facebook_agency_client_declaration_client_postal_code

Client's postal code.

agency_client_declaration_client_province

string

itgen_facebook_agency_client_declaration_client_province

Client's province.

agency_client_declaration_client_street

string

itgen_facebook_agency_client_declaration_client_street

First line of client's street address.

agency_client_declaration_client_street2

string

itgen_facebook_agency_client_declaration_client_street2

Second line of client's street address.

agency_client_declaration_has_written_mandate_from_advertiser

int32

itgen_facebook_agency_client_declaration_has_written_mandate_from_advertiser

Whether the agency has a written mandate to advertise on behalf of this client.

agency_client_declaration_is_client_paying_invoices

int32

itgen_facebook_agency_client_declaration_is_client_paying_invoices

Whether the client is paying via invoice.

amount_spent

decimal

itgen_facebook_amount_spent

Current total amount spent by the account. This can be reset.

attribution_spec

string

itgen_facebook_attribution_spec

The attribution specification of ad account, including click through window length, view through window length, etc.

balance

decimal

itgen_facebook_balance

Bill amount due.

business_city

string

itgen_facebook_business_city

City for business address.

business_country_code

string

itgen_facebook_business_country_code

Country code for the business address.

business_created_by

string

itgen_facebook_business_created_by

Username and id who created this manager.

business_creation_time

string

itgen_facebook_business_creation_time

Time this business created.

business_id

decimal

itgen_facebook_business_id

The id of this person's user account. This ID is unique to each app and cannot be used across different apps.

business_name

string

itgen_facebook_business_name

Name.

business_state

string

itgen_facebook_business_state

State abbreviation for business address.

business_street

string

itgen_facebook_business_street

First line of the business street address for the account.

business_street2

string

itgen_facebook_business_street2

Second line of the business street address for the account.

business_timezone_id

int32

itgen_facebook_business_timezone_id

ID of the business's timezone.

business_update_time

string

itgen_facebook_business_update_time

Last time this Business Manager was updated.

business_updated_by

string

itgen_facebook_business_updated_by

Last user, by name and id, who have updated this manager.

business_zip

string

itgen_facebook_business_zip

Zip code for business address.

business0_name

string

itgen_facebook_business0_name

The business name for the account.

can_create_brand_lift_study

boolean

itgen_facebook_can_create_brand_lift_study

If we can create a new automated brand lift study under the ad account.

capabilities

string

itgen_facebook_capabilities

Capabilities.

created_time

datetime

Created

The time the account was created in ISO 8601 format.

currency

string

itgen_facebook_currency

The currency used for the account, based on the corresponding value in the account settings.

disable_reason

int32

itgen_facebook_disable_reason

The reason why the account was disabled. Possible reasons are: 0 = NONE, 1 = ADS_INTEGRITY_POLICY, 2 = ADS_IP_REVIEW, 3 = RISK_PAYMENT, 4 = GRAY_ACCOUNT_SHUT_DOWN, 5 = ADS_AFC_REVIEW, 6 = BUSINESS_INTEGRITY_RAR, 7 = PERMANENT_CLOSE, 8 = UNUSED_RESELLER_ACCOUNT, 9 = UNUSED_ACCOUNT.

end_advertiser

decimal

itgen_facebook_end_advertiser

The ID of a Facebook Page, Facebook App, or Facebook Business.

end_advertiser_name

string

itgen_facebook_end_advertiser_name

The name of a Facebook Page, Facebook App, or Facebook Business.

failed_delivery_checks

string

itgen_facebook_failed_delivery_checks

Failed delivery checks.

funding_source

decimal

itgen_facebook_funding_source

ID of the payment method. If the account does not have a payment method it will still be possible to create ads but these ads will get no delivery. Not available if the account is disabled.

funding_source_details_amount

decimal

itgen_facebook_funding_source_details_amount

Amount of Facebook Ads Coupon.

funding_source_details_coupon

string

itgen_facebook_funding_source_details_coupon

Details of the Facebook Ads Coupon from the payment method.

funding_source_details_currency

string

itgen_facebook_funding_source_details_currency

Currency of the Facebook Ads Coupon.

funding_source_details_display_amount

string

itgen_facebook_funding_source_details_display_amount

How the amount of Facebook Ads Coupon is displayed.

funding_source_details_expiration

datetime

itgen_facebook_funding_source_details_expiration

When the coupon will expire.

funding_source_details_id

decimal

itgen_facebook_funding_source_details_id

ID of the payment method.

funding_source_details_type

int32

itgen_facebook_funding_source_details_type

Type of the funding source: 0 = Unset, 1 = Credit carrd, 2 = Facebook wallet, 3 = Facebook paid credit, 4 = Facebook extended credit, 5 = Order, 6 = Invoice, 7 = Facebook token, 8 = External funding, 9 = Fee, 10 = FX, 11 = Discount, 12 = PayPal token, 13 = PayPal billing agreement, 14 = FS null, 15 = External deposit, 16 = Tax, 17 = Direct debit, 18 = Dummy, 19 = Altpay, 20 = Stored balance.

has_migrated_permissions

boolean

itgen_facebook_has_migrated_permissions

Whether this account has migrated permissions.

id

string

ID

The string act_{ad_account_id}.

io_number

decimal

itgen_facebook_io_number

The IO number.

is_attribution_spec_system_default

boolean

itgen_facebook_is_attribution_spec_system_default

If the attribution specification of ad account is generated from system default values.

is_direct_deals_enabled

boolean

itgen_facebook_is_direct_deals_enabled

Whether the account is enabled to run Direct Deals.

is_in_3ds_authorization_enabled_market

boolean

itgen_facebook_is_in_3ds_authorization_enabled_market

If the account is in a market requiring to go through payment process going through 3DS authorization.

is_in_middle_of_local_entity_migration

boolean

itgen_facebook_is_in_middle_of_local_entity_migration

If the account is in the peroid localization project rolling out.

is_notifications_enabled

boolean

itgen_facebook_is_notifications_enabled

Get the notifications status of the user for this ad account. This will return true or false depending if notifications are enabled or not.

is_personal

boolean

itgen_facebook_is_personal

Indicates that this ad account is being used for private, non-business purposes which affects how value added tax (VAT) is assessed. NOTE: This does not mean if an account is attached to a business or not.

is_prepay_account

boolean

itgen_facebook_is_prepay_account

If this ad account is a prepay or postpay account.

is_tax_id_required

boolean

itgen_facebook_is_tax_id_required

If tax id for this ad account is required or not.

media_agency

decimal

itgen_facebook_media_agency

The ID of a Facebook Page or Facebook Application.

min_campaign_group_spend_cap

decimal

itgen_facebook_min_campaign_group_spend_cap

The minimum required spend cap of campaign group.

min_daily_budget

decimal

itgen_facebook_min_daily_budget

The minimum daily budget for this ad account.

name

string

Name

Name of the account. If the account name is not set, the name of the first admin visible to the user will be returned.

owner

decimal

itgen_facebook_owner

The ID of the account owner.

partner

decimal

itgen_facebook_partner

The ID of a Facebook Page or Facebook App.

rf_spec_countries

string

itgen_facebook_rf_spec_countries

Array of Supported countries for reach and frequency.

rf_spec_max_campaign_duration

string

itgen_facebook_rf_spec_max_campaign_duration

Object of Maximum campaign duration in days, per supported country.

rf_spec_max_days_to_finish

string

itgen_facebook_rf_spec_max_days_to_finish

Object of Days in advance campaign can finish at time prediction made, per supported country.

rf_spec_min_campaign_duration

string

itgen_facebook_rf_spec_min_campaign_duration

Object of Minimum campaign duration in days, per supported country.

rf_spec_min_reach_limits

string

itgen_facebook_rf_spec_min_reach_limits

Object of Minimum reach in number of people, per supported country.

spend_cap

decimal

itgen_facebook_spend_cap

The maximum that can be spent by this account after which campaigns will be paused. A value of 0 signifies no spending-cap and setting a new spend cap only applies to spend AFTER the time at which you set it. Value specified in basic unit of the currency, e.g. cents for USD.

tax_id

string

itgen_facebook_tax_id

Tax ID.

tax_id_status

int32

itgen_facebook_tax_id_status

VAT status code for the account: 0: Unknown, 1: VAT not required - US / CA, 2: VAT information required, 3: VAT information submitted, 4: Offline VAT validation failed, 5: Account is a personal account.

tax_id_type

string

itgen_facebook_tax_id_type

Type of Tax ID.

timezone_id

int32

itgen_facebook_timezone_id

The timezone ID of this ad account.

timezone_name

string

itgen_facebook_timezone_name

Name for the time zone.

timezone_offset_hours_utc

double

itgen_facebook_timezone_offset_hours_utc

Time Zone difference from UTC.

user_role

decimal

itgen_facebook_user_role

Role ID of the user.

 

Generated 11-01-2019 15:44 on version 17.30.0-PROD+1821.