You need to sign in to do that
Don't have an account?
Ghost Data Appearing in Salesforce Reports
We have scheduled pulls from Salesforce for a few native objects. To show staff which recrods are slated or pulling, we have reports and dashboards available that they can access. We then pull the data using the data loader and SOQL queries that match the report filter criteria for each object. One criterion was that the Contact record have a value in the Phone field.
However, the report for Contacts showed about 100 more records fitting the criteria than were pulled with the data loader. We played around extensively with both the report and query wondering what might be the difference between the two.
What we found is that the Salesforce report was showing some Contacts has having a value in the Phone field (right there in the Phone column on the report) when there was no value on the Contact record itself (when we clicked through, the Phone field was blank).
Has anyone run into something like this?
Yes I am seeing this too. Very Odd.