LinkedIn CV (Revenue on Conversions)
conversion_value
Overview
LinkedIn Conversion Value (LinkedIn CV, LinkedIn Revenue on Conversions) refers to the total conversion value as reported by LinkedIn.
LinkedIn CV = Total LinkedIn-Reported Conversion Value
The calculation is based on data from the Ads table.
Detailed Breakdown
The formula above is derived from the following components:
Conversion Value (CV) = SUM(conversion_value)
--> Ads table
LinkedIn Ads = where channel = 'linkedin'
Insights and Actions
LinkedIn Conversion Value (CV) measures the total value of conversions attributed to your LinkedIn ads, offering insights into the revenue impact of your campaigns:
- Assess Campaign Revenue Impact: Track LinkedIn CV to understand how much revenue your campaigns are generating. Use this data to evaluate the overall effectiveness of your LinkedIn ad spend.
- Identify High-Value Audiences: Compare conversion value across campaigns or audience segments to pinpoint which groups deliver the most revenue, guiding targeting strategies.
- Optimize Campaign Strategy: Pair LinkedIn CV with metrics like ROAS and CPA to refine bidding strategies and allocate budget to high-performing campaigns.
Related Metrics
- LinkedIn ROAS: Complements CV by showing revenue generated per dollar spent, helping evaluate campaign profitability.
- LinkedIn Conversions (Purchases): Provides context for CV by revealing the number of conversions driving the reported revenue.
- LinkedIn Ad Spend: Offers insights into the cost side of the equation, helping to balance revenue against investment for better campaign optimization.
Example Use
Prompt
What's my total LinkedIn-reported conversion value over the last 7 days?
Response
Query
SELECT
pjt.channel AS channel,
SUM(pjt.channel_reported_conversion_value) AS channel_reported_conversion_value
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.model = 'Triple Attribution'
AND pjt.channel = 'linkedin'
AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1
GROUP BY
pjt.channel;
Updated 11 days ago