Insideall / dfp-prebid-lineitems

A PHP script to setup and update your Prebid Line Items in DFP
19 stars 11 forks source link
automation dfp doubleclick-for-publishers headerbidding json php prebid prebidjs

DFP Prebid LineItems Setup Tool

Automatically setup and update your Line Items on DFP for Prebid.js

DFP Setup Tool for Prebid

An automated DFP line item generator for Prebid.js

Overview

When setting up Prebid, your ad ops team often has to create hundreds of line items in DFP.

This tool automates setup for new header bidding partners. You define the advertiser, placements, and Prebid settings; then, it creates an order with one line item per price level, attaches creatives, and sets placement and Prebid key-value targeting.

While this tool covers typical use cases, it might not fit your needs. Check out the limitations before you dive in.

Getting Started

Creating Google Credentials

You will need credentials to access your Google Ad Manager account programmatically. This summarizes steps from Google Ad Manager docs and the DFP PHP library auth guide.

  1. If you haven't yet, sign up for a Google Ad Manager account.
  2. Create Google developer credentials
    • Go to the Google Developers Console Credentials page.
    • On the Credentials page, select Create credentials, then select Service account key.
    • Select New service account, and select JSON key type. You can leave the role blank.
    • Click Create to download a file containing a .json private key.
  3. Enable API access to Google Ad Manager
    • Sign into your Google Ad Manager account. You must have admin rights.
    • In the Admin section, select Global settings
    • Ensure that API access is enabled.
    • Click the Add a service account user button.
      • Use the service account email for the Google developer credentials you created above.
      • Set the role to "Trafficker".
      • Click Save.

Setting Up

  1. Clone this repository.
  2. Include the library via Composer: $ composer require googleads/googleads-php-lib
  3. Rename key
    • Rename the Google credentials key you previously downloaded ([something].json) to googleServiceAccount.json and move it to the project root folder
  4. Make a copy of adsapi_php.ini and save it into the project root folder.
  5. In adsapi_php.ini, set the required fields:
    • application_name is the name of the application you used to get your Google developer credentials
    • network_code is your Google Ad Manager network number; e.g., for https://www.google.com/dfp/12398712#delivery, the network code is 12398712.
    • jsonKeyFilePathis the path to your JSON key file
    • scopes is "https://www.googleapis.com/auth/dfp"
    • impersonatedEmail is the email account of the user you want to impersonate as, if any (something like user@app.iam.gserviceaccount.com)

Verifying Setup

Let's try it out! From the top level directory, run

php script/tests/ConnexionTest.php

and you should whether the connexion is OK or not

Creating Line Items

Modify the settings in /script/hb/HeaderBiddingCreation.php

Then, from the root of the repository, run:

php script/hb/HeaderBiddingCreation.php

You should be all set! Review your order, line items, and creatives to make sure they are correct. Then, approve the order in DFP.

Note: DFP might show a "Needs creatives" warning on the order for ~15 minutes after order creation. Typically, the warning is incorrect and will disappear on its own.

Limitations