Bulk List Segmantation?

Discussion in 'Tips and tricks' started by Leo El, Feb 25, 2019.

  1. Leo El

    Leo El New Member

    Joined:
    Feb 24, 2019
    Messages:
    11
    Likes Received:
    1
    S.E:
    2019-08-25 16:31:06
    L.T:
    Regular
    L.C:
    1
    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.
     
  2. frm.mwz

    frm.mwz Well-Known Member

    Joined:
    Mar 8, 2016
    Messages:
    3,703
    Likes Received:
    676
    S.E:
    2019-11-27 02:17:39
    L.T:
    Regular
    L.C:
    7
    just add a field which will hold either gi or tld in it, then run the query and populate it ;)
     
  3. Leo El

    Leo El New Member

    Joined:
    Feb 24, 2019
    Messages:
    11
    Likes Received:
    1
    S.E:
    2019-08-25 16:31:06
    L.T:
    Regular
    L.C:
    1
    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');
     

Share This Page