Two Minute Reports Logo
Connectors

LinkedIn Ads

Connect LinkedIn Ads to Google Sheets or Google Data Studio

The LinkedIn Ads connector gets your LinkedIn Ads data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.

What you can report on

  • Campaign impressions, clicks, and CTR
  • Cost per click (CPC) and cost per lead (CPL)
  • Lead Gen Form submissions and conversion tracking
  • Audience targeting performance by job title, industry, and company size
  • Sponsored Content, Message Ads, and Dynamic Ads metrics

Prerequisites

  • A LinkedIn Campaign Manager account
  • Report Viewer access or higher on the ad accounts you want to report on
  • Admin access to the LinkedIn Company Page, if you want to measure ad content performance: headlines, images, CTAs, and metadata such as impressions and clicks

Revenue Attribution metrics

The Revenue Attribution metrics include Revenue won (USD), ROAS (Revenue attribution) and Open opportunities. LinkedIn gives these metrics only when these conditions are true:

  • A LinkedIn Business Manager account must claim the ad account.
  • The date range must be 30 days or more.
  • The start date must be in the last 366 days.
Opportunity amount (USD) and Open opportunities show data only when the end date is today.

If a query does not obey these conditions, it shows an error or a warning. See Troubleshooting.

Demographics by campaign group, campaign or creative

You can show a demographic, for example Company Name or Country, for each campaign group, campaign or creative. To do this, add one field from Demographics and one or more fields from Campaign Group, Campaign or Creative. You can also add fields from Time and Account.

These rules apply:

  • A query can have only one field from Demographics.
  • You cannot use a field from Demographics with fields from Conversion or Publisher platform.

LinkedIn gives the demographic data for one campaign group, campaign or creative at a time. Thus a query with many campaigns can take 1 to 2 minutes.

Why the demographic values do not add up to the campaign total

The demographic values of a campaign group, campaign or creative are not equal to its total. This is how LinkedIn reports demographics. The same occurs for an account:

  • LinkedIn removes small values. It shows a demographic value only when it has 3 events or more, for example 3 clicks. Thus the sum of the values is usually less than the total.
  • Engagement metrics lose more data than impressions. Clicks, reactions and other engagement events are fewer, so more values are below the limit. For some campaigns, the demographic rows show only a small part of the clicks.
  • One member can count for more than one value. For example, a member with two jobs counts for two companies. Thus for some demographics, such as Industry or Job function, the sum can be more than the total.
  • Daily data shows a little less than monthly data. LinkedIn applies the limit to each period. A query with Date removes more small values than a query with Year month.
  • A small creative can have no demographic rows.

Ad text fields

Three fields in Creative give the text of an ad. For Sponsored Content, each field shows the text from one field in LinkedIn Campaign Manager:

FieldText from Campaign Manager
Introductory textIntroductory text, the text above the image, video or document
Creative titleHeadline. Empty if the ad has no headline.
Creative textDescription. If the ad has no description, this field shows the introductory text in LinkedIn's internal format: hashtags, mentions and some characters, such as brackets, are written differently. Use Introductory text to get the text as it shows on LinkedIn.

In Creative title and Creative text, each comma shows as a space.

Introductory text is empty for an ad that has no introductory text, for example a Text Ad or a Message Ad.

How to create a connection

  1. In the Hub, open Connections & accounts.
  2. Select Create connection.
  3. Select LinkedIn Ads in the connector list.
  4. Select Next.

  1. In Name the connection, enter a name.
  2. Sign in with LinkedIn. Then allow Two Minute Reports access.

  1. Enable the accounts you want to report on.
  2. Select Done.

Only enabled accounts fetch data, and only enabled accounts count toward your plan. You can enable or disable accounts at any time on the Connections & accounts page.

How to get LinkedIn Ads data into Google Sheets or Google Data Studio

To get LinkedIn Ads data into Google Sheets:

  1. In the Two Minute Reports sidebar, open Data Queries.
  2. Select Add.
  3. Select the accounts you want to report on. You can select more than one.
  4. Select your metrics and dimensions.
  5. Select the date range.
  6. Set sorting and filters if you need them.
  7. Select Run query. Two Minute Reports adds the data to your sheet.

Troubleshooting

The query fails: the ad account must be linked to a LinkedIn Business Manager

A query with Revenue Attribution metrics fails with this error:

Your ad account (ad account ID) must be linked to a LinkedIn Business Manager account to access Revenue Attribution metrics. Please connect it and try again.

LinkedIn gives these metrics only for an ad account that a LinkedIn Business Manager account claims. To correct the error:

  1. In LinkedIn Business Manager, link the ad account to your Business Manager account.
  2. Run the query again.

The query fails: the date range is too short or too old

A query with Revenue Attribution metrics fails with one of these errors:

The Revenue Attributed Metrics can only be queried for more than 30 days. Please adjust your date range and try again.

The Revenue Attributed Metrics can only be queried for the last 366 days. Please adjust your date range and try again.

To correct the error, change the date range of the query:

  • Set a date range of 30 days or more. The count includes the start date and the end date, so a range of exactly 30 days is correct.
  • Set a start date in the last 366 days.

A warning says that a metric is only available when the end date is today

A query with Opportunity amount (USD) or Open opportunities and an end date before today runs, but it shows a warning such as:

The metric 'Opportunity amount (USD)' is only available when the end date is set to today.

LinkedIn gives these two metrics only for a date range that ends today. To get data for them, set the end date of the query to today. To keep a date range that ends before today, remove these two metrics from the query.

Copyright © 2026