Double Your CTR & Conversion Rate on the Content Network

If you advertise on the content network, running a Placement Performance Report is a way to view sites that get clicks, enabling you to do tricks that can double or triple your click through rates and conversions from the content network.

Here’s how you do it:

1. Click on Reports tab – select Placement Performance
2. Make the selections on the page as needed – use a long time frame if possible, the longer the better.
3. Be sure that the conversion boxes are checked in the Add & Remove Columns
4. Download the report as a .csv file for Excel
5. Open the report, and highlight row 4 (the column headers row) click Home >> Insert
6. A blank row appears above your column headers
7. Click anywhere in the sheet below Row 5
8. Click Home >> Sort & Filter >> Filter
9. Go to the column header that says “special category” and click the drop down arrow, deselect the box of special category
10. Go to the column header “CTR” and select Number Filters >> Greater than or Equals…
    
11. Enter 1% in the text box
12. Go to the column header “Domain”, select all the entries in that column
13. Click on Home >> Find & Select >> Go To Special…>> Visible Cells Only
14. Press Ctrl + C to copy all the entries
15. Open your Google AdWords Editor and select the campaigns you wish to add these sites to
16. Click on the Placements tab >> Make Multiple Changes >> Add Update Multiple Placements
17. Press Ctrl + V to paste all the domains into the field
18. Press Post Changes

Now, all these sites will be getting placement targeted traffic as well as showing for the content network, bringing you more relevant users and higher CTRs + conversions!! Sometimes, you may even double your content network performance with this very easy step.

This entry was posted on Thursday, November 20th, 2008 at 2:23 pm and is filed under Excel Tricks, content network. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.