JDBC Driver for Twitter Ads

Build 20.0.7654

AdCampaigns

Retrieve details for some or all campaigns associated with the current account.

View Specific Information

Select

Only the AccountId filter is supported. This is a common required filter for all views related to analytics. If specified, it will override the value of the AccountId connection property. Otherwise, if no value is specified, the driver will try to get the first account from the list returned by the AdAccount view.

Columns

Name Type Description
Id [KEY] String The unique identifier of the campaign. Used to identify a specific campaign.
AccountId String Id of the advertising account to work with.
Name String The name of the campaign.
CreatedAt Datetime The time when campaign was created.
UpdatedAt Datetime The time of the last change of the properties of this campaign.
StartTime Datetime The time when the campaign started serving.
EndTime Datetime The time when the campaign stopped serving.
EntityStatus String The status for this entity: ACTIVE, DRAFT, and PAUSED.
TotalBudget Long The total budget the user has set for this campaign.
DailyBudget Long Daily budget limit to spend on this campaign.
Currency String Default currency.
FundingInstrumentId String The Id which identifies the funding instrument used to get the budget for this campaign.
StandardDelivery String If true, this field specifies an even spend rate throughout the day. Otherwise impressions will be served and engagements will be generated as quickly as possible until your daily budget is exhausted, which may be quite early on in the day, depending on targeting and competition. This is called accelerated delivery.
Deleted Boolean Indicates if this campaign is deleted and not serving anymore.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IncludeDeleted String Boolean used for including or not the deleted accounts.

The default value is false.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654