Connect LinkedIn Ads to Snowflake with Windsor.ai
+
Stream all your marketing data from LinkedIn Ads to Snowflake
About LinkedIn Ads
LinkedIn Ads is a self-service social media advertising platform which allows advertisers to reach out business professionals. It is commonly used by B2B marketers to create brand awareness as well as to drive conversions.
About Snowflake
Snowflake is a cloud data warehouse. Contrary to on premise data bases it eliminates the need to maintain hardware infrastructure. I’s architecture allow it to scale dynamically depending on the resource consumption needed by the users. The outcome of working with a cloud data warehouse like Snowflake is a greatly increased productivity of end users working with Snowflake data.
First Step:
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDOSR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the rerquired 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.
- In Select Destination select Snowflake as destination
- Enter all the credentials required and click Save
- Your data will now be streamed to Snowflake. In case there is an error you will be notified.
You should also read:
Microsoft Power BI LinkedIn Ads Report Dashboard Template
Google Sheets PPC Planning Template for Google Ads, Bing ads, Facebook Ads, LinkedIn Ads
LinkedIn Ads metrics and dimensions available for streaming into Snowflake
| Name | Type | Description |
|---|---|---|
| Account ID | TEXT | Advertisement account ID |
| Account Name | TEXT | A label for the account. |
| Account type | TEXT | Account type |
| Account ID (Duplicate) | TEXT | Advertisement account ID (Duplicate) |
| Ad Name | TEXT | The ad name |
| Ad Network Conversions | NUMERIC | The Ad Network Reported Conversions |
| Ad Network Revenue | NUMERIC | The Ad Network Reported Revenue |
| Approximate Unique Impressions | NUMERIC | The approximate reach of the campaign. The number of unique member accounts with at least one impression. |
| Average frequency | NUMERIC | Average number of impressions seen by each member account exposed to at least one impression |
| Campaign | TEXT | The campaign name |
| Campaign Account | TEXT | Account where campaign is running |
| Campaign Cost Type | TEXT | Campaign cost type |
| Campaign daily budget amount | TEXT | Daily Budget Amount |
| Campaign end date | DATE | Campaign End Date |
| Campaign Group Backfilled | BOOLEAN | Flag 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 ID | NUMERIC | Tumerical identifier for the campaign group. This is a read-only field set by the system. |
| Campaign Group Name | TEXT | The 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 Time | DATE | Represents 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 Time | DATE | Represents 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 Status | TEXT | Status of campaign group. |
| Campaign Group Total Budget | NUMERIC | Maximum amount to spend across all associated campaigns and creatives for duration of the campaign group. |
| Campaign ID | TEXT | The campaign ID |
| Campaign Start Date | DATE | Campaign Start Date |
| Campaign Group Status | TEXT | Status of campaign group. |
| Campaign total budget amount | TEXT | Total Budget Amount |
| Campaign Type | TEXT | Campaign type |
| Clicks | NUMERIC | The count of clicks. |
| Comments | NUMERIC | Number of Comments |
| Completions | NUMERIC | The count of video ads that played 97-100% of the video. |
| Share conversions | NUMERIC | Number of External Website Conversions after Post View |
| Conversion Value (Local Currency) | NUMERIC | Value 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 USD | NUMERIC | Campaign Cost in USD |
| Cost Per External Website Conversions | NUMERIC | Cost 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 Conversions | NUMERIC | Cost 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 Conversions | NUMERIC | Cost 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 Application | NUMERIC | Cost in the account's local currency divided by the number of times a member completed a job application |
| Country Code | TEXT | List of target locations |
| CPC | NUMERIC | Cost-per-click (CPC) |
| CPM | NUMERIC | Cost per mille (CPM).It is the cost an advertiser pays for one thousand views or impressions of an advertisement (1000 * cost / impressions) |
| Creative Creation Datetime | DATE | Creative Creation Date and Time |
| Creative ID | TEXT | Creative ID |
| Creative Last Modified Datetime | DATE | Creative Last Modified Date and Time |
| Creative Status | TEXT | Creative Status |
| CTR | PERCENT | Click-through rate (CTR) |
| Currency | TEXT | Account currency (default="USD") |
| Date | DATE | Dates covered by the report data point. Date is specified in UTC. |
| Engagement Rate | NUMERIC | Number of times members interacted with your ad (paid and free clicks divided by total impressions) |
| Engagements | NUMERIC | The total number of actions that people took on your Linkedin Ads. |
| External Website Conversions | NUMERIC | The count of conversions indicated by pixel loads on an external advertiser website. |
| External Website Post Click Conversions | NUMERIC | The count of post-click conversions indicated by pixel loads on an external advertiser website. |
| External Website Post View Conversions | NUMERIC | The count of post-view conversions indicated by pixel loads on an external advertiser website. |
| Follows | NUMERIC | The count of follows. Sponsored Updates only. |
| Share full screen plays | NUMERIC | Number of Full Screen Plays |
| Impressions | NUMERIC | This is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails. |
| Job Applications | NUMERIC | The 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 Clicks | NUMERIC | The 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 clicks | NUMERIC | Number of Clicks to the Landing Page |
| Landing Page Clicks | NUMERIC | The count of clicks which take the user to the creative landing page. |
| Lead Generation Mail Contact Info Shares | NUMERIC | The number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only. |
| Likes | NUMERIC | The count of likes. Sponsored Updates only. |
| Member company name | TEXT | Company names of LinkedIn members engaged with campaigns |
| Member company size | TEXT | Approximate company size of LinkedIn members engaged with campaigns |
| Member country | TEXT | Countries of LinkedIn members engaged with campaigns |
| Member industry | TEXT | Industry of LinkedIn members engaged with campaigns |
| Member job function | TEXT | Job functions of LinkedIn members engaged with campaigns |
| Member job title | TEXT | Job titles of LinkedIn members engaged with campaigns |
| Member region | TEXT | Geographic regions of LinkedIn members engaged with campaigns |
| Member seniority | TEXT | Seniority of LinkedIn members engaged with campaigns |
| Objective Type | TEXT | Campaign Objective type values. |
| One Click Lead Form Opens | NUMERIC | The count of times users opened the lead form for a One Click Lead Gen campaign. |
| One Click Leads | NUMERIC | The count of leads generated through One Click Lead Gen. |
| Opens | NUMERIC | The count of opens of Sponsored InMail. Sponsored InMail only. |
| Optimization Target Type | TEXT | Determines how this campaign is optimized for spending. If this is not set, there is no optimization. |
| Share other engagements | NUMERIC | Number of Other Engagements |
| Video watches at 25% | NUMERIC | The count of video ads that played through the first quartile of the video. |
| Video watches at 50% | NUMERIC | The count of video ads that played through the midpoint of the video. |
| Video watches at 75% | NUMERIC | The count of video ads that played through the third quartile of the video. |
| Share reactions | NUMERIC | Number of Reactions by Campaign |
| Share creation datetime | DATE | Post Creation Date and Time |
| Share ID | TEXT | Share (Post) ID |
| Share landing page | TEXT | Post landing page |
| Share last modified datetime | DATE | Post Last Modification Date and Time |
| Share text | TEXT | Post Text |
| Share title | TEXT | Post Title |
| Share Type | TEXT | Share/post media category |
| Shares | NUMERIC | This is the count of "shares" for sponsored Shares. |
| Spend | NUMERIC | Cost in the account's local currency |
| Targeting Exclude Age Range | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by organization. |
| Targeting Exclude Employers | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by age rate. |
| Targeting Exclude Groups | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by groups. |
| Targeting Exclude Industries | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by standardized industries. |
| Targeting Exclude Interface Locales | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by interface locales. |
| Targeting Exclude Job Functions | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by standardized job functions. |
| Targeting Exclude Locations | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by locations. |
| Targeting Exclude Seniorities | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by standardized seniorities. |
| Targeting Exclude Titles | OBJECT | A segment of members who will be excluded from the advertising campaign's targeting by standardized titles. |
| Targeting Include Age Range | OBJECT | A segment of members who will be included in the advertising campaign's targeting by organization. |
| Targeting Include Employers | OBJECT | A segment of members who will be included in the advertising campaign's targeting by age rate. |
| Targeting Include Groups | OBJECT | A segment of members who will be included in the advertising campaign's targeting by groups. |
| Targeting Include Industries | OBJECT | A segment of members who will be included in the advertising campaign's targeting by standardized industries. |
| Targeting Include Interface Locales | OBJECT | A segment of members who will be included in the advertising campaign's targeting by interface locales. |
| Targeting Include Job Functions | OBJECT | A segment of members who will be included in the advertising campaign's targeting by standardized job functions. |
| Targeting Include Locations | OBJECT | A segment of members who will be included in the advertising campaign's targeting by locations. |
| Targeting Include Seniorities | OBJECT | A segment of members who will be included in the advertising campaign's targeting by standardized seniorities. |
| Targeting Include Titles | OBJECT | A segment of members who will be included in the advertising campaign's targeting by standardized titles. |
| Share total engagements | NUMERIC | Number of total Engagements |
| Total Cost | NUMERIC | Cost in the account's local currency (Duplicate of Spend) |
| Transaction Revenue (Local Currency) | NUMERIC | Conversion Value (Duplicate of Conversion Value (Local Currency)) |
| Transactions | NUMERIC | The number of transactions (Duplicate of External Website Conversions) |
| Video Completions | NUMERIC | The count of video ads that played 97-100% of the video. |
| Video plays | NUMERIC | The number of times a video starts to play |
| Video plays | NUMERIC | The number of times a video starts to play |
| Video watches at 25% (Duplicate) | NUMERIC | The count of video ads that played through the first quartile of the video. (Duplicate) |
| Video watches at 50% (Duplicate) | NUMERIC | The count of video ads that played through the midpoint of the video. (Duplicate) |
| Video watches at 75% (Duplicate) | NUMERIC | The count of video ads that played through the third quartile of the video. (Duplicate) |
| Video views | NUMERIC | 2 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 clicks | NUMERIC | Number of Viral Clicks Aggregated by Campaign |
| Share viral comments | NUMERIC | Number of Viral Comments by Campaign |
| Viral External Website Conversions | NUMERIC | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. |
| Share viral follows | NUMERIC | Number of Viral Follows by Campaign |
| Share viral full screen plays | NUMERIC | Number of Viral Full Screen Plays |
| Share viral impressoins | NUMERIC | Number of Viral Impressions Aggregated by Campaign |
| Share viral landing page clicks | NUMERIC | Number of Viral Clicks to the Landing Page |
| Share viral likes | NUMERIC | Number of Viral Likes by Campaign |
| Share viral reactions | NUMERIC | Number of Viral Reactoins by Campaign |
| Share viral shares | NUMERIC | Number of Viral Shares by Share |
| Share viral total engagements | NUMERIC | Viral Total Engagements |
| Share viral video completions | NUMERIC | Number of Viral Video Views to 100% |
| Share viral video starts | NUMERIC | Number of Viral Video Starts |
| Share viral video viewed 25pcnt | NUMERIC | Number of Viral Video Views to 25% |
| Share viral video viewed 50pcnt | NUMERIC | Number of Viral Video Views to 50% |
| Share viral video viewed 75pcnt | NUMERIC | Number of Viral Video Views to 75% |
| Share viral video views | NUMERIC | Number of Viral Video Views |
| Viral External Website Conversions (Duplicate) | NUMERIC | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event. |
| Viral External Website Post Click Conversions | NUMERIC | The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click. |
| Viral External Website Post View Conversions | NUMERIC | The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression. |
| Viral One Click Leads | NUMERIC | The count of leads generated through One Click Lead Gen from viral impressions for this activity. |
Windsor.ai: Easily connect LinkedIn Ads to Snowflake
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.