P L E A S E  W A I T...

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

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.

North America is expected to account for the largest market size increase during the forecasted period. Asia-Pacific is the most promising regional market and is projected to grow at the highest Compound Annual Growth Rate (CAGR) during the same period. The increased interest for cloud technology in data visualization and the budding demand for better marketing decision making are driving the imperative for data visualization.

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. This is often easier said than done as the demand for analytic talent and platform ease of use can slow adoption and squander technology investments

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.

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 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


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.

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.

ddatorama 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

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.

Get Expert Datorama Salesforce Implementation Support

Nabler is a tier-one, certified Datorama partner, that has completed hundreds of Datorama implementations for many of the largest and most recognizable brands in the world. With seven 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.

Read more articles by Nabler, then have a look at one of our most recent visualization case studies.

We’ll show you just how far we can push your data.

Partner with one of Datorama’s leaders in Data Management. Nabler 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.

Drive better results by understanding customer data