Skip to main content

Connecting Pinterest to PubPlus

O
Written by Ofir Zodik
Updated over a month ago

Who can Perform this action?

  • Only users with DB access

Steps for connecting ad accounts to PubPlus:

  1. Receive the following data:

    1. Network name (account id) - All in capital letters no spaces

    2. Ad-account id (sub_account_id)

    3. Account name (name)

    4. Provider_id = 102

    5. Status = 1

    6. Network_id

    7. Board id (default_page)

      1. To extract board id paste this in your terminal and fill in the relevant account name:

        curl --location 'https://www.pinterest.com/resource/BoardResource/get/?source_url=%2Ftips0412%2Fpeekably%2F&data=%7B%22options%22%3A%7B%22username%22%3A%22tips0412%22%2C%22slug%22%3A%22peekably%22%2C%22field_set_key%22%3A%22detailed%22%2C%22orbac_subject_id%22%3A%22%22%7D%2C%22context%22%3A%7B%7D%7D&_=1744192837607' \ --header 'x-pinterest-pws-handler: www/[username]/[slug].js' \ --header 'Cookie: _auth=0; _pinterest_sess=TWc9PSZMeWNRTGt2K0tvRVhEdzZEY3hwR2JMck5oaS9ZQndJU3MzZ3dDR0RaMmdhNDE5OFJwWDhqSXkyajM3VVVkVUJ1bkhQSE0zQ3lna2U4M0dwazdxdmZya0Nmc09BMDdpTTRlQjJEODBrNXp3OD0mT3pBR1VVNDlLaEY0S2JCTEFjWmZqSFNxbHRRPQ==; _routing_id="54dc7cfb-de51-4a91-9328-8d94a941bee8"; csrftoken=812dbb52448fb17456ad1a6df37cfc76'
    8. Order line 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 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 ('CRUNCHMEDIA', '549768698793', 'TheFactualist', 102, 0, 1, 52, null, null, null, null, 991636480391895515,2817498680145);

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)

Steps for connecting Pinterest token to PubPlus:

  1. On Sudo - Networks, click on the pop up of the network:

    1. Insert the 'Pinterest App Id' - used to be different for each network, now all with: '1480339'

    2. Insert the 'Redirect Domain' with: 'https://app.pubplus.com'

  2. On PubPlus settings: click on 'Connect Pinterest' button and give access PubPlus access to the Pinterest account

  3. Create a new secret on 'Secrets Manager' to the network

That's it, The account is connected and all set to start creating campaigns!
Keep in mind a new account might start spending only after 48 hours.

Did this answer your question?