Category Archives: Google

Get App Password of G Suite Account

Google Admin:

Grant 2 step authentication for child accounts.

Child account:

Login google account
Enable 2 step authentication
Get app password

Google reCaptcha

.env

RECAPTCHA_SITE_KEY=xxxxx
RECAPTCHA_SECRET=xxxxxx

1 2	RECAPTCHA_SITE_KEY=xxxxx RECAPTCHA_SECRET=xxxxxx

Front

<script src="https://www.google.com/recaptcha/api.js?render={{ env('RECAPTCHA_SITE_KEY') }}"></script>

<script>
grecaptcha.ready(function() {
    grecaptcha.execute('{{ env('RECAPTCHA_SITE_KEY') }}', {action: 'signup'}).then(function(token) {
        //Hidden field
        var recaptchaResponse = document.getElementById('recaptchaResponse');
        recaptchaResponse.value = token;
    });
});
</script>

grecaptcha.ready(function() {

grecaptcha.execute('{{ env('RECAPTCHA_SITE_KEY') }}', {action: 'signup'}).then(function(token) {

//Hidden field

var recaptchaResponse = document.getElementById('recaptchaResponse');

recaptchaResponse.value = token;

});

</script>

Backend

    private function verify_recaptcha($response){
        $recaptcha_url = 'https://www.google.com/recaptcha/api/siteverify';
        $recaptcha_secret = env('RECAPTCHA_SECRET');
        $recaptcha_response = $response;

        // Make and decode POST request:
        $recaptcha = file_get_contents($recaptcha_url . '?secret=' . $recaptcha_secret . '&response=' . $recaptcha_response);
        $recaptcha = json_decode($recaptcha);
        //logg($recaptcha);

        // Take action based on the score returned:
        if($recaptcha->success == false){
            $errors = $recaptcha->{'error-codes'};
            //logg($errors);
            $this->err = implode(', ', $errors);
            return false;
        }else{
            if ($recaptcha->score >= 0.5) {
                // Verified - send email
                return true;
            } else {
                // Not verified - show form error
                $this->err = 'Score is too low';
                return false;
            }
        }
    }

    public function signup_save(SignupSave $req)
    {
        $data = $req->input();
        //logg($data);

        $captcha_response = $data['recaptcha_response'];
        if($captcha_response == false){
            return $this->fail_response('reCaptcha Error');
        }else{
            $result = $this->verify_recaptcha($captcha_response);
            if($result == false){
                return $this->fail_response($this->err);
            }
        }
    }

private function verify_recaptcha($response){

$recaptcha_url = 'https://www.google.com/recaptcha/api/siteverify';

$recaptcha_secret = env('RECAPTCHA_SECRET');

$recaptcha_response = $response;

// Make and decode POST request:

$recaptcha = file_get_contents($recaptcha_url . '?secret=' . $recaptcha_secret . '&response=' . $recaptcha_response);

$recaptcha = json_decode($recaptcha);

//logg($recaptcha);

// Take action based on the score returned:

if($recaptcha->success == false){

$errors = $recaptcha->{'error-codes'};

//logg($errors);

$this->err = implode(', ', $errors);

return false;

}else{

if ($recaptcha->score >= 0.5) {

// Verified - send email

return true;

} else {

// Not verified - show form error

$this->err = 'Score is too low';

return false;

}

public function signup_save(SignupSave $req)

{

$data = $req->input();

//logg($data);

$captcha_response = $data['recaptcha_response'];

if($captcha_response == false){

return $this->fail_response('reCaptcha Error');

}else{

$result = $this->verify_recaptcha($captcha_response);

if($result == false){

return $this->fail_response($this->err);

}

Google Verify API response examples

Type: object<br/><pre>stdClass Object
(
    [success] => 1
    [challenge_ts] => 2020-04-20T15:48:54Z
    [hostname] => localhost
    [score] => 0.9
    [action] => signup
)
</pre>


Type: object<br/><pre>stdClass Object
(
    [success] => 
    [error-codes] => Array
        (
            [0] => timeout-or-duplicate
        )

)
</pre>

Type: object<br/><pre>stdClass Object

(

[success] => 1

[challenge_ts] => 2020-04-20T15:48:54Z

[hostname] => localhost

[score] => 0.9

[action] => signup

)

</pre>

Type: object<br/><pre>stdClass Object

(

[success] =>

[error-codes] => Array

(

[0] => timeout-or-duplicate

)

</pre>

Reference:

reCAPTCHA v3 Example for PHP
https://stevencotterill.com/articles/adding-google-recaptcha-v3-to-a-php-form
Official
https://developers.google.com/recaptcha/docs/v3
Admin Console
https://www.google.com/recaptcha/admin

在網站中加入動態再行銷代碼

https://support.google.com/google-ads/answer/3103357?hl=zh-Hant

使用符合業務類型的自訂參數

https://support.google.com/google-ads/answer/7305793

設定目標對象來源

https://support.google.com/google-ads/answer/7540515?hl=zh-Hant

全域網站代碼

<!-- Global site tag (gtag.js) - AdWords: 0000000 -->
<script async src="https://www.googletagmanager.com/gtag/js?id=AW-0000000"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'AW-0000000');
</script>

window.dataLayer = window.dataLayer || [];

function gtag(){dataLayer.push(arguments);}

gtag('js', new Date());

gtag('config', 'AW-0000000');

</script>

事件程式碼片段

<script>
  gtag('event', 'page_view', {
    'send_to': 'AW-0000000',
    //零售
    'ecomm_pagetype': 'replace with value',//recommended
    'ecomm_prodid': 'replace with value',//required
    'ecomm_totalvalue': 'replace with value',//recommended
    //Hotel
    'hrental_enddate': 'replace with value',
    'hrental_id': 'replace with value',//required
    'hrental_pagetype': 'replace with value',//recommended
    'hrental_startdate': 'replace with value',
    'hrental_totalvalue': 'replace with value',//recommended
    //本地優惠
    'local_id': 'replace with value',//required
    'local_pagetype': 'replace with value',//recommended
    'local_totalvalue': 'replace with value',//recommended
    //旅行
    'travel_destid': 'replace with value',//required
    'travel_enddate': 'replace with value',
    'travel_originid': 'replace with value',
    'travel_pagetype': 'replace with value',//recommended
    'travel_startdate': 'replace with value',
    'travel_totalvalue': 'replace with value',//recommended
    'user_id': 'replace with value'
  });
</script>

gtag('event', 'page_view', {

'send_to': 'AW-0000000',

//零售

'ecomm_pagetype': 'replace with value',//recommended

'ecomm_prodid': 'replace with value',//required

'ecomm_totalvalue': 'replace with value',//recommended

//Hotel

'hrental_enddate': 'replace with value',

'hrental_id': 'replace with value',//required

'hrental_pagetype': 'replace with value',//recommended

'hrental_startdate': 'replace with value',

'hrental_totalvalue': 'replace with value',//recommended

//本地優惠

'local_id': 'replace with value',//required

'local_pagetype': 'replace with value',//recommended

'local_totalvalue': 'replace with value',//recommended

//旅行

'travel_destid': 'replace with value',//required

'travel_enddate': 'replace with value',

'travel_originid': 'replace with value',

'travel_pagetype': 'replace with value',//recommended

'travel_startdate': 'replace with value',

'travel_totalvalue': 'replace with value',//recommended

'user_id': 'replace with value'

});

</script>

Tag Manager and gtag.js

https://support.google.com/tagmanager/answer/7582054?hl=en

Google Ads Related Tags in GTM

https://support.google.com/tagmanager/topic/6334091

自訂變數

活用 Google Analytics 自訂變數的 10 種方法

維度Dimensions & 指標Metrics

5分鐘搞懂Google Analytics的指標、維度

Example to build datalayer for Google Enhanced Ecommerce

<script>
window.dataLayer = window.dataLayer || [];

var products = [];
<?php foreach($order_products as $key => $item): ?>
products.push({
	'name': '<?=$item->name?>',
    'id': '<?=$item->product_id?>',
    'price': '<?=round($item->price, 0)?>',
    'brand': 'WIIB',
    'category': 'Health',
    'quantity': <?=$item->quantity?>,
    'coupon': '' 
});
<?php endforeach; ?>

dataLayer.push({
  'ecommerce': {
    'purchase': {
      'actionField': {
        'id': '<?=$order->transaction_id?>',                         // Transaction ID. Required for purchases and refunds.
        'affiliation': 'WIIB',
        'revenue': '<?=round($order->amount, 0)?>',                     // Total transaction value (incl. tax and shipping)
        'tax':'<?=$order->amount*0.05?>',
        'shipping': '<?=$order->shipping_fee?>'
      },
      'products': products
    }
  }, 
  'event': 'transactionComplete'
});
</script>

window.dataLayer = window.dataLayer || [];

var products = [];

<?php foreach($order_products as $key => $item): ?>

products.push({

'name': '<?=$item->name?>',

'id': '<?=$item->product_id?>',

'price': '<?=round($item->price, 0)?>',

'brand': 'WIIB',

'category': 'Health',

'quantity': <?=$item->quantity?>,

'coupon': ''

});

<?php endforeach; ?>

dataLayer.push({

'ecommerce': {

'purchase': {

'actionField': {

'id': '<?=$order->transaction_id?>', // Transaction ID. Required for purchases and refunds.

'affiliation': 'WIIB',

'revenue': '<?=round($order->amount, 0)?>', // Total transaction value (incl. tax and shipping)

'tax':'<?=$order->amount*0.05?>',

'shipping': '<?=$order->shipping_fee?>'

'products': products

}

'event': 'transactionComplete'

});

</script>

Reference:

Config Pixel Purchase in Google Tag Manager

Install Pixel base
Add this line to tell Tag Manager this tag is loaded.

JavaScript

window.google_tag_manager[{{Container ID}}].onHtmlSuccess({{HTML ID}});

1

window.google_tag_manager[{{Container ID}}].onHtmlSuccess({{HTML ID}});
Get ready your advanced ecommerce datalayer of google

Create a variable (Custom javascript) called “Transform Total for Pixel” to transform data from datalayer for pixel purchase event

function(){
	try{
		var products = google_tag_manager[{{Container ID}}].dataLayer.get("ecommerce").purchase.products;
		var productIds = [];
		
		for(i = 0; i < products.length; i++){
			productIds.push(products[i].id);
		}
		
		return productIds;
	}catch(e){
		return 'undefined';
	}
}

function(){

try{

var products = google_tag_manager[{{Container ID}}].dataLayer.get("ecommerce").purchase.products;

var productIds = [];

for(i = 0; i < products.length; i++){

productIds.push(products[i].id);

}

return productIds;

}catch(e){

return 'undefined';

}

Create a new Tag – Purchase (Custom HTML)
Config trigger (Recommended triggered by event instead of page view)

Reference

Google Analytics Ecommerce tracking via Tag Manager

<?php
// Transaction Data
$trans = array('id'=>'1234', 'affiliation'=>'Acme Clothing',
               'revenue'=>'11.99', 'shipping'=>'5', 'tax'=>'1.29');

// List of Items Purchased.
$items = array(
  array('sku'=>'SDFSDF', 'name'=>'Shoes', 'category'=>'Footwear', 'price'=>'100', 'quantity'=>'1'),
  array('sku'=>'123DSW', 'name'=>'Sandals', 'category'=>'Footwear', 'price'=>'87', 'quantity'=>'1'),
  array('sku'=>'UHDF93', 'name'=>'Socks', 'category'=>'Footwear', 'price'=>'5.99', 'quantity'=>'2')
);
?>

<?php

// Transaction Data

$trans = array('id'=>'1234', 'affiliation'=>'Acme Clothing',

'revenue'=>'11.99', 'shipping'=>'5', 'tax'=>'1.29');

// List of Items Purchased.

$items = array(

array('sku'=>'SDFSDF', 'name'=>'Shoes', 'category'=>'Footwear', 'price'=>'100', 'quantity'=>'1'),

array('sku'=>'123DSW', 'name'=>'Sandals', 'category'=>'Footwear', 'price'=>'87', 'quantity'=>'1'),

array('sku'=>'UHDF93', 'name'=>'Socks', 'category'=>'Footwear', 'price'=>'5.99', 'quantity'=>'2')

);

<?php
// Function to return the JavaScript representation of a TransactionData object.
function getTransactionJs(&$trans) {
  return <<<HTML
ga('ecommerce:addTransaction', {
  'id': '{$trans['id']}',
  'affiliation': '{$trans['affiliation']}',
  'revenue': '{$trans['revenue']}',
  'shipping': '{$trans['shipping']}',
  'tax': '{$trans['tax']}'
});
HTML;
}

// Function to return the JavaScript representation of an ItemData object.
function getItemJs(&$transId, &$item) {
  return <<<HTML
ga('ecommerce:addItem', {
  'id': '$transId',
  'name': '{$item['name']}',
  'sku': '{$item['sku']}',
  'category': '{$item['category']}',
  'price': '{$item['price']}',
  'quantity': '{$item['quantity']}'
});
HTML;
}
?>

<?php

// Function to return the JavaScript representation of a TransactionData object.

function getTransactionJs(&$trans) {

return <<<HTML

ga('ecommerce:addTransaction', {

'id': '{$trans['id']}',

'affiliation': '{$trans['affiliation']}',

'revenue': '{$trans['revenue']}',

'shipping': '{$trans['shipping']}',

'tax': '{$trans['tax']}'

});

HTML;

}

// Function to return the JavaScript representation of an ItemData object.

function getItemJs(&$transId, &$item) {

return <<<HTML

ga('ecommerce:addItem', {

'id': '$transId',

'name': '{$item['name']}',

'sku': '{$item['sku']}',

'category': '{$item['category']}',

'price': '{$item['price']}',

'quantity': '{$item['quantity']}'

});

HTML;

}

<!-- Begin HTML -->
<script>
ga('require', 'ecommerce');

<?php
echo getTransactionJs($trans);

foreach ($items as &$item) {
  echo getItemJs($trans['id'], $item);
}
?>

ga('ecommerce:send');
</script>

ga('require', 'ecommerce');

<?php

echo getTransactionJs($trans);

foreach ($items as &$item) {

echo getItemJs($trans['id'], $item);

}

ga('ecommerce:send');

</script>

Enhanced ecommerce tracking with tag manager

Reference:

Tag Manager for enhanced-ecommerce
https://developers.google.com/tag-manager/enhanced-ecommerce#overview
e-commerce tips for tag manager
https://www.simoahava.com/analytics/ecommerce-tips-google-tag-manager/
Google Analytics for ecommerce:
https://developers.google.com/analytics/devguides/collection/analyticsjs/ecommerce
Unlock the Data Layer: A Non-Developer’s Guide to Google Tag Manager
https://www.lunametrics.com/blog/2013/10/15/unlock-data-layer-google-tag-manager/
Implementing E-commerce tracking via tag manager:
https://www.optimizesmart.com/implementing-e-commerce-tracking-google-tag-manager/

Tag Manager + Pixel

Install Google Tag Manager in web

Create Tag for Pixel base code

Create Tags for Pixel built-in events

<script>
fbq('track', 'AddToCart', {
content_ids: {{Product SKU Array}},
content_type: 'product',
content_name: {{Product Page - Product Name}},
value: {{Product Page - Product Price}},
currency: 'TWD'
});
</script>

fbq('track', 'AddToCart', {

content_ids: {{Product SKU Array}},

content_type: 'product',

content_name: {{Product Page - Product Name}},

value: {{Product Page - Product Price}},

currency: 'TWD'

});

</script>

<script>
fbq('track', 'InitiateCheckout', {
content_ids: {{Product SKU Array}},
content_type: 'product',
content_name: {{Product Page - Product Name}},
value: {{Product Page - Product Price}},
currency: 'TWD',
num_items: {{Product Item Number}}
});
</script>

fbq('track', 'InitiateCheckout', {

content_ids: {{Product SKU Array}},

content_type: 'product',

content_name: {{Product Page - Product Name}},

value: {{Product Page - Product Price}},

currency: 'TWD',

num_items: {{Product Item Number}}

});

</script>

Product Catalog for Pixel

Google Product Category and Product Type

Reference:

G Suite 使用說明

https://admin.google.com

管理網域:

控制台首頁 -> 下方”更多控制項”

低安全性應用程式帳戶存取設定(Allow less secure apps)

預設是禁止所有成員自行改變設定，因此成員登入自己的google帳戶，會看不到這個選項

控制台 -> 安全性 -> 基本設定 -> 開啟「低安全性應用程式」設定 ››

Reference:

APP應用程式密碼:

密須開啟兩階段認證後才可以取得

http://open.mymy.tw/index-traitshow.html?id=109

驗證網域:

https://support.google.com/a/answer/60216?hl=zh-Hant

DNS中的MX設定:

https://support.google.com/a/answer/174125?hl=zh-Hant

SMTP:

https://support.google.com/mail/answer/7126229?visit_id=1-636264511803609300-627858639&hl=zh-Hant&rd=1
https://ec.softking.com.tw/use/use.asp?id=331
Godaddy block all SMTP related request:
https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting

PHP

$mail->isSMTP(); $mail->Host = 'relay-hosting.secureserver.net'; $mail->Port = 25; $mail->SMTPAuth = false; $mail->SMTPSecure = false;

1
2
3
4
5

$mail->isSMTP();
$mail->Host = 'relay-hosting.secureserver.net';
$mail->Port = 25;
$mail->SMTPAuth = false;
$mail->SMTPSecure = false;

用上面這個方式可以順利用SMTP寄信(不知道為什麼)，總之就是不要用SMTP認證。

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Category Archives: Google

Get App Password of G Suite Account

Google reCaptcha

在網站中加入動態再行銷代碼

使用符合業務類型的自訂參數

設定目標對象來源

全域網站代碼

事件程式碼片段

Tag Manager and gtag.js

Google Ads Related Tags in GTM

自訂變數

維度Dimensions & 指標Metrics

Example to build datalayer for Google Enhanced Ecommerce

Config Pixel Purchase in Google Tag Manager

Google Analytics Ecommerce tracking via Tag Manager

Tag Manager + Pixel

G Suite 使用說明

管理網域:

低安全性應用程式帳戶存取設定(Allow less secure apps)

APP應用程式密碼:

驗證網域:

DNS中的MX設定:

SMTP:

July 2020
M	T	W	T	F	S	S
« Jun
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31