Tony-Marketing-API.cn is a vibrant community dedicated to Facebook, Meta,Google Ads api, app development, Instagram, and related technologies. It offers valuable bug solutions, troubleshooting cases, and problem-solving strategies shared by users. Stay updated with real-world solutions, development tips, and the latest trends in digital marketing and app development.
We're using a personal gmail account to manage our Google Ads and therefore create the Oauth access to send LSA data. Is there anyway to provide access to a vendor using the personal gmail as an alternative to the service account method?
Since it's a personal gmail my understanding is a service account won't work...
Tried creating a service account, trying to avoid having to create a g suite just for this
I'm facing an issue with Google Ads event tracking. All requests to googleadservices.com (for every event) are returning a 400 Bad Request status.
However, I've noticed that if I change the URL parameter to something other than my domain, the request responds with a 200 status, which seems correct.
Google support mentioned that the error might be due to a "blocked_by_orb" issue, but I can't see anything on my end that would be causing this. I've already tried the following:
Disabled all firewalls Checked robots.txt for any blocking rules Unfortunately, none of this has resolved the problem. Has anyone encountered something similar or have any suggestions on how to troubleshoot further?
Any help would be much appreciated!
For example, if a web page has three ad slots, will there be a big speed difference between the two methods?
Import adsbygoogle.js only once in the tag:
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-xxxxxxxxxxx" crossorigin="anonymous"></script> After that, each ad unit in the page will no longer import the adsbygoogle.js file,only introduce:
<ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-xxxxxxxxxxx" data-ad-slot="xxxxxxxxxx" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> Each ad unit introduces the adsbygoogle.js file:
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-xxxxxxxxxxx" crossorigin="anonymous"></script> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-xxxxxxxxxxx" data-ad-slot="xxxxxxxxxx" data-ad-format="auto" data-full-width-responsive=" true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> I used PageSpeed Insights to analyze the performance of both, and it seems that there is not much difference。
You are welcome to suggest ways to test the performance of the two methods.
I have loaded google ads data to Big query using data transfer. I am trying to get keyword and search keyword metrics for my analysis
I used below code from p_ads_KeywordBasicStats table
WITH stats AS ( SELECT campaign_id AS CampaignId, ad_group_id AS AdGroupId, ad_group_criterion_criterion_id AS CriterionID, segments_ad_network_type AS AdNetworkType1, metrics_clicks AS Clicks, metrics_cost_micros AS Cost, segments_date AS Date, metrics_impressions AS Impressions FROM `micro-reserve.google_ad.p_ads_KeywordBasicStats_xxxxxx ), keywords AS ( SELECT ad_group_criterion_criterion_id AS CriterionId, MAX(ad_group_criterion_keyword_text) AS Criteria, ad_group_criterion_negative, ad_group_criterion_status FROM `micro-reserve.google_ad.p_ads_Keyword_xxxxxxx GROUP BY ad_group_criterion_criterion_id, ad_group_criterion_negative, ad_group_criterion_status ), campaigns AS ( SELECT campaign_id, MAX(campaign_name) AS campaign_name FROM `micro-reserve.google_ad.p_ads_Campaign_xxxxx GROUP BY campaign_id ) SELECT Clicks, Cost, Date, Impressions, Criteria AS Keywords, campaign_name, ROUND(SAFE_DIVIDE(Clicks, Impressions) * 100, 2) AS CTR FROM stats LEFT JOIN keywords ON stats.CriterionID = keywords.CriterionId LEFT JOIN campaigns ON stats.CampaignId = campaigns.campaign_id WHERE keywords.ad_group_criterion_negative IS FALSE AND keywords.ad_group_criterion_status = 'ENABLED' AND Date BETWEEN '2024-09-01' AND '2024-09-13' ========== Using below query for p_ads_SearchQueryStats table
WITH stats AS ( SELECT campaign_id AS CampaignId, ad_group_id AS AdGroupId, ad_group_ad_ad_id AS CriterionID, segments_ad_network_type AS AdNetworkType1, SUM(metrics_clicks) AS Clicks, SUM(metrics_cost_micros) AS Cost, segments_date AS Date, SUM(metrics_impressions) AS Impressions, MAX(search_term_view_search_term) AS Criteria, search_term_view_status FROM `micro-reserve.google_ad.p_ads_SearchQueryStats_xxxxxx WHERE _PARTITIONTIME = TIMESTAMP('2024-09-13') GROUP BY ad_group_ad_ad_id, search_term_view_status, ad_group_id, campaign_id, segments_ad_network_type, segments_date ), campaigns AS ( SELECT campaign_id, MAX(campaign_name) AS campaign_name FROM `micro-reserve=.google_ad.p_ads_Campaign_xxxxxxxx WHERE _PARTITIONTIME = TIMESTAMP('2024-09-13') GROUP BY campaign_id ) SELECT campaigns.campaign_name, stats.Date, stats.Clicks, stats.Impressions, stats.Cost, stats.Criteria AS Search_Keywords FROM stats LEFT JOIN campaigns ON stats.CampaignId = campaigns.campaign_id WHERE stats.Date = '2024-09-13' The above query works, but the numbers are not matching with Google Ads. Is something I am doing wrong? Can anyone advise please?
I'm using the following Google Apps Script to pull in data using the Google Ads API. The data appears to be pulling in fine, but parsing it seems to be an issue. Here is the script:
function getGoogleAdsData() { const fileId = 'fileID'; const campaignSheetName = 'Campaigns'; const campaignMetrics = ['segments.date', 'campaign.id', 'metrics.cost_micros']; // Calculate the dates for the previous week (Monday to Sunday) const today = new Date(); const dayOfWeek = today.getDay(); // 0 (Sunday) to 6 (Saturday) // Adjust today to get the last Sunday const lastSunday = new Date(today); lastSunday.setDate(today.getDate() - dayOfWeek - 0); // Calculate the previous Monday (6 days before last Sunday) const lastMonday = new Date(lastSunday); lastMonday.setDate(lastSunday.getDate() - 6); const formattedStartDate = Utilities.formatDate(lastMonday, Session.getScriptTimeZone(), 'yyyy-MM-dd'); const formattedEndDate = Utilities.formatDate(lastSunday, Session.getScriptTimeZone(), 'yyyy-MM-dd'); Logger.log(`Fetching data from ${formattedStartDate} to ${formattedEndDate}`); // Fetch Campaign Data const campaignData = fetchGoogleAdsData(formattedStartDate, formattedEndDate, campaignMetrics); const formattedCampaignData = campaignData.map(row => [ formatDate(row[0]), // Date row[1], // Campaign ID row[2] // Cost in currency units ]); // Write to Sheets if there's data if (formattedCampaignData.length > 0) { writeToSheet(fileId, campaignSheetName, formattedCampaignData, ['Date', 'Campaign ID', 'Cost']); } else { Logger.log('No data available to write to the sheet.'); } } function fetchGoogleAdsData(startDate, endDate, metrics) { const query = ` SELECT ${metrics.join(', ')} FROM campaign WHERE segments.date BETWEEN '${startDate}' AND '${endDate}' `; const apiUrl = 'https://googleads.googleapis.com/v17/customers/xxxxxxxx/googleAds:searchStream'; const options = { method: 'POST', headers: { 'Authorization': `Bearer ${ScriptApp.getOAuthToken()}`, 'developer-token': 'OUR-TOKEN', 'login-customer-id': 'xxxxxxxxxx' }, contentType: 'application/json', payload: JSON.stringify({ query: query }), muteHttpExceptions: true }; const response = UrlFetchApp.fetch(apiUrl, options); const responseData = JSON.parse(response.getContentText()); Logger.log(`Full API Response: ${JSON.stringify(responseData)}`); if (responseData.length > 0 && responseData[0].results) { Logger.log(`Found ${responseData[0].results.length} result(s).`); return responseData[0].results.map(result => { Logger.log(`Metrics object: ${JSON.stringify(result.metrics)}`); const row = []; metrics.forEach(metric => { let value = getNestedValue(result, metric.split('.')); Logger.log(`Metric: ${metric}, Value: ${value}`); // Log each metric's value if (metric === 'metrics.cost_micros') { value = value / 10; // Convert micros to currency units Logger.log(`Converted cost_micros: ${value}`); } row.push(value); }); return row; }); } else { Logger.log('No results found in response or response structure is different.'); return []; } } function getNestedValue(obj, keys) { return keys.reduce((acc, key) => (acc && acc[key] !== undefined) ? acc[key] : null, obj); } function writeToSheet(fileId, sheetName, data, headers) { const sheet = SpreadsheetApp.openById(fileId).getSheetByName(sheetName); sheet.clear(); // Clear existing data sheet.appendRow(headers); // Add headers if (data.length > 0 && data[0].length > 0) { sheet.getRange(2, 1, data.length, data[0].length).setValues(data); // Add data } else { Logger.log('No data to write to the sheet.'); } } function formatDate(dateString) { const date = new Date(dateString); return Utilities.formatDate(date, Session.getScriptTimeZone(), 'dd/MM/yyyy'); } The full API response looks something like this:
Full API Response: [{"results":[{"campaign":{"resourceName":"customers/xxxxx/campaigns/3509213","id":"3509213"},"metrics":{"costMicros":"41060000"},"segments":{"date":"2024-08-26"}},{"campaign":{"resourceName":"customers/xxxxx/campaigns/3509213","id":"3509213"},"metrics":{"costMicros":"54460000"},"segments":{"date":"2024-08-27"}},{"campaign":{"resourceName":"customers/xxxxx/campaigns/3509213","id":"3509213"},"metrics":{"costMicros":"33690000"},"segments":{"date":"2024-08-28"}}..... And further logging shows this:
8:05:38 AM Info Found 232 result(s). 8:05:38 AM Info Metrics object: {"costMicros":"41060000"} 8:05:38 AM Info Metric: segments.date, Value: 2024-08-26 8:05:38 AM Info Metric: campaign.id, Value: 3509213 8:05:38 AM Info Metric: metrics.cost_micros, Value: null 8:05:38 AM Info Converted cost_micros: 0 I've tried changing the metrics.cost_micros to metrics.costMicros, but this doesn't work and returns an unrecognised field.
Why is 'Metric: metrics.cost_micros, Value: null'?