PR 499 - AI Tools for Public Relations & Advertising

• last updated 11:00 a.m PT (Pacific Time) Sunday, March 01, 2026

How to Incorporate Files from Cometrics into third-party utilities such as Claude, Perplexity, ChatGPT, Gemini, Microsoft Copilot

1. Download the csv file below, or create a custom csv by searching on Cometrics.io. In order to create a downloadable csv, just make any number of searches to get to a result set you are happy with. In the example below, I'm searching for all LinkedIn content from McDonald's executives. Then, 'export page results'. A full, pre-downloaded file is available here.

2. Export csv and then incorporate into third-party utilities such as Claude, Perplexity, ChatGPT, Gemini, Microsoft Copilot. Ensure data is normalized.

3. Establish outliers and begin thinking about your narrative. Iterate as you wish....

4. Subject to how you wish to produce the report, work within your existing AI app or export your findings to a third party like Figma.
5. Some samples of how to make the data tell the story for you. Variables that you can change include the executive name, the theme, frequency, comparative executives....you can be as creative as you need to be.
6. Let the AI app do the dirty work for you - think strategically. Why are McDonald's executives talking about Cyber Security? What slowly developing themes are the ones to watch? How are my employees talking? Who is the most engaging executive in my company? Why?

6. Below is a sample report / dashboard for the "QSR Sector" to show possible use cases for the content.

Older information from before our course is listed below.

Link to download all tracked executives from nominated companies.

This file shows: executive_id,executive_name,company_id,company_name,linkedin_profile_url,

full_text,publisher_created_at,uuid,like_count,comment_count,repost_count,

view_count,themes

Sample (and real) Executive Communications report for QSR sector . This is close to the desired output for your reports.

Using the Cometrics system - very quick FAQ

• additional info to follow
• Exporting to csv / interface with Meltwater / Interfacing with your favourite AI

Company tracking by Student

PR 499 Class Lists

✅ Company Selected (24 students)

❌ No Company Selected (3 students)

| Jing Fang | [email protected] |
| Dia Gupta | [email protected] |
| Angie Lopez-Yepes | [email protected] |

Executive Tracking List

Be sure to review your selected company and let us know if we are tracking the Executives you wish to follow.

The database is updated near real time, but there can be a delay of up to 8 hours between an executive posting and the post appearing as a searchable record in the Cometrics database.

System Access Credentials

The initial usernames and passwords will be the student email addresses. Students can change their passwords by requesting a password change below:

Sample User: [email protected] / Sample Password: [email protected]

Contact us

If you have any questions during the research period, please: