LogoLogo
  • 🦩Overview
  • 💾Datasets
    • Overview
    • Core Concepts
      • Columns & Annotations
      • Type & Property Mappings
      • Relationships
    • Basic Datasets
      • dbt Integration
      • Sigma Integration
      • Looker Integration
    • SaaS Datasets
    • CSV Datasets
    • Streaming Datasets
    • Entity Resolution
    • AI Columns
      • AI Prompts Recipe Book
    • Enrichment Columns
      • Quick Start
      • HTTP Request Enrichments
    • Computed Columns
    • Version Control
  • 📫Syncs
    • Overview
    • Triggering & Scheduling
    • Retry Handling
    • Live Syncs
    • Audience Syncs
    • Observability
      • Current Sync Run Overview
      • Sync History
      • Sync Tracking
      • API Inspector
      • Sync Alerts
      • Observability Lake
      • Datadog Integration
      • Warehouse Writeback
      • Sync Lifecycle Webhooks
      • Sync Dry Runs
    • Structuring Data
      • Liquid Templates
      • Event Syncs
      • Arrays and Nested Objects
  • 👥Audience Hub
    • Overview
    • Creating Segments
      • Segment Priorities
      • Warehouse-Managed Audiences
    • Experiments and Analysis
      • Audience Match Rates
    • Activating Segments
    • Calculated Columns
    • Data Preparation
      • Profile Explorer
      • Exclusion Lists
  • 🧮Data Sources
    • Overview
    • Available Sources
      • Amazon Athena
      • Amazon Redshift
      • Amazon S3
      • Azure Synapse
      • ClickHouse
      • Confluent Cloud
      • Databricks
      • Elasticsearch
      • Kafka
      • Google AlloyDB
      • Google BigQuery
      • Google Cloud SQL for PostgreSQL
      • Google Pub/Sub
      • Google Sheets
      • Greenplum
      • HTTP Request
      • HubSpot
      • Materialize
      • Microsoft Fabric
      • MotherDuck
      • MySQL
      • PostgreSQL
      • Rockset
      • Salesforce
      • SingleStore
      • Snowflake
      • SQL Server
      • Trino
  • 🛫Destinations
    • Overview
    • Available Destinations
      • Accredible
      • ActiveCampaign
      • Adobe Target
      • Aha
      • Airship
      • Airtable
      • Algolia
      • Amazon Ads DSP (AMC)
      • Amazon DynamoDB
      • Amazon EventBridge
      • Amazon Pinpoint
      • Amazon Redshift
      • Amazon S3
      • Amplitude
      • Anaplan
      • Antavo
      • Appcues
      • Apollo
      • Asana
      • AskNicely
      • Attentive
      • Attio
      • Autopilot Journeys
      • Azure Blob Storage
      • Box
      • Bloomreach
      • Blackhawk
      • Braze
      • Brevo (formerly Sendinblue)
      • Campaign Monitor
      • Canny
      • Channable
      • Chargebee
      • Chargify
      • ChartMogul
      • ChatGPT Retrieval Plugin
      • Chattermill
      • ChurnZero
      • CJ Affiliate
      • CleverTap
      • ClickUp
      • Constant Contact
      • Courier
      • Criteo
      • Crowd.dev
      • Customer.io
      • Databricks
      • Delighted
      • Discord
      • Drift
      • Drip
      • Eagle Eye
      • Emarsys
      • Enterpret
      • Elasticsearch
      • Facebook Ads
      • Facebook Product Catalog
      • Freshdesk
      • Freshsales
      • Front
      • FullStory
      • Gainsight
      • GitHub
      • GitLab
      • Gladly
      • Google Ads
        • Customer Match Lists (Audiences)
        • Offline Conversions
      • Google AlloyDB
      • Google Analytics 4
      • Google BigQuery
      • Google Campaign Manager 360
      • Google Cloud Storage
      • Google Datastore
      • Google Display & Video 360
      • Google Drive
      • Google Search Ads 360
      • Google Sheets
      • Heap.io
      • Help Scout
      • HTTP Request
      • HubSpot
      • Impact
      • Insider
      • Insightly
      • Intercom
      • Iterable
      • Jira
      • Kafka
      • Kevel
      • Klaviyo
      • Kustomer
      • Labelbox
      • LaunchDarkly
      • LinkedIn
      • LiveIntent
      • Loops
      • Mailchimp
      • Mailchimp Transactional (Mandrill)
      • Mailgun
      • Marketo
      • Meilisearch
      • Microsoft Advertising
      • Microsoft Dynamics
      • Microsoft SQL Server
      • Microsoft Teams
      • Mixpanel
      • MoEngage
      • Mongo DB
      • mParticle
      • MySQL
      • NetSuite
      • Notion
      • OneSignal
      • Optimizely
      • Oracle Database
      • Oracle Eloqua
      • Oracle Fusion
      • Oracle Responsys
      • Orbit
      • Ortto
      • Outreach
      • Pardot
      • Partnerstack
      • Pendo
      • Pinterest
      • Pipedrive
      • Planhat
      • PostgreSQL
      • PostHog
      • Postscript
      • Productboard
      • Qualtrics
      • Radar
      • Reddit Ads
      • Rokt
      • RollWorks
      • Sailthru
      • Salesforce
      • Salesforce Commerce Cloud
      • Salesforce Marketing Cloud
      • Salesloft
      • Segment
      • SendGrid
      • Sense
      • SFTP
      • Shopify
      • Singular
      • Slack
      • Snapchat
      • Snowflake
      • Split
      • Sprig
      • Stripe
      • The Trade Desk
      • TikTok
      • Totango
      • Userflow
      • Userpilot
      • Vero Cloud
      • Vitally
      • Webhooks
      • Webflow
      • X Ads (formerly Twitter Ads)
      • Yahoo Ads (DSP)
      • Zendesk
      • Zoho CRM
      • Zuora
    • Custom & Partner Destinations
  • 📎Misc
    • Credits
    • Census Embedded
    • Data Storage
      • Census Store
        • Query Census Store from Snowflake
      • General Object Storage
      • Bring Your Own Bucket
        • Bring your own S3 Bucket
        • Bring your own GCS Bucket
        • Bring your own Azure Bucket
    • Developers
      • GitLink
      • Dataset API
      • Custom Destination API
      • Management API
    • Security & Privacy
      • Login & SSO Settings
      • Workspaces
      • Role-based Access Controls
      • Network Access Controls
      • SIEM Log Forwarding
      • Secure Storage of Customer Credentials
      • Digital Markets Act (DMA) Consent for Ad Platforms
    • Health and Usage Reporting
      • Workspace Homepage
      • Product Usage Dashboard
      • Observability Toolkit
      • Alerts
    • FAQs
Powered by GitBook
On this page
  • Getting Started
  • Prerequisites
  • 1. Generate a ChartMogul API Key
  • 2. Connect ChartMogul to Census
  • 3. Connect your Data Warehouse
  • 4. Create your first model
  • 5. Create your first Sync
  • 6. Confirm the data is in ChartMogul
  • Supported Objects and Sync Behaviors
  • FAQ
  • Need help connecting to ChartMogul?

Was this helpful?

  1. Destinations
  2. Available Destinations

ChartMogul

This page describes how to use Census to sync data from your warehouse to ChartMogul.

PreviousChargifyNextChatGPT Retrieval Plugin

Last updated 2 months ago

Was this helpful?

Getting Started

In this guide, we will show you how to connect ChartMogul to Census and create your first sync.

Prerequisites

  • Have your Census account ready. If you need one, now.

  • Have your ChartMogul account ready.

  • Have the proper credentials to access to your data source. See our docs for each supported data source for further information:

1. Generate a ChartMogul API Key

In your ChartMogul account:

  1. Navigate to Profile > View Profile

  2. Scroll down to API Keys

  3. Click New API Keys

  4. Hold onto this API Key for the next section, you'll need it!

2. Connect ChartMogul to Census

  • Click the New Destination button.

  • Select ChartMogul in the dropdown list

  • Paste your ChartMogul account's API Key. Save your connection and if everything is set up correctly, you should see a successful connection test verifying the connection.

3. Connect your Data Warehouse

Please follow one of our short guides depending on your data warehouse technology.

4. Create your first model

Here you have the ability to write SQL queries to select the data you want to see in ChartMogul. (If you already have you data available in a table or view, you can skip this step and connect your sync directly to that).

Once you have created your model, click Save.

5. Create your first Sync

For our sample sync, we're going to update a ChartMogul Customer record.

In the "What data do you want to sync?" section

  • For the Connection, select the data warehouse you connected in step 2

  • For the Source, select the model you created in step 3

Next up is the "Where do you want to sync data to?" section.

  • Pick ChartMogul as the Connection

  • For Object, we will be using Customer

For the "How should changes to the source be synced?" section.

  • Select Update Only

After the required fields, you can add any further fields you like.

Click the Next button to see the final preview, which will have a recap of what will happen when you start the sync.

6. Confirm the data is in ChartMogul

Now go back to ChartMogul, and check that the customer has been updated as expected.

That's it! In 6 steps, you've connected Census and started syncing product data from your warehouse to ChartMogul 🎉

Supported Objects and Sync Behaviors

Census currently supports syncing to the following ChartMogul objects.

Object Name

Supported?

Sync Keys

Behaviors

Customer

✅

Data Source ID + External ID (both are required)

Update or Create, Update

Invoice

✅

External ID

Add

Transaction

✅

External ID

Add

How do I include line items alongside my invoices?

Need help connecting to ChartMogul?

For more details on finding your ChartMogul API keys, you may

Head back to Census and navigate to .

Next we'll define the data you'll send to ChartMogul. Navigate to the page.

Head to the and click the Add Sync button

Now we'll start mapping fields. ChartMogul requires two fields to be mapped: the customer's External ID and their Data Source ID. You can find the Data Source ID by navigating to within ChartMogul and clicking the gear icon next to the Data Source.

Syncs to the ChartMogul Customer object require both the Data Source ID and the External ID to ensure the customer is updated or created as expected. This is necessary because External IDs can be duplicated across Data Sources. You can find the Data Source ID by navigating to in ChartMogul and clicking the gear icon next to the desired Data Source.

Learn more about all of our sync behaviors in our documentation.

if you want Census to support more Chart Mogul objects and/or behaviors

FAQ

Line items must be modelled as a JSON array on the Invoice record itself. This is necessary because Line Items do not have their own endpoint and must be supplied inline on Invoice creation. For an example of how this type of JSON array might look, see the "line_items" .

via support@getcensus.com or start a conversation with us via the chat.

🛫
❓
create a Free Trial Census account
Azure Synapse
Databricks
Elasticsearch
Google BigQuery
Google Sheets
MySQL
Postgres
Redshift
Snowflake
SQL Server
follow ChartMogul's documentation here.
Destinations
Redshift
Postgres
BigQuery
Snowflake
Models
Sync page
this page
this page
Syncs
Contact us
field here within ChartMogul's documentation
Contact us
in-app