SSIS Components for LinkedIn Marketing Solutions

Build 24.0.9062

AudienceCount

The Audience Count API allows advertisers to forecast the reach of targeting criteria.

Table Specific Information

Select

The AudienceCount view allows advertisers to forecast the reach of targeting criteria.

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

SELECT * FROM AudienceCount WHERE AgeRanges = '(25,34)'

SELECT * FROM AudienceCount WHERE DegreesId = '1234'

SELECT * FROM AudienceCount WHERE FieldsOfStudyId = '1234'

SELECT * FROM AudienceCount WHERE Genders = 'MALE'

SELECT * FROM AudienceCount WHERE IndustriesId = '1234'

SELECT * FROM AudienceCount WHERE JobFunctionsId = '1234'

SELECT * FROM AudienceCount WHERE LocationsId = '1234'

SELECT * FROM AudienceCount WHERE ProfileLocationsId = '1234'

SELECT * FROM AudienceCount WHERE SenioritiesId = '1234'

SELECT * FROM AudienceCount WHERE SkillsId = '1234'

SELECT * FROM AudienceCount WHERE StaffCountRanges = '(11,50)'

SELECT * FROM AudienceCount WHERE TitlesId = '1234'

Select Rules

Audience count reports:

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

Note: Only 1 dimension is allowed in the OR operation and 1 or more dimensions are allowed in the AND operation. If no dimension is specified the default dimension will be Genders and will be set to both MALE and FEMALE as the default value.

Columns

Name Type Description
ActiveAudience Integer Active audience count for the given targeting criteria.
TotalAudience Integer Total audience count for the given targeting criteria.

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