Skip to content

Latest commit

 

History

History
264 lines (137 loc) · 14.2 KB

bridges.md

File metadata and controls

264 lines (137 loc) · 14.2 KB

Data Bridges

Integration Overview

  • Authentication: Integration with source system OAuth mechanisms, including handling expirations, de-authorizations, permissions…
  • User Management: Manage linkage of user to specific resource authorization. Deliver notifications for failed credentials, renewals in addition to auditing status of user supplied source authorizations
  • Versioning: Keep up to date on API versioning for the source systems. This may include forking vendor SDKs to resolve bugs/errors. This also includes resolving undocumented features, functionality or workarounds needed to generate desired outputs
  • Requests: Define, design and manage request to APIs, including any inclusivity/exclusivity rules with requests to an API, how calls are made to APIs, any schema/request definitions…
  • Throttling/Limits: Manage data source Terms of Service for limits or throttling calls to their APIs
  • Errors: Handle API unavailability, failure, malformed outputs and other issues
  • Availability: Know when data becomes available in a source system. Know when the “truth” is settled in the source system
  • Scheduling: Setting up jobs and triggering calls to an API at specific intervals. Keep track of tasks, requests and outcomes
  • Schemas: Defining the request schemas (the “payloads”) and the API response output definitions
  • Encoding: Properly encode data to UTF-8 specifications
  • Processing: Handle the organizing of response output including appending metadata, aligning output formats, validating outputs meet API specs/schemas…
  • Asynchronous/Synchronous Operations: Chain multiple source API’s that need to be called, in sequence or parallel, to generate a desired output

Facebook Page Insights

With direct access to Facebook Page Insights data you can build a deeper understanding of your community and closer relationships with your customers.

Data Definitions

Take a look at our data definition docs for Facebook Page Insights layout and elements.

Delivery Time

We collect data from Facebook Page Insights API once a day. This ensures we are within the limits Facebook places on API calls.

Developer Docs

Check out Facebook Developer docs for more details about Facebook Page Insights API.

YouTube Channel Insights

Discover what drives your video content use on your channel. Identify how your subscribers react to new and existing content. Discover patterns or trends that inform content optimization and performance.

Data Definitions

Take a look at our data definition docs for YouTube Channel Insights layout and elements.

Delivery Time

We collect data from YouTube Analytics API once a day. This ensures we are within the limits YouTube places on API calls.

Developer Docs

Check out YouTube Developer docs for more details about YouTube Analytics and Reporting APIs.

Google Analytics 360

Get deeper understanding of your user activity through simple, direct access to a fully automated pipeline of Google Analytics 360 sessions data direct to Amazon Redshift. Let the data drive decisions on how to optimize ongoing customer engagement and performance.

Data Definitions

Take a look at our data definition docs for Google Analytics 360 layout and elements.

Delivery Time

We collect data once a day. For example, a request to Google Analytics 360 on July 3rd would return data for July 2nd. This ensures you have completed daily views for each reporting period. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Google Developer docs for more details.

Instagram Community IQ

The Instagram Community IQ data bridge allows you to discover what drives your interactions within your Instagram community. Identify your best media and understand how it is being engaged with.

Data Definitions

Take a look at our data definition docs for Instagram Community IQ layout and elements.

Delivery Time

We collect data from Instagram API once a day. This ensures we are within the limits Instagram places on API calls.

Developer Docs

Check out Instagram Developer docs for more details about Instagram APIs.

YouTube Video IQ

Track your competitors’ video performance data to see if their content drives engagement and adjust your YouTube strategies to stand out from the competition.

Data Definitions

Take a look at our data definition docs for YouTube Video IQ layout and elements.

Delivery Time

We collect data from YouTube Data API once a day. This ensures we are within the limits YouTube places on API calls.

Developer Docs

Check out YouTube Developer docs for more details about YouTube API.

Google Adwords

Get deeper understanding of your paid search efforts through simple, direct access to paid advertising data from Google Adwords. Let the data drive decisions on how to optimize ongoing search campaign and keyword performance.

Data Definitions

Take a look at our data definition docs for Google Adwords layout and elements.

Delivery Time

We collect data once a day. For example, a request to Google Search Reporting API on July 3rd would return data for July 2nd. This ensures you have completed daily views for each reporting period. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Google Developer docsfor more details.

Salesforce Email Studio

Get complete access to subscriber, campaign and performance data and let it drive decisions on how to optimize ongoing prospect and customer engagement.

Data Definitions

Take a look at our data definition docs for Salesforce Email Studio layout and elements.

Delivery Time

We collect data based on your scheduling preferences in the Salesforce Marketing Cloud console. For example, you schedule a job in Exacttarget which runs at 2AM EST to deliver all “click” data for the prior day. This means on data delivered at 2AM on July 10th will contain all the click data for July 9th.

Developer Docs

Check out Salesforce Marketing Cloud Developer docs for more details.

Google DoubleClick Search

Empower your brand to find new pathways to make smarter, more informed decisions. Optimize ongoing search campaign and keyword performance with the data from DoubleClick Search

Data Definitions

Take a look at our data definition docs for DoubleClick Search layout and elements.

Delivery Time

We collect data once a day. For example, a request to DoubleClick Search API on July 3rd would return data for July 2nd. This ensures you have completed daily views for each reporting period. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Google Developer docs for more details.

Salesforce Advertising Studio

Unlock Advertising Studio data to understand customer, spend, and social advertising performance. Assess, model, explore and drive customer engagement and maximize your investments in paid social advertising.

Data Definitions

Take a look at our data definition docs for Salesforce Advertising Studio layout and elements.

Delivery Time

Delivery time is between 2AM and 6AM EST. The typical approach is to deliver data for the prior day activity. This means on data delivered at 2AM on July 10th will contain all the Advertising Studio data for July 9th. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Salesforce Marketing Cloud Developer docs for more details.

YouTube Competitor

Track your competitors’ channel data to get insight about how you perform and adjust your video content strategies to stand out from the competition.

Data Definitions

Take a look at our data definition docs for YouTube Competitor layout and elements.

Delivery Time

We collect data from the YouTube Analytics API once a day. This ensures we are within the limits YouTube places on API calls.

Developer Docs

Check out the YouTube Developer docs for more details about YouTube API.

Adobe Clickstream

The Adobe Clickstream data bridge allows you to extract clickstream data residing in Adobe Analytics system.

Data Definitions

Clickstream data can be very wide with over 500+ columns. There are also collections of helper files to support browser, devices, etc. lookups. You can a sample set of data elements in our data defintion doc

Delivery Time

Adobe delivers once a day. Data for each day is delivered after it is processed by Adobe, typically in the early AM hours. The data may arrive from Adobe as a single zipped file, or in multiple zipped files each containing approximately 2 GB of uncompressed data. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

For detailed Adobe Clickstream technical specifications, please refer to Adobe documentation

NCR Aloha Point of Sale

Powerful consumer purchase and loyalty behavioral data direct from NCR Aloha POS

Data Definitions

Take a look at our data definition docs for NCR Aloha POS layout and elements.

Delivery Time

The frequency we collect the data from Aloha is configurable. In many cases the frequency most select is daily. We are happy to discuss options related to the frequency of data retrieval. The data is typically loaded into your Openbridge account within minutes of arriving.

Sizmek Ad IQ

Sizmek Ad IQ delivers comprehensive access to your campaign and advertising performance data.

Data Definitions

Take a look at our data definition docs for Sizmek Ad IQ layout and elements.

Delivery Time

We collect data once a day. We collect data for the prior day’s activity. For example, a request on July 3rd would return data for July 2nd. More frequent requests could result in partial or no responses from Sizmek for the requested metrics. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Sizmek docs for more details about Sizmek MDX Trafficking API.

Adobe Data Warehouse

Data Definitions

Adobe Data Warehouse Reports data is tailored to your report builder queries. As a result there is no standard layout. Our system will automatically detect the custom layout and use it to define your table in your data warehouse. We have provided a sample layout here

Delivery Time

The delivery schedule is something you can setup in Adobe. Adobe delivers once a day. Data for each day is delivered after it is processed, typically in the early AM hours. The data is typically loaded into your Openbridge account within minutes of arriving.

Google DFA Reports

Define the reports in DoubleClick Campaign Manager and we will deliver them to your own private data warehouse.

Data Definitions

Take a look at our data definition docs for a sample DoubleClick DFA Report layout and elements.

Delivery Time

We collect data once a day. For example, a request to Google DFA Reporting API on July 3rd would return data for July 2nd. This ensures you have completed daily views for each reporting period. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Google Developer docs for more details.

Movio Cinema

Movio Cinema data bridge unleashes the full potential of your data. Tap into member, click, campaign, and segment data to inform decisions on how to optimize prospect and customer engagement strategies.

Data Definitions

Take a look at our data definition docs for Movio Cinema layout and elements.

Delivery Time

We collect data once a day. Movio provides data for the prior day’s activity. For example, when we request data on July 3rd Movio would return data for July 2nd. The data is typically loaded into your Openbridge account within minutes of arriving.

Developer Docs

Check out Movio support docs for more details.