Skip to main content

Connecting Google Ads ad-accounts

O
Written by Ofir Zodik
Updated over 3 months ago

Who can Perform this action?

  • Only users with DB access

Steps for connecting ad accounts to PubPlus:

  1. Receive the following data:

    1. Manager account id (account id)

    2. Ad-account id (sub_account_id)

    3. Account name (name)

    4. Provider_id = 91

    5. Status = 1

    6. Network_id

  2. Run the following query with the data above to insert the new account to 'provider_accounts' table on Minder [prod]

  3. insert into minder.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)
    values ('2807707756', '2763639497', 'UrbanAunty2', 91, 0, 1, 84, null, null, null, null, null);

Steps for connecting ad account to domain:

  1. After inserting the above data to 'provider_accounts', the row will automatically fill out the column 'id', copy this id (provider_account_id)

  2. Create a new site for the domain on Sudo or use an existing site, copy it's id (site_id)

  3. Run the following query with these 2 id's into 'site_provider_accounts' table on Minder [prod]

  4. insert into site_provider_accounts (site_id, provider_account_id)
    values (3409,1564781)

That's it, The account is connected and all set to start creating campaigns!

Did this answer your question?