将Adobe Analytics连接到MYSQL [英] Connect Adobe Analytics to MYSQL

问题描述

我正在尝试将从Adobe Analytics收集的数据连接到我的MYSQL本地实例，这可能吗?如果可以，这样做的方法是什么?

I am trying to connect the data collected from Adobe Analytics to my local instance of MYSQL, is this possible? if so what would be the method of doing so?

推荐答案

没有一种方法可以直接将mysql db与AA连接，进行查询或进行其他操作.

There isn't a way to directly connect your mysql db with AA, make queries or whatever.

以下只是一些顶级信息，可为您提供大致指导.进入细节的时间太长了，涉及到这里无法给出答案.但是，在下面，我将列出一些用于从Adobe Analytics中获取数据的选项.

The following is just some top level info to point you in a general direction. Getting into specifics is way too long and involved to be an answer here. But below I will list some options you have for getting the data out of Adobe Analytics.

哪种方法最好取决于本地数据库中要从AA中获取的数据以及要使用的数据.但是总的来说，我按难易程度列出了它们，以便对其进行设置并对收到的文件进行处理，以将它们放入数据库.

Which method is best largely depends on what data you're looking to get out of AA and what you're looking to do with it, within your local db. But in general, I listed them in order of level of difficulty of setting something up for it and doing something with the file(s) once received, to get them into your database.

第一个选择是在AA界面中，定期安排要通过FTP发送给您的数据.这可以是来自报告界面或数据仓库的计划报告，可以多种格式交付，但最常见的是作为CSV文件完成.这会将由AA处理过的数据导出到您.含义，汇总指标等.总的来说，这很容易设置和解析导出的CSV文件.但是对此有很多警告/限制.但这在很大程度上取决于您的具体目标.

First option is to within the AA interface, schedule data to be FTP'd to you on a regular basis. This can be a scheduled report from the report interface or from Data Warehouse, and can be delivered in a variety of formats but most commonly done as a CSV file. This will export data to you that has been processed by AA. Meaning, aggregated metrics, etc. Overall, this is pretty easy to setup and parse the exported CSV files. But there are a number of caveats/limitations about it. But it largely depends on what specifically you're aiming to do.

第二个选项是利用其API端点来发出请求并接收JSON格式的响应.也可以以XML格式接收它，但我建议不要这样做.您将获得与上述类似的数据，但其需求比计划的要多.这种方法实际上需要花费更多的精力来获取数据，但是它为按需获取数据，构建接口(如果与您相关)等提供了更多的功能/灵活性.但是它也附带了与第一个选项相同的一些警告/限制，因为数据已经过处理/汇总.

Second option is to make use of their API endpoint to make requests and receive response in JSON format. Can also receive it in XML format but I recommend not doing that. You will get similar data as above, but it's more on-demand than scheduled. This method requires a lot more effort on your end to actually get the data, but it gives you a lot more power/flexibility for getting the data on-demand, building interfaces (if relevant to you), etc. But it also comes with some caveats/limitations same as first option, since the data is already processed/aggregated.

第三个选项是安排从AA界面导出数据文件.这将向您发送CSV文件，其中包含未汇总的，大部分未经处理的原始匹配数据.这大约是最接近发送给Adobe收集服务器的数据而无需Adobe对其进行任何操作的结果，但这并不是100％像服务器请求日志之类的.除了将其按面值放置在本地数据库中之外，不知道有关最终要使用什么数据的任何细节，这可能是您想要的选项.设置计划的导出非常简单，但是解析接收到的文件可能会让人头疼.您将获得带有原始数据的文件和许多具有许多用于各种事物的值的列，然后，这些其他文件即是其中的列和值的查找表.将所有内容拼凑在一起有点令人头疼，但这是可行的.真正的问题是文件大小.这些是原始的命中数据文件，即使是流量适中的站点，每天，甚至每小时都会生成几千兆字节的文件.因此，如果尝试使用此路由，则需要考虑带宽，磁盘空间和服务器处理能力.

Third option is to schedule Data Feed exports from the AA interface. This will send you CSV files with non-aggregated, mostly non-processed, raw hit data. This is about the closest you will get to the data sent to Adobe collection servers without Adobe doing anything to it, but it's not 100% like a server request log or something. Without knowing any details about what you are ultimately looking to do with the data, other than put it in a local db, at face value, this may be the option you want. Setting up the scheduled export is pretty easy, but parsing the received files can be a headache. You get files with raw data and a LOT of columns with a lot of values for various things, and then you have these other files that are lookup tables for both columns and values within them. It's a bit of a headache piecing it all together, but it's doable. The real issue is file sizes. These are raw hit data files and even a site with moderate traffic will generate files many gigabytes large, daily, and even hourly. So bandwidth, disk space, and your server processing power are things to consider if you attempt to go this route.

这篇关于将Adobe Analytics连接到MYSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！