My company acts as a broker between websites and advertisers looking to advertise on those websites. A single order with an advertiser will contain multiple line items. So the main order will be to purchase 100,000 impressions, for example from all sites in my network. And line item 1 will be a 10,000 impression order from site 1. Line item 2 will be a 10,000 impression order from site 2, etc... We need to create an online portal that is accessible to the website owners whose ad space we sell so that they can see all the data related to line items relating to their websites. We need to be able to report them them in the database: 1) Pending line items for their ad space 2) Current line items for their ad space including impression quanity, selling price, and other sale details unique to that line item 3) Completed line items for their ad space, including impression quantity, selling price, and other sale details unique to that line item 4) Amount website owners are owed by my company for these items 5) Amount my company has paid for these items.
We'll eventually need to integrate this database with reporting data from the ad server we use to track impressions, Google DFP Small Business. We'd integrate using the Google DFP API. We will, of course, compensate additionally for any such integration.