Query form data for the forms that belong to a specified owner (account).

NOTE: The r_marketing_leadgen_automation and r_ads scopes are required to access this view.

Table Specific Information

The Account column 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 Forms WHERE Account = '512859024';
SELECT * FROM Forms WHERE Account IN ('512859024', '513009855');

When no criteria is specified as shown below:

SELECT * FROM Forms;

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

SELECT * FROM Forms WHERE Account IN (SELECT Id FROM Accounts);

The rest of the query is processed client-side.

Columns

Name	Type	Description
Id [KEY]	String	Identifier for the form.
Account	String	Identifier for the owner of the form. This is the advertiser account.
Created	Timestamp	Timestamp for creation of the form.
LastModified	Timestamp	Timestamp for last modification of the form.
Description	String	Description of the form, visible to both the owner and the viewer.
Headline	String	Headline of the form, visible to both the owner and the viewer.
LandingPage	String	The landing page URL after the viewer clicks on submit.
LegalDisclaimer	String	Advertiser's legal disclaimer to accompany this form.
Name	String	Name of the form, visible to the owner of the form but not visible to the viewer.
PrivacyPolicy	String	The URL of the privacy policy that covers any data passed to the owner of the form.
Country	String	A lowercase two-letter language code as defined by ISO-639-1
Language	String	An uppercase two-letter country code as defined by ISO-3166.
ReviewStatus	String	The status of the review of the form.
ReviewedAt	Timestamp	Timestamp for when the form's review status was initiated/last updated.
Status	String	Indicates the state of review for the Lead Form. Can be one of the following: DRAFT, SUBMITTED, PAUSED, ARCHIVED, or CANCELED.
VersionTag	String	The number of times the form has been modified.