Automatic report by topic in Excel

Automatic report by topic in Excel

Automatic report by topic in Excel

In the Semantrum, users can generate an automatic report on a topic by themselves. Users can export reports from the system in .docx, .xlsx or .pptx format. If you need to get a ready-to-use media report about your monitored object with data and graphs, choose the .xlsx export report format.

Automatic report by topic in Excel includes:
  1. Dynamics of mentions for the selected period;
  2. Amount of contacts with the audience;
  3. Distribution by tags, if they are available in the account;
  4. Distribution by tone of voice of mentions;
  5. The role of the monitored object in publications;
  6. Media favorability index;
  7. Media Visibility Index;
  8. Media distribution by countries;
  9. Rating of sources;
  10. Distribution by size, thematics, category, language of sources;
  11. Ratings of automatically identifed organizations and brands, people, geographical objects.


You can export a .docx report if you are viewing a single topic. The automatic report is generated entirely based on the filters you have applied in the topic. Thus, you can generate reports by different time periods and parameters. If you need to get a report by tag, select the topic in which this tag occurs, select the desired tag in the filter panel and download the report.

You can edit, change the graphs in the .xlsx report by color, type of graphs, also, tables with summary data are added to the graphs to allow the user to work with them independently.

Please note:
Excel reports are not available from story mode, without a selected topic and from the Tags mode.

How export an automatic report by topic to Excel


STEP 1. Select the desired topic.


STEP 2. Open the Export menu on the publication action panel.

STEP 3. Select the export option - export report by topic.

STEP 4. Select the .xlsx export format.


Please note:
To export a report on a topic, you do not need to select publications.

Once all the options are selected, the document will be exported. A message about export preparation will appear in the bottom left corner of the window. Wait until another message about successful export appears. Click "Confirm" and wait for the document to be downloaded.

What to do if...
  1. If you need to get basic data about publications, choose the format of exporting publications in .docx or .xlsx.
  2. If you are monitoring several topics and it is important for you to compare their distribution and other metrics, you can use the appropriate section in the graph view mode (more about automatic visual analytics), as well as export an automatic topic comparison report in .docx format. The report is generated if 2 to 5 topics are selected.
  3. If you still can't find the data you need, please contact your support or sales manager to set up a personal dashboard in your account. Please click here to find out what a dashboard can be.


    • Related Articles

    • Automatic report by topic in Word

      Automatic report by topic in Word In the Semantrum, users can generate an automatic report on a topic by themselves. Users can export reports from the system in .docx, .xlsx or .pptx format. If you need to get a ready-to-use media report about your ...

    • Automatic report on a topic in Power Point

      Automatic report on a topic in Power Point In Semantrum, user can generate an automatic report on a topic. You can export reports from the system in .docx, .xlsx or pptx formats. If you need to receive a ready-made media report on your monitored ...

    • Exports in Semantrum

      Semantrum offers several export variants. They are different from each other by formats, data, types, etc. In this article we will list all the export formats available in the system. The main types of exports available in the system are report ...

    • TrackPR: Your guide to analytical reports on press release distribution

      TrackPR is a separate Semantrum product, an analytical report on the results of press release distribution, which is prepared for the client based on integrated data on the distribution of media mentions, conversion of visitors of the client's ...

    • How to set up a topic viewing

      Topic pinning When you sign in to your account, the system automatically filters the feed of publications by the first topic in the list. The topics are always in alphabetical order. If you want to change the order of the topics and fix a specific ...