Reports
  • 30 Nov 2023
  • 14 Minutes to read
  • PDF

Reports

  • PDF

Article summary

Overview

Cloudingo offers a variety of built-in report options. The two most used post-dedupe reports are the Dedupe Audit and the Merge/Convert Summary.

The Activity Stream Error/Warning Report is critical for monitoring job failures (for both Dedupe and Data Maintenance jobs). When running automation jobs, the Automation Summary reports will provide real-time details on the job status.

Find a variety of options available from filter configurations, activity monitoring, user monitoring, and more.



  1. Choose the ‘Reports’ → ‘Reports’ option from the left-hand-side navigation window.


  2. Tabs will appear across the top of the page for options.
    1. Choose ‘Dashboard’ to view the graphical view reports enabled.
    2. Choose ‘Run A Report’ to run a specific report.
      1. Choose the desired report.
      2. Choose the date range and any other options required.
      3. Choose 'Run Report' to generate the report.
    3. Choose 'Schedules' to view/edit, add, or delete report schedules for any user and any report that can be scheduled (see report scheduling details below).
      1. Choose 'Add Schedule' to add a new report schedule.
      2. Choose 'Change Schedule' under the 'Actions' menu options to view/edit any user's existing report schedule.
      3. Choose 'Delete Schedule' under the 'Actions' menu options to delete any user's existing report schedule.
    4. Choose ‘Settings’ to default the preferred dashboard view for display.


Dashboard

Actions

  1. View Reports (Enable Reports): Enable or disable reports for viewing in the Dashboard.
    1. Choose the checkbox next to any report to enable for view in the Dashboard and ‘Save’.
      1. Deselect the checkbox next to any report to hide from the dashboard view and ‘Save’.

  2. Re-Order Reports: Choose to re-order reports in the displayed Dashboard view.
    1.  Drag & drop reports in order as desired for display and ‘Save’.

  3. Refresh All Reports: Choose to recalculate the results for all displayed reports at one time.


Dashboard Reports & Menu Options

Many reports on the Dashboard will display using a graphical view. Each report has a menu option at the top, right.

  1. Refresh: Choose to update results for the selected report.

  2. Change Options: Change the date range specified or set a custom date range.


    1. Some reports will not allow a custom date range from the graphical view. Consider using ‘Full Report’ if applicable (see below for more details).
    2. Choose the 'Run Report' option to refresh the selected report using the date range specified.

  3. Schedule: Set up a schedule to email report results to user-defined email addresses. When chosen, scheduling options will appear.
    1. Toggle the schedule option to the right to enable the schedule.
    2. Choose schedule frequency email one time, daily, or weekly.
      1. Set the desired daily or weekly frequencies if applicable.
    3. Choose a start date and time to begin sending the report.
      1. The time set will be the time the schedule sends future reports.
    4. Choose ‘Keep Schedule Running’ to allow the emailed reports to continue sending.
    5. Specify the email addresses that should receive the report emails.
      1. Separate by a comma.
    6. Current Options: Choose how far back the data in the report should be displayed.
    7. Format: Choose the desired report format (Excel or PDF).
    8. Include Graphical Report: Toggle the setting to the right to enable and include the graphical report with the report data.
    9. Save.

  4. Export: Choose to export the report. Exporting will only include a graphical report or graphical report with metric counts only. To export full report details, use ‘Full Report’ instead (see below). Options include:
    1. EXCEL: Graphical report only.
    2. EXCEL w/Data: Graphical report with Metric Counts only.
    3. JPEG: Graphical report only.
    4. PDF: Graphical report only.
    5. PDF w/Data: Graphical report with Metric Counts only.
    6. PNG: Graphical report only.
    7. WORD: Graphical report only.
    8. WORD w/Data: Graphical report with Metric Counts only.
  5. Hide: Hides the report from the dashboard.
    1. Report(s) can be re-enabled through the 'Actions' → 'View Reports' setting.
  6. Full Report: Only available on select reports. An export with underlying data is available in the Full Report. See below for more details.


Full Report

After choosing the 'Full Report' option from the dashboard report's menu options, new report options will appear.

  1. Choose a date range in the ‘Search’ top left drop box.
  2. Run: Runs the report for the selected criteria.
  3. Additional Options: Opens a search window where criteria can be narrowed down by Action, Success, Display Name, Salesforce ID, Object, User, or Filter Name.
    1. Only available on select reports.
  4. Undo/Restore: Only available on select reports and if the undo/restore feature is included with the Cloudingo license.
    1. Opens the undo/restore settings page.
  5. Export: Choose to generate a CSV file download of the underlying data provided in the report details.
    1. Choose ‘Export’.
    2. When the export is complete, the ‘Export’ button will turn green.
    3. Choose ‘Export’ again to download the CSV file.
    4. The exported CSV will display at the bottom left of the browser.
      1. Choose the arrow to see options to Open or Show in Folder (which opens the download folder where the report can be copied and moved to the desired save location).
  6. Options: The Merge/Convert History (Summary) report will have additional options related to undo/restore. See the specific report details below for more information.


Reports Available

*Output images below show the Full Report output if available.

Post Merge/Convert

  1. Activity Stream Errors/Warnings: Reports merge, convert, or data maintenance job failures.
    1. Use when the activity stream reports failures to see the full message details.
    2. Use when automating jobs to monitor for failures that need to be addressed.
    3. Details: Provides additional details from the Merge/Convert Summary (such as record IDs involved and which user processed the filter that returned the failure).
    4. Output Displays:
      1. Header: The group name.
      2. Text: The generic failure message (such as “convert failed”, “group skipped”, etc.)
      3. Error: The specific details of the error returned when the job failed.
      4. Source: The filter that was running when the job failed.
      5. Description: The type of job (merge, convert, etc.)

  2. Dedupe Audit Report: Reports specific records that have been merged or converted through a Cloudingo dedupe job for a specified time range.
    1. The Audit report can be customized to add additional fields.
    2. Configure a specific field rule and under the ‘Actions’ settings, enable the ‘Audit’ option.
      1. To ensure that the behavior of how the field value is chosen for merge/convert is not impacted, set the rule to ‘Inherit Default’ for both the rule and the override. This will allow configurations on the field for Auditing purposes only.
    3. Additional fields will display in a separate column within the report.
    4. Values displayed will be the values obtained from the records before the merge or conversion.
    5. The field rule for auditing must be configured before merging/converting to track the value. Records merged before enabling the audit rule will not display values for the audited fields.
    6. Original Output Displays:
      1. GroupID: The internal number for the group in Cloudingo that was updated/deleted.
      2. Action: The action that was performed on the records (merge, convert, etc.)
      3. FromType: The object the merged/deleted record came from.
      4. ToType:   The object that the surviving/master record resided (and what object the other non-master records were merged into).
      5. Master: Returns a true or false value. The record ID displayed is the ‘master’ record.
      6. SalesforceID: The unique Salesforce Record ID for the record merged or converted.
      7. DisplayName: The Cloudingo Group Name for the group of records.
      8. MergeDate: The date & time that the merge or convert was performed.
      9. User: The user that performed the merge or convert.

  3. Dedupe Automation Report: Reports an overview of currently running or past dedupe automation jobs for the specified time range. Provides real-time feedback on jobs running to show which jobs are queued or scheduled.
    1. Output Displays:
      1. Automation Runs: Shows a timeline of jobs that have run or are running. Hovering over the points on the line will provide additional details.
      2. Automation Jobs: Lists each job that has run or is running with the current status and results. The ‘View’ hyperlink provides specifics of an individual job.
        1. If a job is canceled without explanation, check the ‘View’ button to see details on why the job was canceled. Too many repetitive errors can cause automation to be halted to prevent wasting API resources. Resolve the errors and restart the job.
    2. Record Summary: Provides a real-time time graphical representation of the status of an automation job.
    3. Currently Running: Shows automation jobs in process. Stop a job by choosing the ‘Stop’ option.
    4. Upcoming/Queued Jobs: Lists any jobs that have not yet been started, but are planned.

  4. Duplicates Eliminated Report: Reports the total count of duplicates per object that have been eliminated during the specified time range.


  5. Merge/Convert Report: Reports specific duplicates eliminated from within Cloudingo for the specified time range.
    1. The final record is listed as a hyperlink into Salesforce.
    2. Choose the report’s menu option to go to ‘Full Report’ to specify a date range and do extensive searches for a particular record.
    3. Undo/Restore: Opens the undo/restore settings page.
      1. Only available when the undo/restore feature is included in the Cloudingo license.
    4. In the full report, additional options will appear:
      1. Details: Displays details of a group of records that were merged.
      2. Restore: Restores merged records that have a backup plan created if the undo/restore feature is enabled. See the undo/restore help article for more details.
        1. Only available when the undo/restore feature is enabled.
        2. Download Backup: After choosing 'Restore', users will have the ability to download the backup files. The files are decrypted during the download process. 
        3. Retry: If a restore fails, an option to retry the restore will appear.
    5. Output Displays:
      1. Date: Date of the merge or conversion.
      2. Action: The action that was performed on the records (merge or convert).
      3. From: The object the merged/deleted record came from.
      4. Display Name: The group name for the group of records.
      5. ID: The unique Salesforce Record ID for the record that was merged/deleted (the non-master ID).
      6. To: The object that the surviving/master record resided (and what object the other non-master records were merged into).
      7. ID: The unique Salesforce Record ID for the master/surviving record that the other record(s) were merged into.
        1. The first ID column is the list of ID(s) that were merged/deleted and the second ID column is the master/surviving record ID.
        2. If multiple records were converted into the same master record, the ‘From’ ID column will display all Salesforce Record IDs combined into one column.
      8. Success: Returns a true or false indicating that the merge or convert was completed successfully.
      9. Filter Name: The filter that was being used at the time the merge or convert was performed.
      10. Filter Run Date: The last time the filter calculation was performed before the merge or conversion.
      11. User: The user that performed the merge or convert.

  6. Record Action Report: Reports counts per job type (address validation, convert, merge, update, etc.) per day to show what type of activity is being performed within Cloudingo during the specified time range.
    1. Change Options: From within the report's menu options, in addition to date selection, additional filtering options by metric type, platform objects, Action Sources, and Display Method are available.




Data Maintenance

  1. Activity Stream Errors/Warnings Report: Reports merge, convert, or data maintenance job failures. See above for more information.

  2. Data Maintenance Audit Report: Reports specific records updated or deleted through a Cloudingo Data Maintenance job for the specified time range.
    1. Output Displays:
      1. GroupID: The internal number for the group in Cloudingo that was updated/deleted.
      2. Action: The type of job performed (Data Maintenance).
      3. FromType: The object that the filter was created on (Contact, Lead, Account, etc.) to obtain the records desired for update.
      4. ToType: The object that filter was created on (Contact, Lead, Account, etc.) for update.
        1. In most cases, the from type & to type will be the same on Data Maintenance jobs except Update Matching jobs.
      5. Master: Displays a True or False value.
        1. Record ID displayed is the ‘master’ record (or record chosen for update when evaluating Data Maintenance results).
      6. SalesforceID: The unique Salesforce Record ID for the record updated/deleted.
      7. DisplayName: The unique display name for Data Maintenance filter results.
      8. MaintenanceDate: Date Data Maintenance job was performed.
      9. User: indicates the user that was logged into Cloudingo performing the merge or convert.

  3. Data Maintenance Automation Report: Reports an overview of currently running or past data maintenance automation jobs for the specified time range. Provides real-time feedback on jobs running to show which jobs are queued or scheduled. Same display as the Merge/Convert Automation Report (see above).
    1. Output Displays:
      1. Automation Runs: Shows a timeline of jobs that have run or are running. Hovering over the points on the line will provide additional details.
      2. Automation Jobs: Lists each job that has run or is running with the current status and results. The ‘View’ hyperlink provides specifics of an individual job.
      3. Record Summary: Provides a real-time graphical representation of the status of an automation job.
      4. Currently Running: Shows automation jobs in process. Stop a job by choosing the ‘Stop’ option.
      5. Upcoming/Queued Jobs: Lists any jobs that have not yet been started but are planned.

  4. Data Maintenance Report: Reports specific records that have been updated from Salesforce through a Cloudingo Data Maintenance job for a specified time range. Additional search options are available under the 'Additional Options' option.
    1. Output Displays:
      1. Date: The date records were updated or deleted.
      2. Action: The action that was performed on the records (update, delete, etc.)
      3. From: Indicates the master record object the updated record/value came from; or the object for the record that was deleted.
      4. ID: The unique Salesforce Record ID for the master record that was providing the update/value; or the ID for the record that was deleted.
      5. To: Indicates the non-master record object that the updated record resided; or the object for the record that was deleted.
      6. ID: The unique Salesforce Record ID for the non-master record(s) that were updated; or the ID for the record that was deleted.
        1. The ‘From’, ‘ID’, and ‘To’ fields will most likely be the same for this report on records that have been updated or deleted using Data Maintenance filters, except for Update Matching jobs.
      7. Success: Returns a true or false value indicating that the merge or convert was completed successfully.
      8. Message:  The message reason for failed updates/deletes.
      9. Job Name: The filter that was being used at the time the update or delete was performed.
      10. Job Run Date: The last time the filter calculation was performed before the update or delete.
      11. User: The user that was logged into Cloudingo performing the update or delete.


Filters

  1. Dedupe Filter Counts Report: Reports current counts for all dedupe dashboard filters. Filters may need to be recalculated to reflect the change in counts.


  2. Filter Definition Report: Reports filter configuration details for all filters and users (matching criteria, record/group limit criteria, rules assigned, and more).


  3. Filter Schedules Report: Reports all filters actively scheduled.
    1. Output Displays:
      1. Filter Name: The name of the filter that is scheduled.
      2. Email Address: The email of the user's dashboard that the filter is scheduled under.
      3. Platform: The Platform name of the connected environment where the filter is scheduled.
      4. Run Automation: 'True' means that the schedule is configured to run the job not just calculate. If 'False', the schedule is configured to recalculate the results only, but not process the job.
      5. Occurrence Type: The schedule's recurring setting (daily, weekly, monthly, etc.)
      6. Interval: The schedule's recurring interval based on the Occurrence Type (Run every '1' day, every '2' days, etc.).
      7. Occurrence Inclusion: The schedule's specified run details if populated based on Occurrence Type (ex: run every week on the following days 'Monday', 'Tuesday', etc.).
      8. Start Date: The date the schedule was set to start.
      9. Next Run Date: The date the schedule is set to run next based on the specified schedule.
      10. End Date: The date the schedule is configured to end (if not set to 'Keep it going').
      11. Filter Calculated Date: The date the filter was last calculated.
      12. Last Automation Run Date: The date the filter was last run via an automation job.


Undo/Restore

Undo features are utilized through the Merge/Convert Summary report detailed in the Post Merge/Convert or Data Maintenance section above. Other reports include:

  1. Backup Activity: Reports the backup plan details on groups of records merged when the undo/restore feature is enabled.
    1. Output Displays:
      1. BackupPlan: The name of the backup plan assigned.
      2. BackupJobID: An internal auto-assigned ID on the batch job performed on any given group of records (one ID per backup job).
      3. Backup Name: An internal auto-assigned name on the batch job performed on any given group of records (one Name per backup job).
      4. Object Name: The name of the Object associated with the backup job.
        1. There may be multiple objects related to the backup, so it is not uncommon to see related objects in addition to the main object in the backup plan.
      5. Backup Date: The date that the merge/convert/update/delete was performed and when the backup plan was generated for the group of records.
      6. Backed up By: The user that performed the merge/convert/update/delete that triggered the backup plan for the group of records.

  2. Restore Activity Report: Reports back all restoration details on groups of records using the Undo/Restore feature. Details are only captured on jobs performed after the feature has been enabled.
    1. Output Displays:
      1. BackupPlan: The name of the backup plan assigned for your organization.
      2. Object Name: The name of the Object associated with the backup job (there may be multiple objects related to the backup, so it is not uncommon to see related objects in addition to the main object in the backup plan).
      3. Original ID: The Salesforce record ID on the record before deletion/restoration (there may be multiple objects related to the backup, so it is not uncommon to see related objects in addition to the main object in the restoration details).
      4. New ID: The Salesforce record ID that was created after restoration (Cloudingo creates a copy of the previously backed up record and inserts a new record during the restore process using the data from the backup - the record ID does physically change during the restoration process).
      5. Success: ‘True’ indicates that the restoration was successful; ‘False’ indicates that the restoration failed.
      6. RestoreMessage: If the restoration failed, details reported back from Salesforce on why the restore plan failed will be provided (the error message returned from Salesforce).
      7. Restored Date: The date that the restore request was initiated.
      8. Restored By: The user that initiated the request to restore the group of records.


Integrations

  1. Callback Integration Activity: Only needed when API Callback Integration is configured and enabled.
  2. Webservice Integration Activity: Only needed when API Webservice Integration is configured and enabled.


User & Activity Monitoring

  1. User Activity Report: Reports back all user activity within Cloudingo.
    1. Limited to multi-user licenses and Admin users.

  2. User Login Activity Report: Reports back all Cloudingo dates & times for user logins.
    1. Limited to multi-user licenses and Admin users.

Was this article helpful?

What's Next