Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search report results for contacts.any_phone_raw vs. any_phone

edited Jun 18, 2020 4:01PM in Reporting & Analytics for B2C Service

Summary

Looking to understand why the rows analyzed are different for the two fields

Content

Why do the fields have a different number of analyzed rows if they're both searching the phone fields? Report definition for the original report  is attached. 

In April 2020 we imported around a half million contact records from product registration to assist servicing warranty inquires. In May 2020 we upgraded from 19C to 20A. 

After the upgrade our "Find a Contact" report could not be processed because it exceeds the query size limitation. Agents are searching by 10 digit phone number in the report filter field contacts.any_phone_raw

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!