Blog
Maybe you want a quick access snapshot of your referral or organic traffic. Maybe you want a custom KPI dashboard to send to your clients. Whatever the reason, pulling custom reports from Google Analytics just got easier.
Using Google Apps scripts, Google spreadsheets and Google Analytics API you can easily create automated reports and turn those reports into visualizations using charts, graphs, and gauges. Below are the steps:
Open a New Google Spreadsheet
First, you will need to navigate to Google docs and open a new spreadsheet. In the top navigation select tools and then click scripts gallery. A popup will then appear displaying all of the scripts in the Google’s library.
Next, use the search function to search the term ‘magic’ and install the first option titled ‘Google Analytics Report Automation’. The script will then prompt you for authorization. Once you accept, the script will then be installed on the spreadsheet.
Add Your Analytics Account
After you exit out of the scripts gallery, refresh your spreadsheet. After 10 seconds or so a Google Analytics menu item should appear in the horizontal navigation.
If you are one of the people that have been skeptical about the relevance of Reddit, now is time to change your tune. Our 44th president, Barack Hussein Obama, has taken to the site to answer questions from people around the world on an IAMA.
Reddit is a user-generated and user voted on content site that now generates over 2 billion pageviews per month. The site thrives on engagement with the average user spending 16 minutes on the site per visit -— which is an incredible statistic from an internet marketing perspective.
The site is made up of ‘subreddits’ which are categories and communities that each have their own topics and rules that govern them. IAMA (stand for I am a…) is a category for people to share about themselves and to allow other Reddit users to ask questions directly to the OP, or original poster. Some other popular IAMA threads include comedians, people with rare medical conditions, professionals offering insight into certain careers, and people living in difficult circumstances. The platform offers a uniquely candid feel which one of the biggest reasons people keep coming back. Users posting the thread are generally encouraged to answer as many questions as possible to help build the community and content base.
President Obama answered generally ‘tame’ questions as compared to others that were submitted on the site, but is impressive nonetheless that he braved the intimidating contingent of Reddit regulars. Below are some of the highest rated answers from the Commander-in-Chief:
Social media websites are the new darlings of the marketing industry and tapping into their business potential is the key to unlocking the doors to increased clientele and, ultimately, greater revenue. Yet, many conventional and online companies have neglected to explore the possibilities sites like Facebook offer for growing one’s business. In fact, Facebook provides the very tools needed for a business to analyze their marketing efforts on a daily basis; Facebook’s Insights is simple to use and filled with the data a company needs to chart its marketing course.
Introduction to Insights
This aptly named Facebook tool provides businesses insight into their marketing practices. Insights shows reliable marketing data that reflects how people react to a business’s posts, information, website, applications, etc…For example, if your restaurant reveals its new menu via Facebook, Insights allows the page administrator (anyone authorized by your business to run the Facebook page), to see how many people see, comment, and like this shared information. Whatever stories your business posts, Insights will graph the impact it has with its readership. This allows a business direct feedback with the very people they do or want to do business with.
Guest blogging has evolved over the years but 2012 has really pushed those who take part in guest blogging into thinking outside the box and going the extra mile to achieve the best quality links. If you are looking for a little inspiration, these handy hints have been compiled with you in mind.
400 Words Doesn’t Cut it
Anyone who creates guest posts on a regular basis will be familiar with the 400 words rule, but it has always been a minimum rather than an example of the perfect guest post length. Posts that just about meet 400 words come across as rushed and many of the more reputable blogs now expect posts of between 600-1000 words so keep this in mind as your benchmark.