Review Mapping Demandbase

Log in to the DemandBase Account

1. Log in to your Demandbase account.

2. Navigate to the Advertising Tab:

   • Go to the left panel.

   • Click on the Advertising tab.

3. View All Campaigns:

   • You will see a list of all campaigns.

   • Check the most recent available date and the last available date in the date range filter.

4. Sort Campaigns by Domains:

   • Look for the column called Domains.

   • Sort it in descending order.

5. Export Campaigns:

   • Click on the export button at the top right of the table.

   • Download all the campaigns.

   • Note: Ensure you only keep the campaigns with non-zero domains.

6. Export Individual Campaign Files:

   • Click on each campaign one by one.

   • Copy the campaign ID.

   • Click on the export button and save the file with its campaign ID.

   • Repeat this process for all campaigns with non-zero domains.

   • For example, if there are 84 campaigns with non-zero domains, you will have 84 campaign files, each named with its campaign ID.

7. Add Campaign ID Column:

   • Save all the files in a folder, let's say the folder name is demandbase.

   • Open the folder in your Python compiler.

   • Run the following Python script to add the campaign ID column to all campaign files:

     

Upload to Revsure:

1. Log into RevSure

• Go to https://app.revsure.ai and log in.

• Navigate to the Data Hub

• In the top navigation, select Data Hub.

• Click on Data Sources.

3. Add a New Data Source

• Click Add New.

• Select CSV as the data source type.

4. Configure Connection

• Enter Customer Name as Demandbase

• Set System to Demandbase from the dropdown.

• Click Next.

5. Upload the Prepared Files

• Upload the following cleaned CSV files:

• Campaign.csv

• ad_statistics_daily.csv

• CampaignMember.csv

• (Include the activity file, if applicable)