ActivTrak’s Salesforce Integration: Data Glossary

Below is an alphabetized list of the different data fields in ActivTrak’s Salesforce integration along with their data type and a short description of each. For a more complete list of the different data fields in ActivConnect Premium, please review the ActivConnect - Premium Data Glossary

 

sf_daily_user_summary

This is a pre-aggregated Salesforce dataset integrated in Bigquery. The key fields are # of leads converted and # of tasks completed.

Field

Type

Definition

at_account_id

INTEGER

ActivTrak account number

at_user_id

STRING

ActivTrak user ID

date

DATE

Date

email

STRING

User email address

first_name

STRING

User first name

last_name

STRING

User last name

leads_converted

INTEGER

# of leads converted. Lead converted means the qualified lead.

sf_user_id

STRING

SalesForce user ID

opps_created

INTEGER

# of opportunities created

task_completed

INTEGER

# of tasks completed

Output Metrics

This is a table created inside PowerBI to store the calculated fields using the raw data from daily_user_sf_summary

Delta Leads Qualified

FLOAT

The delta between individual and group average on # of leads qualified

Delta Tasks Completed Formatted

FLOAT

The formatted delta between individual and group average on # of tasks completed

Delta Opportunities Created Formatted

FLOAT

The formatted delta between individual and group average on # of opportunities created

Delta Leads Qualified Formatted

FLOAT

The formatted delta between individual and group average on # of leads qualified

Delta Opportunities Created

FLOAT

The delta between individual and group average on # of opportunities created

Delta Tasks Completed

FLOAT

The delta between individual and group average on # of tasks completed

Group Avg # of Leads Qualified

FLOAT

The group average of # of leads qualified

Group Avg # of Opportunities Created

FLOAT

The group average of # of opportunities created

Group Avg # of Tasks Completed

FLOAT

The group average of # of tasks completed

Was this article helpful?

0 out of 0 found this helpful

Comments

No comments