One Amazing Report for the Client
There are many great SEO tools out there now. My personal favorite is Web CEO. Their custom branded reporting and local keyword tracking is superior to none other and I use it every day. Moz also offers some basic reporting options, and of course you can get pretty customized reports with the Google Analytics dashboards. However, even with all of these great tools, I will always have to use Excel. There will always be other sources of data that I am pulling in that these tools just don’t have. So here is my solution. It might not be perfect, but in the end the client ends up with one nice PDF with all of the data.
In my example, I will be combining my Excel document first and then my RavenTools report. So In Excel, go to Print and select “PDFCreator” as the printer, and click “Print.”
A PDFCreator prompt will appear and you will want to click on “Wait – Collect.”
Now leave the prompt open as it is waiting.
Go grab your RavenTools or Moz report which is probably already a PDF. Go to Print and make sure PDFCreator is selected and click “Print.”
Now the PDFCreator window will be blinking so bring that back up. Make sure both of your documents are highlighted, go to Document and click on “Combine.”
Now that the PDF is combined, make sure it is selected, go up to Document and click on “Print.”
The prompt will open up again and this time click on “Save.”
It will prompt you where to save the file.
You now have your combined reports all in one PDF! As always feel free to leave your comments below.
Get More Stuff Like This
Marketing, WordPress, Blogging Tips, SEO and Reviews, once a week.
Thank you for subscribing.
Something went wrong.