Tableau Connector for LinkedIn Marketing Solutions

Build 24.0.9062

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 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 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.

デフォルト値はTEXT_ADです。

BidType String The bidding type.

デフォルト値はCPMです。

MatchType String The matching type.

デフォルト値はEXACTです。

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062