{"id":4336,"date":"2024-01-29T12:57:44","date_gmt":"2024-01-29T03:57:44","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=4336"},"modified":"2024-02-06T13:53:54","modified_gmt":"2024-02-06T04:53:54","slug":"post-4336","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/4336","title":{"rendered":"GAS\u3068AdSense Management API\u3092\u4f7f\u3063\u3066\u524d\u65e5\u5206\u306e\u58f2\u308a\u4e0a\u3052\u3092\u30e1\u30fc\u30eb\u901a\u77e5\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

Google\u30a2\u30c9\u30bb\u30f3\u30b9\u306e\u58f2\u308a\u4e0a\u3052\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u969b\u3001\u3044\u3064\u3082\u306f\u30a2\u30c9\u30bb\u30f3\u30b9\u306e\u7ba1\u7406\u753b\u9762\u306b\u898b\u306b\u884c\u3063\u3066\u3044\u305f\u3002\u3053\u308c\u304c\u9762\u5012\u81ed\u3044\u306e\u3067Google Apps Script\u3068AdSense Management API\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u6628\u65e5\u5206\u306eGoogle\u30a2\u30c9\u30bb\u30f3\u30b9\u306e\u58f2\u308a\u4e0a\u3052\u3092\u30e1\u30fc\u30eb\u3067\u53d7\u3051\u53d6\u308a\u305f\u3044\u3002\u4ee5\u4e0b\u306b\u5b9f\u88c5\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

AdSense Management API\u306b\u3064\u3044\u3066<\/h2>\n

\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u7b49\u306f\u4ee5\u4e0b\u516c\u5f0f\u30b5\u30a4\u30c8\u3088\u308a\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n

https:\/\/developers.google.com\/adsense\/management?hl=ja<\/a><\/p>\n

 <\/p>\n

\u5b9f\u88c5\u65b9\u6cd5<\/h2>\n

AdSense Management API\u306e\u6e96\u5099<\/h3>\n

Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8<\/a>\u3092\u958b\u304d\u300c\u62e1\u5f35\u6a5f\u80fd\u2192Apps Script\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002\u30da\u30fc\u30b8\u5de6\u5074\u306e\u300c\u30b5\u30fc\u30d3\u30b9+\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u300cAdSense Management API\u300d\u3092\u8ffd\u52a0\u3059\u308b\u3002\u6b63\u5e38\u306b\u8ffd\u52a0\u3055\u308c\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8868\u793a\u3055\u308c\u308b\u7b48\u3002<\/p>\n

\"\"<\/a><\/p>\n

\u30a2\u30c9\u30bb\u30f3\u30b9ID\u306e\u6e96\u5099<\/h3>\n

Google\u30a2\u30c9\u30bb\u30f3\u30b9\u306e\u7ba1\u7406\u753b\u9762\u3092\u958b\u304f\u969b\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306aURL\u306b\u306a\u308b\u306e\u3067\u3010\u30a2\u30c9\u30bb\u30f3\u30b9ID\u3011\u90e8\u5206\u3092\u30e1\u30e2\u3057\u3066\u304a\u304f\u3002<\/p>\n

https:\/\/www.google.com\/adsense\/new\/u\/0\/pub-\u3010\u30a2\u30c9\u30bb\u30f3\u30b9ID\u3011\/home<\/pre>\n
\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h3>\n
function getAdSenseData(){\r\n\r\n    \/\/\u30a2\u30c9\u30bb\u30f3\u30b9ID\u8a2d\u5b9a\r\n    const adsense_id = `xxxxxxxxxxxxx`;\r\n    const adsense_account = `accounts\/pub-${adsense_id}`;\r\n    const adsense_dimension_id = `ca-pub-${adsense_id}`;\r\n\r\n    \/\/\u6628\u65e5\u306e\u30c7\u30fc\u30bf\u3092\u6307\u5b9a\r\n    const date = new Date();\r\n    date.setDate(date.getDate() - 1);\r\n    const y = date.getFullYear();\r\n    const m = date.getMonth() + 1;\r\n    const d = date.getDate();\r\n    const ymd = `${y}-${m}-${d}`;\r\n\r\n    \/\/\u30ec\u30dd\u30fc\u30c8\u306e\u53d6\u5f97\r\n    const report = AdSense.Accounts.Reports.generate(adsense_account, {\r\n        filters: [`AD_CLIENT_ID==${adsense_dimension_id}`],\r\n        metrics: [`ESTIMATED_EARNINGS`],\r\n        dimensions: [`DATE`],\r\n        'startDate.day': d,\r\n        'startDate.month': m,\r\n        'startDate.year': y,\r\n        'endDate.day': d,\r\n        'endDate.month': m,\r\n        'endDate.year': y,\r\n    });\r\n\r\n    if( report[`totals`][`cells`][1][`value`] ){\r\n        sendMail( report[`totals`][`cells`][1][`value`], ymd );\r\n    }\r\n}\r\n\r\nfunction sendMail( sales, ymd ){\r\n\r\n    \/\/\u9001\u4fe1\u5148\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\r\n    const recipient = `xxxxxxxxxxxx@gmail.com`;\r\n\r\n    \/\/\u30e1\u30fc\u30eb\u4ef6\u540d\r\n    const subject = `\u30a2\u30c9\u30bb\u30f3\u30b9\u901a\u77e5`;\r\n\r\n    const message = `${ymd}\u306e\u58f2\u308a\u4e0a\u3052\u306f${sales}\u5186\u3067\u3059\u3002`;\r\n\r\n    \/\/\u30e1\u30fc\u30eb\u9001\u4fe1\r\n    GmailApp.sendEmail(recipient, subject, message) \r\n\r\n}<\/pre>\n
\u30a2\u30c9\u30bb\u30f3\u30b9ID\u90e8\u5206\u306f\u5148\u307b\u3069\u30e1\u30e2\u3057\u305f\u3082\u306e\u3092\u5165\u529b\u3059\u308b\u3002\u9001\u4fe1\u5148\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3082\u9069\u5b9c\u5909\u66f4\u3059\u308b\u3053\u3068\u3002<\/p>\n
\u5c1a\u3001\u521d\u56de\u5b9f\u884c\u6642\u306f\u6a29\u9650\u306e\u78ba\u8a8d\u304c\u5fc5\u8981\u306b\u306a\u308b\u306e\u3067\u6848\u5185\u306b\u5f93\u3063\u3066\u9032\u3081\u308b\u3053\u3068\u3002<\/p>\n
\u30c8\u30ea\u30ac\u30fc\u8a2d\u5b9a<\/h3>\n
\u6bce\u65e5\u81ea\u52d5\u5b9f\u884c\u3055\u305b\u308b\u305f\u3081\u306b\u30c8\u30ea\u30ac\u30fc\u8a2d\u5b9a\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308b\u3002Apps Script\u30da\u30fc\u30b8\u306e\u5de6\u5074\u306b\u76ee\u899a\u307e\u3057\u6642\u8a08\u3063\u307d\u3044\u30a2\u30a4\u30b3\u30f3\u304c\u3042\u308b\u306e\u3067\u305d\u3061\u3089\u304b\u3089\u30c8\u30ea\u30ac\u30fc\u8a2d\u5b9a\u30da\u30fc\u30b8\u306b\u9032\u307f\u4ee5\u4e0b\u3092\u8a2d\u5b9a\u3059\u308b(\u6642\u523b\u90e8\u5206\u306f\u597d\u304d\u306a\u6642\u9593\u5e2f\u3067OK)\u3002<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n
\u6240\u611f<\/h2>\n
Google\u7cfb\u306e\u30b5\u30fc\u30d3\u30b9\u3068\u9023\u643a\u3057\u305f\u30b7\u30b9\u30c6\u30e0\u3092\u4f5c\u308b\u969b\u3001PHP\u3060\u3068Google Cloud Platform\u3067\u306e\u8a2d\u5b9a\u4f5c\u696d\u3084\u5404\u7a2e\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4f5c\u696d\u304c\u9762\u5012\u81ed\u3044\u3002\u3053\u306e\u8fba\u308a\u3092\u7c21\u6f54\u306b\u5b9f\u88c5\u3067\u304d\u308b\u306e\u304cGAS\u306e\u5f37\u307f\u3060\u306a\u3041\u3068\u601d\u3063\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Google\u30a2\u30c9\u30bb\u30f3\u30b9\u306e\u58f2\u308a\u4e0a\u3052\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u969b\u3001\u3044\u3064\u3082\u306f\u30a2\u30c9\u30bb\u30f3\u30b9\u306e\u7ba1\u7406\u753b\u9762\u306b ... <\/p>\n","protected":false},"author":1,"featured_media":3294,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[72,70],"tags":[],"class_list":["post-4336","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script","category-google"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=4336"}],"version-history":[{"count":4,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4336\/revisions"}],"predecessor-version":[{"id":4543,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4336\/revisions\/4543"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/3294"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=4336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=4336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=4336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}