Fetch Meta Ads data based on specified metrics and dimensions
Field | Type | Required | Description |
---|---|---|---|
Accounts | Dynamic multi-select | Yes | Select one or more Meta Ads accounts to query |
Date Range | Date range picker | Yes | Select date range for the report |
Metrics | Multi-select | Yes | Select metrics to include in the report |
Dimensions | Multi-select | No | Select dimensions to segment your data |
Filters | Rule-based filters | No | Add filters to refine your data |
Order By | Sort configuration | No | Set the order of results |
Limit | Number | No | Maximum number of rows to return |
Options | Report options | No | Additional options for the report |
Operator | Description | Example Use Case |
---|---|---|
EQUALS | Exact match | Campaign name equals “Black Friday Sale” |
NOT_EQUALS | Does not match exactly | Campaign status not equals “PAUSED” |
CONTAINS | Contains substring | Campaign name contains “2024” |
NOT_CONTAINS | Does not contain substring | Campaign name doesn’t contain “test” |
IN_LIST | Matches any value in list | Placement in [“Facebook_Feed”, “Instagram_Feed”] |
NOT_IN_LIST | Doesn’t match any value in list | Device not in [“Desktop”] |
REGEXP_MATCH | Matches regular expression | Campaign name matches ”.(sale|promo).” |
NOT_REGEXP_MATCH | Doesn’t match regex | Campaign name doesn’t match “test.*“ |
GREATER_THAN | Numeric greater than | Spend > 100 |
LESS_THAN | Numeric less than | CPC < 2.00 |
IS_NULL | Field has no value | Purchase value is null |
IS_NOT_NULL | Field has a value | Purchase value is not null |
Placement IN ["Facebook_Feed", "Instagram_Feed", "Instagram_Stories"]
Campaign name REGEXP_MATCH ".*(sale|promo|discount).*"
Option | Description |
---|---|
Pretty Column Names | Converts column headers to Title Case (e.g. campaignName becomes Campaign Name ) |
Add Percent Sign to Ratios | Appends % to ratio metrics like CTR or Engagement Rate |
Display Currency Symbol | Adds $ or local currency symbol to monetary metrics |
Compact Numbers | Converts large numbers to short format (e.g. 10K instead of 10,000 ) |
Pivot Dimensions as Columns | Transforms dimension values into separate columns for easier comparison |
What happens if I select multiple Meta Ads accounts?
account_name
or account_id
dimension to segment results per account.How do I combine filters with OR logic?
What's the difference between CONTAINS and REGEXP_MATCH?
Campaign name CONTAINS "sale"
finds any campaign with “sale” anywhere in the nameCampaign name REGEXP_MATCH "^sale.*"
finds campaigns that START with “sale”Why are my filters not working?
Why don't my conversions match Facebook Ads Manager?
Why is my data different from the Meta Ads Manager?
Why are some conversions missing when I use breakdowns?
Why can't I see conversions for campaign-level data?
How to filter out inactive campaigns?
Why is my report returning no data?
Why are some metrics showing as zero?
Why are my custom conversions different from Events Manager?