在Google Analytics中手动添加电子商务交易 [英] Manually adding e-commerce transactions in Google Analytics

问题描述

我们在电子商务网站中跟踪Google Analytics中的交易时遇到了一些问题，现在由于配置错误，我们已经丢失了几个月的数据。

是否有可能以某种方式批量导入这些交易以及它们的附加参数（事件日期，交易代码，金额）？

我们知道每一次这些事件发生的时间，但我们希望将其导入Google Analytics以获得完整的统计信息。

感谢您的帮助

解决方案

如果数据是以MySQL为例说明的话。

1. 运行一个MySQL命令，它从 date_you_want_start_from 中提取所有命令，然后限制它直到 date_you_want_to_end_from


2. 使用这些数据，然后创建一个MySQL视图，称之为import_table code>


3. 创建一个PHP和XML脚本，它加载 import_table 中的所有数据，然后写入并填充XML feed


4. 只需在分析循环JavaScript中运行该XML馈送，它就会循环并基本为您添加过去的数据。

注意：PHP，XML和MySQL只是一个场景，可以帮助您做到这一点。

we've had some problems with the tracking of the transactions in Google Analytics in our e-commerce website, and now we've lost a couple of months of data due to a configuration error.

Is it possible to bulk import in some way these transactions, along with their additional parameters (date of event, transaction code, money amount)?

We know when every one of these events has taken place, but we would like to import it back into Analytics to have the complete statistics.

Thank you for the help

解决方案

If the data is in MySQL say for example.

1. Run a MySQL command which pulls all the orders from the date_you_want_start_from and then limit it till the date_you_want_to_end_from
2. With this data, then create a MySQL view call it "import_table"
3. Create a PHP and XML script which loads all the data from import_table, it then writes and fills the XML feed
4. Just run that XML feed now inside your analytic loop JavaScript and it will loop and basically add data into the past for you.

Note: PHP, XML and MySQL is just a scenario to give you a head on to do it.

这篇关于在Google Analytics中手动添加电子商务交易的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！