The standard spreadsheet formulas for converting raw PPC totals (impressions, clicks, orders, spend, sales) into efficiency ratios:
Format ACOS, CTR, and CVR as percentages; format CPC as currency to two decimal places. Placed next to a data table — e.g. an Manual Hourly Day-Parting Analysis (Pivot Table Method) hourly pivot table — these let you compare efficiency across segments (hours of the day, campaigns, placements) at a glance rather than eyeballing raw totals.