Conduit Docs
  • Getting Started
    • Importing Data
    • Connecting Multiple Accounts
    • How To Invite Additional Team Members to Your Account
    • How Does the Trial Work?
    • What's a Table/Data Schema?
    • Number of Sub-Connections
    • Default Time Range for Downloading Data
    • Conduit Data Lake
    • Conduit vs Boost.Space
    • Conduit vs Reportz.io
    • Conduit vs Google Looker Studio
  • Use Cases
    • Use Case: AI-powered Text Extraction
    • Use Case: Track Ad Campaign Performance with Conduit
    • Use Case: Enhancing Project Management with Copilot
    • Use Case: Using Conduit for Financial Analysis
    • Use Case: Use ChatGPT with your data
    • Use Case: Build financial models from raw transactional data and generate P&L statements.
    • Use Case: Marketing data analytics
    • Use Case: Using data science frameworks using your data in spreadsheets Low-Code
    • Use Case: Custom Dimensions for Ad Operations
    • Use Case: Custom dimensions for E-Commerce
    • Use Case: Extract invoices from PDF
    • Use Case: Export data from SaaS applications to your spreadsheet
    • Use Case: Online store and a physical retail locations consolidated
    • Use Case: Pull data from Advertisement platforms to a spreadsheet
    • Use Case: Consolidation of data received as separate files, for example, separate Excel reports
    • Use Case: Names, IDs, SKUs normalization
    • Use Case: Integrating Conduit with a custom CRM using SSO/OAuth2
    • Use Case: Chat Bot for Your Data
    • Use Case: Display Net sales On a Dashboard by Subtracting Ad spend from Total Sales
    • Use Case: Conduit for Healthcare Applications
  • Security & Data Privacy
    • Data Retention Policy
    • How Conduit Complies with GDPR?
    • Security
  • Spreadsheets
    • Writing data to spreadsheets: Overwrite and Update
    • Using Formulas in Spreadsheets
    • The Time Range in formulas
    • The table in the spreadsheet does not start from the first line
  • Conduit for Digital Agencies
    • How to Use White Label
    • What is a Workspace and a Sub-account
    • Use Case: Creating a Dashboard for Two Clients
    • Users in Your Team vs. Sub-Accounts in Workspaces
    • Deleting a Workspace
    • How to Log Into a Workspace
    • How to Buy Additional Workspaces
    • Schedulers in Workspaces
  • Troubleshooting
    • Error codes and how to troubleshoot data-related issues
    • Google Drive Refusing To Connect
    • Why Are my Shopify stats different?
    • Facebook Integration: How to Fix the GraphMethodException Error
  • Copilot
    • Copilot Roles: Data Analyst vs AI Generalist
    • Conduit Copilot vs. ChatGPT – What's The Difference?
    • How to Tune the Copilot
    • Data Sources for Copilot
  • For Developers
    • IP Addresses of Conduit Servers
    • Create an AI Сopilot for your app
    • Manage your AI Copilot users
    • Upload CSV files to Conduit via API (Guide)
  • Integrations
    • Instagram Integration
    • Dashboard Widgets Based On a SQL Connection
    • GA4 Integration Notes
    • Salesloft Integration
    • Self-service and Manual integrations
    • Installing Google Sheets Add-On
    • Slack Integration
    • YouTube Integration
    • HubSpot Integration
    • Conduit integration for Bigcommerce
    • Xero Integration
    • Recharge integration
    • Wrike Integration
    • Zoho Integration
    • Monday.com Integration
    • ActiveCampaign Integration
    • ClickUp Integration
    • FreshSales Integration
    • Google Ads Quality Score
    • Facebook Ads Reach
    • Shopify Net Sales and Returns
    • Gorgias tickets with Spam/Deleted/Auto-Close statuses
    • Looker Studio Connector
  • Workflows
    • Workflows – Adding New Columns
    • Workflows – using the Join by Key block
    • Workflows – using the Union block
    • Workflows – using the Transpose block
    • Workflows – creating a weekly Ad Spend report
Powered by GitBook
On this page
  • Begin by creating a workflow
  • Aggregate Ad Spend across Ad Networks
  • Incorporate Sales Data
  • Merge Ad Spend and Sales Data
  • Create Net Sales Metric
  • View and Validate the Result
  • Display the KPIs on a new Dashboard
Edit on GitHub
  1. Use Cases

Use Case: Display Net sales On a Dashboard by Subtracting Ad spend from Total Sales

PreviousUse Case: Chat Bot for Your DataNextUse Case: Conduit for Healthcare Applications

Last updated 11 months ago

Begin by creating a workflow

Set up a new Workflow and name it 'Sales after Ad Spend'

Aggregate Ad Spend across Ad Networks

Start with summing up the Ad Spend from all advertising networks. For the first network, Facebook, use the "Pull Data" building block.

In this block, specify the integration name, select the business accounts (option to select all), and rename the building block to 'raw_facebook.'

Focus on Ad Spend Only

Since we are interested only in the total ad spend, use the "Create Report" building block and rename it to "total_facebook."

To remove all dimensions, open the breakdown list and click "Clear all," leaving the dimensions list empty.

Then, select the 'Spend' metric

And, review the results

Here is what we should see, as our spend:

Repeat for Additional Networks

For each advertising network, add a "Pull Data" block and strip all dimensions to leave a single line indicating the total ad spend.

Combine Ad Spend Data

To consolidate the ad spend across networks, use the "Union" building block, renaming it "total_adspend." Ensure this union includes only the datasets with dimensions removed.

Incorporate Sales Data

Pull the sales data using another "Pull Data" building block and remove all dimensions here as well.

Merge Ad Spend and Sales Data

Combine the Ad Spend and Sales data into a single dataset using an additional "Union" building block.

The resulting dataset should have two columns.

Create Net Sales Metric

Use another "Create Report" building block, named "Sales after Ad Spend," to derive the net sales metric.

Include the "Add Metric" child building block to define the metric name, type, and formula using the previously created columns.

View and Validate the Result

Click the "View" button to confirm that the dataset now includes the required metric.

Display the KPIs on a new Dashboard

  1. Open the dashboard screen.

  2. Create a new dashboard

  3. Select the Workflow created earlier.

  4. Specify the dataset within the workflow that contains all three metrics.

  5. Click "Create" to finalize the dashboard setup.