Returns lead data collected through LinkedIn Lead Gen Forms, allowing you to analyze responses from forms owned by your organization.

Table Specific Information

Select

For the Account 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 AdFormResponses WHERE Account = '512859024';
SELECT * FROM AdFormResponses WHERE Account IN ('512859024', '513009855');

We internally post-process the queries above to the following before executing:

SELECT * FROM AdFormResponses WHERE Account = '512859024' AND LeadType = 'STANDARD';
SELECT * FROM AdFormResponses WHERE Account IN ('512859024', '513009855') AND LeadType = 'STANDARD';

For the LeadType 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 AdFormResponses WHERE LeadType = 'STANDARD';
SELECT * FROM AdFormResponses WHERE LeadType IN ('STANDARD', 'COMPANY');

We internally post-process the queries above to the following before executing:

SELECT * FROM AdFormResponses WHERE LeadType = 'STANDARD' AND Account IN (SELECT Id FROM Accounts);
SELECT * FROM AdFormResponses WHERE LeadType IN ('STANDARD', 'COMPANY') AND Account IN (SELECT Id FROM Accounts);

When no criteria is specified as shown below:

SELECT * FROM AdFormResponses;

, we internally post-process the query to the following before executing:

SELECT * FROM AdFormResponses WHERE Account IN (SELECT Id FROM Accounts) AND LeadType = 'STANDARD';

The rest of the query is processed client-side.

Columns

Name	Type	References	Description
Id [KEY]	String		Unique identifier assigned to each submitted form response.
Account	String	Accounts.Id	Identifier of the advertiser account that owns the lead form associated with this response.
Campaign	String		Uniform Resource Name (URN) that identifies the campaign connected to the form response, linking the lead data to its campaign source.
Creative	String		URN that identifies the ad creative associated with the form response, indicating which ad generated the lead.
Form	String		URN that identifies the specific lead form to which this response belongs.
SubmitedAt	Datetime		Date and time when the form response was submitted by the user.
LeadType	String		Specifies the type of lead, indicating whether it was collected from sponsored content or through organic sharing. The default value is 'SPONSORED'.
TestLead	Boolean		Identifies whether or not the lead represents a test submission used for validation or form setup purposes.
ConsentResponses	String		Stores consent-related details as a JSON object, capturing responses to consent questions.
Answers	String		Stores the respondent's answers and corresponding questions in a JSON object for lead data analysis.