Home
Benefits
Integrations
Pricing
Customers
Blog
Help
About
All Features
Ecommerce Analytics
Inventory Analytics
Product Analytics
Marketing Analytics
Customer Analytics
Traffic & Advertising Analytics
Scheduled Reports
Daily Snapshot
Ecommerce Dashboard
Custom Reports
Data Pipeline
Marketplace
Sign In
Request a Demo
RC Hobby Explosion Customer Story
Tag4MyPet Customer Story
BigCommerce Store Owner Success Story
Maat Luxe Customer Story
Enterprise Business Customer Story
Paleontological Research Customer Story
Nightmaker Customer Story
Efficiency Store Customer Story
Custom Solutions Store Customer Story
Small BigCommerce Business Customer Story
Colour Drama Boutique Customer Story
The Merch Club Customer Story
Heyday Customer Story
BigCommerce Excellence Store Customer Story
Analytics Focused Store Customer Story
BC Analytics Company Customer Story
Enterprise BigCommerce Store Customer Story
Professional BigCommerce Store Customer Story
Ecommerce Business Customer Story
Skip to main content
Features
Benefits
Integrations
Pricing
Customers
Help
Sign In
Request a Demo
Toggle menu
Help Center
/
Marketing
Back to Help Center
Marketing
How to Analyze Marketing ROI & ROAS by Source in PayHelm
Updated November 10, 2025
marketing, roi, roas, advertising, reports, custom metrics
In this article
What You'll Need
Step 1: Connect Your Ad Platforms
How to Connect Ad Platforms
Step 2: Build a Marketing Performance Report
Creating the Report
Step 3: Create Custom Columns for ROAS, CAC, and AOV
Custom Column: ROAS (Return on Ad Spend)
How to Create:
Custom Column: CAC (Customer Acquisition Cost)
How to Create:
Custom Column: AOV (Average Order Value)
How to Create:
Custom Column: ROI (Return on Investment)
How to Create:
Step 4: Analyze Your Results
High ROAS Sources:
Low CAC Sources:
High AOV Sources:
ROI Trends Over Time:
Step 5: Schedule Reports for Ongoing Monitoring
How to Schedule Reports
Tips for Better Marketing Analysis
Compare Multiple Time Periods
Segment by Campaign
Track New vs. Returning Customers
Use Filters to Isolate Specific Products
Common Formulas for Marketing Analysis
Profit Margin
Conversion Rate
Cost Per Order
Revenue Per Click
Troubleshooting
"Ad Spend shows as $0"
"Orders aren't matching to ad sources"
"ROAS looks incorrect"
Need More Help?
Happy analyzing!
Was this article helpful?
Still have questions? Our team is here to help.
Contact Support