Skip to main content
Questions our customers ask most often, grouped by team. Use them as starting points in your dashboard, or ask SourceMedium Agent directly. The other pages in this section walk through products, ROAS, retention, and cohort LTV in the dashboard. Warehouse guides for cohort lifetime orders, revenue retention, gross profit, and contribution margin start at Cohort LTO. Copy-paste queries for the same topics are in the SQL query library.

​
Executive

  • How has the ratio of new to repeat customers changed on a weekly basis so far this year?
  • Are we profitable on our overall marketing spend?
Which module answers this: Executive Summary for the first vs. repeat order share and blended CPA; Marketing Overview for blended spend and ROAS.

​
Marketing & Acquisition

  • Which platform and campaign type has the highest ROAS?
  • Which source/medium is leading to the most conversions?
  • Am I acquiring new subscribers with my lowest cost channels (email vs. paid social)?
Which module answers this: Marketing Overview for platform-reported ROAS by campaign type; Orders Deep Dive for last-click source/medium and the channel driving the most subscription customers.

​
Retention & LTV

  • Which discount code was responsible for acquiring our highest retention cohort?
  • Which initial products were ordered by customers in the highest LTV cohort?
Which module answers this: LTV & Retention. Filters such as discount code apply to the acquisition order, so you can compare cohorts by the code that acquired them.

​
Customer Analysis

  • Which products are most common with new customers?
  • At what interval are non-subscribers making orders?
  • How much more valuable are my subscription customers than non-subscription customers?
Which module answers this: New Customer Analysis for the products new customers buy; Orders Deep Dive for the time between orders; LTV & Retention for subscription vs. non-subscription customer value.

​
Orders & Products

  • What initial products lead to strong repeat purchasing behavior?
  • Which source / mediums are driving repeat purchases?
  • What is our most common cart composition?
  • What percentage of our orders are first time vs. repeat?
Which module answers this: Product Affinity for products bought together and first-to-second order patterns; Orders Deep Dive for source/medium and the first vs. repeat split.

​
Subscription

  • What is the typical subscriber journey?
  • How much of my total revenue is driven by subscriptions?
  • How much of our current revenue is driven by historical subscriber cohorts?
Which module answers this: Subscription Overview for MRR and subscriber health over time; Orders Deep Dive for the split between subscription and non-subscription orders; LTV & Retention with the Slice filter set to Subscription for revenue by subscriber cohort.