Connecting LinkedIn Ads

Pulling your LinkedIn Ads data into Google Sheets takes just a few clicks. Because Metric Might connects directly to the LinkedIn Marketing API, you can pull live B2B spend, Lead Gen Form performance, and demographic breakdowns across all your client accounts instantly.

1. Prerequisites (Required Permissions)

Before you can pull data, you must have the correct permissions inside LinkedIn Campaign Manager.

  • You must have at least Viewer, Campaign Manager, or Account Manager access to the specific LinkedIn Ad Account(s) you wish to query.
  • You authenticate using your personal LinkedIn profile. Ensure the profile you log in with is the one that has been granted access to the client’s ad accounts and associated LinkedIn Company Pages.

2. How to Connect

You can connect your LinkedIn Ads account without leaving the query builder.

  1. Open the Metric Might Web App and navigate to the Queries page.
  2. Under the Data source section, click the dropdown and select Add Data Source.
  3. Choose LinkedIn Ads.
  4. A secure popup will ask you to log into LinkedIn. Review the permissions and click Allow.
⚠️ Popup blocked? If nothing appears when you click to connect, your browser may be blocking the authentication popup. Allow popups for app.metricmight.com and try again.
💡 Personal profile required: LinkedIn's API authenticates via your personal LinkedIn profile, not a company page or agency account. Make sure the profile you use has been granted access to your clients' ad accounts in Campaign Manager.
💡 Agency Tip: When you authenticate your personal LinkedIn profile, Metric Might will automatically detect and unlock access to all of the ad accounts you have been granted access to. You do not need to authenticate every client individually.

3. Available Metrics & Dimensions

Metric Might dynamically fetches the most up-to-date metrics and dimensions directly from the LinkedIn API, so you always have access to the latest B2B advertising fields.

When building your query, click into the Metrics or Dimensions dropdowns to open the search overlay. You can search for standard performance fields like Spend, Impressions, and Clicks, as well as Lead Gen Form metrics like Leads and Cost per Lead.

You can also pull powerful professional dimensions, such as Job Title, Company Size, Industry, and Seniority.

Metric Might’s live compatibility matrix will automatically disable any fields that cannot be queried alongside your current selection.

4. Token Expiry

LinkedIn access tokens typically expire every 365 days, or immediately if you change your personal LinkedIn password or revoke access in your LinkedIn privacy settings.

You can see the exact expiry date of your LinkedIn connection at any time on the Connections page — it is displayed directly on the data source card. This lets you re-authenticate proactively before a scheduled refresh breaks.

If a LinkedIn query stops working unexpectedly with an authentication error, go to the Connections page, click the three-dot menu (⋮) next to the LinkedIn Ads data source, and select Sign In Again.

5. LinkedIn-Specific Quirks & Gotchas

Every ad platform’s API has unique behaviours. If your LinkedIn data looks slightly different from what you expect, or if fields are unexpectedly disabled, it is almost always due to one of the following.

Demographic Privacy Thresholds

LinkedIn provides incredible demographic reporting (e.g., seeing how many “CEOs” clicked your ad). However, to protect member privacy, LinkedIn strictly forbids mixing demographic dimensions with Conversion or Lead metrics. If you select Job Title as a dimension, Metric Might’s compatibility matrix will immediately grey out Leads and Conversions in the metrics list. This is a hard limitation set by LinkedIn, not a bug in Metric Might. You can only query demographic dimensions alongside top-of-funnel metrics like Clicks, Impressions, and Spend.

Conversion Attribution Timing

LinkedIn attributes conversions and leads back to the time the user interacted with the ad, not the time the conversion actually happened. If someone clicks your ad on Monday but fills out the Lead Gen Form on Thursday, LinkedIn credits the lead to Monday. This means your historical data will change retroactively. If you pull a report for “Last Week,” the numbers might look different today than they did three days ago.

Aggregated Performance vs. PII

Metric Might is designed to pull aggregated reporting data (e.g., “Campaign X generated 15 Leads”). We do not extract the Personally Identifiable Information (PII) of the leads themselves (like their names and email addresses) into your Google Sheet. If you need to access the contact details of individual leads, use LinkedIn’s native CRM integrations or a webhook tool like Zapier.

What’s Next?

Did this page help you?