Can I export specific NXT Ratings from Database?
My CDO wants a report that contains the "Next Gift Amount" (NXT terminology) which in Database View is the "Minimum Ask Amount" and the "Maximum Ask Amount". I can't seem to get just these two ratings out of the Database view. I have to take all the NXT ratings categories to get the 2 that I want, and there doesn't appear to be any set pattern to how they show up in the output.
Can anyone help? Something I'm missing?
Thank you!
Comments
-
You're not missing anything, Tammie. Export only allows you to filter based on Rating Source, not Rating Category, and yes they come out in random order. For this type of task I'd export everything and then work in Excel. The random output will make it complicated, but if you sort, you can insert columns to try and line things up. I've successfully done this before with 30,000+ records, but it is time consuming.
2 -
Couldn't you create the list in NXT? The Next Ask Amount and the Maximum Ask Amount are available columns. And you can export the file now directly from NXT. I haven't tried it yet, but it would seem if you're looking for NXT fields, you would want to start there rather than trying to force the information out of the database view.
Good luck!
Katherine0 -
Tammie Cach Abdu:
Hello everyone!
My CDO wants a report that contains the "Next Gift Amount" (NXT terminology) which in Database View is the "Minimum Ask Amount" and the "Maximum Ask Amount". I can't seem to get just these two ratings out of the Database view. I have to take all the NXT ratings categories to get the 2 that I want, and there doesn't appear to be any set pattern to how they show up in the output.
Can anyone help? Something I'm missing?
Thank you!Aaron is correct in that Export is not the tool that exports the ratings in s useful manner which is too bad. I created a query that pulls our ratings into individual columns and then I use the query options to choose my query to pull ratings for those people. I then use Excel and VLookup formulas to add to my export by whatever specific I desire. Tip: In the Prospect Ratings query, I renamed the columns to add what column number they were so that I could easily identify and choose the column number when building my vLookup formulas.
1 -
Tammie Cach Abdu:
Hello everyone!
My CDO wants a report that contains the "Next Gift Amount" (NXT terminology) which in Database View is the "Minimum Ask Amount" and the "Maximum Ask Amount". I can't seem to get just these two ratings out of the Database view. I have to take all the NXT ratings categories to get the 2 that I want, and there doesn't appear to be any set pattern to how they show up in the output.
Can anyone help? Something I'm missing?
Thank you!I will be the first to admit there's so much that I don't know about NXT yet, but I've seen that some queries that are created in the NXT web view get somehow just pushed over into the database view. What do you all think about trying to do a pivot report off that query? Would that be helpful?
0 -
Tammy, I feel your pain! Not being able to easily extract the wealth data via query/export is a HUGE inconvenience. Even worse--there is overlapping data -- "A" for 5 stars in Overall Rating and "A" for Annual Donor in Recommended Donor Type, which get co-mingled in the same columns as you cannot silo the data into its own column. Who came up with those?!? I have brought up this issue with Target Analytics and I get the same response-post it in the Idea Bank, which I have done.
We use Overwealth Rating (Stars) in EVERY report and my solution has been to make an OWR Attribute and which is = to the OWR, and becasue it is an Attribute I can easily extract it. I run a daily check of OWR updates (via a query) and then manually update the Attribute in th records that pop-up. The original set-up was timeconsuming (lots of global changes to get the Attribute into the records that already had the various OWR) but now it is easy as it is typically only a few records each day.0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board