# Assign leads to different users

**URL:** <https://forum.mautic.org/t/assign-leads-to-different-users/5910>\
**Category:** General Discussion\
**Created:** [February 25, 2016, 12:09am UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910 "2016-02-25T00:09:58Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\
**Post date:** [February 25, 2016, 12:09am UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/1 "2016-02-25T00:09:58Z")

</div>

Greetings,  
  
  
  
How can I assign leads to different members? For instance, I have created a user role for “team”. Each user in the “team” role should only see leads assigned to them. How can I assign leads to specific users in this role?  
  
  
  
Secondly, is there a way to have new leads “round robin” assignment to the users? I would like use this to distribute leads to my sals team.

---

<div class="post-metadata">

**Author:** ![kfoley](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@kfoley](https://forum.mautic.org/u/kfoley)\
**Post date:** [September 14, 2016, 6:28pm UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/2 "2016-09-14T18:28:17Z")

</div>

The only real way to do this right now is by executing a SQL query directly in the database.

The table you’re looking for is ma\_leads.

The value you would change is owner\_id.

You can get the owner ID by going to the users page and looking at the right hand side. Be sure to backup your DB before you do this though.

You may be able to do it by exporting your current leads as a CSV using the reports section, then reimporting them with changed Owner ID values but I’m having some weird issues with reports myself so I went straight to the database using phpMyAdmin.

---

<div class="post-metadata">

**Author:** ![kfoley](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@kfoley](https://forum.mautic.org/u/kfoley)\
**Post date:** [September 14, 2016, 6:31pm UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/3 "2016-09-14T18:31:55Z")

</div>

I would love for this to be a feature in future releases though. This is critical for situations such as adding new staff members.

---

<div class="post-metadata">

**Author:** ![kfoley](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@kfoley](https://forum.mautic.org/u/kfoley)\
**Post date:** [September 20, 2016, 2:35pm UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/4 "2016-09-20T14:35:26Z")

</div>

Here is the exact query for those wondering.

UPDATE `ma_leads` SET `owner_id` = ‘9’ WHERE `state` LIKE ‘Texas’;

Change out the `state` LIKE ‘Texas’; to fit your own parameters.

---

<div class="post-metadata">

**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\
**Post date:** [February 25, 2016, 12:09am UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/5 "2016-02-25T00:09:58Z")

</div>

Greetings,

How can I assign leads to different members? For instance, I have created a user role for “team”. Each user in the “team” role should only see leads assigned to them. How can I assign leads to specific users in this role?

Secondly, is there a way to have new leads “round robin” assignment to the users? I would like use this to distribute leads to my sals team.

---

<div class="post-metadata">

**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\
**Post date:** [February 25, 2016, 12:15am UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/6 "2016-02-25T00:15:32Z")

</div>

I see that once you open a lead, and click edit, you can go to the very bottom and change the lead owner. Is there a quicker way to do this?

Is there a way to assign leads to a user by bulk?

Can I auto assign leads to a user based upon the form or lead source?

---

<div class="post-metadata">

**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\
**Post date:** [March 1, 2016, 4:37am UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/7 "2016-03-01T04:37:04Z")

</div>

Anyone else have advice on this?

---

<div class="post-metadata">

**Author:** ![gargmukesh05](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gargmukesh05/32/593_2.png) [@gargmukesh05](https://forum.mautic.org/u/gargmukesh05)\
**Post date:** [December 21, 2020, 11:17am UTC](https://forum.mautic.org/t/assign-leads-to-different-users/5910/8 "2020-12-21T11:17:16Z")

</div>

is it possbile to assign a mautic leads to multiple users of the same interest or city ?