Keyword Tracking - MySQL issue matching with Clicks

Status
Not open for further replies.

madazaar

New member
Jan 1, 2008
3
0
0
Hopefully someone can shed some light on this 'cus I'm either too dense or something is wrong.

I'm running some PPC ads on Google for an affiliate offer and I put PHP scripting from SMAXOR's blog so that my keywords can be databased and an ID# is sent as my subID. So now when I look at my database I can cross reference the ID# with the keyword in my database to see which keyword got the sale.

Here's my question. When I look at my database and export the information into Excel I have over 10,000 entries which to me means I should have that many people clicking on my ads in Adwords. Where I'm confused is that I don't have even remotely near that many clicks in Adwords so I have NO idea why there's such a huge discrepany between my database and the clicks in Adwords.

The site/landing page is new so I'm not getting traffic to it from any other method other than Adwords. How could I have over 10,000 keywords listed in my database yet only have 100 or so clicks in Adwords?
 


weird... if a click comes through with a keyword that is already in your db maybe instead of just adding one to the existing keyword it is making an entire new row. It might have something to do with the way the script is recognizing duplicate keywords.
 
Hopefully someone can shed some light on this 'cus I'm either too dense or something is wrong.

I'm running some PPC ads on Google for an affiliate offer and I put PHP scripting from SMAXOR's blog so that my keywords can be databased and an ID# is sent as my subID. So now when I look at my database I can cross reference the ID# with the keyword in my database to see which keyword got the sale.

Here's my question. When I look at my database and export the information into Excel I have over 10,000 entries which to me means I should have that many people clicking on my ads in Adwords. Where I'm confused is that I don't have even remotely near that many clicks in Adwords so I have NO idea why there's such a huge discrepany between my database and the clicks in Adwords.

The site/landing page is new so I'm not getting traffic to it from any other method other than Adwords. How could I have over 10,000 keywords listed in my database yet only have 100 or so clicks in Adwords?

check your referers and run something like

select ip, count(ip) as count from clicks group by ip order by count desc

on mysql or just use excel's filtering sorting to find clicks by ip address... most of those clicks are google's adbot or other robots checking up on your landing pages by keyword.
 
weird... if a click comes through with a keyword that is already in your db maybe instead of just adding one to the existing keyword it is making an entire new row. It might have something to do with the way the script is recognizing duplicate keywords.

I have to agree, try making a unique index on that particular column if you forgot it and do a "INSERT IGNORE INTO etc" and then an update for the hits "UPDATE table SET hits=hits+1 WHERE kw='';".

Hope that gets you out of trouble.
 
Crawling bots are constantly hammering your site. Did your code consist of this conditional part?

if(isset($_GET['keyword']))
{
insert to mysql...
}

If not, add in a referral code and see where the clicks are coming from.
 
it is definitely just the adwords bot checking your site. It checks for every text ad and every keyword and it checks muliple times per day sometimes.
 
Status
Not open for further replies.