| This Filipina Lady and Penpal Forum is read only for guests and members. If you would like to be part of the New Filipina, Asian and Penpal Forum please click Filipina, Asian, Penpal Forum. If you would like to join one of our FREE Filipina Lady online dating sites, you can check them out by clicking FREE Filipina Lady Dating Sites. |
Tex
Click here for FREE Online Dating Membership
Digg It
Del.icio.us
Slashdot It! |
 Posted: Fri Nov 30, 2007 11:31 am Post subject: Adword Report and excel |
 |
|
|
Dan I didn't know if I should reply to my old comment or make a new one. I made a new one. I hope it is ok.
I understand about the placement report you showed me in adword. You said to import it in to a excel document after I complete the report.
I was able to do all above. When I import it none of the URLs are links, just text. Is there a way in excel to make them links so I can click on it to see what content sites are using my adword ad?
thanks |
|
| Back to top |
|
|
|
|
dan
Site Admin
Joined: 18 Jul 2007
Posts: 63
Digg It
Del.icio.us
Slashdot It! |
| Posted: Fri Nov 30, 2007 12:05 pm Post subject: |
|
|
|
Hey Bill or do you liked to be called Tex.
I just got the email notification of your post while on break at work so I will try to answer.
Bill, I have the worse memory in the world, so I can’t remember what all I told you. I may fill you in again on how I use and you can take from it what you want.
We will start by me providing you some excel macro code:
| Code: |
Sub URL_List()
For Each cell In Selection
If cell.Value <> "" Then
If Left(cell.Value, 7) = "http://" Then
URL = cell.Value
Else
URL = "http://" + cell.Value
End If
ActiveSheet.Hyperlinks.Add Anchor:=cell, _
Address:=URL, TextToDisplay:=cell.Value
End If
Next cell
End Sub |
The above macro should take the content of a cell and turn it into a hyperlink. It is not perfect but will work for 99% of your content. Once caution. If you do get an error, just skip the one cell, highlight the rest of the cells and run the macro again. It may take a few tries, but if you have hundreds or even thousands of urls it is better than doing it manually one at a time. You probably can complete your task in less than 5 minutes with the above macro.
Now, if I remember correctly. I probably told you to use adwords report function to export a placement report in excel format. The reason you want to do this, you can look at the urls where your ad is being placed. Once you know that, you can block those urls if you think it is wasting your budget dollar.
Do not overlook the keywords you are using. It may determine the type of site your ad shows up on.
I hope it helped
dan |
|
| Back to top |
|
|
tex or bill
Click here for FREE Online Dating Membership
Digg It
Del.icio.us
Slashdot It! |
| Posted: Fri Nov 30, 2007 12:28 pm Post subject: |
|
|
|
thanks for the quick reply dan. tex or bill it doesn't matter.
I'm glad i did the report but i have a question.
can i exclude my own site without no problem? I don't want my ads to show up on my own site -- is that possible?
I excluded some enemy sites already so I'm on my way.
thanks |
|
| Back to top |
|
|
dan
Site Admin
Joined: 18 Jul 2007
Posts: 63
Digg It
Del.icio.us
Slashdot It! |
| Posted: Fri Nov 30, 2007 6:39 pm Post subject: |
|
|
|
Tex, do exclude your own site. I have seen my ads show up on my site until I made a change.
Don't exclude a site just because they are your enemy. Only exclude if your ad is on an inappropriate site. Why do you care if your ad shows up on an enemy site? If you are getting clicks it should be even more satisfying that you are being paid from an enemy site. |
|
| Back to top |
|
|
|
|
Powered by phpBB © 2001, 2002 phpBB Group |
|
|
|
