Acoustic Campaign Ideas

The Acoustic Ideas portal has moved! Please sign up for our new Ideas portal and submit your suggestions at

Random Sample in Queries

having the possibility to restrict a query result to a sample of rows.

For example my query gives me 10000 people and I just need to send 1000 emails (because of my number of coupons or for winners of a game).


It could be great if I can restrict the number of rows of my queries.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jan 8 2019
  • Needs review
How will this idea be used?

Select randomly 10000 people of my 100 000 rows query to send an email to my winning group

What is your industry? Retail
What is the idea priority? Medium
DeveloperWorks ID
Link to original RFE
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    January 10, 2019 01:45

    This doesn't necessarily solve the issue, but you could look at doing an A/B test to 10% of base, and then not sending the remainder. That would randomly choose people for you.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    January 10, 2019 22:37

    You could also segment the query with your own criteria for each segment

  • Admin
    Frank Somich commented
    March 01, 2019 13:58

    Thank you for the idea! I can pass this feedback along to the team that works on queries. For the time being, Watson Assistant for Marketing cannot surface contact records