All Collections
Data Sources
Adobe
Setting Up Adobe Clickstream Feeds
Setting Up Adobe Clickstream Feeds
Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

Delivery Endpoints

Adobe defaults delivery to FTP. If you want to use SFTP, it will require a special request to the Adobe support team to setup.

Delivery of files to the following

  • SFTP Hostname = pipeline-01.openbridge.io

The following are the PORT numbers you will need to make sure are used by the system responsible for file delivery

  • SFTP = port:443

Delivery Directory and Filemasks

Feeds must have specific directories on the Openbridge system that correspond to each reporting suite. For example, the delivery would be sent to the root of the report suite directory like this: ".../(report_suite_id)/..." 

The actual delivery will be zipped would follow this convention for the path and filemask.: "/(report_suite_id)/(report_suite_YYYY-mm-dd).tar.gz"

Access Credentials

Adobe supports standard username and password credential for both FTP and SFTP. Openbridge will supply these to you to supply to Adobe technical support team. Adobe will only have access to the specific directory path mentioned previously. They are "locked" there and only have access to deliver files to the target directory.

Delivery Frequency

You have the option of requesting Daily Single or Daily Multiple for delivery. We suggest the delivery of a single, consolidated file each day. The clickstream feeds are typically delivered between 1AM and 4AM daily.

Clickstream Feed Contents

We have provided public repository of samples of clickstream data feeds on Github: https://github.com/openbridge/adobe-clickstream

In addition to reviewing the same data we provided, we suggest you review the Adobe specs here: http://microsite.omniture.com/t2/help/en_US/sc/clickstream/index.html#Clickstream_Data.

If you are planning to use the full payload as defined Adobe there are consideration in complexity and storage volumes. This is due to the fact that there are in excess of 500 columns of data, each with varying lengths and data types. Each record will consume a sizable chunk of space.

Take a look at Adobe's recommended subset of that superset of columns here: http://microsite.omniture.com/t2/help/en_US/sc/clickstream/index.html#Configuring_Data_Feeds

Lookup/Helper Files

Contents of each zip file would contain the following;

  1. column_headers.tsv

  2. browser.tsv

  3. browser_type.tsv

  4. color_depth.tsv

  5. connection_type.tsv

  6. country.tsv

  7. javascript_version.tsv

  8. languages.tsv

  9. operating_systems.tsv

  10. plugins.tsv

  11. resolution.tsv

  12. referrer_type.tsv

  13. search_engines.tsv

  14. event_lookup.tsv

Support or Contact

Having trouble with something? Contact us at http://openbridge.zendesk.com or contact support@openbridge.com and we’ll help you sort it out.

Did this answer your question?