Review Mapping 6sense

Mapping View:

In the configuration of the CSV, if you have chosen 6sense as the source system, follow the steps to use CSV as a source system.

 1. Log into Your 6sense Account

• Visit https://6sense.com and sign in with your credentials.

 2. Navigate to the Advertising Tab

• In the left-hand sidebar, click on Advertising.

3. View All Campaigns

• You will see a list of all your campaigns.
• Apply the following filters:
  • Delivery Timeframe: Set to Lifetime.
  • Columns: Select All Columns.

Download Required Reports

You will need to download three files. Follow these steps for each:

A. Campaign Analytics

• Click the Download icon.
• Select Campaign Analytics from the dropdown.
• Apply the relevant filter (refer to the screenshot or filter configuration provided).
• Click Download and save the file as Campaign.csv.

B. Ad Statistics Daily

• Click the Download icon again.
• Select the appropriate option for Ad Statistics Daily.
• Apply the correct filter.
• Click Download and save the file as ad_statistics_daily.csv.

C. Campaign Member

- Repeat the download steps.

- Choose the Campaign Member data.

- Apply the specified filter.

- Click Download and save the file as CampaignMember.csv.

 Prepare the Files

- Remove the first 7 rows.

- Ensure the first row contains the column headers.

- Delete the last row in the file as well.

Upload to RevSure

1. Log into RevSure

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

2. 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 6Sense.
• Set System to 6Sense 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)