BrandLiftTests
Retrieves information on brand lift tests that measure how advertising impacts brand perception within your LinkedIn Ads account.
Table Specific Information
Select
For the AccountURN column, the = operator is fully supported server-side. The IN operator is partially supported server-side and partially client-side. Refer to the query examples below:SELECT * FROM BrandLiftTests WHERE AccountURN = 'urn:li:sponsoredAccount:512859024';
SELECT * FROM BrandLiftTests WHERE AccountURN IN ('urn:li:sponsoredAccount:512859024', 'urn:li:sponsoredAccount:513009855')
For the ExecutionState column, the = operator is fully supported server-side. Refer to the query example below:
SELECT * FROM BrandLiftTests WHERE ExecutionState = 'CREATED';
When no criteria is specified as shown below:
SELECT * FROM BrandLiftTests;
, we internally post-process the query to the following before executing:
SELECT * FROM BrandLiftTests WHERE AccountURN IN (SELECT URN FROM Accounts);
The rest of the query is processed client-side.
Insert
To create a new brand lift test, use an INSERT statement.The following columns are required for this operation:
- AccountURN
- Name
- BrandName
- BrandNameLocaleLanguage
- BrandNameLocaleCountry
- UserState
- StartTime
- EndTime
INSERT INTO BrandLiftTests(AccountURN, Name, BrandName, BrandNameLocaleLanguage, BrandNameLocaleCountry, UserState, StartTime, EndTime) VALUES('urn:li:sponsoredAccount:512859024', 'Lift Test 1', 'Test Brand 1', 'en', 'US', 'READY', '2025-08-01T00:00:00.000-04:00', '2025-10-01T00:00:00.000-04:00')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier assigned to the brand lift test within LinkedIn Ads. | |
| AccountURN | String | False |
Uniform Resource Name (URN) that identifies the advertising account associated with the brand lift test. | |
| Name | String | False |
Name assigned to the brand lift test for tracking and reporting purposes. | |
| Description | String | False |
Detailed description of the brand lift test, outlining its purpose or scope. | |
| CampaignGroupURN | String | False |
URN that identifies the campaign group included in the brand lift test. When specified, only campaigns within this group are measured; otherwise, all campaigns under the ad account are analyzed. | |
| BrandName | String | False |
Name of the brand used when surveying LinkedIn members as part of the brand lift study. | |
| BrandNameLocaleLanguage | String | False |
Specifies the locale language of the brand name using a lowercase two-letter code as defined by ISO 639. | |
| BrandNameLocaleCountry | String | False |
Specifies the locale country of the brand name using an uppercase two-letter code as defined by ISO 3166. | |
| UserState | String | False |
Represents the advertiser-defined state used to manage or control the brand lift test. The allowed values are DRAFT, READY, CANCELED. | |
| ExecutionState | String | True |
Indicates the current execution state of the brand lift test, derived from both the UserState value and LinkedIn's internal test status. The allowed values are CREATED, SCHEDULED, STARTED, ENDED_RESUMABLE, ENDED. | |
| StartTime | Datetime | False |
Planned start date and time for the brand lift test. | |
| EndTime | Datetime | False |
Planned end date and time for the brand lift test. | |
| EndedAt | Datetime | True |
Actual date and time when the brand lift test concluded. LinkedIn may end the test earlier than the scheduled 'EndTime'. | |
| EndReason | String | True |
Describes the reason why the brand lift test ended. The allowed values are USER_CANCELED, END_DATE_REACHED, CAMPAIGN_GROUP_NOT_RECOVERABLE, ACCOUNT_NOT_RECOVERABLE. | |
| ContentReviewVersion | Long | True |
Version number indicating the specific content iteration reviewed for compliance with LinkedIn's advertising content policies. |