Chrome Extension
adsmanager.facebook.com
Ads ManagerAll Ads
Ad NameSpendRevenueROAS
UGC Testimonial - Summer
€1,240€4,8203.9xStatic Banner - New Arrivals
€860€3,6404.2xCarousel - Bestsellers
€720€2,1603.0xDPA - Product Catalog
€680€3,4205.0xUGC Unboxing - Spring
€540€2,4804.6xVideo - Brand Story
€480€1,6803.5xStatic - Sale 20% Off
€420€1,8904.5xReel - Behind the Scenes
€360€1,2403.4xCarousel - Bundle Deals
€340€1,5604.6xVideo - How It Works
€310€1,1203.6xStatic - Free Shipping
€280€9803.5xUGC Review - Top Seller
€220€6402.9xExtension ready
Click extension to loadUnified Semantic Definitions
Attributes
Search...
Add FilterNameDefinitionConfigurationAggregationData Type
Customer SegmentEventFormulaDimensionString
Sales ChannelEventSourceDimensionString
Payment MethodEventSourceDimensionString
Shipping CountryEventSourceDimensionString
Discount CodeEventSourceDimensionString
Product SKUEventSourceDimensionString
Product Variant TitleEventSourceDimensionString
Product TitleEventSourceDimensionString
Order DateEventSourceDimensionDate
Product VendorEventSourceDimensionString
NC Gross Sold QtyEventFormulaMetricNumeric
NC Net RevenueEventFormulaMetricNumeric
Gross Sold QuantityEventFormulaMetricNumeric
NC CM1EventFormulaMetricNumeric
NC CM2EventFormulaMetricNumeric
CM2EventFormulaMetricNumeric
CM2 90dEventFormulaMetricNumeric
Cumulative CM2 30dEventFormulaMetricNumeric
CAC (Net)EventFormulaMetricNumeric
ROAS (Gross)EventFormulaMetricNumeric
AOV (Gross)EventFormulaMetricNumeric
Product FilterEventFormulaDimensionString
Fulfillment CostsEventFormulaMetricNumeric
Product CostsEventSourceMetricNumeric
Returning SubscribersEventFormulaMetricNumeric
Is SubscriptionEventSourceDimensionBoolean
Channel NameChannelFormulaDimensionString
Channel GroupChannelFormulaDimensionString
Channel SpendChannelFormulaMetricNumeric
Influencer SpendChannelBQ LookupMetricNumeric
CPOChannelFormulaMetricNumeric
Campaign GroupChannelFormulaDimensionString
Hero Order ProductChannelFormulaDimensionString
Influencer BookingChannelGSheetsDimensionString
Influencer FilterChannelGSheetsDimensionString
Landingpage TypeTouchpointFormulaDimensionString
Net Marketing Eff.EventFormulaMetricNumeric
Influencer Coop. TypeChannelGSheetsDimensionString
Pick & Pack CostsEventSourceMetricNumeric
Session CountTouchpointSourceMetricNumeric
Page ViewsTouchpointSourceMetricNumeric
Bounce RateTouchpointFormulaMetricNumeric
Avg. Session DurationTouchpointFormulaMetricNumeric
Simple Formulas
CAC (Net)
No validation warnings
Save
Configuration
Aggregation TypeMetric
Data TypeNumeric
Display Data TypeCurrency
Formula
Channel Spend÷NC Net OrdersFormula valid
Advanced Formulas
{}Product Filter
No Dependencies
Save
Configuration
Definition TypeEvent
Aggregation TypeDimension
Data TypeString
Configuration Type{} Formula
ConversionEvery
{}Formula
1CASE
2 WHEN Shopify Product Variant SKU LIKE 'SR-%' THEN 'Serums'
Shopify Product Variant SKU LIKE 'SR-%' THEN 'Serums'3 WHEN Shopify Product Variant SKU LIKE 'CR-%' THEN 'Creams'
Shopify Product Variant SKU LIKE 'CR-%' THEN 'Creams'4 WHEN Shopify Product Variant SKU LIKE 'CL-%' THEN 'Cleansers'
Shopify Product Variant SKU LIKE 'CL-%' THEN 'Cleansers'5 WHEN Shopify Product Variant SKU LIKE 'BD-%' THEN 'Bundles'
Shopify Product Variant SKU LIKE 'BD-%' THEN 'Bundles'6 WHEN Shopify Product Variant SKU LIKE 'SP-%' THEN 'Supplements'
Shopify Product Variant SKU LIKE 'SP-%' THEN 'Supplements'7 ELSE 'Other'
8END
Query valid