JDBC Driver for LinkedIn Marketing Solutions

Build 22.0.8462

BudgetPricing

The LinkedIn Budget Pricing API provides developers with key insights on pricing metrics (e.g. minimum, maximum and suggested bids) based on targeting criteria.

Table Specific Information

Select

The BudgetPricing view provides developers with key insights on pricing metrics (e.g. minimum, maximum and suggested bids) based on targeting criteria.

The driver uses the LinkedIn Marketing Solutions API to process search criteria. You can combine the following filters also in a single search. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM BudgetPricing WHERE AgeRanges='(25,34)' AND Account='1234'

SELECT * FROM BudgetPricing WHERE DegreesId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE FieldsOfStudyId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE Genders='MALE' AND Account='1234'

SELECT * FROM BudgetPricing WHERE IndustriesId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE JobFunctionsId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE LocationsId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE ProfileLocationsId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE SenioritiesId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE SkillsId='1234' AND Account='1234'

SELECT * FROM BudgetPricing WHERE StaffCountRanges='(11,50)' AND Account='1234'

SELECT * FROM BudgetPricing WHERE TitlesId='1234' AND Account='1234'

Select Rules

Budget pricing reports:

Dimensions Use 1 or more AgeRanges, DegreesId, FieldsOfStudyId, Genders, IndustriesId, JobFunctionsId, LocationsId, ProfileLocationsId, SenioritiesId, SkillsId, StaffCountRanges, TitlesId

Note: If no dimension is specified the default dimension will be Genders and will be set to both MALE and FEMALE as the default value.

Filter Required CampaignType, Account, BidType, MatchType

Note: Only 1 dimension is allowed in the OR operation and 1 or more dimensions are allowed in the AND operation. The default value for CampaignType will be TEXT_AD. The default value for BidType will be CPM. The default value for MatchType will be EXACT. If there is no Account specified there will be records for every account that belongs to the user.

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
SuggestedBidDefault String The suggested bid
SuggestedBidMin String Low end of suggested bid range
SuggestedBidMax String High end of suggested bid range
DailyBudgetLimitsDefault String Default daily budget
DailyBudgetLimitsMin String Minimum daily budget
DailyBudgetLimitsMax String Maximum daily budget
BidLimitsMax String The maximum bid allowed
BidLimitsMin String The minimum bid allowed, also known as the floor price
Account String Sponsored account URN.
CampaignType String The campaign type.

The default value is TEXT_AD.

BidType String The bidding type.

The default value is CPM.

MatchType String The matching type.

The default value is EXACT.

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
AgeRange String Age ranges to match against member. Supported values are: (18,24), (25,34), (35,54), (55,2147483647)
DegreeId String Educational degrees attained to match against those of the member.
FieldOfStudyId String Fields of study to match against those listed by the member.
Gender String Genders to match against member. Supported values are: MALE, FEMALE
IndustryId String Industries to be targeted.
JobFunctionId String Top level groupings of supertitles to be targeted.
LocationId String Location to be targeted.
ProfileLocationId String The values are similar to
SeniorityId String Seniorities to be targeted.
SkillId String Skills to match against the member's listed skills.
StaffCountRange String Organization sizes to be targeted. Supported values are: (1,1), (2,10), (11,50), (51,200), (201,500), (501,1000), (1001,5000), (5001,10000), (10001,2147483647)
TitleId String Job titles to match against the member's current title.
AudienceMatchingSegmentId String An Ad segment is a collection of entities (such as members or companies) to which ads can be targeted.
RetargetingSegmentId String An Ad segment is a collection of entities (such as members or companies) to which ads can be targeted.
EmployerId String Employer ID to match against member's listed companies.
CompanyId String Company ID to match against member's listed companies.
InterfaceLocaleId String Locale ID to match against member's preferred locale settings.

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