How to create PDF and Excel reports in Google Analytics?

Google Analytics is the most used and most popular tool for web analytics. It allows users to create a variety of reports by analyzing different aspects of visitor behavior and website performance.  Reports can be exported in a couple of different formats, enabling users to further analyze trends and data or forward them to other relevant parties.

Once you create a report in Google Analytics, just click on Export, as show in the image, to start the report export process. The available formats for exporting reports are PDF, CSV and TSV. What is important to know is that PDF reports, along with CSV data, include visualizations like graphs and charts within them.

export google analytics How to create PDF and Excel reports in Google Analytics?

But if you want pure numbers just choose the CSV version which can be later imported into Excel, as we have shown in one of our previous articles.

Another option might be to convert the PDF to Excel, which can be done using our site.

A useful trick for Google Analytics is learning how to show more than 500 rows in the table. As you can see, 500 is the regular limit that is imposed.

google analytics How to create PDF and Excel reports in Google Analytics?

If you want more data to be shown, just take the URL string “explorer-table.rowCount” and replace the number 500 with any number you want. This allows you to show more rows and export more data from your account.

more than 500 How to create PDF and Excel reports in Google Analytics?

Another helpful Analytics tip is to set up your account for regularly receiving reports on via email. To do this, simply click on the Email tab in Google Analytics and from there you can set up how often you want to receive reports and in which format you want them sent to you.

email reports ga How to create PDF and Excel reports in Google Analytics?

This is a good option if you need to report to a supervisor or third party regularly and want to have the stats coming to you on automatically on a regular basis.

How to share files without ads and intrusive pop-ups?

Ads are a major source of income for the majority of websites and in most cases users, have nothing against being shown a few ads in exchange for free content or services. However, in some cases publishers try to mask these ads and make them look like relevant links cases in order to trick users into clicking these ads.  This is especially common with file sharing websites. For example, when a user wants to download a shared file, he or she is often presented with multiple download URLs on the page and doesn’t know which one is real. Clicking on such hidden ads also runs users the risk of downloading possible viruses or intrusive software.  Clicking on an ad which leads you to a different website is a one thing, but downloading and opening suspicious files or software onto your computer is a whole other level of annoyance and potential problems for your computer.

Even if you are completely sure about our ability to distinguish ads from content, or maybe you even use an ad blocking browser extension, it is not the case with all users. That is why users have to be careful when choosing what sites to use for share files with other people.

Cometdocs is a free service that enables users to convert and share files online without ads. The download page is clear and clutter-free, and there is only one download URL present on it, so you have no issue with having to guess which one you need to click.

convert files with cometdocs How to share files without ads and intrusive pop ups?

To share a file with Cometdocs, you should be logged in as a registered user. Unregistered users can share files using Cometdocs as well, but in that case, the sharing URL will be valid for only 24h. Registration is free and it gives users a lot of sharing options in terms of privacy and sharing methods.

After you have dragged your uploaded file to Store tab, select the file and click on Share.

Online Document Manager How to share files without ads and intrusive pop ups?

As you can see, there are multiple sharing options available – you can share files with other Cometdocs users, or to others outside of Cometdocs using a private URL or a public one.

The main point and advantage of sharing with Cometdocs is that the download page is completely safe and easy to navigate. There is only one download link, which guarantees that you will never click on ads or any other annoyances while trying to download a file from Cometdocs.

Introducing the New Cometdocs

Dear Users,

Our team is very happy to announce the release of our new online service. As you already know, Cometdocs has been one of the leading online file conversion services for the last several years, attracting millions of users.  After taking years of feedback from our loyal users to heart and working to turn these ideas into a reality, we believe that we have taken our service to brand new heights with this new format.

The new version of Cometdocs is an all-in-one document management service of the highest order.  Using the new Cometdocs, users can now convert, store, transfer and share their files online easily and free of charge.

cometdocsblog Introducing the New Cometdocs

When you upload a document to the new Cometdocs, you have an option of four different actions that you can perform with it, whether you are registered as a Cometdocs user or not.

New Features

1)      File Transfer

cometdocs transfer Introducing the New Cometdocs

Users can now transfer large files to other users. Unregistered users can send a daily total of 100MB worth of files per IP and their transfer URLs are valid for a period of 24 hours. Once unregistered users send files, however, they cannot remove them or make them unavailable for sharing.

Registered users can send 100MB daily as well, but their transfer URLs are valid for three days. Additionally, registered users who want their transfer URLs to be valid indefinitely can store their documents with Cometdocs before transferring them. In such a case, the URLs will be valid until the file is made private or deleted.  The registered user transferring his or her files has complete control over the privacy setting of the documents as well and unlike unregistered users, has the option to delete the files at any time.

2)      File Storage

Registered users now have the option to store files online using Cometdocs. Even though Cometdocs is a service specialized for document use, any file type other than .exe format files can be stored at Cometdocs as well. Registered users can store 1GB worth of files for free.

Registered users are also able to change file metadata, store multiple versions of the same document, share, convert, transfer the stored files and organize them into folders. This is one facet of the new Cometdocs that unregistered users cannot access.

3)      File Sharing

Both registered and unregistered users can share files via Cometdocs.

Unregistered users get a sharing link for their uploaded file which will be valid for a period of 24 hours. Registered users, however, can share their files indefinitely, since their files are part of their storage quota. Registered users have complete control over their sharing privacy options in this case as well.

There are also a great number of options when choosing with whom you want to share your files. It is possible to share files only with other Cometdocs users. You also have the option of sharing your files publicly on the web or only to specific people by providing them with a URL to download the file.

10 Great Free Alternatives to AutoCAD Introducing the New Cometdocs

Cometdocs also has a public directory of shared files that allows users to browse through public documents that have been uploaded and made public by various Cometdocs users.

4)      File Conversion

Continuing with our old tradition, Cometdocs still offers high quality document conversion with all vital aspects of the original document remaining preserved in the newly converted document. A full list of available conversions can be found here.

cometdocs conversion formats Introducing the New Cometdocs

As you have probably noticed, many Cometdocs features can be used both by those who are registered and unregistered users who do not have a Cometdocs account.

Cometdocs can be used anonymously without registering an account, but there are certain limits for these unregistered users. For example, unregistered users can convert only three documents weekly and all of their sharing links are available for only 24 hours at a time. Also, they do not have as many options when it comes to controlling the visibility and privacy of their documents. For example, if you upload a document to share as an unregistered user, you cannot change your mind and delete that file. A registered Cometdocs user has more control over these types of options.

Migration

If you already had an account with the old Cometdocs service, you can migrate all of your files to the new Cometdocs.  However, since there is 1GB of storage available, users who have more than that on their old Cometdocs accounts will have to delete some of their files in order to meet this limit.

Premium Services

The new Cometdocs will also offer premium services that provide users with numerous benefits. For example, a premium user can make an unlimited number of conversions and has the option of performing OCR conversions as well.  Data storage and link visibility limits are also increased.  Premium users can also send larger files to more people and their sharing URLs are valid for significantly longer amounts of time. Another bonus is that premium users have the ability to preview their PDF files within the new Cometdocs.

Our entire team at Cometdocs is very proud of the changes that we have made. We are incredibly excited about our new service and what we can now offer to our users old and new. We invite you to come and try out the new Cometdocs, and we hope that it will one day become your favorite and most trusted free online document management service.

10 Great Excel Templates for Planning your Household Budget

Planning your family’s budget can be quite a hassle when you take into consideration all of the financial aspects that go into running a household. From the cost of basic food and domestic necessities to loans, mortgages, retirement funds and even college tuitions, running the “family business” can be quite the handful.

10greatexceltemplatesfo 10 Great Excel Templates for Planning your Household Budget

Here are ten fantastic Microsoft Excel spreadsheet templates that can help make planning and executing a successful household budget a lot easier and less stressful.

1. Family monthly budget planner

This is a simple yet all-encompassing planning template which allows you to put your plan out and correlate your family budget needs all in one place. Take into consideration all expenses and earning in order to know ahead of time how much money you need for everything. This is also a great way to find out where you are spending the most money unnecessarily and where you can cut down on spending in order to save money.

2. Buy vs. rent home calculator

This is a very big decision that everyone has to make at one point in their lives. Everyone’s financial and family situation is different, so one option is not always better than the other. Take all of your financial information into consideration with the help of this template and decide whether renting or buying is the best option for your current financial situation.

3. Check register

Balancing a checkbook can be a real pain. If you are prone to making mistakes in your math, let this Excel spreadsheet help you out. Not only will the math always be accurate, but it will be much clearer and easier to follow than the handwritten calculation in your checkbook.

4. Loan calculator

If you are need deep in loans and are can’t keep up with them all on your own anymore, give this template a try. It will help you calculate your loans and debts with interest rates and loan periods so that you will be able to make the best possible plan for paying all of them off on time.

5. College costs calculator

It is never too early to start putting money aside for your children’s education. This template couldn’t be easier to use. All you have to do is fill in the cells like you were doing a survey and Excel will calculate and give you a fairly accurate estimate of how much you will need, which will allow you to start planning for college properly.

 6. 401(k) retirement account planner

A lot of people have a hard time keeping up with their retirement plans. This template will allow you to “put it all on paper” and give you the insight you need to plan your retirement savings better in order to reach all of your financial goals. This template will help you to estimate your accounts over time accurately.

7. Credit card use log

Keeping track of credit card debt and payments can be very time consuming, especially if you have more than one – which most people do. This template helps you to keep all of your credit cards in line without and pay off your debt without the unneeded hassles and headaches.

8. Personal monthly budget planning

This is a great template for personal budget use. It’s also a great think to use if you want to teach your children about financial responsibility and get them to keep track of the money they make or receive from their parents and the way they spend it. The template allows you to calculate your projected and actual income and then gives you a balance summary in the end once all expenses are noted.

9. Mortgage loan refinance calculator

If you are in the market for a mortgage refinancing, use this template to help you make the right decision. This spreadsheet will allow you to compare your current mortgage deal with the possible options you are looking at for refinancing so that you will make the best financial decision possible.

10. Retirement budget

If the house is paid off, the college funds are full, and everything else is going according to plan, you can use this template to plan your perfect retirement. Feed the spreadsheet your ideal age for retirement and then calculate expected expenses and retirement earnings in order to find out how much you are going to need to retire in style.

Best of all, Microsoft offers all of these financial spreadsheet templates for free and there are many more available that can help you with other aspects of your household budget that might not have been covered with these ten.

3 Tools for Removing Metadata from Microsoft Office Files

Not many people are aware of the fact that whenever they create a Microsoft Office file, whether it is an Excel, Word of even PowerPoint document, that document stores information that you might not necessarily want to have stored in the document. This is often information that you do not want to have disclosed when you send the document to someone else – it’s called metadata.

screenshot01c 3 Tools for Removing Metadata from Microsoft Office Files

Things such as your name, company name, the name of your computer, or revisions you have made to the document might all be included in this metadata. Thankfully, there are tools that you can use in order to remove this metadata from your Office documents before you send or share them.

Here are three of the best metadata removal tools available.

1. Document Metadata Cleaner

This tool will allow you to analyze all of your Office documents in order to discover and then delete all of the potentially harmful or even embarrassing metadata that you don’t want others to see. It is a free tool for business or personal use and is able to clean one or multiple documents at the same time.

2. BEC MetaReveal

BEC MetaReveal will scrub away any metadata that you don’t want included in your documents. You can either tell the software to get rid of all metadata in your Office document or to show you what metadata is included in the document, so that you can then selectively decide what metadata you want to keep or remove. It’s great because it is linked to Microsoft Outlook and prompts you to remove your metadata as you press the send button, making it impossible for you to forget to take a look at the metadata of an Office document before you email it to someone.

3. iScrub 7 EP1

Not only does this tool clean your documents and manage your metadata, but it also allows you to convert your documents into PDF after you have cleaned them. There is no metadata that is safe from iScrub – it will find everything from past document author information, to tracked changes, deleted text and any other metadata that you want to keep hidden from whoever you are sending the document to via email or any other method of sharing your Office files.