Issue Description: “While working on the Cummings Enrollment dashboard I noticed that there is a mismatch of records in the Inquiries data that I receive for the dashboard and data directly from HubSpot. There are 460 records in HubSpot that do not have a match in the Slate data that I receive. There are around 300 records in Slate that are not in HubSpot. Is it possible to check the HubSpot flag? I can share with you the list of records that do not have a match, let me know if that is helpful.”
Troubleshooting/Research
Assumptions: “In Slate” means in the data feed
pulled both of the feeds from Slate and made them a single spreadsheet with a new column for which spreadsheet they came from
compared the e-mail addresses in my Slate sheet to Sananda’s
For the 460 she is not finding in the Slate Prospect feed:
324 applicant status (so in App feed)
6 test records
49 with weird formatting, emojis, diacritics:
where the e-mail address was deleted or updated manually by Vet staff
Came in one feed with different email address than what is in the spreadsheet Sananda sent:
Then there are some weird ones
li
Resolution Steps
Add Comment