When tracking the impact of ad campaigns on total revenue, a common need is to compare Conversions from Facebook Ads (Meta Ads) with Total Sales from Shopify in the same chart. This helps answer a key question: What portion of my sales can be attributed to ads?
1. First, configure the Total Sales metric from Shopify
Since the Shopify Metric "Total Sales" contains a currency unit inside the metric, we first need to remove it to make it compatible with the Meta Ads metric.
Create a Data Calculation by navigating to Data Calculations (Metrics > Data Calculations) and create a new Calculated Metric.
Select the Shopify “Total Sales” metric and ensure that the unit is selected. This will ensure that the metric will be compatible with the Purchase Conversion Value Metric from Facebook Ads.
Save the Calculated Metric.
2. Visualize the Metrics on the Databoard
You can use any of the following options to visualize the data.
a) Visualize both metrics side-by-side
Add the calculated version of the Total Sales metric from Shopify to a Databoard.
Additionally, add the Facebook Ads "Purchase Conversion Value" metric to the same Databoard. You can add them to separate visualizations or to the same visualization (for example in the Number Block) by showcasing them side-by-side.
b) Create a Radial Chart and visualize the percentage of the Purchase Conversion Value vs the Total Sales.
Navigate to the Databoard and select the Purchase Conversion Value metric from Facebook Ads.
Set the visualization to Radial Chart.
Open the Datablock Editor on the right-hand side of the screen and set the Max Value setting to Metric.
Set the Metric to the new Calculated Metric Total Sales from Shopify. Make sure to set All Units to No Unit. This ensures both values are interpreted consistently in the same chart.
Now you’ll be able to visualize both Shopify sales and Meta conversions in a single data block for direct comparison—giving you clearer insight into how ads contribute to revenue.
To learn more about using Data Calculations, check out this help article: How to create a Calculated Metric.