AdSense Tip – Attract New Advertisers to your Site

Google AdSense is an auction based advertising system so your advertising revenue (or CPMs) will automatically go up if more advertisers choose to target your website.

The system, in simple English, works like eBay. You (the website owner) are selling ad space and the buyers (in this case, advertisers) are competing against each other to grab that space. The bid amount will therefore increase as more buyers enter the auction process thus benefiting the seller (you).

Increase your Site’s Visibility on the Google Ad Network

Advertisers are using tools like DoubleClick Ad Planner to determine which websites on the Google Ad Network they should target and you therefore need to ensure that your website is both visible and discoverable in these tools.

For instance, here’s a public listing of my blog on Ad Planner. This report is like a marketing brochure that you are handing out to an unknown number of prospective clients daily through Google and therefore it always should have updated information.

Advertisers can see the type of ads that are accepted on the site, the traffic details (pulled from Google Analytics), the topics that are covered by the site (categories) and other information that will help them quickly decide whether or not they should include the site in their campaigns.

In this video, Vijay Vachani of the AdSense team will walk you through the steps that are required to add your website to Google Ad Planner.

Step 1. If you have not added your website to Google Webmaster Tools yet, do that first. Sign-in to Webmaster Tools using your Google Account and add the site URL.

Step 2. Once your site is verified, go to the Publisher Center of Google Ad Planner and include the site** to your Ad Planner profile. If you have just added your site to Webmaster Tools, it may not immediately show up in Ad Planner.

Step 3. Finally, click the “Edit Site Info” link to assign a good description and relevant categories to your site. Google will automatically present a rough estimate of your site’s traffic to advertisers but you can give them a more accurate picture by allowing Ad Planner to use data* from your Google Analytics account.

In addition to creating your own Ad Planner Profile, you may also want to implement these three simple yet effective suggestions by Lauren Weitzman to attract advertisers:

• Always allow text and image ads on your site.
• Create channels for placement targeting so advertisers can target specific slots on your site (see #16).
• Always put the main ad unit above the fold.

[*] When you share Google Analytics data with DoubleClick Ad Planner, the same data may also be displayed in Google Trends for Websites.

[**] You might want to use Chrome or Firefox when using Google Ad Planner because some of the features of the site don’t work in IE.

How To Extract SWF Flash From Excel or Word

 

Besides watching Flash videos (FLV files), you should have seen or played some Flash animation game as well (SWF files, a.k.a. Shockwave flash).
And most of the time, you received SWF Flash animation in Microsoft Office document. Very likely, the SWF animation file is embedded in Office Excel.
The reason of embedding SWF animation file in Office document is probably that majority of users is running on Windows / MS Office, and MS Office can serve as a container to run or play the SWF file.
(If you received an un-embedded SWF file, you might able to open and play the SWF animation in web browser that installed with Shockwave Flash add-on)
While the SWF flash appears as an embedded file in Office Excel or Word, you might want to extract or retrieve the embedded SWF flash for your blog.
However, there is no intrinsic or built-in function to extract / retrieve embedded SWF Flash animation from Microsoft Office document files. This is definitely true, that you won’t able to find this wanted feature in Office 2007 as well!
So, how could you do that in case you’re really wanted to do so? OK, here we go:
How to extract SWF Flash animation from Office Excel?
A simple VBA program (a.k.a Visual Basic for Applications) can extract the embedded SWF Flash animation file in less than a minute or so.
The VBA / guide has been tested in Office 2003 Professional, and it should be working perfectly in any Office versions / editions too (e.g. the latest Office 2007), provided the Office system has installed the VBA components.

1. Open a new Microsoft Excel document,
2. Click the Tools menu, Marco, Visual Basic Editor. You can also press the ALT+ F11 hotkey to bring up the VBA editor,
3. While in MS Visual Basic editor, click the View Code icon on the upper-left panel,
   
4. Copy the VBA program source code at below here and paste it onto the VBA source code editor,
5. Press F5 to execute the VBA source code,
6. An Open File dialog box prompts you to select the Office Excel document that embed the SWF Flash animation file,
7. A message box appears shortly after the Excel file is selected, with a message that says where the extracted SWF Flash animation file is saved in local hard disk!

The extracted SWF Flash animation file ended with SWF file extension, and it can be open/play in a web browser with Shockwave Flash addon (e.g. Flash9e.ocx in IE7).
The VBA source code used to extract or retrieve SWF Flash animation files that embedded in Microsoft Office Excel or Word:

Sub ExtractFlash()

Dim tmpFileName As String
Dim FileNumber As Integer
Dim myFileId As Long
Dim MyFileLen As Long
Dim myIndex As Long
Dim swfFileLen As Long
Dim i As Long
Dim swfArr() As Byte
Dim myArr() As Byte

tmpFileName = Application.GetOpenFilename("MS Office File (*.doc;*.xls), *.doc;*.xls", , "Open MS Office file")

If tmpFileName = "False" Then Exit Sub

myFileId = FreeFile

Open tmpFileName For Binary As #myFileId

MyFileLen = LOF(myFileId)

ReDim myArr(MyFileLen - 1)

Get myFileId, , myArr()

Close myFileId

Application.ScreenUpdating = False

i = 0

Do While i < MyFileLen

   If myArr(i) = &H46 Then

      If myArr(i + 1) = &H57 And myArr(i + 2) = &H53 Then

         swfFileLen = CLng(&H1000000) * myArr(i + 7) + CLng(&H10000) * myArr(i + 6) + CLng(&H100) * myArr(i + 5) + myArr(i + 4)

         ReDim swfArr(swfFileLen - 1)

         For myIndex = 0 To swfFileLen - 1
            swfArr(myIndex) = myArr(i + myIndex)
            Next myIndex
         Exit Do

      Else
            i = i + 3
      End If

   Else
        i = i + 1
   End If

Loop

myFileId = FreeFile

tmpFileName = Left(tmpFileName, Len(tmpFileName) - 4) & ".swf"

Open tmpFileName For Binary As #myFileId

Put #myFileId, , swfArr

Close myFileId

MsgBox "Save the extracted SWF Flash as [ " & tmpFileName & " ]"

End Sub

Fix this Annoying Security Warning in IE 8

“Do you want to view only the webpage content that was delivered securely?”

If you open a secure web page inside Internet Explorer 8 (one that begins with https  like the Gmail web site or even Amazon.com), you might see a security warning dialog that says -- “This webpage contains content that will not be delivered using a secure HTTPS connection, which could compromise the security of the entire webpage.”

This is annoying because IE won’t remember your choice and the warning message will appear every time you visit that page or web site. It basically means that the secure (https) web page that you are trying to open contains images and other elements that are hosted on a non-https location. They call it mixed content.

Disable “Mixed Content” Warnings in IE

If you would like to disable this security warning forever, go to Tools -> Internet Options and select the Security tab. Make sure the “Internet” zone is selected and then click the “Custom Level” button. Scroll-down the list of options and set the “Display mixed content” setting from “Prompt” to “Enable.”

This video screencast explains the whole problem and the fix in detail. The mixed content issue can only be fixed by the web developer, you are only suppressing the warning in the browser.

Why Planning is important?

One Night 4 college students were playing till late night and could not study for the test which was scheduled for the next day.In the morning they thought of a plan. They made themselves look as dirty with grease and dirt.
They then went up to the Dean and said that they had gone out to a wedding last night and on their return the tyre of their car burst and they had to push the car all the way back and that they were in no condition to appear for the test.
So the Dean said they could have the re-test after 3 days. They thanked him and said they would be ready by that time.
On the third day they appeared before the Dean. The Dean said that as this was a Special Condition Test, all four were required to sit in separate classrooms for the test.
They all agreed as they had prepared well in the last 3 days.

The Test consisted of 2 questions with a total of 100 Marks.
See Below for the question Paper
Q.1. Your Name........ ......... ......... (2 MARKS)

Q.2. Which tyre burst? (98 MARKS)
          a) Front Left           b) Front Right
          c) Back Left            d) Back Right

Make a Screen Protector for your Cell Phone

Though Apple has officially stopped selling screen protector films for the iPhone and the iPod Touch, you may still want to have them in order to protect the screen of your expensive mobile device from scratches, dirt or even your own fingerprints.

Screen protectors are easily available for all popular mobile devices and they are pretty cheap, so much so that you may end up paying more for shipping than for the product itself.

That said, if you can’t find a good cover film that will exactly fit the screen of your current cell phone, you can easily build one on your own for free using material that is already available in your home.

Scratch Proof your Cell Phone Screen

All you need is a ruler (to measure the screen size of your gadget), some clear packing tape (that will act as the cover), a bowl of water with some soap and an old credit card to firm apply that homemade screen protector to your cell phone screen.

The video is produced by Howcast.com and it shares another very useful tip -- avoid putting your cell phone in the same pocket that has your keys and /or loose coins.

Make a Screen Protector for your Cell Phone