Who can Perform this action?
Only users with DB access
Steps for connecting ad accounts to PubPlus:
Receive the following data:
(account id) = 'adi@crunchmind.com'
(sub_account_id) = exactly as the account name appears in the URL
For example:
βhttps://ads.taboola.com/campaigns?...%2522%252C%2522accountName%2522%253A%2522crunchmind-spellrockrsoc2-sc%2522%257D&pickerEntity=CAMPAIGN
Account name (name) in this format: '[CM] - CarterFive1 - SC'
Provider_id = 1
Status = 1
Network_id
Run the following query with the data above to insert the new account to 'provider_accounts' table on Minder [prod]
insert into provider_accounts (account_id, sub_account_id, name, provider_id, bid_discount, status, network_id, timezone, dsa_payor, dsa_beneficiary, red_track_campaign_id, default_page, order_line_id)
values ('adi@crunchmind.com', 'cm-spellrockrsoc2-sc', '[CM] - SpellRockRSOC2 - SC', 1, 0, 1, 280, null, null, null, null, null,null);
Steps for connecting ad account to domain:
After inserting the above data to 'provider_accounts', the row will automatically fill out the column 'id', copy this id (provider_account_id)
Create a new site for the domain on Sudo or use an existing site, copy it's id (site_id)
Run the following query with these 2 id's into 'site_provider_accounts' table on Minder [prod]
insert into site_provider_accounts (site_id, provider_account_id)
values (3306,1564839)
That's it, The account is connected and all set to start creating campaigns!