Power BI Connector for LinkedIn Marketing Solutions

Build 25.0.9454

BudgetPricing

Provides bid and budget recommendations for campaigns, including minimum, maximum, and suggested bids based on your targeting parameters.

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 connector uses the LinkedIn Marketing Solutions API to process search criteria. You can combine the following filters also in a single search. The connector processes other filters client-side within the connector. 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.

Columns

Name Type References Description
SuggestedBidDefault String Represents the suggested bid amount recommended for a given campaign setup.
SuggestedBidMin String Indicates the lower end of the suggested bid range for the selected targeting criteria.
SuggestedBidMax String Indicates the upper end of the suggested bid range for the selected targeting criteria.
DailyBudgetLimitsDefault String Specifies the default daily budget amount recommended by LinkedIn Ads.
DailyBudgetLimitsMin String Specifies the minimum allowable daily budget for the campaign.
DailyBudgetLimitsMax String Specifies the maximum allowable daily budget for the campaign.
BidLimitsMax String Defines the maximum bid amount permitted for the selected campaign type or bidding strategy.
BidLimitsMin String Defines the minimum bid amount allowed, also referred to as the floor price.
Account String Uniform Resource Name (URN) that identifies the advertising account associated with the budget or pricing configuration.
CampaignType String Specifies the type of campaign.

The allowed values are TEXT_AD, SPONSORED_UPDATES.

The default value is TEXT_AD.

BidType String Defines the bidding method used for the campaign.

The allowed values are CPM, CPC, CPV.

The default value is CPM.

MatchType String Specifies the targeting match type used to determine how closely audience attributes must align with defined criteria.

The allowed values are EXACT, AUDIENCE_EXPANDED.

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 Defines the age ranges used for audience targeting. Supported values: (18, 24), (25, 34), (35, 54), (55, 2147483647).
DegreeId String Specifies the educational degrees attained by members for use in audience targeting.
FieldOfStudyId String Defines the academic fields of study to target, based on members' profile information.
Gender String Specifies gender-based audience targeting criteria. Supported values: MALE, FEMALE.
IndustryId String Defines the industries to target based on members' professional backgrounds.
JobFunctionId String Specifies the job functions to target, representing broad categories of professional roles.
LocationId String Defines the geographic locations to include in audience targeting.
ProfileLocationId String Specifies member profile locations for targeting, similar to LocationId but based on a member's listed profile location.
SeniorityId String Specifies the seniority levels to target, such as entry-level, manager, or executive.
SkillId String Defines the professional skills to target, matched against those listed in members' profiles.
StaffCountRange String Defines the organization size range to target. Supported values: (1, 1), (2, 10), (11, 50), (51, 200), (201, 500), (501, 1000), (1001, 5000), (5001, 10000), (10001, 2147483647).
TitleId String Specifies the job titles to target, matched against members' current titles.
AudienceMatchingSegmentId String Identifies an ad segment consisting of specific entities, such as members or companies, used for audience matching.
RetargetingSegmentId String Identifies an ad segment composed of entities previously engaged with your ads, used for retargeting campaigns.
EmployerId String Specifies the employer identifier to match against companies listed in members' profiles.
CompanyId String Specifies the company identifier to target, matched against companies listed in members' profiles.
InterfaceLocaleId String Defines the locale identifier to target, matched against members' preferred language or regional settings.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454