Connect LinkedIn Ads to Snowflake

linkedin ads to snowflake

Stream marketing data from LinkedIn Ads to Snowflake

Connect LinkedIn Ads to Snowflake in 2023

It is very simple to connect LinkedIn Ads to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1.You need to select Linkedin ads as a Data Source and Grant Access to Windsor.ai.

LinkedIn Ads Windsor.ai Onboarding Screen

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

4. Your data will now be streamed from Linkedin Ads to Snowflake. In case there is an error you will be notified.

Linkedin Ads metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account IDTEXTAdvertisement account ID
Account NameTEXTA label for the account.
Account typeTEXTAccount type
Account ID (Duplicate)TEXTAdvertisement account ID (Duplicate)
Form DescriptionTEXTDescription of the form, visible to both the owner and the viewer.
Form HeadlineTEXTHeadline of the form, visible to both the owner and the viewer.
TEXTOwner's legal disclaimer to accompany this form. Optional since the owner may alternatively use other fields (e.g. legalDisclaimer, consents) to surface the privacy policy.
TEXTUnique identifier of the LeadGenFormLegalInfo.
Form NameTEXTName of the Lead Form provided by the owner..
Form Review Last UpdatedDATEThe date indicating when the review status is initiated/last updated.
Form Review Reject ReasonTEXTAn array of rejection reasons for the Lead Form. It's Non-empty if the review status is REJECTED in the latest review.
Form Review StatusTEXTIndicate the state of review for the Lead Form. PENDING - The form is pending review and not serving. APPROVED - The form is approved for serving. REJECTED - The form is rejected. PREAPPROVED - form has been pre-approved, it's ready for serving but still need further review. AUTO_APPROVED - The form has been auto approved by content model. NEEDS_REVIEW - The form has been rejected by content model or policy checker or returned by fallback case that auto approval didn't make any decision. AUTO_REJECTED - The form has been auto rejected by content model.
Form Post Submission Call To Action LabelTEXTLabel for the call to action shown to the viewer. Default is VISIT_COMPANY_WEBSITE
Form Post Submission Call To Action TargetTEXTTarget where the user is taken after clicking on the CTA. E.g. a LandingPageUrl which is a url redirect to a web page. It can be empty for CTA's which don't require additional information.
Form Post Submission MessageTEXTThe message displayed to a member after the Lead Form is submitted.
Form Privacy Policy URLTEXTThe URL of the privacy policy that covers any data passed to the owner of the form. Optional since it is not required to be present for all the use cases.
Form StatusTEXTDRAFT, PUBLISHED, ARCHIVED. Draft - The form is still being edited. Published - The form is published, i.e. it has gone through processing (e.g. manual review) and is ready to be used. Archived - The form is archived.
Form Post Submission Message (Duplicate)TEXTThe message displayed to a member after the Lead Form is submitted.
Form Post Submission Call To Action Label (Duplicate)TEXTLabel for the call to action shown to the viewer. Default is VISIT_COMPANY_WEBSITE
(Deprecated) Ad NameTEXTDeprecated field. Alias for sponsored_creative_content_title. Probably you are looking for 'Creative Ad Context DSC Name' (creative_content_data_share_ad_context_dsc_name)
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Ad Network RevenueNUMERICThe Ad Network Reported Revenue
Form Response AnswersTEXTAll answers on form response
Approximate Unique ImpressionsNUMERICThe approximate reach of the campaign. The number of unique member accounts with at least one impression. Can be requested for date ranges with a maximum range of 92 days. The expected delay for current UTC day will be 24-48 hours. Requests which include today in the date range will only return reach for days where data exists.
Average frequencyPERCENTAverage 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 IDTEXTTumerical 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 TimeTIMESTAMPRepresents 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 TimeTIMESTAMPRepresents 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
Card ClicksNUMERICThe number of clicks for each card of a carousel ad.
Card Clicks (Viral)NUMERICThe number of viralClicks for each card of a carousel ad.
Card ImpressionsNUMERICThe number of impressions for each card of a carousel ad.
Card Impressions (Viral)NUMERICThe number of viralImpressions for each card of a carousel ad.
Card IndexTEXTGroup results by conversion.
ClicksNUMERICThe count of clicks.
CommentsNUMERICNumber of Comments
CompletionsNUMERICThe count of video ads that played 97-100% of the video.
Conversion Attribution TypeTEXTThe model that describes how conversion actions are to be counted. Acceptable values are: LAST_TOUCH_BY_CAMPAIGN and LAST_TOUCH_BY_CONVERSION
Conversion Created DateDATEConversion Created Date
Conversion EnabledBOOLEANSet to true or false to enable or disable this rule from matching on the advertiser’s website. The initial state can be either, but only rules that are enabled will trigger conversion events.
Conversion IDTEXTConversion ID
Conversion Last Callback At DateDATEThe last time one or more of the URL match rules fired and called back to the server.
Conversion Last Modified DateDATEA date corresponding to the last modification of this resource.
Conversion NameTEXTA short name for this conversion.
Conversion PivotTEXTGroup results by conversion.
Conversion Post Click Attribution Window SizeTEXTSpecifies a user's settings on the post click attribution window in days.
Conversion TypeTEXTThe type of the conversion.
Conversion View Through Attribution Window SizeTEXTSpecifies a user's settings on the view through (post view) attribution window in days.
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 CodeCOUNTRYList of country codes 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 Ad Context DSC Ad TypeTEXTThe type of DSC (e.g. VIDEO, STANDARD, CAROUSEL, etc.)
Creative Ad Context DSC NameTEXTPlain text name of the DSC post.
Creative Ad Context DSC StatusTEXTThe status of the advertising company content. Representing whether the content is usable from the advertiser's perspective as a DSC
Creative Creation DatetimeTIMESTAMPCreative Creation Date and Time
Creative IDTEXTCreative ID
Creative Last Modified DatetimeTIMESTAMPCreative Last Modified Date and Time
Creative StatusTEXTCreative Status
Creative thumbnailIMAGE_URLCreative thumbnail
CTRPERCENTClick-through rate (CTR)
CurrencyTEXTAccount currency (default="USD")
Data SourceTEXTThe name of the Windsor connector returning the row
DateDATEDates covered by the report data point. Date is specified in UTC.
Day of monthTEXTDay of the month
Engagement RatePERCENTNumber 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.
Form Response Campaign IDTEXTCampaign id that this form response is connected
Form Response Campaign NameTEXTCampaign name that this form response is connected
Form Campaign TypeTEXTCampaign type that this form response is connected
Form Created DateDATEDate and time corresponding to the creation of the form.
Form Creation Locale CountryCOUNTRYA lowercase two-letter language code as defined by ISO-639-1
Form Creation Locale LanguageTEXTAn uppercase two-letter country code as defined by ISO-3166
Form Creative IDTEXTForm creative id
Form IDTEXTNumerical identifier for the form.
Form Last Modified DateDATEDate and time corresponding to the last modified date of the form.
Form Response Owner Account Info NameTEXTName of the owner of the Lead Form Response.
Form Owner IDTEXTID that identifies the owner of the Lead Form.
Form Response Associated Creative StatusTEXTStatus of creative, associated with this Form Response
TEXTAll Consent Response answers on this Form Response
Form Response idTEXTID of a Form response
Form Response Owner IDTEXTID that identifies the owner of the Lead Form Response.
Form Response SubmitterTEXTID that identifies the person who submitted the Lead Form Response.
Form Version IDTEXTThe version ID of the form. This is a derived field and is generated on the server side.
Form Version TagTEXTThe number of times the form has been modified.
Share full screen playsNUMERICNumber of Full Screen Plays
Form Hidden FieldsOBJECTHidden fields used by the owner to track key attributes of the form that generated the lead. The field is empty if the owner chooses to not append any tracking attributes to the Lead Form.
Impression device typeTEXTGroup results by the device type the ad made an impression on. Reach metrics and conversion metrics will not be available when this pivot is used.
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).
Landing PageTEXTLanding Page
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 type Form ResponseTEXTType of the lead representing the origination of the lead.
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 countryCOUNTRYCountries 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 regionREGIONGeographic regions of LinkedIn members engaged with campaigns
Member seniorityTEXTSeniority of LinkedIn members engaged with campaigns
MonthTEXTNumber of the month
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
Placement NameTEXTGroup results by placement.
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
Service LocationTEXTGroup results by serving location, onsite or offsite.
Share creation datetimeTIMESTAMPPost Creation Date and Time
Share IDTEXTShare (Post) ID
Share landing pageTEXTPost landing page
Share last modified datetimeTIMESTAMPPost 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.
SourceTEXTThe name of the Windsor connector returning the row
SpendNUMERICCost in the account's local currency
Creative DescriptionTEXTSponsored creative (ad) description
Creative TitleTEXTcreative (ad) title
Form Response submitted at timeDATEForm response submitted time f: YYYY-MM-DD
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.
Is this test lead?BOOLEANTrue/False is this test lead form response
TodayDATEToday's date
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 plays (duplicate)NUMERICThe 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.
WeekTEXTWeek (Sun-Sat).
Day of week and day numberTEXTWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
Day of week and day number, ISOTEXTWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
Week ISOTEXTWeek, ISO format (Mon-Sun).
YearTEXTYear
YearmonthTEXTYear and month, e.g. 2024|3
Year of weekTEXTThe year that contains first day of the week (Sun-Sat).
Year of week, ISOTEXTThe year that contains first day of the ISO week (Mon-Sun).
Year weekTEXTYear and week for US weeks (Sun-Sat), e.g. 2024|15
Year week ISOTEXTYear and week for ISO weeks (Mon-Sun), e.g. 2024|20

Easily connect Linkedin Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

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

insights

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

Build your Linkedin Ads and Snowflake Integrations