How to export my LinkedIn metrics?
|MagicPost exports your LinkedIn metrics in two ways: a CSV file of your posts, from the Posts tab of the Metrics page, and a visual report in PDF, PNG or JPEG, from the Reporting tab. Both exports come with the MagicPost metrics dashboard, included in Growth, Creator, Agency, and Team and open during the free trial. On the Metrics page, both exports cover your own profile only. An organization admin, on the Agency or Team plan, can also export the report of a member.
The white-label LinkedIn reports page presents the report. The dashboard itself is described in how to analyze your LinkedIn metrics.
How to export your posts to CSV
In MagicPost, open Metrics, then the Posts tab.
Set the period with the date selector at the top right of the page.
Click Export to CSV, at the end of the quick filters row, after the columns icon (tooltip Columns). With no filter and no search active, the download starts right away.
When no filter and no search is active, the MagicPost CSV export contains every post of the selected period. Your choice of columns never changes the file.
How to export only the posts your filters show
MagicPost can export only the posts that your filters keep in the Posts tab. As soon as a filter or a search is active, the Export to CSV button opens a menu instead of downloading right away. Active filters are the quick filters (Viral, Bangers, Good, Flops, labels), the settings behind the filter icon (tooltip Filters: impressions, likes and comments ranges, format, type, theme, reposts) and the search field.
In MagicPost, open Metrics, then the Posts tab, and set the period.
Apply your filters, or type a search.
Click Export to CSV. The menu title names the period, for example Period: Last 90 days, or shows the dates of a custom range.
Click Export with filters for the posts the table shows, or Export all posts for every post of the period. Each entry shows its number of posts on the right.
The MagicPost filtered export covers all the pages of the Posts table, not only the page on screen, and keeps the current sort order of the table. Its file name ends in -filtered.csv. Export with filters is greyed out when no post matches your filters.
MagicPost never exports direct reposts, filtered export included, so the count next to Export with filters can be lower than the number of rows in the table.
To get a MagicPost CSV of only your carousels, for example, click the filter icon (tooltip Filters), choose Carousel under Format, then click Export to CSV and Export with filters.
What the CSV file contains
The MagicPost CSV file has one row per post and always the same columns, whatever columns the Posts table shows:
URL, Post (the text), Type, Format, Labels, Theme
Impressions, Likes, Comments, Reposts, Engagement %
Unique views, Saves, Link clicks, Premium CTA clicks, Followers gained, Profile views
Date, Day, Hour
The column headers of the MagicPost CSV are in English, whatever the language of the MagicPost interface. The MagicPost CSV adds columns the Posts table does not have: a Reposts column, and separate Day and Hour columns. The Profile views column of the CSV is the metric the Posts table calls Profile clicks. A cell is empty when LinkedIn provides no figure for that post. Direct reposts are never exported, because they have no statistics of their own.
The Followers gained column of the MagicPost CSV is not filled: MagicPost does not collect that figure per post from LinkedIn, so the column is empty or reads 0. The followers gained per post exist only as an estimate, in the Timeline view of the Posts tab.
How to export a report
In MagicPost, open Metrics, then the Reporting tab, on a computer.
Click Export stats. A window opens with a preview of the report and its settings.
Under Period, choose the period of the report.
Adjust the other settings. The preview updates as you go.
Click Download, choose a format (JPEG, PNG or PDF) and a quality (Normal or High quality), then confirm.
The MagicPost report has its own period, separate from the period of the dashboard. Each time you open the Export stats window, the report period starts on Last month, whatever period the dashboard shows. Set the period in the window before you download.
The settings of the report
Trend metric: the metric plotted on the main chart of the MagicPost report.
Average per post: the figure shown on the second key card, impressions or likes. This setting appears only when MagicPost has access to your impressions.
Report contents: Include audience and Include benchmarks each add a page to the report.
Profile picture and Personal information: the photo, first name, last name and job title printed on the report. These edits change the report only, not your LinkedIn profile.
Company logo: by default the report shows the MagicPost logo. Add a company logo replaces it with yours, and the Show switch removes the logo from the report. The accepted formats and the size limit are written under the upload button. MagicPost keeps the logo in your browser, so add it again on another computer.
The color picker at the bottom of the settings sets the color of the report. MagicPost uses the same color for the charts of the dashboard.
The first page of the MagicPost report shows your profile, the trend chart, the key figures, your best days, your formats, your top posts and your themes for the period.
The company logo and the color of the MagicPost report are available with the metrics dashboard on every plan that includes it. They are not reserved for the Agency plan.
How an organization admin exports a member's report
An admin of a MagicPost organization, on the Agency or Team plan, exports the report of a member from the organization's metrics.
In the MagicPost sidebar, click Admin view, then open Metrics. Use a computer with a wide browser window: the export button is hidden on a narrow one.
Click Export stats.
Choose Individual report, then pick the member in the list. MagicPost opens the same report window as on the Metrics page, on that member's data.
For one report that covers several accounts, choose the second entry of the menu: Multi-account report in an agency organization, Multi-member report in a team organization.
The CSV export of MagicPost has no organization version: a CSV file always contains the posts of the profile you are logged in to.
What the exports do not do
The MagicPost CSV export does not follow your choice of columns. The file always has the same columns.
The MagicPost report does not take the period of the dashboard. It has its own period setting.
The report cannot be downloaded in Safari, or in a browser window too narrow for the report. Use Chrome, Firefox or Edge on a computer.
The Export stats button is not shown on a phone or in a narrow browser window.
MagicPost does not send an export on a schedule.
MagicPost does not export the data of a creator outside your organization. On another creator's profile, the Metrics page hides both exports.
FAQ
Does the CSV export keep the filters I applied in the Posts tab?
Yes, if you choose it. When a filter or a search is active, the MagicPost Export to CSV button opens a menu: Export with filters downloads only the posts the table shows, across all pages, and Export all posts downloads every post of the period. With no filter and no search active, the button exports every post of the period directly.
Why is Export with filters greyed out?
MagicPost greys out Export with filters when no post that can be exported matches your filters. Direct reposts are never exported, so filters that keep only direct reposts leave nothing to export, for example Reposts only on a period where every repost is a direct repost. Change the filters, or choose Export all posts.
Why does my report not cover the same period as my dashboard?
The MagicPost report has its own period, and it starts on Last month each time you open the Export stats window. Change the period under Period in the settings of the window.
Why can I not check Include audience in the report?
Include audience stays greyed out until an audience analysis has run on your MagicPost account. Start one from the Audience tab of the Metrics page, then reopen Export stats. See how to use the Audience and Benchmarks tabs.
Why does the report download fail in Safari?
MagicPost does not support Safari for the report export and shows an Unsupported browser message. Open MagicPost in Chrome, Firefox or Edge, on a computer, and download the report again.
Why do the numbers in my export look out of date?
A MagicPost export shows the figures of the last sync. Click the last sync line under your name on the Metrics page (Synced …), wait for the refresh to finish, then export again. See why MagicPost numbers differ from LinkedIn's.
Can I export another creator's data?
No, unless the creator is a member of your organization. When the Metrics page shows another creator's profile, MagicPost hides both the CSV export and Export stats. An organization admin, on the Agency or Team plan, exports a member's report from Metrics in the Admin view: Export stats, then Individual report.
Can I get my MagicPost metrics automatically?
MagicPost has no scheduled export. The MagicPost API gives programmatic access to your metrics. API keys are included in Creator, Agency, and Team. See how to create a MagicPost API key.
Need help?
Reach out via the in-app chat, or book a 30-minute onboarding call: https://cal.com/magicpost/book-a-call