How to connect DataXu
The connector we have for DataXu is an S3 connection that will pull data into TapClicks via a single file that gets delivered daily by the team at DataXu. Along those lines in order to create the individual data views we use unique combinations of dimensions to parse the data out of the single file. By default, there are four views a user will get upon connection.
Below illustrates how one should go about requesting a new connection between DataXu and TapClicks. Feel free to email firstname.lastname@example.org with any and all questions that you have around this process.
- Mutual Client wants their DataXu data in TapClicks
- Client submits a request via email to their DataXu CSM and cc’s TapClicks AM & email@example.com
- The client can send this template that shows which fields are required for TapClicks
- Note that the template will populate the four standard views
- Columns in the report template must be exact to work with the connection between TapClicks and DataXu without any variations
- These must be included in the reports even if a client doesn’t desire to report on them - the UI of TapAnalytics will allow the client to build visualizations to their needs
- DataXu setups Amazon S3 folder & file delivery
- The Folder Name = [string]
- The Mapping File Naming Convention = "metadata_[string].CSV"
- The Data File = "[string]_daily_tapclicks_YYYY-MM-DD.csv"
- The Folder Name = "autoflyte_cR2VggxMaHnTvaNe"
- The Mapping File Naming Convention = "metadata_autoflyte_cR2VggxMaHnTvaNe.csv"
- The Data File = "autoflyte_cR2VggxMaHnTvaNe_daily_tapclicks_YYYY-MM-DD.csv"
- DataXu provides client with “Credentials” = [String]
- Only provide the client with credentials once first set of files are in the S3 folder
- Cost Metrics must be in Microdollars for consistency (added 12/12/2017)
- DataXu provided files must have a field for “created_dt” as the first column in the file provided - this indicates what day that row is associated with in TapAnalytics, even though this is not exposed in the UI
Additional Data Views
In order to allow for ease of connection TapClicks has built out eight additional views that are supported by additional fields that can be added to DataXu files. If these “predefined views” meet the reporting need, one can reach out to a DataXu Representative to request that the specific fields are added to existing files. Once these are present in the files TapClicks can enable the view(s) on the client’s TapAnalytics Instance!
If the data that a client is looking for is not included in the predefined views today, then TapClicks can go through the standard process of creating additional views or adding additional fields. The flow for both types of requests are depicted by the chart below.
- “Page Details”
- “Device and Browsers”
- “Device and Vendor”
- “Time of Day”