Build a report
Sign in with Google
Works with Looker Studio

LinkedIn Ads creative analysis dashboard template for Google Sheets

Identify your most effective LinedIn ads and creative assets by analyzing their engagement and conversion rates. Compare ad performance against your targets, examining key metrics such as ad names, Return on Ad Spend (ROAS), and hook rate to determine which creatives are driving the best results.

Download Template

By Porter

This template is built by the same marketers behind all our tutorials, support, and our template gallery.

Data sources included

+40,000 marketers have downloaded our dashboards

Questions you can answer using this LinkedIn Ads dashboard template

  • Which ads are significantly overperforming, and what common elements do they share?
  • Which ads are underperforming, and what factors might be contributing to their poor performance?
  • How do different budget strategies (daily, weekly, lifetime) impact ad performance?
  • What targeting methods (e.g., lookalike audiences, interest-based, custom audiences) are yielding the best results?
  • How does the duration of ad campaigns affect their performance?
  • Are there any trends in performance based on ad content or messaging?
  • How effective are our video ads compared to static image ads?
  • Which ads have the best ROI, and how can we scale their success?
  • What is the relationship between ad spend and performance across different metrics?
  • How do our best-performing ads compare to our target metrics?

How to set up this Google Sheets template?

Copy the LinkedIn Ads creative analysis dashboard template for Google Sheets in one click and automate your reporting

Follow these steps:


  • Step 1: Make a copy of the template.

  • Step 2: Download the extension and authorize your profile.

  • Step 3: Choose the accounts you want to pull data from.

  • Step 4: Use our prebuilt queries or build one from scratch to automate your data collection. Alternatively, you can input data manually.

  • Step 5: Set up automatic refresh to keep your dashboard updated.


Metrics and dimensions included

Customize the template’s metrics and dimensions as you like. See all available Facebook Ads fields.

Metrics

  • Engagement metrics

    • Link clicks
    • CTR (Click-through rate)
    • Landing page views
    • Hook rate

  • Customizable charts

    • Leads
    • Lead conversion value
    • Purchase ROAS (Return on Ad Spend)
    • CPA (Cost Per Acquisition)
    • ROAS score (Winner/Loser)

Dimensions

  • Date

    • Time progress: hours, days, weeks, month, quarter, and year.
    • Status: overspending or underspending
    • By day, week, month, quarter, or year.

Features

You can customize your marketing reports directly in Google Sheets with your logo, colors, and branding.
Set up email alerts using conditional notifications when a cell value changes.
Edit all charts and change style values, and then paste them on your Google Slides so they can auto sync.

Utilize functions like SUMIF, VLOOKUP, IF, and ARRAYFORMULA to calculate key metrics like CPA, ROAS, and CTR, automating calculations and combining data fields.

Pull your historical marketing data automatically using our Google Sheets marketing extension.

Filter by date, campaign, channel, and more to get the insights you need.
Set, track, and achieve marketing goals with real-time updates.
Set sync intervals to match your reporting needs, whether daily, weekly, or monthly.
Connect Google Analytics, Facebook Ads, Instagram, LinkedIn, and more to create a unified view of your marketing performance.

FAQs

A LinkedIn Ads creative analysis dashboard report should include key metrics such as Total Impressions, Click-Through Rate (CTR), and Engagement Rate to evaluate the performance of each ad creative. Metrics like Video Views (25%, 50%, 75%, 100%) and Completion Rate are crucial for understanding how effectively each creative captures and retains viewer attention. Additionally, metrics like Conversion Rate, Cost per Conversion, and Leads Generated will help assess the effectiveness of the creative in driving key business outcomes.
The dashboard should also feature important financial metrics such as Return on Ad Spend (ROAS), Cost per Click (CPC), and Cost per Lead to provide insights into the cost-efficiency of each ad creative. Engagement metrics such as Likes, Comments, Shares, and Clicks on Call-to-Actions (CTAs) are essential for understanding audience interaction levels with each ad.
Including visualizations like creative performance comparisons, trend lines for CTR and ROAS, and audience engagement heatmaps will help provide clear insights into which ads are performing the best.

To automate this report, you should include a Google Sheets extension like Porter to allow autosync you Facebook Ads data for real-time data updates.

While this template is designed specifically for LinkedIn Ads, you can use Google Sheets’ multichannel connectors such as LinkedIn Ads, GA4, Shopify to integrate data from other marketing platforms. By combining insights from different sources, you can create a unified view of your overall marketing performance.

To set up email alerts, use the built-in notifications feature in Google Sheets. You can create custom rules to trigger email alerts based on specific conditions, such as when your actual spend exceeds the budget or when pacing percentages hit certain thresholds.

Yes, you can fully customize the charts in the dashboard. You can choose different chart types, adjust colors, fonts, and styles, add data labels, legends, and trendlines, and customize axes and gridlines to match your reporting needs.

Additional marketing templates you can copy

Connectors

Tutorials

Looker Studio templates

Google Sheets templates

Report templates