Follow the steps below to set up the recommended Custom columns in Google Ads.
Google Ads allows you to monitor the performance of campaigns with data from secondary conversion actions.
During the first stages of data collection after implementing ProfitMetrics, this is an excellent method to learn your setup from a gross profit and POAS point of view.
How to get started
- Log in to https://ads.google.com and make sure you are in the correct account.
- Go to Campaigns > Columns > Modify columns
- Click "+ Custom Column"
- Create the following custom columns
PM Conversions
Data Format: Number
Formula (Text):
All_conversions.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster")
PM Revenue
Data Format: Money
Formula (Text):
All_conversion_value.conversion_action("PM Revenue - Browser", "PM Revenue - Conversion Booster")
PM ROAS
Data Format: Number
Formula (Text):
All_conversion_value.conversion_action("PM Revenue - Browser", "PM Revenue - Conversion Booster") / Cost
PM Gross Profit
Data Format: Money
Formula (Text):
All_conversion_value.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster")
PM Gross Profit After Ad Spend
Data Format: Money
Formula (Text):
All_conversion_value.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster") - Cost
PM POAS
Data Format: Number
Formula (Text):
All_conversion_value.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster") / Cost
PM Gross Profit Margin
Data Format: Percentage (%)
Formula (Text):
All_conversion_value.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster") / All_conversion_value.conversion_action("PM Revenue - Browser", "PM Revenue - Conversion Booster")
Recommended order:
PM Conversions
PM Revenue
PM ROAS
PM Gross Profit
PM Gross Profit After Ad Spend
PM POAS
PM Gross Profit Margin
Save your column set: ProfitMetrics
ADDITIONAL COLUMNS:
PM Ad Spend Per Order
Data Format: Money
Formula (Text):
Cost / All_conversions.conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster")
EXPERIMENTAL COLUMNS:
The following custom columns are experimental and work in progress.
PM Expected Ad Spend (This Month)
Data Format: Money
Formula (Text):
(Cost.between_dates(month_start, yesterday) / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))
PM Expected Conversions (This Month)
Data Format: Number
Formula (Text):
(All_conversions.between_dates(month_start, yesterday).conversion_action("PM Gross Profit - Browser", "PM Gross Profit - Conversion Booster") / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))
PM Expected Revenue (This Month)
Data Format: Money
Formula (Text):
(Conversion_value.between_dates(month_start, yesterday).conversion_action("PM Revenue - Conversion Booster", "PM Revenue - Browser") / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))
PM Expected Gross Profit (This Month)
Data Format: Money
Formula (Text):
(Conversion_value.between_dates(month_start, yesterday).conversion_action("PM Gross Profit - Conversion Booster", "PM Gross Profit - Browser") / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))
PM Expected Gross Profit After Ad Spend(This Month)
Data Format: Money
Formula (Text):
((Conversion_value.between_dates(month_start, yesterday).conversion_action("PM Gross Profit - Conversion Booster", "PM Gross Profit - Browser") - Cost.between_dates(month_start, yesterday)) / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))
PM Expected POAS (This Month)
Data Format: Number
Formula (Text):
((Conversion_value.between_dates(month_start, yesterday).conversion_action("PM Gross Profit - Conversion Booster", "PM Gross Profit - Browser") / Cost) / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))
PM Expected ROAS (This Month)
Data Format: Number
Formula (Text):
((Conversion_value.between_dates(month_start, yesterday).conversion_action("PM Revenue - Conversion Booster", "PM Revenue - Browser") / Cost) / (day(today()) - 1)) * day(offset_days(offset_months(month_start(), 1), -1))