Who can Perform this action?
Only users with DB access
Ad-accounts connection statuses:
Connected with Creation - We collect the ad-account data and creating campaigns is possible on Pub+
status=1 on provider_accounts table && row exist on site_provider_accounts table
Connected with Collection - We collect the ad-account data and no option of creating campaigns is possible on Pub+
status=1 on provider_accounts table
Disconnected - We don't collect any data and no option of creating campaigns is possible on Pub+
status=2 on provider_accounts table
Steps for disconnecting ad accounts from creation:
PubPlus Settings:
In PubPlus settings go to 'Account' tab
Select the desired network in the dropdown menu
In the Ad Accounts table, search for the ad accounts you want to disconnect
For each account, remove all selected sites
Click Save to apply the changes
Or in the database:
Receive the wanted Ad-account ID from the user
Run this query to find the relevant row on the site_provider_accounts table
select *
from site_provider_accounts
where provider_account_id in (select id from provider_accounts where sub_account_id={sub_account_id});Go through the results and make sure that they match the user request
Delete the relevant rows from the table
Steps for disconnecting ad accounts completely:
Make sure the ad-account is disconnected from creation (use the steps above)
Go to the provider_accounts table and query the ad account ID
Change the status to 2
Moving ad accounts between networks:
First, make sure the ad-account is disconnected from the first network (use the steps above)
Delete the relevant rows from provider_accounts table (status 2 is not enough)
Connect the ad account as new to the second network