Commit Graph

175 Commits

Author SHA1 Message Date
7ed007094e Add status field for digitals 2024-07-17 08:54:41 +00:00
8b1d674626 Update date range for reports.
Replace hotel name with routing hotel name for calls
2024-07-17 08:48:00 +00:00
51cd892506 Update script with agents deduplication 2024-07-16 11:03:00 +00:00
2e068f0859 Add more patterns for language extraction 2024-07-09 09:47:40 +00:00
bc7acf150f Adding new fields to calls report 2024-07-09 07:28:52 +00:00
1c8a756261 Add TALK_TIME_LESS_HOLD_AND_PARK formatted filed 2024-07-09 07:23:14 +00:00
73baea4a11 Add formatted fields to reports 2024-07-04 14:48:29 +00:00
e6285f8ee3 Same for digital 2024-07-04 14:43:58 +00:00
0ab2a1f697 Keeping both formatted and not time fields for calls 2024-07-04 14:39:43 +00:00
bb96e38bf2 Same for digital 2024-07-04 14:26:44 +00:00
966b0c4615 Add time fields conversion 2024-07-04 14:14:58 +00:00
3e37926450 Remove calls with abandoned as NULL 2024-07-04 13:58:37 +00:00
8bd623ce2b Update source tables for exports 2024-06-25 12:52:23 +00:00
748a9bc726 Add disposition match for NULL values 2024-06-25 11:09:40 +00:00
df5633a0ec Adding coalesce for NULL values in AGENT_GROUP 2024-06-25 09:52:09 +00:00
c4ecd8eb15 Adding source table 2024-06-25 09:51:08 +00:00
2cc745a55a Update key field DNIS to get 0 instead of NULL 2024-06-25 08:35:50 +00:00
2e58b02e5e Add deduplication to digital stg table 2024-06-24 13:55:25 +00:00
ae11ad5f6b Assertion update 2024-06-20 14:16:51 +00:00
38b21ef1ed Add key field to digital report 2024-06-20 12:11:14 +00:00
cc0a7dddf3 Update all_interaction tables 2024-06-20 12:09:05 +00:00
e65b9f2d38 Adding schema to wildcard tables 2024-06-20 09:06:53 +00:00
ccb919db03 Add deduplication 2024-06-19 14:33:29 +00:00
16bf93a06c Added dot 2024-06-19 08:47:50 +00:00
cd89da27eb 1 2024-06-19 07:18:52 +00:00
609185904f Delete old tables 2024-06-18 14:51:11 +00:00
1ad3fbca6c Remove extra table 2024-06-18 13:17:11 +00:00
78d6f3660a 1 2024-06-18 13:11:41 +00:00
3c2e234092 Add columns 2024-06-18 13:06:13 +00:00
ce7d32ecbe Update column name 2024-06-18 12:52:56 +00:00
8ace4b2096 Update column name 2024-06-18 12:28:14 +00:00
3146475a80 Update table all_interactions 2024-06-18 11:46:15 +00:00
2e7e7a8aa2 Create calls report 2024-06-17 15:01:23 +00:00
dc7482e030 +1 2024-06-17 14:52:48 +00:00
f04f8bb0ef Delete old digital tables 2024-06-17 14:51:52 +00:00
7e15b298b2 Update calls history table 2024-06-17 14:47:58 +00:00
a68eccad6b 1 2024-06-14 14:43:28 +00:00
614c72997b update source table 2024-06-14 14:28:26 +00:00
3d36821dd5 interval 2024-06-12 13:29:37 +00:00
6b7a3534a8 Mistypo 2024-06-11 14:32:12 +00:00
6c758039d9 Improve script 2024-06-07 11:16:19 +00:00
68621588f1 Make report non-incremental 2024-06-05 14:41:25 +00:00
2d29c6684d New report table for digital 2024-06-05 13:35:13 +00:00
d41b98f15f Create report for digital data. 2024-06-04 14:52:01 +00:00
62ad1ed247 New tag for this table 2024-05-29 13:02:30 +00:00
c134a3f3f1 Field name update 2024-05-29 08:55:31 +00:00
2cd21c56af Comment update 2024-05-29 08:54:34 +00:00
27e24cff90 MERGE for digital and calls tables 2024-05-29 08:46:34 +00:00
0aeb4130c3 Part of calls 2024-05-22 14:54:30 +00:00
6d0e53205a New sources 2024-05-22 14:09:26 +00:00