Systems, methods, and computer-readable media are for generating service order count metrics. A selected subset of all customer order information is extracted from a database table and stored in a summary table and detail table. The information, including text strings associated with communication device identifiers, is extracted for a selected period of time, linked together by order number, and stored in a completions table within a local database. The completions table is searched in cycles according to different search criteria of decreasing order of reliability in order to reconcile the order information in the completions table with the completed order count from the summary table. Once the orders in the completions table are accurate, logic is employed to count the number of communication device identifiers from the text strings corresponding to each order number.