I am trying a query
SQL in Salesforce to count the number of click per user on one link. However, the count column stays empty even tough my query looks good from a syntax point of view.
Here is my query:
SELECT subscriberkey, bannername, COUNT(bannername) AS freq FROM tablebanner GROUP by subscriberkey, bannername