new search idea

[SirRawrsalot]

alright:

No questions about my idea, i dont want anyone to STEAL IT! lol j/k

this is how i plan to organize some search result for a company that's paying me ...money! lol



I have two tables: searches and outbound. An entry is made into "searches" whenever somebody does a search. It stores the keyword, whether the search was via user-input or via clicking a text-link (bKeyed) and has a timestamp (datetime). Each search also has an ID (nSearchID).

An entry to outbound is created when a user clicks a link away from the site. We use the last nSearchID that this user generated, a SID (varchar 50) and a datetime.

I need a tool that allows the admin to enter a start & end date / time (year, month, day hour, minute) which then shows # of keyword searches total; then broken down into # that were manually inputted (bKeyed=1) and # that were text link clicked (bKeyed=0). Then we want to see how many clicks of the text ads occurred for each of these types [aka CTR]. Show the top 20 keywords manually inputted vs the top 20 keywords not manually inputted [along with # of searches for each]. For each keyword, we want to know the conversions/CTR based on whether it was manually inputted vs not manually inputted. [This might look like:

7/7/08 - 7/7/08 total searches: 13,000

top 20 manually inputted: searches clicks CTR
britney spears 100 20 20%
.....


Remember a search can have 0 to many clicks (outbound).

Table structure is:

CREATE TABLE IF NOT EXISTS `outbound` (
`nID` int(10) unsigned NOT NULL auto_increment,
`nSearchID` int(10) unsigned NOT NULL,
`cSID` varchar(50) NOT NULL,
`tsDatetime` datetime NOT NULL,
PRIMARY KEY (`nID`),
KEY `nSearchID` (`nSearchID`),
KEY `cSID` (`cSID`),
KEY `tsDatetime` (`tsDatetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=312 ;

-- ------------------------------

--------------------------

--
-- Table structure for table `searches`
--

CREATE TABLE IF NOT EXISTS `searches` (
`nSearchID` int(10) unsigned NOT NULL auto_increment,
`cKeyword` varchar(255) NOT NULL,
`bKeyed` tinyint(1) unsigned NOT NULL,
`tsDatetime` datetime NOT NULL,
PRIMARY KEY (`nSearchID`),
KEY `cKeyword` (`cKeyword`),
KEY `bKeyed` (`bKeyed`),
KEY `tsDatetime` (`tsDatetime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4219 ;

[iJack]

Ummm....you do that...

[Techno Monster]

lmao iJack, It looks good to me, your smart. :P

[SirRawrsalot]

lmao thanks


the database is utube.com and there's absolutely nothing cool about this site except the fact that they can offer me $40/hour lol :D I'm pretty much set for a long time. I also believe I get a cut of profits... legal work still needs fine tuning, but so far so good.


Edit:

YAY IM DONE! All I did was divide total number of searches by number of clicks times number of searches append % - and thats how I generated click through ratio
to determine how many people clicked on the links onto other sites

And there were a hefty amount of searches being done at exactly the same time. I was pretty annoyed lol So my end pay was around 550 bucks, and they said that I'll be compensated for the rest. I was like... "umm....sure. whatever you say" because I thought I got paid what I got paid. They said "No, you get paid a minimum and if you are paid under that minimum you are paid extra for each dollar that you're under paid"

Basically (this logic makes some sense... ) :

My minimum was 1,000 I got paid 550.... so for every dollar I didn't get paid I got paid extra. A ratio of like 1:2.3 (every dollar I get 2.3 dollars or somewhere near there.). BUT!!! if you get paid over the 1,000 dollars your ratio makes you get paid less. (no less than 1,000 dollars). If you are supposed to get paid 2000 dollars your ratio is like 1:0.70 (every dollar you get seventy cents that isn't the actual rate but you catch my drift. I think it changes based on how much more you earned).... so I guess that eventually it is better to work faster and get paid less because I'll earn more in the end... I dont really understand it either, but my end final pay is around 1,240 bucks or something like that. I don't have any numbers pinned down. I have a letter about it somewhere.

[Neverender]

EDIT: sorry, please lock this. i accedentally jumped to this page and i wasn't paying attention to the dates. so i posted in it. sorry mod's. Bash me if you feel like it. im worse than a newbie in the boys puberty forum now..lol

[Mzor203]

It's okay, just make sure to check the dates every time you post in a topic.

:locked: