JDBC Driver for LinkedIn Marketing Solutions

Build 22.0.8462

Campaigns

The Ad Campaign status finder returns all campaigns in a specified status that the authenticated user has access to.

Table Specific Information

Select

The Campaigns view returns a list of the campaigns that belong to the authenticated user so they can be used as dimensions in analytic requests.

The driver uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Status column. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM Campaigns

SELECT * FROM Campaigns WHERE Status='ACTIVE'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
Id String Numerical identifier for the campaign
Account String URN identifying the advertising account associated with the Campaign.
CampaignGroup String Numerical identifier for the campaign group.
AssociatedEntity String An URN for a strongly associated object, with semantics varying based on the Campaign type.
AudienceExpansionEnabled Boolean Enable Audience Expansion for the campaign provides query expansion for certain targeting criteria
CostType String CPM - Cost per thousand advertising impressions. CPC - Cost per individual click on the associated link
CreativeSelection String ROUND_ROBIN - Rotate through available creatives to serve them as easily as possible. OPTIMIZED - Bias selection taking into account such things as expected performance
DailyBudgetAmount String The amount of money as a real number string
DailyBudgetCurrency String ISO currency code
Country String An uppercase two-letter country code as defined by ISO-3166.
Language String A lowercase two-letter language code as defined by ISO-639.
Name String The name of the Campaign
OffsiteDeliveryEnabled Boolean Allow this campaign access to be served on the LinkedIn Advertising Network.
ScheduleStartTime Datetime Scheduled date range to run associated creatives.
ScheduleEndTime Datetime Scheduled date range to run associated creatives.
Status String Current Status of the campaign
Type String Type of campaign
UnitCostAmount String Amount to bid per click, impression, or other event depending on the pricing model.
UnitCostCurrency String Currency of the UnitCostAmount
ObjectiveType String The Campaign Objective type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462