Data Productivity Cloud Pipeline

Quickstart Salesforce Opportunities With Primary Campaign Source

Use this Quickstart Data Productivity Cloud pipeline to generate an integrated report from the Account, Campaign, Opportunity and User Salesforce tables.

Salesforce tables used

  • Account
  • Campaign
  • Opportunity
  • User

Referring to the Salesforce Architects Sales Objects reference:

Image ofSalesforce Entity Relationship Diagram
Salesforce Entity Relationship Diagram

Integrated Salesforce object report table

Output table: mtln_qs_sf_opportunities_with_primary_campaign_source

Granularity: One record per Opportunity

Generating the report

Start by opening the Orchestration pipeline:

Image ofOrchestration pipeline qs-sf-opportunities-with-primary-campaign-source-orch
Orchestration pipeline qs-sf-opportunities-with-primary-campaign-source-orch

Set the default value of the pipeline variable SalesforceOAuthName to the name of your Salesforce OAuth.

Run the Orchestration pipeline. It will sync your Salesforce data, and create the output table using the Transformation pipeline.

Image ofTransformation pipeline qs-sf-opportunities-with-primary-campaign-source-tran
Transformation pipeline qs-sf-opportunities-with-primary-campaign-source-tran

Customizing the Salesforce report

  • Add more fields using the Salesforce Query components in the Orchestration pipeline
  • Add your own Table Inputs to the Transformation pipeline to customize the integration with your own data
  • You may choose to apply filters in the Transformation pipeline, in which case they will apply to all report users. Alternatively, apply filters in your visualization instead

Downloads

Licensed under: Matillion Free Subscription License

Download qs-sf-opportunities-with-primary-campaign-source-orch.orch.yaml

  • Target: Snowflake

Download qs-sf-opportunities-with-primary-campaign-source-tran.tran.yaml

  • Target: Snowflake

Installation Instructions

How to Install a Data Productivity Cloud Pipeline
Author: Matillion
Date Posted: Feb 7, 2024
Last Modified: Feb 7, 2024