google-apigoogle-api-php-clientadsensegoogle-api-clientadsense-api

Struggling to store token for AdSense API


I've successfully managed to connect to the AdSense API and run a report. However, it requires a log in each time I run it, so it won't run as a cron job.

I've found a few other questions related to this. Some advise a service account, while others point out that a service account does not work with AdSense. The proposed solution is to store a token on my server, but I've been struggling to get that to work. Here is my code so far (which works, but requires manual log in):

$scriptUri = "http://".$_SERVER["HTTP_HOST"].$_SERVER['PHP_SELF'];

$client = new Google_Client();
$client->addScope('https://www.googleapis.com/auth/adsense.readonly');
$client->setAccessType('offline');
$client->setApplicationName('My Application name');
$client->setClientId(' MY ID ');
$client->setClientSecret(' MY SECRET ');
$client->setRedirectUri($scriptUri);
$client->setDeveloperKey(' MY KEY '); // API key

$accountId = " MY ACCOUNT " ;
$adClientId = " MY CLIENT " ;


// $service implements the client interface, has to be set before auth call
$service = new Google_Service_AdSense($client);

if (isset($_GET['logout'])) { // logout: destroy token
    unset($_SESSION['token']);
    die('Logged out.');
}

if (isset($_GET['code'])) { // we received the positive auth callback, get the token and store it in session
    $client->authenticate($_GET['code']);
    $_SESSION['token'] = $client->getAccessToken();
}

if (isset($_SESSION['token'])) { // extract token from session and configure client
    $token = $_SESSION['token'];
    $client->setAccessToken($token);
}

if (!$client->getAccessToken()) { // auth call to google
    $authUrl = $client->createAuthUrl();
    header("Location: ".$authUrl);
    die;
}

$startDate = '2015-11-01';
$endDate = 'today';
$optParams = array(
  'metric' => array(
    'EARNINGS'),
  'dimension' => array('DATE'),
  'sort' => '+DATE',
  'filter' => array(
    'CUSTOM_CHANNEL_NAME==Mega Seating Plan'
  )
);
// Run report.
$report = $service->accounts_reports->generate($accountId, $startDate,
    $endDate, $optParams);
if (isset($report) && isset($report['rows'])) {


  // Get results.
  foreach($report['rows'] as $row) {

    $date = $row[0] ;
    $earnings[$date] = $row[1] ;  


  }
} else {
  print "No rows returned.\n";
}

Can anybody give me any pointers about how I can incorporate token storage into the above code, please?


Solution

  • Thank you to @jkns.co for the previous answer here which helped me to get it working.

    Here's my final code:

    $scriptUri = "I HAD TO PUT MY ABSOLUTE URL HERE, OTHERWISE THE CRON JOB WOULD LOOK IN THE WRONG PLACE" ;
    
    $client = new Google_Client();
    $client->addScope('https://www.googleapis.com/auth/adsense.readonly');
    $client->setAccessType('offline');
    $client->setApprovalPrompt ("force");  // This line had to be added to force the approval prompt and request a new token
    $client->setApplicationName('My Application name');
    $client->setClientId('BLAH');
    $client->setClientSecret('BLAH');
    $client->setRedirectUri($scriptUri);
    $client->setDeveloperKey('BLAH'); // API key
    
    $accountId = "BLAH" ;
    $adClientId = "BLAH" ;
    
    
    // $service implements the client interface, has to be set before auth call
    $service = new Google_Service_AdSense($client);
    
    if (isset($_GET['logout'])) { // logout: destroy token
        unset($_SESSION['token']);
        die('Logged out.');
    }
    
    if (isset($_GET['code'])) { // we received the positive auth callback, get the token and store it in session
        $client->authenticate($_GET['code']);
        $_SESSION['token'] = $client->getAccessToken();
    
        // If it successfully authenticates, I request the refresh token
        $refreshToken = $client->getRefreshToken();
    
        storeRefreshToken($refreshToken) ;  // This function stores the token in MySQL
    }
    
    else {      // Otherwise it loads the refresh token from MySQL
    
    
        $refreshToken = getRefreshToken() ;
    
    
    
        $client->refreshToken($refreshToken);
        $_SESSION['token'] = $client->getAccessToken();
    
    }
    
    if (isset($_SESSION['token'])) { // extract token from session and configure client
        $token = $_SESSION['token'];
        $client->setAccessToken($token);
    
    
    }
    
    if (!$client->getAccessToken()) { // auth call to google
        $authUrl = $client->createAuthUrl();
        header("Location: ".$authUrl);
        die;
    }