ADO.NET Provider for Facebook Ads

Build 26.0.9655

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655