Geez! That's a wildly vague post there Rick. You say there's a front-end where people create ad links that are clicked. Well what happens when the links are clicked? Is the data recorded? In a database? Log file? On one machine? Many?

Ideally your ad links contain some information that encapsulates the member and the ad campaign. When the link is clicked, you should be taken to some type of app that logs the member/campaign info and then redirects to the target. And that's just the tip of the iceberg - some ad tracking systems track ads delivered (displayed) *and* ads clicked.

You're back end system could easily be CRUD system that exposes the member slice of the underlying database or it may need to aggregate all the log info and then populate a database (of some type, not necessarily an RDBMS).

Either way, for PM you either need to tell us what code you have so far and where you're having *code* problems or you need to hire a consultant to build your solution.