Sorry this site requires JavaScript to be enabled in your browser. See the following guide on How to enable JavaScript in Internet Explorer, Netscape, Firefox and Safari. Alternatively you may be blocking JavaScript with an advert-related or developer plugin. Please check your browser plugins.

Sphinn Home » PPC
Monthly PPC Performance Report Template [download & explanations]
PPC News Source: http://www.shimonsandler.com
Published: Nov 26, 2007 - 02:24 pm
Story Found By: chriswinfield 1538 Days ago
Category: PPC
Shimon Sandler gives out a download of his “basic” PPC Performance Report in Excel format which has many self-calculating formulas within the cells.
 Comments9 Comments  

Comments

Avatar
from chriswinfield 1538 Days ago #
Votes: 1

Direct link to the template here.

Avatar
from DaveDavis 1538 Days ago #
Votes: 0

VERY handy spreadsheet. Another gem from Simon.

Avatar
from Kalena 1538 Days ago #
Votes: 0

Nice! But if I was him, I would’ve put my URL or direct link into that logo and protected the cell. Great find Chris.

Avatar
from DaveDavis 1538 Days ago #
Votes: 0

Then what use would it be Kelena? You could hardly show a client the report with another company logo on it.

Avatar
from Kalena 1538 Days ago #
Votes: 0

It gives credit where credit’s due and helps Shimon promote his brand. Not everybody who will download the s/sheet will re-brand it as their own. Not everybody will use it for clients. And if this travels virally, persons who receive it from others might like to know who Shimon is.

Avatar
from Nicole 1538 Days ago #
Votes: 1

Kalena, if I do not want to give credit, I just remake the file if it was protected that way, people have done this for ages. It should have a page in it about who this is from, why it is there etc as an about page.But anyhow, while this is a nice spreadsheet template, you would never really work professionally with something handfilled like this but rather use pivot tables or even olap tools for this. This is an inspiration on how to set up your result pages.Additional point why it will get remade anyhow: It is a $ based which is not usuable over here for example. :)

Avatar
from shimsand 1537 Days ago #
Votes: 0

Nicole - You are dead wrong about this not being used professionally.  I know for certain that Search firms/Agencies like Universal McCann, Avenue A, and 360i use a similar spreadsheet.  I am willing to bet they have much more experience & more demanding clients than you.  And, to address your endorsement of pivot tables...that is old school for bid mgmt, and furthermore you need to populate the pivot table with data before you can manipulate it.  The spend & conversions do not magically appear in your pivot table. There are better, and more sophisticated tools like Omniture Search Center, Atlas, Search Ignite, etc that do much more than you can accomplish with pivot tables.

Avatar
from MikeMarshall 1537 Days ago #
Votes: 0

Great content Shimon.  Very useful for reference.

Avatar
from ZNicola 1523 Days ago #
Votes: 0

Thanks for the direct link at the top Chris.  kudos

Upcoming Conferences

Search Marketing ExpoSearch Engine Land produces SMX, the Search Marketing Expo conference series. SMX events deliver the most comprehensive educational and networking experiences - whether you're just starting in search marketing or you're a seasoned expert.


SMX Web Site » | SMX Difference » | SMX News »

Join us at an upcoming SMX event:

Latest News From Marketing Land
Upcoming Webcasts

Search Marketing Now Learn more about search marketing with our free online webcasts and webinars from our sister site, Search Marketing Now. Upcoming online events include:


Latest News From Search Engine Land