Do you know of a way that we can identify or tag records that do not have SFDC matches?

Hello, I am having problems with a conditional wait. The goal is to have the CW evaluate if a date field has been updated within the last 7 days. If the field has been updated, then I want the participant to drop, however, if the field has not been updated, I would like them to receive a second email communication.

I have two questions/issues. I’m a brand new admin so these may be easy peasy but I’m struggling 

1. We have children account that rollup to an “Ultimate Parent Account.” GS Support has shared that our lookup set up for the field and the SFDC parent field is looking up to to SFDC account id. Ultimate parent has 15 digits and the SFDC account id values have 18 digits. “No match” is causing the lookup not to work. Long story short, how in the world do I adjust the lookup to get the parent to show? I’m ultimately trying to get my data designer report to show parent accounts alongside my child accounts.

• https://share.getcloudapp.com/7KuPOQYp
• https://share.getcloudapp.com/YEuRxrEl

2. I work off a spreadsheet to create support cases (Salesforce case) when a specific customer site needs to be shutdown or they are dropping a solution. These accounts don’t have assigned CSMs. I know I can generate CTA’s and other things with the excel list, BUT, what I would love to know is if Gainisight has any possible way of automating this task for me and where would I even start. I don’t necessarily need to trigger anything in Gainisight since I am owning the creation of these cases and low touch (tech touch) clients. Just curious if I could create cases somehow via Gainsight

Is it possible to connect Gainsight to Microsoft Planner? 

I’d like to understand best practices on how to update accounts when they churn so that they do not show under a CSM’s BOB.