从谷歌网站管理员工具API下载数据

Question

有没有人能提供一个例子或链接，说明如何从谷歌网站管理员工具API导出TOP\u查询？

存储库中没有示例，似乎任何地方都没有可用的教程/示例

https://github.com/google/google-api-php-client

此代码连接到网站管理员工具。。如何从特定日期间隔下载TOP\u查询？

require_once 'googleapi/autoload.php';

try{
    $credentials = new Google_Auth_AssertionCredentials(
        '[e-mail]',
        [Google_Service_Webmasters::WEBMASTERS_READONLY],
        file_get_contents('9f21d103bb56.p12')
    );
    
    $client = new Google_Client();
    $client->setAssertionCredentials($credentials);
    if($client->getAuth()->isAccessTokenExpired()){
        $client->getAuth()->refreshTokenWithAssertion();
    }
    
    $service = new Google_Service_Webmasters($client);
    $t = $service->sites->get('https://example.com/');
    print_r($t);
}
catch(Google_Exception $e){
    echo $e->getMessage();
}
catch(Google_Service_Exception $e){
    echo $e->getMessage();
}

Answer 1

假设您的应用程序设置正确，下面是我所采取的方法的示例：

// Authenticate through OAuth 2.0
$credentials = new Google_Auth_AssertionCredentials(
    '[e-mail]',
    [Google_Service_Webmasters::WEBMASTERS_READONLY],
    file_get_contents( 'path-to-your-key.p12' )
);
$client = new Google_Client();
$client->setAssertionCredentials( $credentials );
if ( $client->getAuth()->isAccessTokenExpired() ) {
    $client->getAuth()->refreshTokenWithAssertion();
}
$service = new Google_Service_Webmasters($client);

// Setup our Search Analytics Query object
$search = new Google_Service_Webmasters_SearchAnalyticsQueryRequest;
$search->setStartDate( date( 'Y-m-d', strtotime( '1 month ago' ) ) );
$search->setEndDate( date( 'Y-m-d', strtotime( 'now' ) ) );
$search->setDimensions( array( 'query' ) );
$search->setRowLimit( 50 );

// Pass our Search Analytics Query object as the second param to our searchanalytics query() method
$results = $service->searchanalytics->query( $url, $search, $options )->getRows();

// Build a CSV
if ( ! empty( $results ) ) {
    // Setup our header row
    $csv = "Rank,Query,Clicks,Impressions,CTR,Position\r\n";
    foreach ( $results as $key => $result ) {
        // Columns
        $columns = array(
            $key + 1,
            $result->keys[0],
            $result->clicks,
            $result->impressions,
            round( $result->ctr * 100, 2 ) . '%',
            round( $result->position, 1 ),
        );
        $csv .= '"' . implode( '","', $columns ) . '"' . "\r\n";
    }
    file_put_contents( dirname( __FILE__ ) . '/data.csv' );
}

我刚刚在博客上发布了一篇完整的文章，其中有一个我开始编写的示例类，作为网站管理员工具应用编程接口和分析应用编程接口的包装器。请随意使用此作为参考：

http://robido.com/php/a-google-webmaster-tools-api-php-example-using-search-analytics-api-to-download-search-analytics-data-as-csv-with-the-new-oauth-2-0-method/

Answer 2

Error calling GET
https://www.googleapis.com/webmasters/v3/sites/https%3A%2F%2Fexample.com%2F: (404)
'https://example.com/'

在此帐户中不是已验证的网站管理员工具网站。

该网站并非以http://开头，而是以www.example.com或example.com开头。也没有后面的斜杠。

$t = $service->sites->get('example.com');

https://api.kdyby.org/class-Google_Service_Webmasters_SitesListResponse.html

请尝试以下代码片段：

<?php
$sites = $service->sites->listSites();
print_r(json_encode($sites->toSimpleObject());

或者

<?php
$sites = $service->sites->listSites();
foreach ($sites as $site) {
    print_r($site);
}

Answer 3

在这条线之后

    $service = new Google_Service_Webmasters($client);

加上这个

$searchanalytics = $webmastersService->searchanalytics;
$request = new \Google_Service_Webmasters_SearchAnalyticsQueryRequest();
$request->setStartDate('2016-03-01'); // startdate required 
$request->setEndDate('2016-03-31');  // Enddate required 
$dimensions[] = 'query';
$request->setDimensions($dimensions);

然后更换这条线

$results = $service->searchanalytics->query( $url, $search, $options )->getRows();

通过

$results = $searchanalytics->query('site_URL', $request);

它为我们工作……：）