---
title: "LinkedIn Pages to AWS Redshift Connector | OWOX"
canonical: "https://www.owox.com/connectors/free-linkedin-pages-connector-to-aws-redshift"
updated: "2026-10-29"
---

# Send LinkedIn Pages data to AWS Redshift

Your company page follower statistics as Redshift tables: followers by seniority, industry, function and location, plus daily follower gains split into organic and paid. Set them beside ad spend, web analytics and CRM.

![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)LinkedIn Pages · Connected · Follower Statist… · Time-Bound Follo…

Data Mart · Published · one definition

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)AWS Redshift · Organ… · Time · TimeDaily 09:00

Refreshed on a schedule. No exports, no copy-paste.

[Get Started Free](https://www.owox.com/app-signup)

## Endpoints

## LinkedIn Pages Endpoints

[Documentation](https://docs.owox.com/packages/connectors/src/sources/linked-in-pages/readme/)

2 LinkedIn Pages endpoints you can import. Each lands in its own table in your data warehouse.

*   [Follower Statistics Lifetime follower counts broken down by segment — seniority, industry, function, geography, and association type. 6 fields](/data-sources/linkedin-pages#schema-follower-statistics)

*   [Time-Bound Follower Statistics Daily follower gains broken down by organic and paid — tracks how your audience grows over time. 12 fields · Time series](/data-sources/linkedin-pages#schema-time-bound-follower-statistics)

## S00 · Why

## Why join LinkedIn Pages with ad spend and CRM in AWS Redshift

LinkedIn tells you how many people followed the page. It does not say whether the right people did, what paid growth cost, or whether pipeline moved in the same industries. Page statistics, ad spend and CRM records have to share one [data warehouse](/data-storages) to answer that.

*   Follow organic and paid follower gain by day, not only the total
*   Break followers down by seniority, industry, function and location
*   Weigh paid follower gain against your LinkedIn Ads spend

![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)LinkedIn Pages · Page followers

LinkedIn Ads · Spend

CRM · Pipeline

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)Your data warehouse · AWS Redshift · Followers · Ad spend · PipelineJoined by id · Follower gained · Pipeline growsJoin them by date to compare growth with spend.

## S01 · Step 1

## Step 1: Pick LinkedIn Pages and the fields to load

Create a Data Mart on your Redshift [data storage](/data-storages), choose LinkedIn Pages as the [data source](/data-sources), authorize once, then open an endpoint and select the fields.

*   2 endpoints and 18 fields to choose from
*   Time-Bound Follower Statistics holds the daily organic and paid gains

New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%2048%2048%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%3E%3Cpath%20fill%3D%22%230A66C2%22%20d%3D%22M40.8983%2040.8992h-7.1121V29.761c0-2.656-.0474-6.0751-3.699-6.0751-3.7043%200-4.271%202.8938-4.271%205.8817v11.3309h-7.1121V17.9938h6.8276v3.1302h.0956c.6833-1.1684%201.6706-2.1295%202.8569-2.781%201.1863-.6516%202.5271-.9691%203.8796-.9189%207.2084%200%208.5375%204.7415%208.5375%2010.91l-.003%2012.5651Zm-30.219-26.0363c-.81634.0001-1.61436-.2418-2.29316-.6952-.67881-.4534-1.20788-1.0979-1.5204-1.852-.31252-.7542-.39442-1.584-.23531-2.38469.15911-.80066.55207-1.53616%201.12917-2.11349.5771-.57732%201.31244-.97055%202.11302-1.12995.80058-.1594%201.63038-.07781%202.38468.23444.7542.31226%201.3988.84116%201.8525%201.51982.4536.67866.6958%201.47661.696%202.29297.0001.542-.1066%201.0787-.3139%201.5795-.2074.5008-.5113.9558-.8944%201.3392-.3832.3833-.8382.6874-1.3389.8949-.5007.2075-1.0374.3144-1.5793.3145Zm3.556%2026.0363H7.11579V17.9938h7.11951v22.9054ZM44.444.00327032H3.54198C2.61362-.00720657%201.71904.351327%201.05488%201.00008.390724%201.64884.0113301%202.53475%200%203.46313V44.5362c.0109423.9288.390114%201.8153%201.05425%202.4647.66413.6495%201.55891%201.0087%202.48773.9988H44.444c.9306.0117%201.8279-.3465%202.4947-.9959.6667-.6494%201.0484-1.537%201.0613-2.4676V3.46017c-.0133-.93023-.3952-1.81714-1.062-2.465882-.6668-.648742-1.5638-1.0062509-2.494-.99398236%22%2F%3E%3C%2Fsvg%3E)LinkedIn Ads · ![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)LinkedIn Pages · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · AuthorizeConnected · Endpoint · Time-Bound Follow… · Follower Statisti…

![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)Time-Bound Follow… · 12 fields · organization\_urntime\_range\_starttime\_range\_endorganic\_follower\_gainpaid\_follower\_gain

## S02 · Step 2

## Step 2: Load LinkedIn Pages into a Redshift schema and table

Schema and table in your Redshift database are pre-filled and editable. The first run writes to your cluster or Serverless workgroup.

*   The current follower breakdown and the daily gains stay in separate tables
*   Run History logs each load

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)Destination · AWS Redshift · Schema · linkedin\_pages · Table · follower\_statistics\_time\_bound · Run

Run History · Pending · Running · SuccessIncremental load

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)Table · linkedin\_pages.follower\_stati…

## S03 · Step 3

## Step 3: Read follower fields in plain words

The output schema describes each field, such as the organic followers gained in the period. Your [data quality](/product/data-quality) checks can use it.

*   No API names to decode
*   Marketing and sales read the same columns

![](https://cdn.owox.com/www/portfolio-management-connectors/redshift-connector-to-google-sheets/icon/1.png/public)linkedin\_pages.follower\_statistics\_time… · Output schema · Field · Descriptionorganization\_urn · Organization URN · time\_range\_start · Start timestamp of the time range · time\_range\_end · End timestamp of the time range · organic\_follower\_gain · Number of organic followers… · paid\_follower\_gain · Number of paid followers gained…

## S04 · Step 4

## Step 4: Link the page tables in Redshift

Follower Statistics and Time-Bound Follower Statistics are separate tables that share the organization URN. Joined, they show who follows the page and how fast it grows.

*   Join on organization\_urn, the page organization identifier
*   Bring ad spend and CRM tables into the same [data model](/product/data-modeling)

![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)Follower Statisti… · organization\_urn · segment\_name · segment\_value · paid\_follower\_co…

![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)Time-Bound Follow… · organization\_urn · time\_range\_start · organic\_follower… · paid\_follower\_ga…

## S05 · Step 5

## Step 5: Schedule the refresh and backfill the past

A daily scheduled refresh adds each new period of follower gains. A backfill loads an earlier period.

*   No pipeline to maintain
*   Backfill history the first time you connect

Schedule · Run on a schedule · Daily 09:00

Backfill · Run backfill

Run History · Daily schedule · Manual backfill · Daily schedule

## S06 · Step 6

## Step 6: Point every report at the same Redshift tables

The Redshift tables behind your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) and scheduled AI insights are the same ones.

*   Define each number once
*   Reports agree because they read one table

![](https://cdn.owox.com/www/portfolio-management-connectors/free-linkedin-pages-connector-to-aws-athena/icon/1.svg/public)LinkedIn Pa… · Data Mart · Published

Your data model

![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets

![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards

![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT

![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email

## Related connectors

[LinkedIn Pages to Claude](/connectors/linkedin-pages-connector-to-claude)[LinkedIn Pages to ChatGPT](/connectors/linkedin-pages-connector-to-chatgpt)[Facebook Ads to AWS Redshift](/connectors/free-facebook-ads-connector-to-aws-redshift)[Google Ads to AWS Redshift](/connectors/free-google-ads-connector-to-aws-redshift)[Microsoft Ads to AWS Redshift](/connectors/free-microsoft-ads-connector-to-aws-redshift)[TikTok Ads to AWS Redshift](/connectors/free-tiktok-ads-connector-to-aws-redshift)[Bank of Canada to AWS Redshift](/connectors/bank-of-canada-connector-to-aws-redshift)[Criteo Ads to AWS Redshift](/connectors/free-criteo-ads-connector-to-aws-redshift)[LinkedIn Ads to AWS Redshift](/connectors/free-linkedin-ads-connector-to-aws-redshift) · Show 6 more · Show fewer

## Recent updates

*   [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410)
*   [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410)
*   [0.41.0 · Shared SQL logic stays in one place: build a Data Mart on top of another](https://docs.owox.com/docs/changelog/#shared-sql-logic-stays-in-one-place-build-a-data-mart-on-top-of-another-0410)
*   [0.41.0 · Rotating a connector key is one change: Sources share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-connector-key-is-one-change-sources-share-reusable-credentials-0410)
*   [0.40.0 · Connecting a plan from Google Sheets takes fewer guesses](https://docs.owox.com/docs/changelog/#connecting-a-plan-from-google-sheets-takes-fewer-guesses-0400)

## Why OWOX

## Why OWOX for LinkedIn Pages in AWS Redshift

API scripts and generic ETL both pull follower numbers. OWOX keeps them in Redshift, readable and ready to sit beside ad spend and CRM.

*   **Your database.** Tables sit in your Redshift database, behind your AWS credentials.
*   **Readable columns.** Field names and descriptions in plain words, not API identifiers.
*   **Ready to join.** The organization URN links the tables, and a date links them to spend and CRM.
*   **API handled.** No scripts to fix when LinkedIn changes it.
*   **Free to self-host.** The open-source OWOX Data Marts runs in your own infrastructure.

[Book a call](/book-a-call)

[Get Started Free](https://www.owox.com/app-signup)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get Started Free](https://www.owox.com/app-signup)
- [Documentation](https://docs.owox.com/packages/connectors/src/sources/linked-in-pages/readme)
- [Follower StatisticsLifetime follower counts broken down by segment — seniority, industry, function,…](https://www.owox.com/data-sources/linkedin-pages) — /data-sources/linkedin-pages.md
- [data warehouse](https://www.owox.com/data-storages) — /data-storages.md
- [data source](https://www.owox.com/data-sources) — /data-sources.md
- [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md
- [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md
- [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md
- [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md
- [LinkedIn Pages to Claude](https://www.owox.com/connectors/linkedin-pages-connector-to-claude) — /connectors/linkedin-pages-connector-to-claude.md
- [LinkedIn Pages to ChatGPT](https://www.owox.com/connectors/linkedin-pages-connector-to-chatgpt) — /connectors/linkedin-pages-connector-to-chatgpt.md
- [Facebook Ads to AWS Redshift](https://www.owox.com/connectors/free-facebook-ads-connector-to-aws-redshift) — /connectors/free-facebook-ads-connector-to-aws-redshift.md
- [Google Ads to AWS Redshift](https://www.owox.com/connectors/free-google-ads-connector-to-aws-redshift) — /connectors/free-google-ads-connector-to-aws-redshift.md
- [Microsoft Ads to AWS Redshift](https://www.owox.com/connectors/free-microsoft-ads-connector-to-aws-redshift) — /connectors/free-microsoft-ads-connector-to-aws-redshift.md
- [TikTok Ads to AWS Redshift](https://www.owox.com/connectors/free-tiktok-ads-connector-to-aws-redshift) — /connectors/free-tiktok-ads-connector-to-aws-redshift.md
- [Bank of Canada to AWS Redshift](https://www.owox.com/connectors/bank-of-canada-connector-to-aws-redshift) — /connectors/bank-of-canada-connector-to-aws-redshift.md
- [Criteo Ads to AWS Redshift](https://www.owox.com/connectors/free-criteo-ads-connector-to-aws-redshift) — /connectors/free-criteo-ads-connector-to-aws-redshift.md
- [LinkedIn Ads to AWS Redshift](https://www.owox.com/connectors/free-linkedin-ads-connector-to-aws-redshift) — /connectors/free-linkedin-ads-connector-to-aws-redshift.md
- [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog)
- [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md
