我正在尝试从我们的 Google Analytics 实例中获取一些数据，并希望使用 Analytics Reporting API V4 Client Library for .NET（https://developers.google.com/api-client-library/dotnet/apis/analyticsreporting/v4）以便将这些数据整合进我们构建的管理网站。然而，我发现很难找到此代码的使用示例，文档似乎也非常稀少。我们只需要查看与我们控制的分析帐户相关联的数据，因此我想要使用服务帐户进行授权。
如果有人能够提供一些示例代码或指导我如何使用 .net api 获取一些基本的报告数据，那将不胜感激。
GoogleAnalyticsApiConsole。一旦项目创建完成，我们将使用 NuGet 包管理器控制台（在 Visual Studio 2015 的“工具”菜单下找到）添加对 Google Analytics Reporting API V4 Client Library for .NET 的引用。启动控制台并在 PM> 提示处发出以下命令：
PM> Install-Package Google.Apis.AnalyticsReporting.v4
安装该包将下载所需的客户端库来调用 Google Analytics 报告 Web 服务以及许多其他依赖项。登录Google Cloud平台控制台: https://console.cloud.google.com/。请确保使用具有访问要使用报告API查询的Google Analytics帐户的帐户登录。
单击Google Cloud平台菜单，然后选择API管理器。
Reporting，并从列表中选择Analytics Reporting API V4。在下一个屏幕上，单击启用。启用此API后，您应该能够在右侧面板的已启用API列表下看到它。
client_secret.json文件创建一个Google.Apis.Auth.OAuth2.UserCredential，以查询给定日期范围内视图中所有会话的Reporting API。该代码改编自此处的Java示例。client_secret.json文件的Build Action设置为Content，并将Copy to Output Directory设置为Copy if newer。还有两个需要正确设置的变量。首先，在GetCredential()方法中，将loginEmailAddress值设置为用于创建OAuth 2.0凭据的电子邮件地址。然后，在Main方法中，确保将reportRequest变量中的ViewId设置为您想要使用Reporting API查询的视图。要查找ViewId，请登录Google Analytics并选择管理选项卡。从那里，在右侧的视图下拉菜单中选择要查询的视图，然后选择视图设置。 View ID将显示在基本设置下方。Google Analytics API Console访问API数据。选择允许以继续。从那时起，该权限将存储在GoogleAnalyticsApiConsole FileDataStore中。如果删除该文件，则需要再次授予权限。该文件可以在%APPDATA%\GoogleAnalyicsApiConsole目录中找到。
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using Google.Apis.AnalyticsReporting.v4;
using Google.Apis.AnalyticsReporting.v4.Data;
using Google.Apis.Auth.OAuth2;
using Google.Apis.Services;
using Google.Apis.Util.Store;
namespace GoogleAnalyticsApiConsole
{
class Program
{
static void Main(string[] args)
{
try
{
var credential = GetCredential().Result;
using(var svc = new AnalyticsReportingService(
new BaseClientService.Initializer
{
HttpClientInitializer = credential,
ApplicationName = "Google Analytics API Console"
}))
{
var dateRange = new DateRange
{
StartDate = "2016-05-01",
EndDate = "2016-05-31"
};
var sessions = new Metric
{
Expression = "ga:sessions",
Alias = "Sessions"
};
var date = new Dimension { Name = "ga:date" };
var reportRequest = new ReportRequest
{
DateRanges = new List<DateRange> { dateRange },
Dimensions = new List<Dimension> { date },
Metrics = new List<Metric> { sessions },
ViewId = "<<your view id>>"
};
var getReportsRequest = new GetReportsRequest {
ReportRequests = new List<ReportRequest> { reportRequest } };
var batchRequest = svc.Reports.BatchGet(getReportsRequest);
var response = batchRequest.Execute();
foreach (var x in response.Reports.First().Data.Rows)
{
Console.WriteLine(string.Join(", ", x.Dimensions) +
" " + string.Join(", ", x.Metrics.First().Values));
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
static async Task<UserCredential> GetCredential()
{
using (var stream = new FileStream("client_secret.json",
FileMode.Open, FileAccess.Read))
{
const string loginEmailAddress = "<<your account email address>>";
return await GoogleWebAuthorizationBroker.AuthorizeAsync(
GoogleClientSecrets.Load(stream).Secrets,
new[] { AnalyticsReportingService.Scope.Analytics },
loginEmailAddress, CancellationToken.None,
new FileDataStore("GoogleAnalyticsApiConsole"));
}
}
}
}
AnalyticsReportingService 实现了 IDisposable 接口，应该用 using 块进行包装。 - TrueWillusing语句来围绕AnalyticsReportingService实例。 - rsbarro以下是更新至2019年9月的步骤。
首先，了解OAuth下有两个选择：用户凭据和服务帐户凭据。当您不知道将要连接哪个Google Analytics帐户时，使用用户凭据，因此用户授予应用程序权限。服务帐户凭据则是为您的公司构建自己的仪表板以显示Google Analytics数据等情况而使用。
大多数情况下，如果您需要对Analytics数据进行编程访问，则属于第二种情况。
以下步骤可以让您开始一个简单的C＃示例。请注意，Google Web控制台部分可能会略有不同，但应该很容易找到。
xxx@xxx.iam.gserviceaccount.com结尾）Google配置完成。现在跳转到Visual Studio。
using Google.Apis.AnalyticsReporting.v4.Data;
using System;
namespace ConsoleApplication {
class Program {
static void Main(string[] args) {
var credential = Google.Apis.Auth.OAuth2.GoogleCredential.FromFile("serviceAccount.json")
.CreateScoped(new[] { Google.Apis.AnalyticsReporting.v4.AnalyticsReportingService.Scope.AnalyticsReadonly });
using (var analytics = new Google.Apis.AnalyticsReporting.v4.AnalyticsReportingService(new Google.Apis.Services.BaseClientService.Initializer {
HttpClientInitializer = credential
})) {
var request = analytics.Reports.BatchGet(new GetReportsRequest {
ReportRequests = new[] {
new ReportRequest{
DateRanges = new[] { new DateRange{ StartDate = "2019-01-01", EndDate = "2019-01-31" }},
Dimensions = new[] { new Dimension{ Name = "ga:date" }},
Metrics = new[] { new Metric{ Expression = "ga:sessions", Alias = "Sessions"}},
ViewId = "99999999"
}
}
});
var response = request.Execute();
foreach (var row in response.Reports[0].Data.Rows) {
Console.Write(string.Join(",", row.Dimensions) + ": ");
foreach (var metric in row.Metrics) Console.WriteLine(string.Join(",", metric.Values));
}
}
Console.WriteLine("Done");
Console.ReadKey(true);
}
}
}
这里是你实际寻找的代码 -
protected void Page_Load(object sender, EventArgs e)
{
IRestRequest request = new RestRequest("", Method.POST, DataFormat.Json);
string url = "https://analyticsreporting.googleapis.com/v4/reports:batchGet";
RestClient restClient = new RestClient();
RestRequest Tokenrequest = new RestRequest();
Tokenrequest.AddQueryParameter("client_id", "<CLIENTID>");
Tokenrequest.AddQueryParameter("client_secret", "<CLIENTSECRET>");
Tokenrequest.AddQueryParameter("grant_type", "refresh_token");
Tokenrequest.AddQueryParameter("refresh_token", "<REFRESH_TOKEN>");
restClient.BaseUrl = new System.Uri("https://oauth2.googleapis.com/token");
restClient.Post(Tokenrequest);
var responseToken = restClient.Execute(Tokenrequest);
//Response.Write(responseToken);
dynamic Tokendata = JObject.Parse(responseToken.Content);
var newToken = Tokendata.access_token.Value;
request.AddHeader("authorization", string.Concat("Bearer "+newToken));
string jsonString = "{" +
"\"reportRequests\": [{" +
"\"dateRanges\" : [{\"" +
"startDate\" :'2021-07-01' ," +
"\"endDate\" : '2021-07-07'" +
"}]," +
"\"metrics\":["+
"{\"expression\":'ga:totalEvents'},"+
"{\"expression\": 'ga:pageviews'}"+
"]," +
"\"dimensions\": ["+
"{\"name\": 'ga:eventCategory'}" +
",{" +
"\"name\": 'ga:eventAction'"+
"},"+
//"{\"name\": 'ga:deviceCategory'}"+
"]," +
"\"dimensionFilterClauses\": [{"+
"\"filters\": [{"+
"\"dimensionName\": 'ga:eventCategory',"+
"\"operator\": 'EXACT',"+
"\"expressions\": ["+
"\"Login_Form"+
"\"]}]}],"+
"\"viewId\":'<VIEWID>'" +
"}]" +
"}";
IRestClient client = new RestClient(url);
request.AddHeader("Content-Type", "application/json; CHARSET=UTF-8");
request.Resource = "";
request.AddParameter("application/json", jsonString, ParameterType.RequestBody);
var response = client.Execute(request);
dynamic jdata = JObject.Parse(response.Content);
var Row_data = jdata.reports[0].data.rows;
Response.Write(Row_data);
}
阅读文档以通过刷新令牌获取访问令牌。
https://developers.google.com/identity/protocols/oauth2/web-server#offline