David, I apologize for never getting back to you. I'm sitting here this
Thanksgiving day catching up on old email and I see there are a number of
these that I just dropped about that time; I wondered why, for a while, and
then remembered that's when I got my new job and moved to a new city, so I
was pretty busy then and I guess I forgot all about it. Understandable, I
suppose, but inconsiderate of you and I'm sorry.

If it's not too late, I'd like to take this up again. I didn't really
understand what was going on, but I want to, not only because I like puzzles
but also because I want to understand how web advertising works; I figure
after helping you with this I'll understand much better what market forces
are at work behind the scenes. But if you've already solved the problem,
I'll understand.

"David J" wrote:

Bob,

I did not see any response from my last post, do I need to repost this
issue, for further assistance, if you don't have time I understand.

David J

"Bob Bridges" wrote:

You were probably right to mention those other things, but I agree that once
you have a general idea of how to go about it, with a few examples, you can
expand it to them. So since I have chores to do this morning, I'll ignore
the additional values for now; if you have trouble with one of them later for
some reason, bring it up then.

--- "David J" wrote:
One other thing I felt might be of help, there are other fields that need to
be added, I thought once I had the basic formula down or how to build it I
could take it from there. But it probably helps if I named the fields for
you.

B2: Is the adlet ID from drop down.
C2: Is the number of adlets played.
D2: Is the number of times the web surfer keyed through (IE: K2P)to the
website.
E2: Is the K2P ratio between number of plays to the number K2Ps
F2: Is the number of times the surfer K2P to the site by "date"
G2: Is the number of times the surfer K2P to the site at by "time of day"
H2: Is the number of times the surfer K2P to the site by "Country"
I2: Is the number of times the surfer K2P to the site by "State"
J2: Is the number of times the surfer K2P to the site by "City"

This information is pulled from the analytics system in the back office of
the running campaign, and is input into this spreadsheet by hand but the info
is spread out over 12 different locations, the sheet I am trying to build is
bringing all of this information to one location, and Z sheet is an
accumulation of all that data so I have a quick view of what is working and
what is not.