LeadValues
Query information about a lead. Accessing Lead Information requires the ads_read and either pages_manage_ads or leads_retrieval permissions.
Table Specific Information
LeadValues in Facebook represent individual values available from a Lead Ad. The types of values describing a leads are varied and can range from custom information such as a car model, or something general such as name and email.
Select
When querying lead values, either the Id or Target must be used to filter results. The Id represents the id of the individual lead while the Target must be a Lead Ad. If neither filter is supplied, the Target will automatically be sliced on the Ads table.
The following columns and operators are supported server-side:
- Id supports the '=' operator.
- Target supports the '=', 'IN' operators.
- CreatedTime supports the '>', '<', '<=' operators.
Sample queries:
SELECT * FROM LeadValues WHERE Target = 'lead_ad_id'
SELECT * FROM LeadValues WHERE Id = 'lead_id'
SELECT * FROM LeadValues WHERE Target IN (SELECT id FROM Ads WHERE Target = 'campaign_id')
SELECT * FROM LeadValues where Target='6043999879662' AND CreatedTime > '2026-01-01'
Note that many values may come back for a single lead id. The leads themselves are a collection on the Lead Ad, and the lead values are a collection on each individual lead.
Columns
| Name | Type | Description |
| ID | String | The Id of Lead. |
| Target | String | The target or Ads Id to get Lead values from. |
| AdId | String | The id of the Ad the lead originates from. |
| AdName | String | The name of the Ad the lead originates from. |
| AdSetId | String | The id of the Ad Set the lead is associated with. |
| AdSetName | String | The name of the Ad Set the lead is associated with. |
| CampaignId | String | The id of the Campaign the lead is associated with. |
| CampaignName | String | The name of the Campaign the lead is associated with. |
| FormId | String | The id of the form the lead originates from. |
| FieldName | String | The name of the field of lead data. |
| FieldValues | String | The values for the given field of lead data. |
| IsOrganic | Boolean | A boolean indicating if the lead is organic. |
| CreatedTime | Datetime | The datetime the lead was created. |