Pull LinkedIn Pages data into Microsoft Excel
Follower counts are easy to screenshot and hard to trust. Load LinkedIn Pages into your data warehouse, join its two follower tables on the organization, and pull one Data Mart into Excel for the social report.
The social report in Microsoft Excel is built from follower screenshots, and nobody can say where last month's number came from.
Paste this into your AI assistant. It loads LinkedIn Pages into your data warehouse, joins the two follower tables on the organization, and pulls one Data Mart into Microsoft Excel through the add-in.
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-connector-to-microsoft-excel.md. The task: give me a Microsoft Excel workbook of LinkedIn Pages follower gain by month, organic and paid, with followers by industry and seniority, that I refresh for the social report. 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 go straight to Excel
The page analytics export can technically be opened in Excel, but not reliably, at scale or business-ready. You get one snapshot of followers with no history. The data warehouse keeps every period and joins the follower tables first.
- LinkedIn Pages reports followers by group or by period, in separate responses
- The data analyst joins both on the organization and controls the result
- The social report reads one Data Mart, not a folder of exports
Step 1: Load LinkedIn Pages into your data warehouse first
Step 2: Join LinkedIn Pages followers into one Data Mart
In your data warehouse the model joins the two follower tables on organization_urn, so the page's audience groups and its gains by period sit in one Data Mart. Organic reach can then sit next to bought reach from LinkedIn Ads.
- Both tables carry organization_urn, the key that joins them
- Followers by seniority, industry and function line up with gains per period
- Organic and paid follower counts are separate columns, not mixed
Step 3: Pull LinkedIn Pages data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published LinkedIn Pages Data Mart (Time-Bound Follower Statistics), tick the columns you want and press Create & Run.
- Tick time_range_start, organic_follower_gain and paid_follower_gain
- The add-in reads the data warehouse, so no LinkedIn access token sits in the workbook
Step 4: Refresh the LinkedIn Pages workbook when you need it
Refresh before the monthly social review. The imported columns update; the growth-rate column you added beside them keeps working.
- Your own columns and charts stay after refresh
- Pull on demand: nothing runs until you press Refresh
Step 5: Reuse LinkedIn Pages inside OWOX MCP
The follower Data Mart answers in OWOX MCP, your assistant for data. Request any report, chat with it, then get the result in Google Sheets or Excel in one click.
- Ask which period added the most organic followers
- Chat and workbook read the same organic_follower_gain
- 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.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
- 0.36.0Start a connector run without expanding the Input Source card
Why OWOX for LinkedIn Pages in Excel
A page export gives Excel a count. OWOX gives it a history you can group, split and set beside paid reach.
- Organic and paid, separated. organic_follower_gain and paid_follower_gain are separate columns in one Data Mart.
- Groups and periods together. Seniority, industry and function sit beside the gain in each period, joined on the organization.
- Your columns stay. Refresh rewrites the imported columns only, so a growth formula beside them is safe.
- Maintained for you. No token to renew in a workbook when LinkedIn changes its API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.
