How to export campaigns delivery logs

[nemesis82]

Dear all,

can i export the campaigns delivery logs in csv / other format ?
If no, could you tell me which query MW run ?

Thanks
Best

 

[twisted1919]

You can do it only one by one for each campaign, i.e:


Otherwise, the campaign_delivery_log table contains all this info.

 

[nemesis82]

hi twisted1919
i need an export every month for all campaign because we need to split by domain and analyze the output.
There isn't another way?
Maybe i can export the result directly from mysql, could you share the query you run ?

 

[nemesis82]

#edit -- i've retrieved the sqlquery.
Possible through another way ? ( maybe from dashboard in a future release ) ?

 

[twisted1919]

If you're sending hundred of thousand of emails each months, extracting the logs won't be an easy task, it has to be done from command line most likely, so what you need is to create a console command in mailwizz, just like the one for send-campaigns for example, and make that export the data you want. Most likely you will need a dev to help you export write that command.
From our side, we consider this to be very specific, so i don't add it to the app.

You can explain us in details what you need it to export and what, and if it's simple enough, we can write the code for you, but only if it's simple, otherwise, please get a dev on board.

 

[nemesis82]

Ok, thanks for your reply.
I’ve solved with my script to export all necessary data.
In the next day i’ll add the output in my customer dash as new menu item
Bye