To calculate your Blended Customer Acquisition Cost (CAC) by product, follow these steps to set up a Custom Dimension. This Custom Dimension will help you break down Ad Spend by product title, allowing you to accurately analyze CAC for each product.
Prerequisites:
Campaign Naming: Ensure your campaign names include product titles or other identifiers, such as targeted countries.
Ad Spend & New Customer Orders: Understand that Blended CAC involves Ad Spend and New Customer Orders. Without the Custom Dimension, you can't break down Ad Spend by product title.
How-To: Calculate CAC by Product with Custom Dimensions
1. Prepare Campaign Names
Make sure your campaign names clearly indicate which products they target. they target.
2. Create a Custom Dimension
Launch the Custom Dimension Builder: Start the Custom Dimension builder
Set Up the Dimension: Follow the steps below to assign product titles based on your campaigns.
Add Rules for Ad Sources and Shopify:
Rule Setup:
Condition:
Campaign name contains [Product Title]
OR
Product titles (from Shopify) contain [Product Title]
Result:
'{Product Title}'
OR
'OTHER' (or another default value for unmatched conditions)
Repeat this setup for each product you want to track. Add additional "When" blocks and "OR" rules for each product and marketing source as needed.
Save the Custom Dimension once you’ve added all necessary rules.
3. Create a Custom Report
Generate the Report: Create a Custom Report to display "Blended CAC" and break it down by the Custom Dimension you just created. You can see an example report of this below.
Note: If you are using Google Shopping, you will soon be able to import costs by item ID and map the item IDs to your Shopify SKUs. Let us know if you're interested in learning more about this process.
If you'd like assistance building the Custom Dimension detailed above in order to analyze your Blended CAC by Product, please don't hesitate to reach out to our Support Team via the in-app live chat.