Returning Customer Agency Fees tracks user-defined agency costs allocated to repeat buyer orders.
RC Agency Fees = SUM ( Order Cost Entries ) WHERE category = Agency Fees AND customer_type = returning_customer
| Metric | Definition |
|---|
| Order Cost Entries | User-defined costs configured in Upstack Cost Settings |
| category = Agency Fees | Filters to costs categorized as agency fees |
| customer_type = returning_customer | Filters to repeat buyer orders |
| Metadata | |
|---|
| Type | Currency |
| Data Source | Upstack Costs, Shopify |
| Aggregation | Sum |
Example
Your Shopify store has $5,000 in agency fees for 300 returning customer orders.
| Metric | Value | Calculation |
|---|
| Returning Customer Orders | 300 | Repeat buyers |
| RC Agency Fees | $5,000 | Sum of agency cost entries |
| RC Agency Fees Per Order | $16.67 | $5,000 ÷ 300 |
How It Works
Agency fees are allocated to returning customer orders based on your cost configuration. This helps you understand the cost of retention marketing managed by external agencies.
When to Use
| Scenario | Action |
|---|
| Retention cost analysis | Include agency fees in retention costs |
| Agency performance evaluation | Compare RC agency costs to retention results |
| Budget allocation | Understand agency impact on RC margins |
| NC vs RC agency comparison | Compare acquisition vs retention agency efficiency |
| Metric | Relationship |
|---|
| Agency Fees | Total agency fees for all orders |
| NC Agency Fees | Agency fees for new customer orders |
| RC Marketing Cost | Other marketing costs for returning customers |
| RC MER | Retention marketing efficiency |
