LeadValues
Query information about a lead. Accessing Lead Information requires the ads_read permission.
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. For instance:
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')
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. |