MuleSoft Connector for Facebook Ads

Build 21.0.7930

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930