JDBC Driver for LinkedIn Marketing Solutions

Build 22.0.8462

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

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
ActiveAudience Integer Active audience count for the given targeting criteria.
TotalAudience Integer Total audience count for the given targeting criteria.

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