Connect LinkedIn Ads to Google Data Studio with Windsor.ai

Directly connect LinkedIn Ads to Google Data Studio, in minutes, and in an easy-to-use format.

data integration

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Data Automation
data warehouse

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About LinkedIn Ads

LinkedIn Ads is a pay-per-click (PPC) advertising platform that allows businesses to display ads to LinkedIn users, the world’s largest professional network on the internet with 875 million members in more than 200 countries and territories worldwide. LinkedIn is a professional networking platform, so the users are typically professionals and decision-makers in their industries. LinkedIn Ads offers a number of targeting options that are specific to the professional context, such as job title, industry, company size, and location. This can make LinkedIn Ads a particularly effective way to reach a business-to-business (B2B) audience.

 

Learn more about LinkedIn Ads

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.

 

Learn more about Google Data Studio

Why integrate LinkedIn Ads with Google Data Studio?

  • Google Data Studio allows you to collect all your marketing data in one place and can save you time and effort by eliminating the need to manually download and combine data from multiple sources.,

 

  • By integrating LinkedIn Ads with Google Data Studio, you can see how your LinkedIn Ads campaigns are performing alongside your other marketing efforts, such as search engine marketing or social media advertising.

 

  • You can create customizable dashboards and reports to track the performance of your LinkedIn ads in real time which gives you insights into how best to optimize them for maximum results.

 

  • Google Data Studio can help you measure the impact of your ad creatives, make smarter creative strategy decisions, and make modifications as needed.

 

  • You can also share your reports and dashboards with others in your organization, such as your team members or clients. This can help you communicate your marketing performance and results effectively.

About the LinkedIn Ads Google Data Studio Connector

The Linkedin Ads Google Data Studio Connector pulls Metrics and Dimensions for Linkedin Ads. The Insights are retrieved at the Campaign Level.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

To set up the connector, the user should have:

How to connect LinkedIn Ads to Google Data Studio?

Select the fields on the right to later use in your data source. For example, you can include metrics such as Spend, Impressions, or Conversions.

select fields on the right

Go to “Select Destination” and choose Google Data Studio.

Once done, select “connect” and authorize access to your data source.

Windsor.ai LinkedIn Ads Google Data Studio Connector

Windsor.ai: All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

  • Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
  • The setup is done in minutes. No coding is required.
  • Currently, we support more than 3000 dimensions and metrics.
  • See the value and return on every marketing touchpoint.
  • Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Google Data Studio Templates for LinkedIn Ads

Do you plan to connect and visualize your LinkedIn Ads in Google Data Studio? 

These free and customizable Google Data Studio LinkedIn Ads templates will assist you in visualizing your data for easy reporting and analysis.

Google Data Studio Tutorials for LinkedIn Ads

Would you like to take your Google Data Studio LinkedIn Ads dashboards to the next level? 

Here are some of our favorite tutorials to help you:

Available LinkedIn Ads Metrics and Dimensions

NameTypeDescription
Account IDTEXTAdvertisement account ID
Account NameTEXTA label for the account.
Account typeTEXTAccount type
Account ID (Duplicate)TEXTAdvertisement account ID (Duplicate)
Ad NameTEXTThe ad name
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Ad Network RevenueNUMERICThe Ad Network Reported Revenue
Approximate Unique ImpressionsNUMERICThe approximate reach of the campaign. The number of unique member accounts with at least one impression.
Average frequencyNUMERICAverage number of impressions seen by each member account exposed to at least one impression
CampaignTEXTThe campaign name
Campaign AccountTEXTAccount where campaign is running
Campaign Cost TypeTEXTCampaign cost type
Campaign daily budget amountTEXTDaily Budget Amount
Campaign end dateDATECampaign End Date
Campaign Group BackfilledBOOLEANFlag that denotes whether the campaign group was created organically or to backfill existing campaigns. This is a read-only field set by the system.
Campaign Group IDNUMERICTumerical identifier for the campaign group. This is a read-only field set by the system.
Campaign Group NameTEXTThe name of the campaign group used to make it easier to reference a campaign group and recall its purpose. The value of this field cannot exceed 100 characters.
Campaign Group Run Scedule End TimeDATERepresents the exclusive (strictly less than) date when to stop running the associated campaigns under this campaign group. If this field is unset, it indicates an open range with no end date. This field is required if totalBudget is set.
Campaign Group Run Scedule Start TimeDATERepresents the inclusive (greater than or equal to) date when to start running the associated campaigns under this campaign group. This field is required.
Campaign Group StatusTEXTStatus of campaign group.
Campaign Group Total BudgetNUMERICMaximum amount to spend across all associated campaigns and creatives for duration of the campaign group.
Campaign IDTEXTThe campaign ID
Campaign Start DateDATECampaign Start Date
Campaign Group StatusTEXTStatus of campaign group.
Campaign total budget amountTEXTTotal Budget Amount
Campaign TypeTEXTCampaign type
ClicksNUMERICThe count of clicks.
CommentsNUMERICNumber of Comments
CompletionsNUMERICThe count of video ads that played 97-100% of the video.
Share conversionsNUMERICNumber of External Website Conversions after Post View
Conversion Value (Local Currency)NUMERICValue of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range.
Share cost in USDNUMERICCampaign Cost in USD
Cost Per External Website ConversionsNUMERICCost in the account's local currency divided by the count of conversions indicated by pixel loads on an external advertiser website.
Cost Per External Website Post Click ConversionsNUMERICCost in the account's local currency divided by the count of post-click conversions indicated by pixel loads.on an external advertiser website.
Cost Per External Website Post View ConversionsNUMERICCost in the account's local currency divided by the count of post-view conversions indicated by pixel loads on an external advertiser website.
Cost Per Job ApplicationNUMERICCost in the account's local currency divided by the number of times a member completed a job application
Country CodeTEXTList of target locations
CPCNUMERICCost-per-click (CPC)
CPMNUMERICCost per mille (CPM).It is the cost an advertiser pays for one thousand views or impressions of an advertisement (1000 * cost / impressions)
Creative Creation DatetimeDATECreative Creation Date and Time
Creative IDTEXTCreative ID
Creative Last Modified DatetimeDATECreative Last Modified Date and Time
Creative StatusTEXTCreative Status
CTRPERCENTClick-through rate (CTR)
CurrencyTEXTAccount currency (default="USD")
DateDATEDates covered by the report data point. Date is specified in UTC.
Engagement RateNUMERICNumber of times members interacted with your ad (paid and free clicks divided by total impressions)
EngagementsNUMERICThe total number of actions that people took on your Linkedin Ads.
External Website ConversionsNUMERICThe count of conversions indicated by pixel loads on an external advertiser website.
External Website Post Click ConversionsNUMERICThe count of post-click conversions indicated by pixel loads on an external advertiser website.
External Website Post View ConversionsNUMERICThe count of post-view conversions indicated by pixel loads on an external advertiser website.
FollowsNUMERICThe count of follows. Sponsored Updates only.
Share full screen playsNUMERICNumber of Full Screen Plays
ImpressionsNUMERICThis is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails.
Job ApplicationsNUMERICThe number of times a member completed a job applicationafter viewing or clicking on an ad. Currently, this metric is broken down into postViewJobApplications (if the member applied after viewing the ad) and postClickJobApplications (if the member applied after clicking the ad).
Job Apply ClicksNUMERICThe number of times a member clicked on the job’s apply button on an LinkedIn jobs page after viewing or clicking on an ad which has a LinkedIn job landing page. Currently, this metric is broken down into postViewJobApplyClicks (if the member performed the action after viewing the ad) and postClickJobApplyClicks (if the member performed the action after clicking the ad).
Share landing page clicksNUMERICNumber of Clicks to the Landing Page
Landing Page ClicksNUMERICThe count of clicks which take the user to the creative landing page.
Lead Generation Mail Contact Info SharesNUMERICThe number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
LikesNUMERICThe count of likes. Sponsored Updates only.
Member company nameTEXTCompany names of LinkedIn members engaged with campaigns
Member company sizeTEXTApproximate company size of LinkedIn members engaged with campaigns
Member countryTEXTCountries of LinkedIn members engaged with campaigns
Member industryTEXTIndustry of LinkedIn members engaged with campaigns
Member job functionTEXTJob functions of LinkedIn members engaged with campaigns
Member job titleTEXTJob titles of LinkedIn members engaged with campaigns
Member regionTEXTGeographic regions of LinkedIn members engaged with campaigns
Member seniorityTEXTSeniority of LinkedIn members engaged with campaigns
Objective TypeTEXTCampaign Objective type values.
One Click Lead Form OpensNUMERICThe count of times users opened the lead form for a One Click Lead Gen campaign.
One Click LeadsNUMERICThe count of leads generated through One Click Lead Gen.
OpensNUMERICThe count of opens of Sponsored InMail. Sponsored InMail only.
Optimization Target TypeTEXTDetermines how this campaign is optimized for spending. If this is not set, there is no optimization.
Share other engagementsNUMERICNumber of Other Engagements
Video watches at 25%NUMERICThe count of video ads that played through the first quartile of the video.
Video watches at 50%NUMERICThe count of video ads that played through the midpoint of the video.
Video watches at 75%NUMERICThe count of video ads that played through the third quartile of the video.
Share reactionsNUMERICNumber of Reactions by Campaign
Share creation datetimeDATEPost Creation Date and Time
Share IDTEXTShare (Post) ID
Share landing pageTEXTPost landing page
Share last modified datetimeDATEPost Last Modification Date and Time
Share textTEXTPost Text
Share titleTEXTPost Title
Share TypeTEXTShare/post media category
SharesNUMERICThis is the count of "shares" for sponsored Shares.
SpendNUMERICCost in the account's local currency
Targeting Exclude Age RangeOBJECTA segment of members who will be excluded from the advertising campaign's targeting by organization.
Targeting Exclude EmployersOBJECTA segment of members who will be excluded from the advertising campaign's targeting by age rate.
Targeting Exclude GroupsOBJECTA segment of members who will be excluded from the advertising campaign's targeting by groups.
Targeting Exclude IndustriesOBJECTA segment of members who will be excluded from the advertising campaign's targeting by standardized industries.
Targeting Exclude Interface LocalesOBJECTA segment of members who will be excluded from the advertising campaign's targeting by interface locales.
Targeting Exclude Job FunctionsOBJECTA segment of members who will be excluded from the advertising campaign's targeting by standardized job functions.
Targeting Exclude LocationsOBJECTA segment of members who will be excluded from the advertising campaign's targeting by locations.
Targeting Exclude SenioritiesOBJECTA segment of members who will be excluded from the advertising campaign's targeting by standardized seniorities.
Targeting Exclude TitlesOBJECTA segment of members who will be excluded from the advertising campaign's targeting by standardized titles.
Targeting Include Age RangeOBJECTA segment of members who will be included in the advertising campaign's targeting by organization.
Targeting Include EmployersOBJECTA segment of members who will be included in the advertising campaign's targeting by age rate.
Targeting Include GroupsOBJECTA segment of members who will be included in the advertising campaign's targeting by groups.
Targeting Include IndustriesOBJECTA segment of members who will be included in the advertising campaign's targeting by standardized industries.
Targeting Include Interface LocalesOBJECTA segment of members who will be included in the advertising campaign's targeting by interface locales.
Targeting Include Job FunctionsOBJECTA segment of members who will be included in the advertising campaign's targeting by standardized job functions.
Targeting Include LocationsOBJECTA segment of members who will be included in the advertising campaign's targeting by locations.
Targeting Include SenioritiesOBJECTA segment of members who will be included in the advertising campaign's targeting by standardized seniorities.
Targeting Include TitlesOBJECTA segment of members who will be included in the advertising campaign's targeting by standardized titles.
Share total engagementsNUMERICNumber of total Engagements
Total CostNUMERICCost in the account's local currency (Duplicate of Spend)
Transaction Revenue (Local Currency)NUMERICConversion Value (Duplicate of Conversion Value (Local Currency))
TransactionsNUMERICThe number of transactions (Duplicate of External Website Conversions)
Video CompletionsNUMERICThe count of video ads that played 97-100% of the video.
Video playsNUMERICThe number of times a video starts to play
Video playsNUMERICThe number of times a video starts to play
Video watches at 25% (Duplicate)NUMERICThe count of video ads that played through the first quartile of the video. (Duplicate)
Video watches at 50% (Duplicate)NUMERICThe count of video ads that played through the midpoint of the video. (Duplicate)
Video watches at 75% (Duplicate)NUMERICThe count of video ads that played through the third quartile of the video. (Duplicate)
Video viewsNUMERIC2 or more continuous seconds of playback while the video is at least 50% on screen, or a click on the CTA, whichever comes first.
Share viral clicksNUMERICNumber of Viral Clicks Aggregated by Campaign
Share viral commentsNUMERICNumber of Viral Comments by Campaign
Viral External Website ConversionsNUMERICThe count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
Share viral followsNUMERICNumber of Viral Follows by Campaign
Share viral full screen playsNUMERICNumber of Viral Full Screen Plays
Share viral impressoinsNUMERICNumber of Viral Impressions Aggregated by Campaign
Share viral landing page clicksNUMERICNumber of Viral Clicks to the Landing Page
Share viral likesNUMERICNumber of Viral Likes by Campaign
Share viral reactionsNUMERICNumber of Viral Reactoins by Campaign
Share viral sharesNUMERICNumber of Viral Shares by Share
Share viral total engagementsNUMERICViral Total Engagements
Share viral video completionsNUMERICNumber of Viral Video Views to 100%
Share viral video startsNUMERICNumber of Viral Video Starts
Share viral video viewed 25pcntNUMERICNumber of Viral Video Views to 25%
Share viral video viewed 50pcntNUMERICNumber of Viral Video Views to 50%
Share viral video viewed 75pcntNUMERICNumber of Viral Video Views to 75%
Share viral video viewsNUMERICNumber of Viral Video Views
Viral External Website Conversions (Duplicate)NUMERICThe count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
Viral External Website Post Click ConversionsNUMERICThe count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
Viral External Website Post View ConversionsNUMERICThe count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
Viral One Click LeadsNUMERICThe count of leads generated through One Click Lead Gen from viral impressions for this activity.