Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: Banner Rotation, AdvertPro, and Links SQL

Quote Reply
Re: Banner Rotation, AdvertPro, and Links SQL In reply to
OK here's my thoughts on how it could better manage accounts from the advertisers POV:

We'd need to have an account balance, which can be added to the account screen/table and be maintained by the software and Admin. Possibly a method of recording payments made to top-up the account as well so we get an account statement of sorts if there are any disputes with clients?

Then we'd need a system of deducting the relative amounts from the account balance based on the ads that we display/that get clicked.

Essentially there are two ways to go about this, either we set a flat rate for each 'zone/area/region/group', or set the rates for each individual advertiser.

To do it for the zones/regions is the simplest - we'd just need to add a 'rate' setting to the region, i.e.; CPM = $?, CPC = $?. This would enable the adveriser to select the rate they wish to use for that specific region (if only one amount is set it can become the default). The advertiser can then set the "max clicks" or "max impressions" from the banner account, and each impression/click is deducted from their balance based on its set rate!

To do it for each individual advertiser (the not-so-simple method), we'd need a method of identifying which types of ads we are offering so we can set a rate specific to that advertiser;

Ad Type Name:
Ad Model: Image/Text
Ad Width (Image ad): ___
Ad Height (Image Ad): ___
Ad Max. Characters (Text ad): ___

E.g.;

Full Banner, Image, 468, 60,
Half Banner, Image, 234, 60,
Button 1, Image, 120, 90,
Button 2, Image, 120, 60,
Micro Button, Image, 88, 31,
Text Long, Text, , , 200
Text Medium, Text, , , 120
Text Short, Text, , , 60

Somewhere on the account screen we'd add a section for Rates where we can set the ad-type available to them and what rate we are charging for this specific advertiser, i.e.;

Account Name: inserted already
Ad Type: select list generated from 'ad-types' table
Cost Per Impression (CPM): $____ (only fill-out one charge rate!!)
Cost Per Click (CPC): $____

The 'rates' table will then hold the account name, the ad-type, and the rates for either CPM or CPC (we can't bill for both at the same time for the same ad!!).

In the 'regions' settings we can put which 'ad-type' will be used by that region, allowing us to identify what we look for when calculating the 'rate' to deduct from the account balance.

On the banner[/i] screen we can first 'ask' which ad-type they want to use and pre-select the groups/zones/regions based on those available for this ad-type. We can also use the 'account name' to pre-set the rates we are charging, and offer either a "max clicks" or "max impressions" input boxes.

Then when we call a banner:

get region for banner call
get ad-type (from the region settings)
get active banner for this region
get account name for banner

Now we can use the info to query the 'rates' table and deduct from the account:

account name, ad-type > looks in the rates table for current charge rate
choice > gets the respective rate that has an amount filled-in (either CPM or CPC)
if choice = CPM > add 1 to impression count and deduct 'rate' from account balance > if impressions = max impressions, set banner to 'off'
if choice = CPC > add 1 to impression count and, if clicked, deduct 'rate' from account balance > if total clicks = max clicks, set banner to 'off'
etc.

I'm sure there's a lot more to it than that, and my logic probably has a lot of flaws, but its a start and I'm sure others can find additional things that could be done with such a system and maybe find easier ways of managing all the account balancing, etc.

Anyway, I've got to get on with my site management so I'll leave this with you other 'big thinkers' and see what you make of it Smile


All the best
Shaun

Subject Author Views Date
Thread Banner Rotation, AdvertPro, and Links SQL pugdog 5475 Oct 26, 2000, 2:20 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
qango 5372 Oct 27, 2000, 5:08 AM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5365 Oct 27, 2000, 11:34 AM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5372 Oct 27, 2000, 6:55 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
Stealth 5359 Oct 27, 2000, 9:33 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5349 Oct 27, 2000, 10:07 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5351 Oct 27, 2000, 10:12 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
Stealth 5351 Oct 27, 2000, 10:22 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5360 Oct 27, 2000, 11:59 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
qango 5362 Oct 28, 2000, 6:59 AM
Post Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5275 Nov 1, 2000, 3:42 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5280 Nov 1, 2000, 4:29 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5278 Nov 1, 2000, 9:57 PM
Post Re: Banner Rotation, AdvertPro, and Links SQL
Michael_Bray 5261 Nov 1, 2000, 10:50 PM