Account Aggregation
After you have discovered the schema and identified required attributes, you can load accounts.
-
Enter the query into the Account SQL Query field in the Account Query Settings.
-
Go to Account Management > Account Aggregation and select Start Aggregation.
-
Check the results in the Aggregation Activity log.
If the results do not seem right, try running the query as a database user and compare the number of rows returned by the query.