BrandLiftTests
Read data on brand lift tests in your LinkedIn ad-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 |
The unique identifier of the brand lift test. | |
| AccountURN | String | False |
The URN of the ad-account to which this brand lift test belongs. | |
| Name | String | False |
The name of the brand lift test. | |
| Description | String | False |
The brand lift test's description. | |
| CampaignGroupURN | String | False |
The URN of the campaign group to include in the brand lift test. When specified, only campaigns within this group will be measured. Otherwise, the test will analyze all campaigns across the entire ad account. | |
| BrandName | String | False |
The brand name used when surveying LinkedIn users with this brand lift test. | |
| BrandNameLocaleLanguage | String | False |
The locale language of the brand name. A lowercase two-letter language code as defined by ISO-639. | |
| BrandNameLocaleCountry | String | False |
The locale country of the brand name. An uppercase two-letter country code as defined by ISO-3166. | |
| UserState | String | False |
The state used by the advertiser to control the brand lift test. The allowed values are DRAFT, READY, CANCELED. | |
| ExecutionState | String | True |
The execution state of the brand lift test derived from the 'UserState' column and internal state of the LinkedIn platform. The allowed values are CREATED, SCHEDULED, STARTED, ENDED_RESUMABLE, ENDED. | |
| StartTime | Datetime | False |
The scheduled start time of the brand lift test. | |
| EndTime | Datetime | False |
The scheduled end time of the brand lift test. | |
| EndedAt | Datetime | True |
The actual end time of the brand lift test. LinkedIn may terminate the brand lift test before the time specified in the 'EndTime' column. | |
| EndReason | String | True |
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 |
A long value representing the content version that was reviewed in accordance to LinkedIn content policies. |