I have a welcome journey in which the subscriber at a point chooses which room needs a redesign.
The links for these 3 rooms have tracking aliases like this:
I want to pull everyone that clicks those links into a data extension with these fields:
I want the field LinkName to be populated with one of the 6 tracking aliases above. This is the query I have created for now:
SELECT MasterSubscribers.SubscriberKey, EmailAddress, _Click.LinkName FROM MasterSubscribers JOIN _Click ON MasterSubscribers.SubscriberKey = _Click.SubscriberKey WHERE MasterSubscribers.SubscriberKey IN (SELECT SubscriberKey FROM _Click WHERE LinkName IN ('Image_RoPLivingRoom','CTA_RoPLivingRoom','Image_RoPBedroom','CTA_RoPBedroom','Image_RoPDiningRoom','CTA_RoPDiningRoom'))
The DataExtension is populated, but not only with the tracking aliases as the ones above. ie. tracking aliases like CTA_Instagram, CTA_VelvetFelt and CustomerService are only in the Data Extension.
Can you please guide me to how alter the query to have only subscribers with clicks on those tracking aliases populated to the data extension?