For our targeting work and our mailing segments, we need to be able to query ratings by a combination of Date, Description (the rating itself), and Notes.
Query's Prospect > Ratings > Specific Sources will output the rating in its currency form, but you cannot use the additional query items to fine tune your results outside of the description/rating itself.
You can use the Prospect > Ratings non-specific source fields of Date, Description, and Notes to do a better results BUT the Description is being handled in text format. Therefore, you cannot query for >=$1000 ratings correctly as a $110 rating would also show as it is greater than 1000 in text/alpha order.
Please have the description respect the ratings config table for query so that we can use the fields to do our targeting and mailing segments where we need to look for a specific date range mixed with a specific $ amount rating for our leadership or non-leadership.
For our targeting work and our mailing segments, we need to be able to query ratings by a combination of Date, Description (the rating itself), and Notes.
Query's Prospect > Ratings > Specific Sources will output the rating in its currency form, but you cannot use the additional query items to fine tune your results outside of the description/rating itself.
You can use the Prospect > Ratings non-specific source fields of Date, Description, and Notes to do a better results BUT the Description is being handled in text format. Therefore, you cannot query for >=$1000 ratings correctly as a $110 rating would also show as it is greater than 1000 in text/alpha order.
Please have the description respect the ratings config table for query so that we can use the fields to do our targeting and mailing segments where we need to look for a specific date range mixed with a specific $ amount rating for our leadership or non-leadership.