Dear Kasim
i have put new code but it give me error
kindly check it my code again.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
// Google Analytic settings
SET gUserName='noel@cleartrip.com';
SET gPassword='advertising';
SET gProfileId='25040351';
// Date period
SET gDateStart='2010-01-01';
SET gDateEnd='2010-01-07';
// Dimensions & Metrics Reference
// See http://code.google.com/apis/analytics/docs/gdata/gdataReferenceDimensionsMetrics.html for details.
SET gDimensions='ga:date,ga:country';
SET gMetrics='ga:visits,ga:pageviews,ga:newVisits';
// Fetch data from Google Analytics into visits.csv
/*
-u Login name for your Google Account (required)
-p Password for your Google Account (required)
-f Your Google Analytics profile ID (the number used in your Google Analytics code snippet) (required)
-o File to write the output CSV (standard output by defaults
-d Dimensions to be displayed in your report (default: ga:date)
-m Metrics to be displayed in your report (default: ga:visits,ga:visitors,ga:pageviews)
-h Print a help screen
-n Do not print the header row
-s Fetch data starting at day (YYYY-MM-DD) (default: a week ago = 2009-09-23)
-e Fetch data up to day (YYYY-MM-DD) (default: today = 2009-09-30)
*/
//EXECUTE java -jar GoogleAnalyticsClient-20090930.jar -u $(gUserName) -p $(gPassword) -f $(gProfileId) -d $(gDimensions) -m $(gMetrics) -s $(gDateStart) -e $(gDateEnd) -o visits.csv;
EXECUTE java -jar GoogleAnalyticsClient-20100127.jar -u noel@cleartrip.com -p advertising -f 25040351\-d ga:date,ga:country -m ga:visits,ga:pageviews,ga:newVisits\ -s 2009-01-01 -e 2009-12-31 --start-index=2001 --max-results=2000;
// java -Dhttp.proxyHost=192.168.0.4 -Dhttp.proxyPort=8080 \ -Dhttps.proxyHost=192.168.0.4 -Dhttps.proxyPort=8443 \
//java -Dhttp.proxyHost=192.168.0.4 -Dhttp.proxyPort=8080 \ -Dhttps.proxyHost=192.168.0.4 -Dhttps.proxyPort=8443 \ -jar GoogleAnalyticsClient-20100115.jar -u foo@bar.com -p mypassword -f 123456 \ -d ga:date,ga:country -m ga:visits,ga:pageviews,ga:newVisits \ -s 2009-01-01 -e 2009-01-07 --filters=ga:country=Turkey.
// Load data from visits.csv
Directory;
LOAD ga:date,
ga:country,
ga:visits,
ga:pageviews,
ga:newVisits
FROM
visits.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Regards
Ashish Kumar
