SQL=SELECT DISTINCT c.id, artid, file, title, description, cat.art_title FROM campaigns as c, catbyid as cat, artbyid as art WHERE (cat.category = 'Segmentation') and (art.category = 'Segmentation') and (c.id = cat.emailid) and (c.id = art.emailid) GROUP BY c.id, artid

Category: Segmentation Index of Articles only

";
id Rvw artid file title description art_title
117[rvw] [art:6] [campaigns/7417335_clarity-first-september-21-2018-110.html] Clarity First, September 21, 2018, #110 We need to learn as fast as the world changes. Media companies have rolled out ad products that they say can match ads to people in certain moods.
CONTENT
142[rvw] [art:6] [campaigns/7592435_clarity-first-march-15-2019-134.html] Clarity First, March 15, 2019, #134 Redeem the work of fools. Why the term “behavioral archetype” is more accurate than “customer persona”.
CONTENT
217[rvw] [art:5] [campaigns/7875816_clarity-first-august-7-2020-207.html] Clarity First, August 7, 2020, #207 This is no time for complacency or despair. All too often brands are obsessed with what makes people different rather than looking for traits and behaviors they share.
CONTENT