API Connectors

users-love-us medal soc2
Send your Facebook Lead Ads (Meta) data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabaseGemini EnterpriseCursorManusGrok

Facebook Lead Ads (Meta) Connector Reference

35 dimensions
Fields

The Facebook Lead Ads (facebook_leads) connector pulls Facebook Leads Ads data on a lead level. The supported fields can be found in the table below.

A sample query looks like this:

 

https://connectors.windsor.ai/facebook_leads?api_key=<APIKEY>&date_preset=last_28d&fields=account_name,account_id,campaign,ad_set_name,ad_name,email

And returns data in the following format:

{
"data": [
{
"account_name": "Pied Piper",
"account_id": "1234567898012345",
"campaign": "Facebook_Leads_Campaign",
"ad_set_name": "AdSet_1",
"ad_name": "LeadAd_Acquisition_35",
"email": "[email protected]"
}
]
}

The Facebook Lead Ads (Meta) connector exposes 35 fields (0 metrics, 35 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Facebook Lead Ads (Meta) Fields

Facebook Lead Ads (Meta) Leads fields

The Leads report of the Facebook Lead Ads (Meta) connector includes 17 fields.

ID Type Name Description
account_id TEXT Account ID The Page ID of the Facebook Page
account_name TEXT Account Name The Page Name of the Facebook Page
ad_name TEXT Ad Name Ad name for the Lead Ad
adset_id TEXT Ad Set ID Ad Set ID for the Lead Ad
adset_name TEXT Ad Set Name Ad Set name for the Lead Ad
campaign TEXT Campaign Name Campaign name for the Lead Ad
campaign_id TEXT Campaign ID Campaign ID for the Lead Ad
created_time TIMESTAMP Created Time Time this object was created
date DATE Date The dimension that determines how date-based data in a chart
date_start DATE (Deprecated) Reporting Starts The start date for your data. This is controlled by the date range you've selected for your reporting view. Facebook Leads is no longer supports this field so it will always return null
date_stop DATE (Deprecated) Reporting Ends The end date for your data. This is controlled by the date range you've selected for your reporting view. Facebook Leads is no longer supports this field so it will always return null
email TEXT Email Email
form_id TEXT Form ID Form ID used for the Lead Ads
form_name TEXT Lead Form Name Form name used for the Lead Ads
full_name TEXT Full Name Full Name
id TEXT ID ID of the LeadGenInfo object
phone_number TEXT Facebook Lead Phone Number Phone Number

Facebook Lead Ads (Meta) other fields

The Facebook Lead Ads (Meta) connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20