Follow the Metric Recipe below to create the metric:
Step 1: Create Custom Metric 1: Total Ad Spend
Since the standard Facebook Ads connector usually provides this, you might not need to create it, but you'll use the Metric Builder to select and potentially segment it if you're pulling from a complex source or need a specific filter. If it's a standard metric, you can skip to Step 3, but for a true custom pull, follow this:
Navigate to Metrics: Go to the Metrics section in your Databox account.
Access Custom Metrics: Click on Custom Metrics (or Metric Builder).
Create New: Click the + New Custom Metric button.
Data Source: Select your connected Facebook Ads (or Facebook Ads) data source.
Metric: Select the base metric for Spend (or the most relevant total cost metric).
Filter/Dimension (Optional): If you only want to track spend for a specific campaign or ad set, apply the necessary filters/dimensions here.
Name: Name the metric clearly, e.g., "FB Ads - Total Spend".
Save: Click Save.
Step 2: Create Custom Metric 2: Cost Per ThruPlay
Similar to Spend, this is likely a standard field, but you may need to use the Custom Metric builder to select and filter it.
Navigate to Metrics: Go back to the Custom Metrics area.
Create New: Click the + New Custom Metric button.
Data Source: Select your connected Facebook Ads data source.
Metric: Select the base metric for Cost Per ThruPlay.
Filter/Dimension (Optional): Apply the same filters/dimensions as you did for the Spend metric to ensure both metrics cover the same data set.
Name: Name the metric clearly, e.g., "FB Ads - Cost Per ThruPlay".
Save: Click Save.
Step 3: Create the Calculated Metric: Number of ThruPlays
This step uses the metrics created (or verified) in the previous steps to perform the reverse calculation.
Navigate to Calculated Metrics: Go to the Metrics screen and then select the Calculated Metrics tab.
Create New: Click the + New Calculated Metric button.
Enter the Formula: You will build the equation:
Number of ThruPlays = FB Ads - Total Ad Spend \ FB Ads - Cost Per ThruPlay
Variable A: Select your "FB Ads - Total Spend" Custom Metric.
Operator: Select the Division (/) operator.
Variable B: Select your "FB Ads - Cost Per ThruPlay" Custom Metric.
Name: Name the resulting metric clearly, e.g., "Calculated ThruPlays".
Format: Ensure the metric format is set to Number (not Currency or Percentage) with the desired decimal places, as this represents a count, e.g., "#,###".
Preview and Save: Review the data preview on the right side to ensure the results look accurate, and then click Save.
Your new "Calculated ThruPlays" metric is now available to use on any Databoard, complete with historical tracking based on the underlying metrics.