AI for Corporate Communications Specialist

of 5— Export Your Metrics Data

What you'll accomplish

By the end of this guide, you'll be able to turn a spreadsheet of channel metrics — email open rates, intranet page views, survey scores — into a well-structured narrative communications effectiveness report with strategic recommendations. A report that used to take half a day to write takes 90 minutes.

What you'll need

Claude Pro or ChatGPT Plus ($20/mo)
Your communications channel analytics exported as text or pasted numbers (email platform reports, intranet analytics, pulse survey results)
A basic understanding of what benchmarks are normal for your industry
Time needed: 30 minutes for the first report; 20 minutes for recurring ones
Cost: $20/month

How-To Guide: Turn Raw Communications Analytics into a Strategic Report

Step 1: Export Your Metrics Data

Pull together your channel performance data for the period you're reporting on. You'll need:

Email analytics (from Poppulo, Mailchimp, Outlook, etc.):

Open rate for each newsletter or major send
Click-through rate
Number of sends and total reach

Intranet analytics (from SharePoint or your CMS):

Total page views
Unique visitors
Top pages by views
Time on page for key content

Pulse survey data:

Communication effectiveness score
"I receive the information I need to do my job" score
Open-ended comments summary

Export these as CSV or just copy the key numbers into a text document.

What you should see: A data file or document with your channel metrics organized by source.