Can an admin make another user the owner of an email, campaign, or segment?

Product Support
1

Your software
My Mautic version is: 4.4
My PHP version is: PHP 7.4
My Database type and version is: MariaDB 10.3

Is there any way for an admin to to create an email, campaign, or segment and make another user the owner (the way they can with Contact records)? From a marketing management standpoint, this would be helpful. I’d love to be able to make campaigns, channels, and segments owned by individual sales reps so that they could log into mautic to see only emails and campaigns that pertain to them.

I’ve been using Mautic a long time, and I’m pretty sure it’s not currently possible, but I thought I’d ask in case anyone has found a clever way to do this?

Cheers,
Scott

2

Hey, I can confirm, it’s not possible at the moment. But great suggestion.
There is a ‘created by’ field in campaigns, emails, forms, which determines the access if you set up roles.
This proposed admin function needs to change it.
You can’t even edit this via api, cause the api user will be the creator.
J

1 Like
3

This is a real PITA. Here’s how to do it editing the MySQL.

  1. Find the id of the email you wish to change by opening it in the UI from Channels > Emails. You’ll see the id in the URL. E.g. https://examples.com/s/emails/view/584
    The id is 584
  2. Find the id of the user you wish to change by opening the user in the UI from Settings Cog > Users. You’ll see the id in the URL. E.g. https://example.com/s/users/edit/16
    The id is 16
  3. Open up your MySQL, and use the following: update emails set created_by=16 where id=584;

To summarize, use:

update emails set created_by=<USER_ID> where id=<EMAIL_ID>;

You may also want to update the created_by_name as well. Don’t ask me why that’s hard-coded in the database :man_facepalming:

1 Like