Report manager September 19, 2023 16:09 Updated Index What is the report manager for? How to access the report manager What reports can I export through the manager? How to extract data in the report manager Usage recommendations Additional articles Renewal of Expired Media What is the report manager for? The report manager is the feature that centralizes the extraction of reports from Blip. With it, you can extract various service reports and also the histories of the conversations conducted. Reports for the last five years can be generated, but always in 90-day periods. For example, to export data for a complete year, four reports will be generated, one for each quarter. The report manager is a tool that assists in the collection and analysis of data for an increasingly productive operation guided by metrics and results. Required Permissions To access the service report screen, you need the following permission in the system: Helpdesk > "View" or "View and edit." How to access the report manager To access the report manager, follow these steps: Access the portal. Select the company where your chatbot(s) is/are located. Then choose the chatbot for which you want to configure. Next, access the "Service" menu. Then the "Service Reports" menu. Finally, click on the "Report Manager" button. What reports can I export through the manager? In the report manager, you can export the following reports: Active Messages: brings data from active notifications separated into two tables: The Notifications Summary table with detailed data of the active notifications sent. The Notifications Users table with a summary of the data, usually grouped by template and bot. Event Tracking: Retrieves all tracking events from your intelligent contact. Chatbot and User Metrics: Provides data on conversations between the client and the bot in three tables. The Conversations Details table provides information about Waba, the bot, the user, date, time, among others. The Conversations Summary table provides a summary with month and year, router, MAUs (Monthly Active Users), MEUs (Monthly Unique Users), and MSGs (Messages). The User Details table provides information on dates, bot ID, User ID, and messages. Service Metrics: brings raw ticket data for the period, with which it is possible to calculate service metrics presented on the service reports screen and other necessary metrics related to your service. Service History: Retrieves conversations between clients and agents that occurred during the selected period, separated by ticket. Agent Status: provides information about agents, including online times, breaks, offline, invisible, among others. How to extract data in the report manager The report manager allows you to extract historical data up to five years ago, as long as the extraction is requested in periods of no more than 90 days, and with D-1 data, meaning data from the current day is not extracted, only from the previous day backward. Example: If you need to extract data from the last semester, you should request two reports, one considering the first 90 days of the period, and another considering the last 90 days of the period. Then simply open them in a spreadsheet manager and merge the two spreadsheets into one. To extract reports through the report manager, follow these steps: Access the report manager as indicated in the above steps. Select the type of report you want to export. Then choose the chatbot from which you want to extract data. Next, select the period of up to 90 days for which you want the data. Then click on "Generate Report." The system will process your request, which will be ready in a few minutes. You can track the processing status in the "My Reports" table. You can leave this screen and come back later to download your reports. When the report is ready, a download button will appear in place of the processing icon. Simply click the download button, and the file in .csv format will be downloaded to your computer. Repeat the above steps to request other reports. Usage Recommendations: As mentioned above, you can extract reports from up to 5 years ago, as long as the extraction windows have 90 days. You don't need to wait for a report to finish processing to request new extractions, meaning you can request multiple exports simultaneously. After processing is complete, your reports will be available for 7 days; after that period, you will need to request them again. Renewal of Expired Media To renew expired media in the history, there are two possibilities: 1. Renewal using the Media Extender extension available in the Blip Store: Renewal via API (Complex process). In this case, we provide a video that will walk you through the step-by-step process of renewing media via API. Watch it below: Additional Articles Report of Support Service Monitoring Calculating customer service metrics For more information, visit the discussion on the subject in our community or the videos on our channel. 😃 Related articles Report Manager - General Information How to Create Custom Reports Dashboard - Data Analysis Managing Access Permissions Using Dynamic Content