AdFormResponses
Query the response data for leads that filled out a Lead Form. Collecting Lead Form responses requires the user to be the owner of the Lead Form.
NOTE: The r_marketing_leadgen_automation scope is required to access this view.
Table Specific Information
The Account and LeadType columns must be specified in the criteria to use this view.
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');
To satisfy the requirement mentioned in the beginning, 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');
To satisfy the requirement mentioned in the beginning, 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 | Description |
Id [KEY] | String | Identifier for the form response. |
Account | String | Identifier for the owner of the form. This is the advertiser account. |
Campaign | String | URN identifying the campaign to which the form response is responding. |
Creative | String | URN identifying the creative to which the form response is responding. |
Form | String | URN identifying which form this response responds to. |
SubmitedAt | Datetime | Timestamp for when the form response was submitted. |
LeadType | String | Type of the lead. This field indicates whether the lead is collected from sponsored content or viral share. Defaults to SPONSORED. |
TestLead | Boolean | Whether the lead is a test lead. |
ConsentResponses | String | A JSON object containing all the consent responses. |
Answers | String | A JSON object containing all the answers and the respective questions. |