Marketing Cloud - Create a Data Extension by filtering out Subscribers

Question

big Marketing Cloud Noob here!

I have inherited the admin Role in the Company in Marketing Cloud and I cannot make ends meet.

My Company regularly sends emails to their subscribers and professionals we have registered on our website.

Our list of subscribers is stored in data extension file. than we have several where subscribers are filtered by country (As you might see from the image)

here is a portion of the screen:

I want to be able, to create another list where Mexicans audience is filtered out.

I just cant find a way! Im not asking you to guide me step by step, but maybe sending me some useful material I can study. Checked out trailhead and found nothing related.

So, this is a print screen of our Subscribers and the field related. I should be able to filter a different audience by Country code but doesn't work!

Answer 1

Based on your source DE screenshot, I would guide you like this:

1. From the source DE, click on the funnel icon on the top right corner
2. Drag the field "CountryCode" from the left column to the Create Filter canvas
3. Put a value for the filter. For example: CountryCode is equal to "MX" (I am assuming that the MX value is using for Mexican audiences)
4. Click "Save & Build"
5. Enter a Name for the filtered data extension and Select a folder to store the filtered DE
6. Save and wait until it completely finishes.

Actually, it will perform the same steps as the document I mentioned in my comment, but from the DE source

Answer 2

To find the distinct values of the CountryCode field and the number of related contacts, you can use the following query in Query Studio:

SELECT COUNT(Id), CountryCode
FROM [DE Name]
GROUP BY CountryCode

This will give you a list of all the different country codes that exist in the data extension along with the number of contacts associated with each one.

Then you can take the exact CountryCode value for Mexico for use in your Filtered Data Extension.