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