Hello,
Like if we goto /backend/campaigns/index
We can see each campaign processed % in Status Column, I Want to know how to calculate this % in my own query & which Tables are used ?
@AHK - You can use the number of subscribers in a certain list (mw_list_subscriber table) and the number of emails sent so far for a campaign (mw_campaign_delivery_log).
Hello @twisted1919,
Thanks for update I did that but the issue is if some list have segment then result is wrong...
How to fix this segment issue , as segment have many operators and conditions...
If you could help me with YII query or SQL query, it would be great
Thanks
@AHK - We already have defined functions to do this, have a look at apps/customer/components/behaviors/CampaignStatsProcessorBehavior.php Line 680.
If a campaign uses a segment, you can count the subscribers in that segment using $campaign->segment->countSubscribers()
