top of page

Integrating Account Engagement with CRM Analytics Using External Data APIs?

In today's competitive business landscape, integrating marketing platforms with powerful analytics tools is essential for gaining actionable insights. One such integration is between Salesforce's Account Engagement (formerly Pardot) and CRM Analytics (formerly Einstein Analytics). This integration allows marketers to leverage advanced data visualization and analytics capabilities, leading to more informed decision-making and optimized marketing strategies.

In this blog, we will explore how the integration between Account Engagement and Tableau CRM can be achieved using Salesforce's External Data APIs, specifically focusing on the InsightsExternalData and InsightsExternalPartsData objects. These objects play a crucial role in the data import process, enabling a seamless flow of data from Account Engagement into Tableau CRM.


Understanding the Integration Components


The InsightsExternalData object serves as the foundation for importing data into Tableau CRM. It holds metadata about the dataset being imported, such as the dataset name, format, and the type of operation (e.g., overwrite or append). This object essentially sets up the parameters for the data import process, ensuring that the data is correctly identified and processed once it reaches Tableau CRM.

Example Syntax for InsightsExternalData in Apex

InsightsExternalData data = new InsightsExternalData();

data.Format = 'CSV';

data.EdgemartAlias = 'Account_Engagement_Data';

data.Operation = 'Overwrite';

data. Action = 'None';

insert data;



The InsightsExternalPartsData object complements InsightsExternalData by storing the actual data chunks that will be imported into Tableau CRM. These chunks are Base64 encoded and uploaded sequentially, allowing large datasets to be managed efficiently. This approach ensures that the data is transferred in a structured manner, facilitating accurate and efficient data ingestion.

Example Syntax for InsightsExternalPartsData in Apex

InsightsExternalPartsData part = new InsightsExternalPartsData();

part.InsightsExternalDataId = data.Id;

part.PartNumber = 1;

part.DataFile = EncodingUtil.base64Encode(Blob.valueOf('your_data_chunk_here'));

insert part;

The Integration Flow

The integration flow involves several key steps: preparing and exporting data from Account Engagement, creating the necessary records in Salesforce, uploading data chunks, and finally processing the data in Tableau CRM. Below is an image illustrating this flow:

By following this structured approach, marketers can ensure that their data is accurately imported and ready for analysis in Tableau CRM.

Account Engagement Overview

Account Engagement (formerly Pardot) is Salesforce’s B2B marketing automation solution. It enables marketing and sales teams to work together to find and nurture leads, close more deals, and maximize ROI. Here are some key features:

  • Lead Management: Capture and nurture lead with automated marketing campaigns. Use forms, landing pages, and lead grading to qualify leads before passing them to sales.

  • Email Marketing: Create and deploy personalized email campaigns. Track engagement to understand which messages resonate with your audience.

  • Campaign Management: Plan, execute, and measure the success of marketing campaigns. Use detailed reports to refine your strategies and maximize impact.

  • Lead Scoring and Grading: Prioritize leads based on their interactions with your marketing materials and their fit for your product or service.

CRM Analytics Overview

Tableau CRM (formerly Einstein Analytics) is Salesforce's advanced analytics platform, designed to provide AI-powered insights and predictive analytics. It helps businesses make smarter decisions by uncovering patterns and trends in their data. Key features include:

  • Data Integration: Seamlessly integrate data from multiple sources, including Salesforce, to create a comprehensive view of your business.

  • Advanced Analytics: Use AI and machine learning to analyze data, predict outcomes, and recommend actions.

  • Interactive Dashboards: Create interactive, customizable dashboards that provide real-time insights into your data. Users can drill down into the data to uncover deeper insights.

  • Mobile Accessibility: Access your data and analytics on the go with mobile-optimized dashboards and reports.


Benefits of Integration

Integrating Account Engagement with Tableau CRM offers several benefits:

  • Enhanced Data Visibility: Marketers can visualize and analyse their marketing data in more sophisticated ways, uncovering trends and insights that were previously hidden. Tableau CRM's advanced visualization tools enable a deeper understanding of campaign performance and customer behaviour.

  • Improved Decision-Making: Access to comprehensive analytics helps in making data-driven decisions, optimizing marketing campaigns, and increasing ROI. With detailed insights, marketing teams can refine their strategies to better meet customer needs and market demands.

  • Seamless Data Flow: The use of External Data APIs ensures that data transfer is efficient and reliable, minimizing the risk of errors and data loss. This seamless integration supports continuous data updates, keeping analytics up-to-date and relevant.

  • Scalability: The integration can handle large volumes of data, making it suitable for organizations of all sizes. Whether dealing with small datasets or large-scale data imports, the integration framework is designed to scale and adapt to varying data needs.

Business Scenarios for Pardot Data Integration in Salesforce CRM

  1. Lead Scoring and Sales Prioritization:

  • Pardot captures lead engagement data such as email interactions, form submissions, and website visits. When integrated with Salesforce CRM, this data enriches lead records. Salesforce CRM's analytics capabilities can then prioritize leads based on their engagement levels and readiness to convert. For example, sales teams can focus on leads with high engagement scores, there by increasing conversion rates.

  1. Campaign Performance Analysis:

  • Pardot tracks the performance of marketing campaigns through metrics like email open rates, click-through rates, and landing page conversions. By integrating this data with Salesforce CRM's analytics, marketers gain insights into which campaigns are most effective in generating leads and influencing sales. This helps in optimizing marketing spend and refining future campaign strategies.

  1. Customer Journey Mapping:

  • Integrating Pardot data with Salesforce CRM allows businesses to map the entire customer journey from initial lead capture to conversion and beyond. This holistic view enables marketers to identify touchpoints that drive conversions and upsell opportunities, enhancing overall customer experience and retention strategies.

B2BMA Templated App and its Use Cases

Salesforce's B2B Marketing Analytics (B2BMA) templated app provides pre-built dashboards and reports tailored for B2B marketers. It leverages Pardot and Salesforce CRM data to offer insights into marketing performance, pipeline contribution, and ROI. Key use cases include:

  • Campaign Attribution: Understand which marketing activities contribute most to closed deals and revenue.

  • Pipeline Health Monitoring: Track the progression of leads through the sales pipeline, identifying bottlenecks and optimizing conversion rates.

  • Account-Based Marketing (ABM) Insights: Analyses engagement and conversion metrics at the account level to personalize marketing efforts effectively.

Disadvantages of B2BMA Templated App

While B2BMA offers valuable insights out-of-the-box, some considerations include:

  • Customization Limitations: Templated apps may not fully align with unique business processes or reporting requirements, necessitating additional customization effort.

  • Data Complexity: Integrating data from multiple sources (e.g., Pardot, CRM) into a templated app can be complex, requiring robust data governance and integration strategies.

Real-World Example: Customer Success Story

We recently implemented a Pardot to CRM Analytics integration for a customer who needed to analyze customer behavior on a particular product. By integrating Pardot data into Tableau CRM, we enabled the client to gain detailed insights into how their customers interacted with this product. This integration allowed them to:

  • Enhance Lead Scoring: The integration enriched their lead records with detailed engagement metrics, allowing their sales team to prioritize high-quality leads effectively.

  • Optimize Campaign Performance: They used the analytics capabilities to identify successful marketing campaigns, reallocating resources to maximize ROI.

  • Improve Customer Journey Mapping: With a complete view of the customer journey, they could better understand customer behavior, leading to improved customer retention and upsell strategies.


Integrating Salesforce Account Engagement with Tableau CRM using InsightsExternalData and InsightsExternalPartsData objects transforms how marketing data is analyzed and utilized. This powerful integration enables marketers to gain deeper insights into their campaigns, improve their strategies, and drive business growth.

Whether you're looking to enhance your data analytics capabilities or streamline your marketing operations, this integration is a valuable step towards achieving those goals. Embrace the power of data-driven marketing and unlock the full potential of your marketing efforts with this seamless integration. Are you ready to transform your marketing analytics?

15 views0 comments


bottom of page