Bulk List Segmantation?

[Leo El]

Hello,

I want to separate GI vs TLD, and further segment the list down for better sending. Is there a way to bulk add a list of domains, or auto copy/paste an insert statement into sql? Any constructive input helps.


Thank you.

 

[frm.mwz]

Hello,

I want to separate GI vs TLD, and further segment the list down for better sending. Is there a way to bulk add a list of domains, or auto copy/paste an insert statement into sql? Any constructive input helps.


Thank you.

just add a field which will hold either gi or tld in it, then run the query and populate it

 

[Leo El]

just add a field which will hold either gi or tld in it, then run the query and populate it

Thanks, i think i got it, to help others out. here is what i got.

INSERT INTO `mw_list_segment_condition` (`condition_id`, `segment_id`, `operator_id`, `field_id`, `value`, `date_added`, `last_updated`) VALUES (NULL, '2', '4', '1', 'aol.com', '2019-02-26 23:54:29', '2019-02-26 23:54:29');
INSERT INTO `mw_list_segment_condition` (`condition_id`, `segment_id`, `operator_id`, `field_id`, `value`, `date_added`, `last_updated`) VALUES (NULL, '2', '4', '1', 'hotmail.co.uk', '2019-02-26 23:54:29', '2019-02-26 23:54:29');
INSERT INTO `mw_list_segment_condition` (`condition_id`, `segment_id`, `operator_id`, `field_id`, `value`, `date_added`, `last_updated`) VALUES (NULL, '2', '4', '1', 'msn.com', '2019-02-26 23:54:29', '2019-02-26 23:54:29');