JDBC Driver for Facebook Ads

Build 23.0.8839

Ads

Query information about an Ad or the Ads in a specific Ad Set, Campaign, or Ad Account. Accessing Ad Information requires the ads_read permission.

Table Specific Information

Ads in Facebook represent individual ads that have been created.

Select

When querying ad accounts, either the Id or Target must be used to filter results. For instance:

SELECT * FROM Ads WHERE Target = 'act_123456'

Additionally, UpdatedTime may be used with the > or >= operators to retrieve only records newer than a certain date. For instance:

SELECT * FROM Ads WHERE Target = 'act_123456' AND UpdatedTime > '01/01/2016' 

Columns

Name Type Description
ID [KEY] String The Id of Ad.
Target String The Ad Account Id, Campaign Id, or Ad Set Id to get Ads in.
Name String The name of the Ad.
AdStatus String The status of the Ad.

The allowed values are ACTIVE, PAUSED, CAMPAIGN_PAUSED, CAMPAIGN_GROUP_PAUSED, CREDIT_CARD_NEEDED, DISABLED, DISAPPROVED, PENDING_REVIEW, PREAPPROVED, PENDING_BILLING_INFO, ARCHIVED, DELETED.

BidInfo String The value of the bid info taken from the Ad Set.
BidType String The bid type value taken from the Ad Set.

The allowed values are CPM, CPC, MULTI_PREMIUM, ABSOLUTE_OCPM, CPA.

CampaignId String The Id of the Campaign the Ad belongs to.
AdSetId String The Id of the Ad Set the Ad belongs to.
AdCreativeId String The Id of the Ad Creative associated with the Ad.
ConfiguredStatus String The configured status of the ad. Prefer using 'status' instead of this.

The allowed values are ACTIVE, PAUSED, DELETED, ARCHIVED.

CreatedTime Datetime The time when the Ad was created.
UpdatedTime Datetime When the Ad was last updated.
ConversionSpecs String The Ad's conversion specs.
FailedDeliveryChecks String Possible checks that could have failed which will prevent the Ad from showing up.
Recommendations String If there are recommendations for this ad, this field includes them. Otherwise, this field will be null.
TrackingSpecs String The Ad's tracking specification. This field will be defaulted based on the objective, if not set to NONE, or based on the ad creative.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839