TargetingEntities
Returns details about available LinkedIn Ads targeting entities, such as companies, job titles, and industries.
Table Specific Information
Select
To read data from this view, some conditions must be specified in the criteria of the statement, depending on your use case.1. Read all ad-targeting entities in a specific ad-targeting facet by using the AD_TARGETING_FACET finder:
SELECT * FROM TargetingEntities WHERE FacetURN = 'urn:li:adTargetingFacet:titles';
SELECT * FROM TargetingEntities WHERE FacetURN IN ('urn:li:adTargetingFacet:titles', 'urn:li:adTargetingFacet:seniorities');
2. Read all ad-targeting entities which contain the specified characters in their name (and optionally specify the entity type), by using the the TYPEAHEAD finder:
SELECT * FROM TargetingEntities WHERE FacetURN = 'urn:li:adTargetingFacet:locations' AND TypeaheadCriteria = 'Denv';
SELECT * FROM TargetingEntities WHERE FacetURN = 'urn:li:adTargetingFacet:locations' AND TypeaheadEntityType = 'REGION' AND TypeaheadCriteria = 'Denv';
3. Read all ad-targeting entities which are similar to another ad-targeting entity, by using the SIMILAR_ENTITIES finder:
SELECT * FROM TargetingEntities WHERE FacetURN = 'urn:li:adTargetingFacet:titles' AND SimilarEntityURN = 'urn:li:title:25194';
SELECT * FROM TargetingEntities WHERE FacetURN = 'urn:li:adTargetingFacet:titles' AND SimilarEntityURN IN ('urn:li:title:25194', 'urn:li:title:21544');
NOTE: Some of the use cases above might not apply for specific facets. To learn which finders are applicable to each facet, query the TargetingFacets view.
4. Read all ad-targeting entities with the specified URN-s:
SELECT * FROM TargetingEntities WHERE URN = 'urn:li:title:10738';
SELECT * FROM TargetingEntities WHERE URN IN ('urn:li:title:10738', 'urn:li:title:19179');
Columns
| Name | Type | References | Description |
| URN [KEY] | String | Uniform Resource Name (URN) that uniquely identifies the ad-targeting entity within LinkedIn Ads. | |
| Name | String | Display name of the ad-targeting entity used in audience selection or campaign setup. | |
| FacetURN | String |
TargetingFacets.URN | URN that identifies the ad-targeting facet used when searching for entities within a specific targeting category. |
| TypeaheadEntityType | String | Specifies the type of entity to search for using the TYPEAHEAD finder, such as company or skill. | |
| TypeaheadCriteria | String | Defines the text or name input used to search for entities through the TYPEAHEAD finder. |
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 | |
| SimilarEntityURN | String | URN of an entity used with the SIMILAR_ENTITIES finder to identify related or similar entities for targeting. |