Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Is there a way to simply get record counts of a query without having to populate a data extension? I want to see how many records meet some criteria without creating a new DE, or a new filtered DE.
I know there's some 3rd party plugin (considering getting one).
Unfortunately to retrieve counts you will need to create a Data Extension. If your account uses Audience Builder, it is possible to quickly generate counts for dimensions already set. But then again, these dimensions have to be set by Salesforce and takes ages to them to do it.
As a quick hack you can set up a data extension with just a "Count" field, and adjust the queries for that data extension to return to counts of the population you are querying.
