Send LinkedIn Pages reports to Slack
LinkedIn Pages follower gains, organic and paid, once a week. LinkedIn Pages goes into your data warehouse first, is linked there by SQL keys, and only then reaches Slack. The channel gets the answer, not a copy of the source.
LinkedIn PagesConnectedFollower Statist…Time-Bound Follo…
SlackOrgan…TimeTimeDaily 09:00A follower total in Slack hides whether the LinkedIn page grew on its own or because of paid promotion.
Paste this into your AI assistant. It loads LinkedIn Pages follower statistics into a Data Mart in your data warehouse and sends organic and paid follower gain to a Slack channel every week.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/linkedin-pages-insights-to-slack.md. The task: send a Monday Slack message with last week's LinkedIn Pages follower gain split into organic and paid, and the share of each over the last month. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
LinkedIn Pages Endpoints
2 LinkedIn Pages endpoints you can import. Each lands in its own table in your data warehouse.
Why LinkedIn Pages does not post straight to Slack
LinkedIn Pages counts followers of your company page, not clicks or deals. A message posted from the page data shows how many people followed, and says nothing about the campaigns that earned them or the visits that came next. A Slack channel reads fast, so a number posted there is quoted quickly. Whoever posts it needs to be sure of its definition. The join belongs in a warehouse first.
- LinkedIn Pages counts organic and paid followers, apart from campaign results
- Slack channels are quoted in meetings, so every figure needs one definition
- The data analyst links the sources by SQL keys and controls what the message says
LinkedIn PagesOrganic followersSlack
Data warehouseJoined by idStep 1: Load LinkedIn Pages into your data warehouse first
Create a Data Mart with LinkedIn Pages as the source and choose where the data lands. It works with any popular data warehouse.
- Two endpoints and 18 fields to choose from, each endpoint in its own table
- Lifetime counts by seniority, industry, function and geography, plus gains by period
- Open the LinkedIn Pages connector for your data warehouse below
LinkedIn Pa…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databrickslinkedin_pages.follower_stati…Step 2: Link LinkedIn Pages follower data into one Data Mart
In your data warehouse the model joins follower segments and follower gains by the page, organization_urn, into one Data Mart. Add your ad platforms in the same data warehouse to see what the paid gains cost.
- Both endpoints join on organization_urn
- Lifetime segments and gains per period read as one table
- Paid follower gains sit ready to meet ad spend
Step 3: Send LinkedIn Pages reports to Slack
Create a Slack destination in OWOX with the email address of the channel that should get the report, then add a report to the published Data Mart. The message is Markdown, and Preview shows how it looks in Slack.
- Slack gives every channel an email address, and OWOX posts to it
- Type / in the message to add the Time-Bound Follower Statistics table with time_range_start, time_range_end, organic_follower_gain, paid_follower_gain
- Create & Run sends the first report at once
SlackWeeklyWeekly LinkedIn Pages reporttime_range_starttime_range_endorganic_followe…paid_follower_g…Step 4: Add a short analysis under the LinkedIn Pages report
Write two or three lines under the table in the same Markdown message. Add a trigger on the Triggers tab, for example every Monday morning, and the channel gets a fresh run each week.
- The lines read time_range_end and organic_follower_gain from the report, with no figure from outside it
- The table is filled from a new run of the Data Mart before every send
- A report with a send condition posts only when the result is not empty
SlackWeekly LinkedIn Pages reporttime_range_starttime_range_endorganic_followe…paid_follower_g…Analysisorganic_follower_gain shows growth nobody paid forpaid_follower_gain shows followers that came with a campaigntime_range_start keeps every gain tied to its weekStep 5: Reuse LinkedIn Pages inside OWOX MCP
The same Data Mart works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- Define the numbers once and every report reads them
Google SheetsOpen
ExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.36.0Start a connector run without expanding the Input Source card
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
Why OWOX for LinkedIn Pages in Slack
A Slack bot or a script pulling from the LinkedIn Pages source posts numbers as they are. OWOX posts answers from your data warehouse, in the channel your team already uses.
- Followers by week. Slack shows LinkedIn Pages follower gains for the week, split into organic and paid.
- You own the data. LinkedIn Pages lands in your own data warehouse, in tables you control, before anything reaches Slack.
- Slack stays simple. Paste the channel email address once; no Slack app to build and no token to renew.
- Posts only when it matters. Set a report to send only when the result is not empty, so the channel stays quiet on a quiet week.
- Maintained for you. When the source changes its API, the connector is updated, not your Slack setup.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.