Read data on LinkedIn ad-targeting entities.

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		The ad-targeting entity URN.
Name	String		The name of the ad-targeting entity.
FacetURN	String	TargetingFacets.URN	The URN of the ad-targeting facet to use for searching entities.
TypeaheadEntityType	String		The entity type to search for with the 'TYPEAHEAD' finder.
TypeaheadCriteria	String		The name of the entity to search for with the 'TYPEAHEAD' finder.

Pseudo-Columns

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

Name	Type	Description
SimilarEntityURN	String		The URN of an entity to use for finding other similar entities with the 'SIMILAR_ENTITIES' finder.