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!

Get started

Note that this will start a 14-day free trial of Supermetrics for Looker Studio.

carousel image
Data sources:LinkedIn Revenue Attribution
Use cases:
Paid media
Social media

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.

  1. Click on ‘Get the template’.
  2. Authenticate your account by clicking on ‘Authorize’.
  3. 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. ‘
  4. Once you’re happy, click on ‘Connect’ in the top-right.
  5. The next page will display all available dimensions and metrics.
  6. Click 'Create report'. After this, the template will fetch all your data in the report, ready for you to derive insights!
Get the template

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

All marketing templates

All marketing templates