Facebook Ads

Facebook Ads Default Column Setup

for ROI focused e-commerce campaigns.

This column setup gives a good overview of your ROI focused e-commerce campaigns and ad sets.

OrderColumn Name
1Object Names & Ids > Campaign Name
2Object Names & Ids > Ad Set Name
3Performance > Delivery
4Ad Relevance Diagnostics > Quality Ranking
5Performance > Attribution Setting
6Performance > Impressions
7Performance > Reach
8Performance > Clicks (All)
9Clicks > Outbound Clicks
10Performance > CTR (All)
11Clicks > Outbound CTR
12Conversions > Adds to Cart: Total
Deselect all sub-categories
13Conversions > Purchases: Total
Deselect all sub-categories
14Conversions > Purchases: Value
Deselect all sub-categories
15Conversions > Purchases: Cost
Deselect all sub-categories
16Performance > Amount Spent
17Goal, Budget & Schedule > Budget
18Performance > Frequency
19Conversions > Website Purchase ROAS (Return on Ad Spend)
  • Select “Save as Preset” and name your column set “ROAS”
  • Click the column icon and select “Set as Default”

Optional: Custom Columns

Optionally, create the following custom columns

% Cost of Sales

This indicates what percentage of your sales are going towards Facebook ads cost (ad spend as a cost of sales). Where ROAS is advertiser centrice, Cost of Sales is more business centric.

NameCost of Sales
DescriptionAd spend as a % of revenue.
FormulaAmount Spent รท Purchases Conversion Value
Who can access thisEveryone

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s