Connect LinkedIn Ads to Google BigQuery with Windsor.ai

linkedin

+

bigquery

Stream all your marketing data from LinkedIn Ads to Google BigQuery

About LinkedIn Ads

LinkedIn ads is a self-service social media advertising platform which allows advertisers to reach out business professionals.

About Google BigQuery

Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.

LinkedIn Ads metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
CampaignTEXTThe campaign name
Ad NameTEXTThe ad name
DateDATEDates covered by the report data point. Date is specified in UTC.
ClicksNUMERICThe count of chargeable clicks.
CTRNUMERICClick-through rate (CTR)
CPCNUMERICCost-per-click (CPC)
SpendNUMERICCost in the account's local currency
Total CostNUMERICCost in the account's local currency (Duplicate of Spend)
ImpressionsNUMERICThis is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails.
Landing Page ClicksNUMERICThe count of clicks which take the user to the creative landing page.
LikesNUMERICThe count of likes. Sponsored Updates only.
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.
Transaction Revenue (Local Currency)NUMERICConversion Value (Duplicate of Conversion Value (Local Currency))
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.
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.
FollowsNUMERICThe count of follows. Sponsored Updates only.
Viral External Website ConversionsNUMERICThe 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.
TransactionsNUMERICThe number of transactions (Duplicate of External Website Conversions)
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.
Viral One Click LeadsNUMERICThe count of leads generated through One Click Lead Gen from viral impressions for this activity.
EngagementsNUMERICThe total number of actions that people took on your Linkedin Ads.
Video CompletionsNUMERICThe count of video ads that played 97-100% of the video.
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.
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.
Video playsNUMERICThe number of times a video starts to play
Share clicksNUMERICThe count of share clicks.
Share impressionsNUMERICThis is the count of "impressions" for sponsored Shares.
Share sharesNUMERICThis is the count of "shares" for sponsored Shares.
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Ad Network RevenueNUMERICThe Ad Network Reported Revenue
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 StatusTEXTStatus of campaign group.
Campaign Group Run Scedule Start TimeNUMERICRepresents 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 Run Scedule End TimeNUMERICRepresents 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 Total BudgetNUMERICMaximum amount to spend across all associated campaigns and creatives for duration of the campaign group.
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.

Windsor.ai: Easily connect LinkedIn Ads to Google BigQuery

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.