Home Services Resources About Careers Contact

RESOURCES / Articles

Datorama Connectors:
Connect, Collect, and Unify Your Data Sources

September 13, 2021

The global data visualization tools market size is expected to reach $10.8 billion by 2027, rising at a market growth of 11.2% CAGR.
Source: researchandmarkets.com


According to Research and Markets, the data visualization market has witnessed several tool advancements by industry incumbents such as Salesforce, SAP, Microsoft, Alteryx, SAS, Tibco, and Tableau.

Integrating Marketing Data Continues to Be a Challenge

Marketing data is continuously changing with emerging channels, partners and technologies. Every marketer’s mandate is to measure the success of their campaigns against measured KPIs, spend and defined business goals. Savvy Data Marketers must be agile enough to pivot based on the key insights of their consumers’ engagement. Organizing marketing data can be hard and it’s imperative to quickly clean, collect and unify data from disparate sources – online and offline. Unfortunately, this is often easier said than done.

Salesforce Data Management and Visualization

Salesforce Datorama is one of the leading Data Visualization and Marketing Intelligence tools in the industry designed to help marketers understand consumer and commercial marketing trends. Datorama is easy to use and powerful enough to help onboard, clean, connect and visualize marketing information.

Datorama Connectors Simplify Automated Reports and Dashboards

Salesforce Datorama connects different data sources with the help of advanced, AI-powered marketing intelligence and presents reports and customized visuals within attractive, automated dashboards. This is made easier with pre-packaged Datorama connectors, which integrate different data sources to organize, aggregate, perform advanced analytics and generate, AI infused insights. These data connectors also give marketers a chance to import or export data from the Salesforce Marketing Cloud with basic authentication protocols and a click of a button.

Datorama provides so many ways to safely and securely connect preferred data partners and other third-party vendors, but unstructured data can remain a challenge.

Let’s discuss about some of the available custom Datorama connectors which makes managing unstructured data assembly easier.

Salesforce Datorama’s APIConnect, LiteConnect, and TotalConnect Capabilities

Datorama offers:

APIConnect allows access to a library of marketing APIs, popular databases, cloud storage platforms, and big data environments. With the supported APIs Datorama provides, you’re covered by a wide spectrum of the MarTech and AdTech ecosystems.

LiteConnect is the one of the easiest ways to connect to any flat file and instantly visualize it in Datorama. This option is best suitable for ad hoc analytics and non-marketing sources such as sales, geographic, or weather data, because they don’t require any upfront model considerations.

TotalConnect automates data cleansing and data model mapping by using Machine Learning intelligence to analyze data files. It helps dynamically organize your data into the right KPIs, metrics, and classification with built-in data model intelligence.

Salesforce Datorama Marketing Cloud Connectors: Social Studio, Email Studio, and Mobile Studio

Datorama connects data across marketing, advertising, technical, and flat file data sources and maps it to the data model automatically. The marketing cloud connector helps marketers to integrate messaging data for email, journeys, SMS, and mobile push. Following are the connectors available in Datorama marketing cloud:

Social Studio connector helps analyze how social media conversations captured in Social Studio impacts overall marketing performance.

Email Studio connector sheds a light on the performance of email marketing campaigns.

Mobile Studio connector aims to capture the performance of mobile campaigns.

Creating Custom Datorama Data Connectors

Custom connectors are basically API connections that have been developed independently of the Datorama Infrastructure. Datorama API streams integrate with external code based a set of configurations managed from inside the platform. Using independent code, it pulls data from external providers and uploads it to Datorama.

The creation, updates, and management of custom connectors’ configuration and permissions can be performed in the Marketplace connectors screen in Datorama.

datorama data connectors



Some examples of custom connectors configuration files:

{
  “imageUrl”: “url-to-connector-logo”,
  //authentication
  “userPassDetails” : {
    “loginUrl”: “url-to-user-pass-login”
  },
  //profiles
   “profileDetails”: {
    “profilesUrl”: “url-to-profiles-endpoint”
  },
  //data
  “dataDetails”: {
    “dataUrl”: “url-to-get-data”
  },
 “responseType”: “JSON”,
 //mapping
 “preDefinedMappings”: [
   {
       “dimensions”: [
        {
          “internalName”: “date_id”,
          “externalName”: “Date”,
          “type”: “DATE”
        },
        {
          “internalName”: “campaign_name”,
          “externalName”: “campaignName”
        },
        {
          “internalName”: “ad_key”,
          “externalName”: “creativeId”
        },
        {
          “internalName”: “ad_name”,
          “externalName”: “creativeName”
        },
        {
          “internalName”: “media_buy_external_id”,
          “externalName”: “placementId”
        },
        {
          “internalName”: “media_buy_name”,
          “externalName”: “placementName”
        },
        {
          “externalName”: “clientId”
        },
        {
          “externalName”: “networkId”
        }
      ],
      “measurements”: [
      {
          “internalName”:
          “human_impressions”,

          “externalName”: “maskedImpression”
        },
        {
          “internalName”: “unblocked_impressions”,
          “externalName”: “safeImpression”
        },
        {
          “internalName”: “non_human_impressions”,
          “externalName”: “unmaskedImpression”
        },
        {
          “internalName”: “blocked_impressions”,
          “externalName”: “unsafeImpression”
       },
      ],
      “buckets”: [
        “AD_VERIFICATION”
      ]
    }
  ],
  “schemaMapping”: [
    {
      “schemaField”: “date_id”,
      “schemaType”: “REMOVE”,
      “buckets”: [
        “AD_VERIFICATION”
      ]
    },
    {
      “schemaField”: “campaign_advertiser”,
      “schemaFieldFormula”: “EXTRACT(csv[‘campaignName’],’_’,0)”,
      “buckets”: [
        “AD_VERIFICATION”
      ]
    }
  ],
  “serverErrorSleep”: “2000”,
  “serverErrorTries”: “3”
}

{
  “imageUrl”: “url-to-connector-logo”,
  //authentication
  “auth2Details”: {
    “authUrl”: “url-to-authurization-see-details-eof”,
    “tokenUrl”: “url-to-token”,
    “accountUrl”: “url-to-get-account-details”
  },
  //data
  “pollingDetails”: {
  “requestUrl”: “url-to-start-job”,
  “statusUrl”: “url-to-check-job”,
  “dataUrl”: “url-to-get-data”
},
“responseType”: “POLLING”,
“serverPollingSleep”: 5000, //in milliseconds
“serverPollingTries”: 3,
//extended properties
  “extendedProperties”: [
    {
      “key”: “extendedPropertyKey”,
      “label”: “Extended Property Label”,
      “type”: “COMBOBOX”,
      “note”: “Extended Property Note (may contain Html tags like <br>)”,
    }
  ],
  //mapping
  “manualMappings”: [
   {
      “dimensions”: [
        {
          “externalName”: “Profile Id”
        },
        {
          “externalName”: “Profile”
        },
        {
          “externalName”: “Status”
        }
        ],
      “measurements”: [
        {
          “externalName”: “Users”
        }
      ],
      “buckets”: [“ALL”]
    }
  ],
  “serverErrorSleep”: “10000”,
  “serverErrorTries”: “2”,
}
Source: Datorama.com

Some of the other popular custom, data connectors include:

  • Baidu API Connector
  • Twitter Public API Connector
  • YouTube Public API Connector
  • Integrate API Connector
  • Performance Horizon API Connector

How Many Connectors Does Datorama Have?

As of October 24, 2021, the actual number of Datorama data connectors is 167, including (123) for integrating with marketing vendors, (8) for flat-file ingestion, (34) for integrating with popular data platforms such AWS, SAP, and Oracle and finally, two (2) covering Datorama’s Native Total Connect and Total Lite Connect tools.

167 Datorama data connectors

Although the volume of data connectors is often used as a competitive metric, it may not be the correct proof point to consider value. Connectors are only as good as what’s in them. As an example, a vendor might state they have 5 custom, data connectors for Adobe Analytics. Each retrieving various data points. However, if those 5 connectors fail to ingest your specific metrics or dimensions, is it useful? Instead, focus on the ways in which a platform allows you to onboard your specific data needs. As an example, 350 data connectors may mean nothing to a Publisher if none of their SSP partners are supported.

Datorama continues to develop new data connectors for a variety of purposes as the market evolves, but provides the flexibility to create custom API connections of your own using JSON/Python.

Get Expert Datorama Salesforce Implementation Support

Decision Foundry is a tier-one Datorama partner years of hard-earned platform experience, and four Salesforce Marketing champions. We are a certified partner that offers a combination of design, engineering, user experience, and data science, to deliver accurate and insightful dashboards.

Our implementation process increases confidence our clients’ data strategy, dashboard builds, and ability to act on credible marketing insights.

Partner with one of Datorama’s leaders in Data Management. We will create custom data connectors, document, build, and automate a new reporting solution for you, or extend the value of your existing reporting infrastructure. Contact us for a brief discovery call.