SELECT
campaign.id,
campaign.name,
campaign.status,
campaign_budget.amount_micros,
metrics.clicks,
metrics.impressions,
metrics.cost_micros,
metrics.conversions,
metrics.cost_per_conversion,
segments.date
FROM
campaign
WHERE
segments.date BETWEEN '$start' AND '$end'
ORDER BY campaign.id
this is my
$start = Carbon::now()->startOfMonth();
$start = $start->format('Y-m-d');
$end = Carbon::now()->format('Y-m-d');
// dd($start,$end);
$campaignQuery = "SELECT
campaign.id,
campaign.start_date,
campaign.name,
campaign.status,
metrics.clicks,
metrics.impressions,
metrics.cost_micros,
me
$accessToken = $user->token;
$oauth2Token = (new OAuth2TokenBuilder())
->withAccessToken($user->token)
->build();
// Load the OAuth2 credentials from a file (google_ads_php.ini).
$credentialsLoader =
CredentialsLoader::fromFile(public_path('google_ads_php.ini'));
// Build the Google Ads client w
$parameters = ['access_type' => 'offline'];
$driver = Socialite::driver('google')->with($parameters);
$user = $driver->stateless()->user();
// dd($user);
$accessToken = $user->token;
$authorizationCode = $_GET['code'];
// $this->afterGoogleCallback($user,$authorizationCode,$accessToken);
$client
