LinkedIn revenue attribution reporting template for Looker Studio
Discover how your LinkedIn ad campaigns influenced closed won deals and business revenue using this (beta template) revenue attribution reporting template for Looker Studio (formerly Google Data Studio). See the instructions below and start using the template!
Stay on top of your revenue target
Identify top-performing campaigns
How to use the template
Please ensure that you have the correct permissions to authenticate the integration. In order to get the data you need, connect your LinkedIn Ads and CRM (Salesforce or HubSpot) from the Revenue Attribution Report Tab on LinkedIn.
- Click on ‘Get the template’.
- Authenticate your account by clicking on ‘Authorize’.
- Choose an account. All the blue check marks must be selected: Allow 'Select ad accounts', ‘Lookback window’, ‘Influence level’, and ‘Engagement type’ to be modified in reports. The ‘Use report template for new reports’ checkmark must be selected too. ‘
- Once you’re happy, click on ‘Connect’ in the top-right.
- The next page will display all available dimensions and metrics.
- Click 'Create report'. After this, the template will fetch all your data in the report, ready for you to derive insights!
Questions you can answer with this template
Revenue performance
- What is the overall trend in revenue won over the specific time period?
- How does revenue performance vary month over month?
- How close are you to meeting your revenue targets?
Ad spend and efficiency
- How has spend on LinkedIn Ads evolved over time?
- Are there any noticeable patterns or trends in LinkedIn Ads spend?
- What is the Cost Per Acquisition (CPA) trend?
- How does the Return on Ad Spend (ROAS) vary month over month, and what does it indicate?
- How do ROAS and CP fluctuate on a monthly basis, and are there any patterns?
- Can you identify any specific months where efficiency metrics showed significant changes?
Deal metrics
- What is the average time it takes to close a deal and has there been any significant change?
- How can you leverage insights into the average days to close for better planning?
- How have leads, open opportunities, and closed-won deals performed over the specific period?
- Are there any correlations between these metrics and revenue won?
- How does the average deal size vary each month, and what factors may contribute to these changes?
Campaigns metrics
- Which campaigns have contributed the most to revenue, and what distinguishes them?
- How can we optimize strategies based on the performance of these top or bottom campaigns?
- Are there specific campaigns or campaign groups that stand out in terms of performance?
Want to know how many of the closed deals are influenced by your marketing campaigns?
Try our free LinkedIn revenue attribution reporting template to uncover the insights with a 14-day free trial. No credit card required.
See our other templates
Stay in the loop with our newsletter
Be the first to hear about product updates and marketing data tips