我对UTM(Urchin跟踪模块)很陌生,我想获取用户从何处点击链接的UTM参数(如Facebook,Google,Twitter),以及用户使用相同UTM来源点击链接的次数,并将其保存到MySQL数据库中。
我有一个PHP片段,但是UTM参数没有被获取和保存在数据库中。
如何解决这个问题?
if(isset($_SERVER['HTTP_REFERER'])){
$utm_source = isset($_GET['utm_source']) ? $_GET['utm_source'] : '';
$utm_medium = isset($_GET['utm_medium']) ? $_GET['utm_medium'] : '';
$utm_campaign = isset($_GET['utm_campaign']) ? $_GET['utm_campaign'] : '';
$utm_term = isset($_GET['utm_term']) ? $_GET['utm_term'] : '';
echo $_SERVER['HTTP_REFERER'];
$sql = "INSERT INTO utm_param(utm_source,utm_medium,utm_campaign)
VALUES('".$conn->real_escape_string($utm_source)."',
'".$conn->real_escape_string($utm_medium)."',
'".$conn->real_escape_string($utm_campaign)."')";
}
utm_param 数据库表结构
$_POST
更改为$_GET
,如何保存UTM参数(例如http://example.com/?utm_source=facebook&utm_medium=social&utm_campaign=test)? - User014019