The Scenario
You're a social media manager at a B2B healthcare company. Every month you put together a LinkedIn page performance report for the VP of Marketing — page views, unique visitors, follower growth — and every month you export it from LinkedIn Analytics, wrestle with the date formatting, and copy it into your dashboard workbook by hand. This month the VP asked for the last 90 days broken out by week, which means three months of weekly data you'll need to stitch together from multiple exports.
The bad version:
- Log into LinkedIn, navigate to the company page analytics, set the date filter to the last 90 days.
- Export the page view report. Open it in Excel, discover that the date column exported as a Unix timestamp.
- Convert the dates, filter for the weekly rows, copy the metrics into your dashboard worksheet.
- Repeat for follower stats, which lives on a different analytics worksheet with a slightly different export structure.
What should be a ten-minute task is forty-five minutes because three different export formats need to be normalized before they're useful.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and pulls LinkedIn page statistics directly from the API — views, unique visitors, follower growth — in the format and date range you specify.
Get LinkedIn page view and click statistics for organization ID 98765 for the last 90 days and write the date, page views, and unique visitors into columns A, B, and C starting at row 2
What You Get
- Column A: dates formatted as readable calendar dates, not timestamps.
- Column B: page view count per day or week depending on the granularity you request.
- Column C: unique visitor count for the same period.
- Row 2 onward: one period per row, in chronological order, ready for your dashboard formulas.
What If the Data Is Not Quite Ready
I need weekly aggregates instead of daily rows
Get LinkedIn page view statistics for organization ID 98765 for the last 90 days, aggregated by week. Write the week start date, total page views, and total unique visitors into columns A, B, and C
I also need follower growth in the same worksheet, in adjacent columns
Get LinkedIn page view and follower growth data for organization ID 98765 for the last 90 days by week. Write the week start date into column A, page views into column B, unique visitors into column C, and new followers that week into column D
Some weeks have no data and I need the rows filled in with zeros rather than left blank
Get LinkedIn page statistics for organization ID 98765 for the last 90 days by week. Write all 13 weeks into the worksheet even if some weeks have zero activity. Use the week start date in column A, page views in column B, and unique visitors in column C, and fill any missing weeks with zero
Full dashboard-ready table with a calculated engagement rate in one shot
Get LinkedIn page view, unique visitor, and follower growth data for organization ID 98765 for the last 12 weeks. Write week start date into column A, page views into column B, unique visitors into column C, and new followers into column D. Add a column E that shows the follower growth rate as a percentage of the prior week's total follower count, using 14,200 as the starting total. Flag any week where page views dropped more than 20% from the prior week with "review traffic source" in column F
That prompt produces a dashboard-ready table with anomaly flagging built in.
Try It
Get the 7-day free trial of SheetXAI and open your LinkedIn page analytics dashboard workbook, then ask it to pull the last 90 days of page view and follower data in one prompt. For more LinkedIn page analytics workflows, see the follower demographics article or the organic post engagement guide.