Intelligence you can count on

While FPinfomart offers a built-in suite of Media Analysis tools, we realize that there are times when you’d like to perform your own metrics on various data points surrounding the media content you’ve collected.  Whether it’s simple story counts; a byline or publication frequency counts; or customized measurement using circulation or ad values (such as your organizations definition of “impressions”), getting at the raw data behind the stories can be desirable.

To assist you in this, we now offer the ability to export the contents of an FPinfomart Saved (or Shared) Folder as citations and metadata associated with them to a spreadsheet, in your choice of Excel (xls) or Comma-Separated Values (csv) formats.

To try this feature, visit your Folders page (click the Folder count at the top of any screen).  Click the green “Export” link next to the name of the Folder whose contents you’d like to export.

Click the Export link next to the Folder name to create an Excel file containing citations of the Folder contents.

Next, you’ll be asked to select which of the two available file formats you’d like to create.

You have a choice of Excel (.xls) or Comma-Separated Values (.csv) formats.

Once your file is created, click the link provided to save a copy to your computer, and open it in your choice of spreadsheet software.

The resultant Excel file will have column headers for each of the exported fields, and a hyperlink back to the original item in your Folder.

Your export file will contain the following columns:  Publication name, Title, Byline, Date of publication, Region, Media type, Tone, Ad Value, Circulation, a link to the article in your Folder, and any Notes that have been added to the document.  The entire contents of your Folder will be exported into this file.

Now that your data is in spreadsheet format, you can create any charts or graphs you desire, or add in any missing or updated data you may have available.

Please note that like all content you obtain from FPinfomart.ca, copyright and redistribution policies apply in accordance with your subscription agreement.  Please see our Terms of Use for more details.