Google Analytics (GA) is invaluable when you need to slice and dice web traffic data along numerous dimensions. For example, by date, time, location just to name few measuring visits, vistiors, pageviews, etc. For full list of possible combinations take a look at this documentation.
While many business users and SEO/SEM analyts use GA on regular basis to manage their Internet Marketing spend and improve site traffic for better ROI, they can chart a single measure for different segments and analyse one metric at a time. Many a time users download their data from adwords or get GA data through their in-house API setup. With almost all business users having used Excel as one of their main analytical tool, they prefer it over other tools (either in-house or 3rd party). Also, as quickly as things change in Internet Marketing (IM) world, some quick analysis business user can do on their own allows them to respond to quickly to market changes. You may find bullet 3 and 4 in this article from Avinash Kaushik relevant.
Data Engineering and Science, DW, BI & more - Posts by Shiva Maganahalli. Also, see http://www.hiregion.org
Showing posts with label Analytics. Show all posts
Showing posts with label Analytics. Show all posts
Google Analytics Data Retriever (API) - SEM, SEO
Google Analytics should be an integral part of any company's marketing data analysis strategy that plays in SEM, SEO field. Not too long ago Google released API for their Analytics and one can use this data or reports to compliment their in-house data analysis.
Here I have provided a small utility program that can be used to retrieve most popular six (6) reports and have used similar utilities that I have built to dump the data into MySQL data warehouse for much bigger data sets.
The application has two Perl modules (GAProfile.pm and GAReport.pm) and a main program (ga_report_retriever.pl). GAProfile.pm module is used to authenticate your account and get the auth_code that will be used in the subsequent calls to GA to get reports. GAReport.pm module is used to pull the report and dump important dimension and metrics to standard output. Put both these modules in the same directory (or copy them to directory in the path of PERL5LIB) as the main program and run it. To get different report, make a change in "ga_report_retriever.pl" passing the name of the report.
Before you start using the GA API, you may want to go through the documentation.
Here I have provided a small utility program that can be used to retrieve most popular six (6) reports and have used similar utilities that I have built to dump the data into MySQL data warehouse for much bigger data sets.
The application has two Perl modules (GAProfile.pm and GAReport.pm) and a main program (ga_report_retriever.pl). GAProfile.pm module is used to authenticate your account and get the auth_code that will be used in the subsequent calls to GA to get reports. GAReport.pm module is used to pull the report and dump important dimension and metrics to standard output. Put both these modules in the same directory (or copy them to directory in the path of PERL5LIB) as the main program and run it. To get different report, make a change in "ga_report_retriever.pl" passing the name of the report.
Before you start using the GA API, you may want to go through the documentation.
At command prompt> ./ga_report_retriever.pl
Subscribe to:
Posts (Atom)