Elasticsearch - count users query

Hi All,
I have a problem that I hope someone can help me with:

I have the next mapping for my user index -> docs(users) containing events in which the user bought different products. each event(date) can contain several products. I would like to retrieve the count of users that their last purchase of TV was TOSHIBA. for that I am willing to have a 'TV' as a product by itself.

So in case a have the next events:

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1 should be counted because its last bought TV was TOSHIBA but user2 should not.

Does anyone have an idea how to approach this query?

I tried several times but I'm new to elasticsearch so no success yet.

Thanks in advanced,

    {

"user" : {
"properties" : {
"name": {"type" : "string"},
"events" : {
"type" : "nested",
"properties" : {
"event_time" : {"type" : "Date"},
"products" : { "properties" : { "product" : {"type" : "string"} } }
}
}
}
}
}

Hello,

I don't see a clean way of doing this. But you can pay some prices, either
at query or at index time, to obtain this.

For example, at query time, you can try to get a list of unique users by
doing a terms facethttp://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/on
the user field. Then, you can do a multi
search http://www.elasticsearch.org/guide/reference/api/multi-search/ for
all the users to see what was the last thing they bought. Finally, you can
count on the application side which of those was a Toshiba TV. Very slow
and doesn't scale, but you can do anything.

On the other hand, if you have a predefined list of such queries, you can a
separate index (eg: last_item_bought) for each query. For example, with
this one, you can have an index where, each time a use buys something, you
update the document with their name as the ID, and the item they bought. It
shouldn't hurt indexing performance too much. When you want to search, you
just do a filter on "tv" and "toshiba", with size=0 and see the number of
hits.

Best regards,
Radu

On Thu, Jun 27, 2013 at 6:21 PM, oreno oreno@exelate.com wrote:

Hi All,
I have a problem that I hope someone can help me with:

I have the next mapping for my user index -> docs(users) containing events
in which the user bought different products. each event(date) can contain
several products. I would like to retrieve the count of users that their
last purchase of TV was TOSHIBA. for that I am willing to have a 'TV' as a
product by itself.

So in case a have the next events:

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1 should be counted because its last bought TV was TOSHIBA but user2
should not.

Does anyone have an idea how to approach this query?

I tried several times but I'm new to elasticsearch so no success yet.

Thanks in advanced,

    {

"user" : {
"properties" : {
"name": {"type" : "string"},
"events" : {
"type" : "nested",
"properties" : {
"event_time" : {"type" : "Date"},
"products" : { "properties" : { "product" : {"type" : "string"} } }
}
}
}
}
}

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- ElasticSearch -- Solr -- Lucene

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Hi Radu,
thank you for taking the time to assist me with this problem.
Since the search time is highly important, my first choice would have been
to use the second option that you mentioned, and
use a separate index for each product such as TV.

unfortunately, there is another restriction, that makes the problem even
more complex.
I need to be able to set a date range for the query.
For example, if again I am looking for the user count of TOSHIBA buyers at
18 - 20 of May, I should get count=1 (as before).But if my range is 18 -21
of May (as appear below), I should get count = 0, because at that range,
there is no user that his last TV was TOSHIBA.

So as you can see, creating an user_tv_index that gets overridden on each
TV bought is a problem, because I will still need the info for old actions.

Do you think that there is still a good way of retrieving this information
without slowing the search time?

Thanks in advanced. I highly appreciate your help.

Oren

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1|2013-05-21|TV,SAMSUNG

On Fri, Jun 28, 2013 at 3:41 PM, Radu Gheorghe-2 [via ElasticSearch Users] <
ml-node+s115913n4037241h6@n3.nabble.com> wrote:

Hello,

I don't see a clean way of doing this. But you can pay some prices, either
at query or at index time, to obtain this.

For example, at query time, you can try to get a list of unique users by
doing a terms facethttp://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/on the user field. Then, you can do a multi
search http://www.elasticsearch.org/guide/reference/api/multi-search/for all the users to see what was the last thing they bought. Finally, you
can count on the application side which of those was a Toshiba TV. Very
slow and doesn't scale, but you can do anything.

On the other hand, if you have a predefined list of such queries, you can
a separate index (eg: last_item_bought) for each query. For example, with
this one, you can have an index where, each time a use buys something, you
update the document with their name as the ID, and the item they bought. It
shouldn't hurt indexing performance too much. When you want to search, you
just do a filter on "tv" and "toshiba", with size=0 and see the number of
hits.

Best regards,
Radu

On Thu, Jun 27, 2013 at 6:21 PM, oreno <[hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=0

wrote:

Hi All,
I have a problem that I hope someone can help me with:

I have the next mapping for my user index -> docs(users) containing events
in which the user bought different products. each event(date) can contain
several products. I would like to retrieve the count of users that their
last purchase of TV was TOSHIBA. for that I am willing to have a 'TV' as a
product by itself.

So in case a have the next events:

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1 should be counted because its last bought TV was TOSHIBA but user2
should not.

Does anyone have an idea how to approach this query?

I tried several times but I'm new to elasticsearch so no success yet.

Thanks in advanced,

    {

"user" : {
"properties" : {
"name": {"type" : "string"},
"events" : {
"type" : "nested",
"properties" : {
"event_time" : {"type" : "Date"},
"products" : { "properties" : { "product" : {"type" : "string"} }
}
}
}
}
}
}

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=1
.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- ElasticSearch -- Solr -- Lucene

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=2
.
For more options, visit https://groups.google.com/groups/opt_out.


If you reply to this email, your message will be added to the discussion
below:

http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172p4037241.html
To unsubscribe from elasticsearch - count users query, click herehttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4037172&code=b3Jlbm9AZXhlbGF0ZS5jb218NDAzNzE3Mnw4ODk1Mjk2Nzg=
.
NAMLhttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html!nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers!nabble%3Aemail.naml-instant_emails!nabble%3Aemail.naml-send_instant_email!nabble%3Aemail.naml

--

Oren Orgad

eXelate
software engineer

p: +972- 72-2221329 | m: +972- 52-3401051 | e: oreno@exelate.com

Hi Oren,

Unfortunately, I don't see a way of indexing your documents so you can get
what you want in a fast way. But maybe someone else can find a way...

Best regards,
Radu

On Sat, Jun 29, 2013 at 12:34 AM, oreno oreno@exelate.com wrote:

Hi Radu,
thank you for taking the time to assist me with this problem.
Since the search time is highly important, my first choice would have been
to use the second option that you mentioned, and
use a separate index for each product such as TV.

unfortunately, there is another restriction, that makes the problem even
more complex.
I need to be able to set a date range for the query.
For example, if again I am looking for the user count of TOSHIBA buyers at
18 - 20 of May, I should get count=1 (as before).But if my range is 18 -21
of May (as appear below), I should get count = 0, because at that range,
there is no user that his last TV was TOSHIBA.

So as you can see, creating an user_tv_index that gets overridden on each
TV bought is a problem, because I will still need the info for old actions.

Do you think that there is still a good way of retrieving this information
without slowing the search time?

Thanks in advanced. I highly appreciate your help.

Oren

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1|2013-05-21|TV,SAMSUNG

On Fri, Jun 28, 2013 at 3:41 PM, Radu Gheorghe-2 [via ElasticSearch Users]
<[hidden email] http://user/SendEmail.jtp?type=node&node=4037265&i=0>wrote:

Hello,

I don't see a clean way of doing this. But you can pay some prices,
either at query or at index time, to obtain this.

For example, at query time, you can try to get a list of unique users by
doing a terms facethttp://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/on the user field. Then, you can do a multi
search http://www.elasticsearch.org/guide/reference/api/multi-search/for all the users to see what was the last thing they bought. Finally, you
can count on the application side which of those was a Toshiba TV. Very
slow and doesn't scale, but you can do anything.

On the other hand, if you have a predefined list of such queries, you can
a separate index (eg: last_item_bought) for each query. For example, with
this one, you can have an index where, each time a use buys something, you
update the document with their name as the ID, and the item they bought. It
shouldn't hurt indexing performance too much. When you want to search, you
just do a filter on "tv" and "toshiba", with size=0 and see the number of
hits.

Best regards,
Radu

On Thu, Jun 27, 2013 at 6:21 PM, oreno <[hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=0

wrote:

Hi All,
I have a problem that I hope someone can help me with:

I have the next mapping for my user index -> docs(users) containing
events
in which the user bought different products. each event(date) can contain
several products. I would like to retrieve the count of users that their
last purchase of TV was TOSHIBA. for that I am willing to have a 'TV' as
a
product by itself.

So in case a have the next events:

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1 should be counted because its last bought TV was TOSHIBA but user2
should not.

Does anyone have an idea how to approach this query?

I tried several times but I'm new to elasticsearch so no success yet.

Thanks in advanced,

    {

"user" : {
"properties" : {
"name": {"type" : "string"},
"events" : {
"type" : "nested",
"properties" : {
"event_time" : {"type" : "Date"},
"products" : { "properties" : { "product" : {"type" : "string"}
} }
}
}
}
}
}

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=1
.

For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- ElasticSearch -- Solr -- Lucene

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=2
.

For more options, visit https://groups.google.com/groups/opt_out.


If you reply to this email, your message will be added to the
discussion below:

http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172p4037241.html
To unsubscribe from elasticsearch - count users query, click here.
NAMLhttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html!nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers!nabble%3Aemail.naml-instant_emails!nabble%3Aemail.naml-send_instant_email!nabble%3Aemail.naml

--

Oren Orgad

eXelate
software engineer

p: +972- 72-2221329 | m: +972- 52-3401051 | e: [hidden email]http://user/SendEmail.jtp?type=node&node=4037265&i=1


View this message in context: Re: elasticsearch - count users queryhttp://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172p4037265.html

Sent from the ElasticSearch Users mailing list archivehttp://elasticsearch-users.115913.n3.nabble.com/at Nabble.com.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- ElasticSearch -- Solr -- Lucene

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Thanks Radu,
I appreciate your effort here.
I'm now looking into native script option for running java based logic
after running a more basic query(that will just return the documents
containing the range I need and contain the TV string).
is that what you meant by running on application side? do you think I will
pay a big price for this way of searching?

Thanks in advanced,

Oren

On Sun, Jun 30, 2013 at 4:53 PM, Radu Gheorghe-2 [via ElasticSearch Users] <
ml-node+s115913n4037282h77@n3.nabble.com> wrote:

Hi Oren,

Unfortunately, I don't see a way of indexing your documents so you can get
what you want in a fast way. But maybe someone else can find a way...

Best regards,
Radu

On Sat, Jun 29, 2013 at 12:34 AM, oreno <[hidden email]http://user/SendEmail.jtp?type=node&node=4037282&i=0

wrote:

Hi Radu,
thank you for taking the time to assist me with this problem.
Since the search time is highly important, my first choice would have
been to use the second option that you mentioned, and
use a separate index for each product such as TV.

unfortunately, there is another restriction, that makes the problem even
more complex.
I need to be able to set a date range for the query.
For example, if again I am looking for the user count of TOSHIBA buyers
at 18 - 20 of May, I should get count=1 (as before).But if my range is 18
-21 of May (as appear below), I should get count = 0, because at that
range, there is no user that his last TV was TOSHIBA.

So as you can see, creating an user_tv_index that gets overridden on each
TV bought is a problem, because I will still need the info for old actions.

Do you think that there is still a good way of retrieving this
information without slowing the search time?

Thanks in advanced. I highly appreciate your help.

Oren

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1|2013-05-21|TV,SAMSUNG

On Fri, Jun 28, 2013 at 3:41 PM, Radu Gheorghe-2 [via ElasticSearch
Users] <[hidden email]http://user/SendEmail.jtp?type=node&node=4037265&i=0

wrote:

Hello,

I don't see a clean way of doing this. But you can pay some prices,
either at query or at index time, to obtain this.

For example, at query time, you can try to get a list of unique users by
doing a terms facethttp://www.elasticsearch.org/guide/reference/api/search/facets/terms-facet/on the user field. Then, you can do a multi
search http://www.elasticsearch.org/guide/reference/api/multi-search/for all the users to see what was the last thing they bought. Finally, you
can count on the application side which of those was a Toshiba TV. Very
slow and doesn't scale, but you can do anything.

On the other hand, if you have a predefined list of such queries, you
can a separate index (eg: last_item_bought) for each query. For example,
with this one, you can have an index where, each time a use buys something,
you update the document with their name as the ID, and the item they
bought. It shouldn't hurt indexing performance too much. When you want to
search, you just do a filter on "tv" and "toshiba", with size=0 and see the
number of hits.

Best regards,
Radu

On Thu, Jun 27, 2013 at 6:21 PM, oreno <[hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=0

wrote:

Hi All,
I have a problem that I hope someone can help me with:

I have the next mapping for my user index -> docs(users) containing
events
in which the user bought different products. each event(date) can
contain
several products. I would like to retrieve the count of users that their
last purchase of TV was TOSHIBA. for that I am willing to have a 'TV'
as a
product by itself.

So in case a have the next events:

user1|2013-05-18|TV,SAMSUNG
user1|2013-05-19|TV,TOSHIBA
user1|2013-05-20|PC
user2|2013-05-18|TV,TOSHIBA
user2|2013-05-19|TV,SAMSUNG
user2|2013-05-20|PC
user1 should be counted because its last bought TV was TOSHIBA but user2
should not.

Does anyone have an idea how to approach this query?

I tried several times but I'm new to elasticsearch so no success yet.

Thanks in advanced,

    {

"user" : {
"properties" : {
"name": {"type" : "string"},
"events" : {
"type" : "nested",
"properties" : {
"event_time" : {"type" : "Date"},
"products" : { "properties" : { "product" : {"type" : "string"}
} }
}
}
}
}
}

--
View this message in context:
http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=1
.

For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- ElasticSearch -- Solr -- Lucene

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037241&i=2
.

For more options, visit https://groups.google.com/groups/opt_out.


If you reply to this email, your message will be added to the
discussion below:

http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172p4037241.html
To unsubscribe from elasticsearch - count users query, click here.
NAMLhttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html!nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers!nabble%3Aemail.naml-instant_emails!nabble%3Aemail.naml-send_instant_email!nabble%3Aemail.naml

--

Oren Orgad

eXelate
software engineer

p: +972- 72-2221329 | m: +972- 52-3401051 | e: [hidden email]http://user/SendEmail.jtp?type=node&node=4037265&i=1


View this message in context: Re: elasticsearch - count users queryhttp://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172p4037265.html

Sent from the ElasticSearch Users mailing list archivehttp://elasticsearch-users.115913.n3.nabble.com/at Nabble.com.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037282&i=1
.
For more options, visit https://groups.google.com/groups/opt_out.

--
http://sematext.com/ -- ElasticSearch -- Solr -- Lucene

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [hidden email]http://user/SendEmail.jtp?type=node&node=4037282&i=2
.
For more options, visit https://groups.google.com/groups/opt_out.


If you reply to this email, your message will be added to the discussion
below:

http://elasticsearch-users.115913.n3.nabble.com/elasticsearch-count-users-query-tp4037172p4037282.html
To unsubscribe from elasticsearch - count users query, click herehttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4037172&code=b3Jlbm9AZXhlbGF0ZS5jb218NDAzNzE3Mnw4ODk1Mjk2Nzg=
.
NAMLhttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html!nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers!nabble%3Aemail.naml-instant_emails!nabble%3Aemail.naml-send_instant_email!nabble%3Aemail.naml

--

[image: Inline image 1]
*
*
Oren Orgad | Software Engineer | eXelate http://www.exelate.com/

p: +972- 72-2221329 | e: oreno@exelate.com

Hello Oren,

On Sun, Jun 30, 2013 at 5:27 PM, oreno oreno@exelate.com wrote:

Thanks Radu,
I appreciate your effort here.
I'm now looking into native script option for running java based logic
after running a more basic query(that will just return the documents
containing the range I need and contain the TV string).
is that what you meant by running on application side?

I'm not sure where scripting would fit here. What I had in mind was a
3-step process:

  1. You get the list of unique users from that time range (that bought a
    samsung TV) using a facet
  2. You get the last buy for each user by running a filter for each user and
    sort descending on the date of the buy
  3. At this point you still have to see if the last buy of these users was a
    samsung TV or not. You can simply get all the info you have in your
    application (nothing to do with ES here) and filter those out.
    Alternatively, you can treat results at step 2 as a stream and push that
    back into a new index/type in ES. Then, you could use ES for filtering.
    Alternatively, you can use TTL to keep that data for a while, as some sort
    of cache in case you need to repeat the query.

do you think I will pay a big price for this way of searching?

Yeah, if the number of unique users at step 1 is high, my guess is it will
be horribly expensive/slow. You can try and see if it works for you, though.

But I keep thinking "there must be a better way". I just don't see it right
now :frowning:

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.