/// <summary>
/// Runs a Query against the Google Analytics provider - AnalyticsService
/// </summary>
/// <param name="dimensions">multiple dimensions separated by a comma: ga:dimensionName, ga:dimensionName</param>
/// <param name="metrics">multiple metrics separated by a comma: ga:metricName, ga:metricName</param>
/// <param name="numberToRetrieve">the max number of entries to return</param>
public void RunQuery(string dimensions, string metrics, int numberToRetrieve = default(int))
{
try
{
// GA Data Feed query uri.
DataQuery query = new DataQuery(_baseUrl);
query.Ids = GaProfileId;
query.Dimensions = dimensions; //"ga:date";
query.Metrics = metrics; //"ga:visitors, ga:newVisits, ga:bounces";
//query.Segment = "gaid::-11";
//query.Filters = "ga:medium==referral";
//query.Sort = "-ga:visits";
//query.NumberToRetrieve = 5;
if (numberToRetrieve != default(int))
{
query.NumberToRetrieve = numberToRetrieve;
}
query.GAStartDate = DateAsGAString(StartDate);
query.GAEndDate = DateAsGAString(EndDate);
Uri url = query.Uri;
// Send our request to the Analytics API and wait for the results to
// come back.
queryResults = AnalyticsService.Query(query);
}
catch (AuthenticationException ex)
{
throw new Exception("Authentication failed : " + ex.Message);
}
catch (Google.GData.Client.GDataRequestException ex)
{
throw new Exception("Authentication failed : " + ex.Message);
}
}
private const String TABLE_ID = "ga:37386554"; //"INSERT_TABLE_ID_HERE";
#endregion Fields
#region Constructors
public DataFeed_DirectTraffic(DateTime Start, DateTime Finish, string GALogin, string GAPassword, string ids)
{
string start = Start.ToString("yyyy-MM-dd");
AnalyticsService asv = new AnalyticsService("gaExportAPI_acctSample_v2.0");
asv.setUserCredentials(GALogin, GAPassword);
String baseUrl = "https://www.google.com/analytics/feeds/data";
DataQuery query = new DataQuery(baseUrl);
query.Ids = "ga:" + ids;
query.Dimensions = "ga:eventLabel";
// query.Metrics = "ga:timeOnSite, ga:newVisits";
query.Metrics = "ga:visits";
query.Segment = "gaid::-7";
query.GAStartDate = Start.ToString("yyyy-MM-dd");
query.NumberToRetrieve = 10000;
query.GAEndDate = Finish.ToString("yyyy-MM-dd");
feed = asv.Query(query);
}
/**
* Creates a new service object, attempts to authorize using the Client Login
* authorization mechanism and requests data from the Google Analytics API.
*/
public DataFeedExample()
{
// Configure GA API.
AnalyticsService asv = new AnalyticsService("gaExportAPI_acctSample_v2.0");
// Client Login Authorization.
asv.setUserCredentials(CLIENT_USERNAME, CLIENT_PASS);
// GA Data Feed query uri.
String baseUrl = "https://www.google.com/analytics/feeds/data";
DataQuery query = new DataQuery(baseUrl);
query.Ids = TABLE_ID;
query.Dimensions = "ga:source,ga:medium";
query.Metrics = "ga:visits,ga:bounces";
query.Segment = "gaid::-11";
query.Filters = "ga:medium==referral";
query.Sort = "-ga:visits";
query.NumberToRetrieve = 5;
query.GAStartDate = "2010-03-01";
query.GAEndDate = "2010-03-15";
Uri url = query.Uri;
Console.WriteLine("URL: " + url.ToString());
// Send our request to the Analytics API and wait for the results to
// come back.
feed = asv.Query(query);
}
private static List<KeywordResult> GoogleDataFeedToRemoveDuplicatesOrBadWords(DataFeed dataFeed)
{
// Rules to perform on transformation
// 1. Lowercase all keywords
// 2. Remove duplicates
// 3. Add the views of the duplicates to the existing keyword so as to keep its true position
// 4. Remove keywords that are on the blacklist e.g. urls
// 5. Order by page views in descending order i.e. most popular first
List<KeywordResult> keywords = new List<KeywordResult>();
foreach (DataEntry item in dataFeed.Entries)
{
int matchIndex = -1;
for (int i = 0; i < keywords.Count; i++)
{
if (keywords[i].Keyword == item.Dimensions[0].Value.ToLower())
{
matchIndex = i;
}
}
if (matchIndex > -1)
{
// Match keyword and get page views
int matchedKeywordPageViewCount = keywords[matchIndex].PageViews;
// Increment page views to include duplicate page views
matchedKeywordPageViewCount += Convert.ToInt32(item.Metrics[0].Value);
// Update page views for keyword
keywords[matchIndex].PageViews = matchedKeywordPageViewCount;
}
else
{
// Still need to apply rule 4
string checkedKeyword = RemoveBlacklistedKeywords(item.Dimensions[0].Value.ToLower());
if (checkedKeyword.Length > 0)
{
keywords.Add(new KeywordResult() { Keyword = checkedKeyword, PageViews = Convert.ToInt32(item.Metrics[0].Value) });
}
}
}
// Rule 5 reorder based on pageviews in descending order
return keywords.OrderByDescending(x => x.PageViews).ToList();
}
public void DataParseTest()
{
string xml = @"<?xml version='1.0' encoding='UTF-8'?>
<feed xmlns='http://www.w3.org/2005/Atom' xmlns:dxp='http://schemas.google.com/analytics/2009' xmlns:openSearch='http://a9.com/-/spec/opensearch/1.1/' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='W/"DUINSHcycSp7I2A9WxRWFEQ."' gd:kind='analytics#data'>
<id>http://www.google.com/analytics/feeds/data?ids=ga:1174&dimensions=ga:medium,ga:source&metrics=ga:bounces,ga:visits&filters=ga:medium%3D%3Dreferral&start-date=2008-10-01&end-date=2008-10-31</id>
<updated>2008-10-31T16:59:59.999-07:00</updated>
<title>Google Analytics Data for Profile 1174</title>
<link rel='self' type='application/atom+xml' href='http://www.google.com/analytics/feeds/data?max-results=5&sort=-ga%3Avisits&end-date=2008-10-31&start-date=2008-10-01&metrics=ga%3Avisits%2Cga%3Abounces&ids=ga%3A1174&dimensions=ga%3Asource%2Cga%3Amedium&filters=ga%3Amedium%3D%3Dreferral'/>
<link rel='next' type='application/atom+xml' href='http://www.google.com/analytics/feeds/data?start-index=6&max-results=5&sort=-ga%3Avisits&end-date=2008-10-31&start-date=2008-10-01&metrics=ga%3Avisits%2Cga%3Abounces&ids=ga%3A1174&dimensions=ga%3Asource%2Cga%3Amedium&filters=ga%3Amedium%3D%3Dreferral'/>
<author>
<name>Google Analytics</name>
</author>
<generator version='1.0'>Google Analytics</generator>
<openSearch:totalResults>6451</openSearch:totalResults>
<openSearch:startIndex>1</openSearch:startIndex>
<openSearch:itemsPerPage>5</openSearch:itemsPerPage>
<dxp:aggregates>
<dxp:metric confidenceInterval='0.0' name='ga:visits' type='integer' value='136540'/>
<dxp:metric confidenceInterval='0.0' name='ga:bounces' type='integer' value='101535'/>
</dxp:aggregates>
<dxp:dataSource>
<dxp:property name='ga:profileId' value='1174'/>
<dxp:property name='ga:webPropertyId' value='UA-30481-1'/>
<dxp:property name='ga:accountName' value='Google Store'/>
<dxp:tableId>ga:1174</dxp:tableId>
<dxp:tableName>www.googlestore.com</dxp:tableName>
</dxp:dataSource>
<dxp:endDate>2008-10-31</dxp:endDate>
<dxp:startDate>2008-10-01</dxp:startDate>
<dxp:segment id='gaid::-11' name='Mobile Traffic'>
<dxp:definition>ga:operatingSystem==iPhone</dxp:definition>
</dxp:segment>
<entry gd:etag='W/"C0UEQX47eSp7I2A9WxRWFEw."' gd:kind='analytics#datarow'>
<id>http://www.google.com/analytics/feeds/data?ids=ga:1174&ga:medium=referral&ga:source=blogger.com&filters=ga:medium%3D%3Dreferral&start-date=2008-10-01&end-date=2008-10-31</id>
<updated>2008-10-30T17:00:00.001-07:00</updated>
<title>ga:source=blogger.com | ga:medium=referral</title>
<link rel='alternate' type='text/html' href='http://www.google.com/analytics'/>
<dxp:dimension name='ga:source' value='blogger.com'/>
<dxp:dimension name='ga:medium' value='referral'/>
<dxp:metric confidenceInterval='0.0' name='ga:visits' type='integer' value='68140'/>
<dxp:metric confidenceInterval='0.0' name='ga:bounces' type='integer' value='61095'/>
</entry>
<entry gd:etag='W/"C0UEQX47eSp7I2A9WxRWFEw."' gd:kind='analytics#datarow'>
<id>http://www.google.com/analytics/feeds/data?ids=ga:1174&ga:medium=referral&ga:source=google.com&filters=ga:medium%3D%3Dreferral&start-date=2008-10-01&end-date=2008-10-31</id>
<updated>2008-10-30T17:00:00.001-07:00</updated>
<title>ga:source=google.com | ga:medium=referral</title>
<link rel='alternate' type='text/html' href='http://www.google.com/analytics'/>
<dxp:dimension name='ga:source' value='google.com'/>
<dxp:dimension name='ga:medium' value='referral'/>
<dxp:metric confidenceInterval='0.0' name='ga:visits' type='integer' value='29666'/>
<dxp:metric confidenceInterval='0.0' name='ga:bounces' type='integer' value='14979'/>
</entry>
</feed>
";
Google.GData.Analytics.DataFeed feed = Parse(xml);
Dataset f = new Dataset(feed);
f.AutoPaging = false;
Assert.IsNotNull(f.Aggregates);
Assert.IsNotNull(f.DataSource);
Assert.IsNotNull(f.Entries);
Assert.AreEqual(136540, f.Aggregates.Metrics[0].IntegerValue);
Assert.AreEqual("0.0", f.Aggregates.Metrics[0].ConfidenceInterval);
Assert.AreEqual("ga:visits", f.Aggregates.Metrics[0].Name);
Assert.AreEqual("integer", f.Aggregates.Metrics[0].Type);
Assert.AreEqual("ga:1174", f.DataSource.TableId);
Assert.AreEqual("www.googlestore.com", f.DataSource.TableName);
Assert.AreEqual("1174", f.DataSource.ProfileId);
Assert.AreEqual("UA-30481-1", f.DataSource.WebPropertyId);
Assert.AreEqual("Google Store", f.DataSource.AccountName);
Assert.AreEqual(136540, Int32.Parse(feed.Aggregates.Metrics[0].Value));
DataEntry blogger = feed.Entries[0] as DataEntry;
Assert.IsNotNull(blogger, "entry");
Assert.IsNotNull(blogger.Dimensions);
Assert.IsNotNull(blogger.Metrics);
Assert.AreEqual("ga:source", blogger.Dimensions[0].Name);
Assert.AreEqual("blogger.com", blogger.Dimensions[0].Value);
Assert.AreEqual("ga:visits", blogger.Metrics[0].Name);
Assert.AreEqual(68140, int.Parse(blogger.Metrics[0].Value));
DataEntry google = feed.Entries[1] as DataEntry;
Assert.IsNotNull(google, "entry");
Assert.IsNotNull(google.Dimensions);
Assert.IsNotNull(google.Metrics);
Assert.AreEqual("ga:source", google.Dimensions[0].Name);
Assert.AreEqual("google.com", google.Dimensions[0].Value);
Assert.AreEqual("ga:visits", google.Metrics[0].Name);
Assert.AreEqual(29666, int.Parse(google.Metrics[0].Value));
foreach (DataEntry entry in feed.Entries)
{
Assert.IsNotNull(entry, "entry");
Assert.IsNotNull(entry.Dimensions);
Assert.IsNotNull(entry.Metrics);
Assert.AreEqual("ga:source", entry.Dimensions[0].Name);
Assert.IsNotEmpty(entry.Dimensions[0].Value);
Assert.AreEqual("ga:visits", entry.Metrics[0].Name);
Assert.Greater(int.Parse(entry.Metrics[0].Value), 0);
}
foreach (Data d in f.Entries)
{
Assert.IsNotNull(d, "entry");
Assert.IsNotNull(d.Dimensions);
Assert.IsNotNull(d.Metrics);
Assert.AreEqual("ga:source", d.Dimensions[0].Name);
Assert.IsNotEmpty(d.Dimensions[0].Value);
Assert.AreEqual("ga:visits", d.Metrics[0].Name);
Assert.Greater(int.Parse(d.Metrics[0].Value), 0);
}
Assert.IsNotEmpty(feed.Segments);
Segment s = feed.Segments[0];
Assert.IsNotNull(s.Name);
Assert.AreEqual(s.Id, "gaid::-11");
Assert.IsNotNull(s.Id);
Assert.AreEqual(s.Name, "Mobile Traffic");
Assert.IsNotNull(s.Definition);
Assert.IsNotEmpty(s.Definition.Value);
Assert.AreEqual(s.Definition.Value, "ga:operatingSystem==iPhone");
}
public void DataParseTest()
{
string xml = "<?xml version='1.0' encoding='UTF-8'?>" +
"<feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearch/1.1/' xmlns:dxp='http://schemas.google.com/analytics/2009' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='W/"A05PSHcycSp9ImA2WxJSGYQ."'>" +
"<id>http://www.google.com/analytics/feeds/data?ids=ga:123456&dimensions=ga:browser&metrics=ga:pageviews&start-date=2009-04-28&end-date=2009-05-10</id>" +
"<updated>2009-05-10T01:01:01.999-07:00</updated><title>Google Analytics Data for Profile 123456</title>" +
"<link rel='self' type='application/atom+xml' href='http://www.google.com/analytics/feeds/data?max-results=200&sort=ga%3Abrowser%2Cga%3Apageviews&end-date=2009-05-10&start-date=2009-04-28&metrics=ga%3Apageviews&ids=ga%3A123456&dimensions=ga%3Abrowser'/>" +
"<author><name>Google Analytics</name></author>" +
"<generator version='1.0'>Google Analytics</generator>" +
"<openSearch:totalResults>10</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>200</openSearch:itemsPerPage>" +
"<dxp:startDate>2009-04-28</dxp:startDate>" +
"<dxp:endDate>2009-05-10</dxp:endDate>" +
"<dxp:aggregates>" +
"<dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='50599'/>" +
"</dxp:aggregates>" +
"<dxp:dataSource>" +
"<dxp:tableId>ga:123456</dxp:tableId>" +
"<dxp:tableName>www.test.com</dxp:tableName>" +
"<dxp:property name='ga:profileId' value='123456'/>" +
"<dxp:property name='ga:webPropertyId' value='UA-111111-1'/>" +
"<dxp:property name='ga:accountName' value='Test Account'/>" +
"</dxp:dataSource>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Camino&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Camino</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Camino'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='8'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Chrome&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Chrome</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Chrome'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='894'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Firefox&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Firefox</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Firefox'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='9969'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Internet%20Explorer&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Internet Explorer</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Internet Explorer'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='36261'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Konqueror&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Konqueror</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Konqueror'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='1'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Mozilla&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Mozilla</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Mozilla'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='21'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Mozilla%20Compatible%20Agent&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Mozilla Compatible Agent</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Mozilla Compatible Agent'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='11'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Netscape&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Netscape</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Netscape'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='4'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Opera&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Opera</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Opera'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='84'/></entry>" +
"<entry gd:etag='W/"CQFFQX53eSp7ImA8WxPSGUw."'><id>http://www.google.com/analytics/feeds/data?ids=ga:123456&ga:browser=Safari&start-date=2009-04-28&end-date=2009-05-10</id><updated>2009-05-09T17:00:00.001-07:00</updated><title>ga:browser=Safari</title><link rel='alternate' type='text/html' href='http://www.google.com/analytics'/><dxp:dimension name='ga:browser' value='Safari'/><dxp:metric confidenceInterval='0.0' name='ga:pageviews' type='integer' value='3346'/></entry>" +
"</feed>";
Google.GData.Analytics.DataFeed feed = Parse(xml);
Dataset f = new Dataset(feed);
f.AutoPaging = false;
Assert.IsNotNull(f.Aggregates);
Assert.IsNotNull(f.DataSource);
Assert.IsNotNull(f.Entries);
Assert.AreEqual(50599, f.Aggregates.Metrics[0].IntegerValue);
Assert.AreEqual("0.0", f.Aggregates.Metrics[0].ConfidenceInterval);
Assert.AreEqual("ga:pageviews", f.Aggregates.Metrics[0].Name);
Assert.AreEqual("integer", f.Aggregates.Metrics[0].Type);
Assert.AreEqual("ga:123456", f.DataSource.TableId);
Assert.AreEqual("www.test.com", f.DataSource.TableName);
Assert.AreEqual("123456", f.DataSource.ProfileId);
Assert.AreEqual("UA-111111-1", f.DataSource.WebPropertyId);
Assert.AreEqual("Test Account", f.DataSource.AccountName);
Assert.AreEqual(50599, Int32.Parse(feed.Aggregates.Metrics[0].Value));
DataEntry camino = feed.Entries[0] as DataEntry;
Assert.IsNotNull(camino, "entry");
Assert.IsNotNull(camino.Dimensions);
Assert.IsNotNull(camino.Metrics);
Assert.AreEqual("ga:browser", camino.Dimensions[0].Name);
Assert.AreEqual("Camino", camino.Dimensions[0].Value);
Assert.AreEqual("ga:pageviews", camino.Metrics[0].Name);
Assert.AreEqual(8, int.Parse(camino.Metrics[0].Value));
DataEntry chrome = feed.Entries[1] as DataEntry;
Assert.IsNotNull(chrome, "entry");
Assert.IsNotNull(chrome.Dimensions);
Assert.IsNotNull(chrome.Metrics);
Assert.AreEqual("ga:browser", chrome.Dimensions[0].Name);
Assert.AreEqual("Chrome", chrome.Dimensions[0].Value);
Assert.AreEqual("ga:pageviews", chrome.Metrics[0].Name);
Assert.AreEqual(894, int.Parse(chrome.Metrics[0].Value));
DataEntry fireFox = feed.Entries[2] as DataEntry;
Assert.IsNotNull(fireFox, "entry");
Assert.IsNotNull(fireFox.Dimensions);
Assert.IsNotNull(fireFox.Metrics);
Assert.AreEqual("ga:browser", fireFox.Dimensions[0].Name);
Assert.AreEqual("Firefox", fireFox.Dimensions[0].Value);
Assert.AreEqual("ga:pageviews", fireFox.Metrics[0].Name);
Assert.AreEqual(9969, int.Parse(fireFox.Metrics[0].Value));
DataEntry ie = feed.Entries[3] as DataEntry;
Assert.IsNotNull(ie, "entry");
Assert.IsNotNull(ie.Dimensions);
Assert.IsNotNull(ie.Metrics);
Assert.AreEqual("ga:browser", ie.Dimensions[0].Name);
Assert.AreEqual("Internet Explorer", ie.Dimensions[0].Value);
Assert.AreEqual("ga:pageviews", ie.Metrics[0].Name);
Assert.AreEqual(36261, int.Parse(ie.Metrics[0].Value));
foreach (DataEntry entry in feed.Entries)
{
Assert.IsNotNull(entry, "entry");
Assert.IsNotNull(entry.Dimensions);
Assert.IsNotNull(entry.Metrics);
Assert.AreEqual("ga:browser", entry.Dimensions[0].Name);
Assert.IsNotEmpty(entry.Dimensions[0].Value);
Assert.AreEqual("ga:pageviews", entry.Metrics[0].Name);
Assert.Greater(int.Parse(entry.Metrics[0].Value), 0);
}
foreach (Data d in f.Entries)
{
Assert.IsNotNull(d, "entry");
Assert.IsNotNull(d.Dimensions);
Assert.IsNotNull(d.Metrics);
Assert.AreEqual("ga:browser", d.Dimensions[0].Name);
Assert.IsNotEmpty(d.Dimensions[0].Value);
Assert.AreEqual("ga:pageviews", d.Metrics[0].Name);
Assert.Greater(int.Parse(d.Metrics[0].Value), 0);
}
}
public void DataFeedConstructorTest()
{
DataFeed target = new DataFeed(null, null);
Assert.IsNotNull(target, "better have an object");
Assert.IsNull(target.Service, "better have no service yet");
}
public void CreateDataFeedTest()
{
DataFeed target = new DataFeed(null, null);
DataEntry entry = target.CreateFeedEntry() as DataEntry;
Assert.IsNotNull(entry, "better have a DataEntry here");
}
private static Google.GData.Analytics.DataFeed Parse(string xml)
{
byte[] bytes = new UTF8Encoding().GetBytes(xml);
DataFeed feed = new DataFeed(new Uri(DataFeedUrl), null);
feed.Parse(new MemoryStream(bytes), AlternativeFormat.Atom);
return feed;
}
private const String TABLE_ID = "ga:37386554"; //"INSERT_TABLE_ID_HERE";
#endregion Fields
#region Constructors
public DataFeed_KeywordsCost(DateTime Start, DateTime Finish, string GALogin, string GAPassword, string ids)
{
string start = Start.ToString("yyyy-MM-dd");
AnalyticsService asv = new AnalyticsService("gaExportAPI_acctSample_v2.0");
asv.setUserCredentials(GALogin, GAPassword);
String baseUrl = "https://www.google.com/analytics/feeds/data";
DataQuery query = new DataQuery(baseUrl);
query.Ids = "ga:" + ids;
query.Dimensions = "ga:adGroup,ga:keyword";
query.Metrics = "ga:CPC";
query.GAStartDate = Start.ToString("yyyy-MM-dd");
query.NumberToRetrieve = 10000;
query.GAEndDate = Start.ToString("yyyy-MM-dd");
feed = asv.Query(query);
}