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 = 'Audience Definition') and (art.category = 'Audience Definition') and (c.id = cat.emailid) and (c.id = art.emailid) GROUP BY c.id, artid

Category: Audience Definition Index of Articles only

";
id Rvw artid file title description art_title
117[rvw] [art:1] [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. Sustainability is the new black.
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
472[art:5] [campaigns/10337741_love-work-april-25-2025-457.html] Love & Work, April 25, 2025, #457 What we do can be beautiful
CONTENT