Segment - Select user based on advanced SQL query

MelanieB

Hi,
I am trying to create more advanced segments using the advanced SQL query. I have already run the filter I want to create in MySQL database to get the correct syntax. However when I apply it in AcyMailing advanced select query it produces no users. Can you tell me if my SQL is structured correctly for Acymailing. This is what I put in the query box but when save it says Number of AcyMailing users matching these conditions:
An error occurred and no users are selected. Im MySQL it produces the correct results and shows all users for that particular mail ID who have not opened the email:

SELECT * FROM azun3_acym_user_stat WHERE mail_id = 340 AND open = 0

Any help would be greatly appreciated

mihha

Advanced query should return some email addresses and then those email addresses are compared to your AcyMailing subscribers to match

If you don't have subscribers in AcyMailing which match those returned by the query, nothing will be shown

MelanieB

Hi thanks,

I want to return all users from my email campaign with the ID of 340 and filter those on whether they opened the mail or not. How would you do this? Does it work for you in your own copy of acymailing? If yes how does your query look? This would help me.

mihha

You don't need adanced query for this

You just have to use Statistic filter

MelanieB

Hi,
mine doesn't seem to work. I mentioned it here:

https://forum.acymailing.com/d/2753-segments-statistics-doesn-t-work

Which is why I was trying the advanced SQL (and want to get the sql working so I can apply other conditions to get acymailing to do what I need for my particular circumstances.

MelanieB

Sorry posted reply before i could finish. I tried to upload a screen capture video but it wouldn't accepted it so converted to a gif. You should just about make out what happens. You can see my Emails in the Email list. You will also see they have just over 13k subscribers. When I go to Segments and select the list, then statistics and either opened or not opened it shows zero users (whether I select 0 in the hour or 1). Then after I save the segment in the top right notifications it shows Email not found message (even though the email does exist as you will see at begining of clip

mihha

We can't solve this here in the forum so please open a support ticket using our contact form