Freshsales CRM Data Export

What is Freshsales CRM?

With Freshsales CRM (Freshwoks) your team can use AI-based lead scoring, phone, email, activity capture, and more. Freshsales CRM bridges the capabilities of CRM, Marketing Automation and AI to provide unified experience for sales and marketing teams.

How to add a Freshsales CRM Source in Electrik.AI?

Follow these steps to connect your Freshsales CRM account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Freshsales CRM Connection in Electrik.AI

a. Freshsales CRM Domain Name.

b. API Key

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Dashboard - ElectrikAI

Step 4: Select the Connections Icon in the left most panel and Click on “Add” button on the top.

Select the Connection icon from right most panel - Electrik AI

Step 5: The Source default tab is selected just click on “Freshsales CRM” connection.

The Source default tab is selected just click on “Freshsales CRM” connection - ElectrikAI

Step 6: Enter your Freshsales Domain URL and API Key.

Conn-Enter your Freshsales Domain URL and API Key - ElectrikAI

Step 7: Click on Save button on the top. 

Conn-Click on the Save button on the top - ElectrikAI

Congratulations, you have now successfully created a Freshsales CRM Connection in Electrik.AI.

Congratulations, you have now successfully created Freshsales Connection in ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following databases to export Freshsales CRM Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI

How to export Freshsales CRM Data?

Electrik.AI creates a data flow (or ETL process) that exports Freshsales CRM data of your choice to a target database or data warehouse. This process runs daily at scheduled time and exports data.

Follow these steps to create a Data Flow from Freshsales CRM to Database

Step 1: Ensure you have the following prerequisites.
1. Access to Freshsales CRM.
2. Freshsales CRM Domain URL and API Key.
3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password
Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard.

Select IO in Dashboard - ElectrikAI

Step 4: Click on Add button to create a Freshsales CRM Performance Data Extractor Flow.

Select the Connection icon from right most panel - Electrik AI

Step 5: Select Freshsales CRM Connection present in the list of available sources.

Select Freshsales CRM Connection - ElectrikAI

Step 6: Select your existing Freshsales CRM connection in Electrik.AI.

Select your existing Freshsales CRM connection - ElectrikAI

To Configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.
In this example we are choosing BigQuery.

Click on a destination of your choice from list of available destinations - ElectrikAI

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Select your existing BigQuery connection - ElectrikAI

Step 9:
a. Choose the desired report to get the appropriate data. In this example we are choosing Account. 

Choose the desired report to get the appropriate data of Freshsales CRM - ElectrikAI

b. Review the Data Source, Data Destination, Data Set, Report Name, Provide Success Notification Email, Failure Notification Email.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Save and Proceed to continue Freshsales CRM - ElectrikAI

Note: By Default, Electrik.AI chooses an existing Data Set to load your Freshsales CRM Report. You can create a new Dataset in your bucket by selecting the “Create Data Set” radio button.
Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen - ElectrikAI

Congratulations, you have now successfully setup Freshsales CRM Performance Report to BigQuery flow in Electrik.AI.

Congratulations you have now successfully setup Freshsales CRM - ElectrikAI

Your Freshsales CRM data will start loading after 24 hours in your Data Set.

Note: Following reference tables will also get created and populated for maintaining ids and names of respective existing users, deals, leads and sales views – fs_deal_stages; fs_owners; fs_deal_reasons; fs_deal_types; fs_lead_sources; fs_contact_statuses; fs_sales_activity_types; fs_sales_activity_outcomes; fs_sales_activity_entity_types; fs_industry_types; fs_business_types; fs_currencies; fs_deal_payment_statuses.
New-Your Freshworks CRM data will start loading after 24 hours in your Data Set

Freshsales Data Schema

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionactive_sales_sequencesActive Sales Sequence
2DimensionaddressAddress of the account
3Metricannual_revenueAnnual revenue of the account
4Dimensionbusiness_type_idID of the business that the account belongs to
5DimensioncityCity that the account belongs toLondon
6Dimensioncompleted_sales_sequencesCompleted Sales Sequence
7DimensioncountryCountry that the account belongs tounited kingdom
8Dimensioncreated_atAccount creation timestamp2020-07-15t14:59:27-04:00
9Dimensioncustom_fieldCustom Fields{“cf_operating_system”:null, “cf_database”:null,”cf_type”:null, “cf_description”:null, “cf_account_id”:null, “cf_dm”:null,”cf_fax_number”:null, “cf_account_type”:null}
10Dimensiondomain_nameName of Freshworks domaintoranainc.freshsales.io
11DimensionfacebookFacebook username of the accounthttps://www.facebook.com/sainsburys
12DimensionidUnique ID of the account2010226311
13Dimensionindustry_type_idID of the industry that the account belongs to
14Dimensionis_deletedSet to true if the account has been deletedFALSE
15Dimensionjob_titleJob Title
16Dimensionlast_assigned_atLast Assigned At2020-07-15t14:59:28-04:00
17Dimensionlast_contactedLast Contacted2019-07-25t08:58:28-04:00
18Dimensionlast_contacted_modeLast Contacted Modeemail outgoing
19Dimensionlast_contacted_sales_activity_modeLast Contacted Sales Activity Modetask
20Dimensionlast_contacted_via_chatLast Contacted via chat
21Dimensionlast_contacted_via_sales_activityLast Contacted via sales activity2020-07-15t14:59:28-04:00
22DimensionlinkedinLinkedIn account of the accounthttps://www.linkedin.com/company /sanbury-corporation
23DimensionlinksLinks{“conversations”:”/sales_accounts/ 2010226311/conversations/ all?include=email_conversation _recipients%2Ctargetable%2Cphone _number%2Cphone_caller%2Cnote%2 Cuser&per_page=3″, “document_associations”: “/sales_accounts/2010226311 /document_associations”,
“notes”:”/sales_accounts /2010226311/notes?include =creater”,”tasks”:”/ sales_accounts/2010226311 /tasks?include=creater, owner,updater,targetable ,users,task_type”,”appointments” :”/sales_accounts/2010226311/ appointments?include=creater,
owner,updater,targetable, appointment_attendees, conference,note”}
24DimensionnameName of the accountsainsbury’s
25Dimensionnumber_of_employeesNumber of employees in the account1
26Dimensionopen_deals_amountOpen Deals Amount0
27Dimensionopen_deals_countOpen Deals count0
28Dimensionowner_idID of the user to whom the account has been assigned2000053454
29Dimensionparent_sales_account_idParent account id of the account
30DimensionphonePhone number of the account
31Dimensionrecent_noteRecent Note
32Electrik.AIsha_idHashed primary key1e86eab9b22a13a9059fdeae70c 142c2d6e9261070b2c1 ad2164bd5d9bc7535d
33DimensionstateState that the account belongs toengland
34DimensiontagsTags[]
35Dimensionteam_user_idsTeam User Id
36Dimensionterritory_idID of the territory that the account belongs to
37DimensiontwitterTwitter username of the accounthttps://twitter.com/sainsburys
38Dimensionupdated_atAccount updated timestamp2020-07-15t14:59:27-04:00
39Dimensionview_idView Id2001139014
40Dimensionview_nameView NameAll Accounts
41DimensionwebsiteWebsite of the accountsainsburys.co.uk
42Dimensionwon_deals_amountWon deals amount.0
43Dimensionwon_deals_countWon deals count.0
44DimensionzipcodeZipcode of the region that the account belongs to
45Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
46Electrik.AIetl_orgOrganization IdORG000097
47Electrik.AIetl_projectProject IdPR000154
48Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
49Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
50Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
51Electrik.AIetl_flow_nmEAI Flow CodeFL001282
52Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionactive_sales_sequencesActive sales sequences
2DimensionaddressAddress of the contact650, newport centre drive
3Dimensioncampaign_idThe campaign that led your contact to your web app.
4DimensioncityCity that the contact belongs tonewport beach
5Dimensioncompleted_sales_sequencesCompleted sales sequences
6Dimensioncontact_status_idID of the contact status that the contact belongs to
7DimensioncountryCountry that the contact belongs tounited states
8Dimensioncreated_atContact creation timestamp2019-02-26t05:20: 04-05:00
9Dimensioncustom_fieldCustom field{“cf_salutation”:null, “cf_type_of_contact”:null, “cf_visitor_id”:null, “cf_home”:null,”cf_fax”:null, “cf_alt_address”:null, “cf_alt_city”:null, “cf_alt_state”:null, “cf_alt_zip_code”:null, “cf_alt_country”:null, “cf_description”:null, “cf_lead_source”:null,
“cf_contact_id”:null}
10Dimensioncustomer_fitCustomer fit0
11DimensiondepartmentDepartment
12Dimensiondisplay_nameDisplay namekaran garg
13Dimensiondo_not_disturbDo not disturbFALSE
14Dimensiondomain_nameDomain nametoranainc. freshsales.io
15DimensionemailPrimary email address of the contactkaran.garg@pimco.com
16Dimensionemail_statusEmail Statusactive
17DimensionemailsEmail addresses of the lead[{“id”:2008355436,”value”: “karan.garg@pimco.com”,”is_primary”:true, “label”:null,”_destroy”:false}]
18DimensionfacebookFacebook username of the contact
19Dimensionfirst_nameFirst name of the contactkaran
20Dimensionhas_authorityFALSE
21DimensionidUnique ID of the contact2.01E+09
22Dimensionis_deletedFALSE
23Dimensionjob_titleDesignation of the contact in the account he belongs toconsultant
24DimensionkeywordThe keywords that the contact used to reach your website/web app
25Dimensionlast_assigned_atLast assigned at2019-02-26t05: 20:05-05:00
26Dimensionlast_contactedLast contacted datetime2019-05-15t14: 40:07-04:00
27Dimensionlast_contacted_modeLast contacted modeemail incoming
28Dimensionlast_contacted_sales _activity_modeLast contacted sales activity modeemail
29Dimensionlast_contacted_via_chatLast contacted via chat
30Dimensionlast_contacted_via_ sales_activityLast contacted via sales activity2019-05-15t14 :40:07-04:00
31Dimensionlast_nameLast name of the contactgarg
32Dimensionlast_seenLast seen
33Dimensionlead_qualityLead qualitywarm
34Metriclead_scoreLead score69
35Dimensionlead_source_idID of the source where contact came from
36DimensionlinkedinLinkedIn account of the contact
37DimensionlinksLinks{“conversations”:”/contacts /2011101968/conversations/all? include=email_conversation_ recipients%2Ctargetable%2C phone_number%2Cphone_caller %2Cnote%2Cuser&per_page=3″, “timeline_feeds”:”/contacts /2011101968/timeline_feeds”, “document_associations”:”
/contacts/2011101968/document_ associations”,”notes”:”/contacts /2011101968/notes?include=creater”, “tasks”:”/contacts/2011101968 /tasks?include=creater,owner, updater,targetable,users, task_type”,”appointments”: “/contacts/2011101968
/appointments?include= creater,owner,updater, targetable,appointment_ attendees,conference, note”,”reminders”:”/ contacts/2011101968/ reminders?include= creater,owner,updater, targetable”,”duplicates”: “/contacts/2011101968/ duplicates”,”connections”:
“/contacts/2011101968/ connections”}
38DimensionmediumThe medium that led your contact to your website/ web app
39Dimensionmobile_numberMobile phone number of the contact
40Metricopen_deals_amountDeal Amount0
41Metricopen_deals_ countDeals count0
42Dimensionowner_idID of the user to whom the contact has been assigned
43Dimensionphone_numbersPhone number[]
44Dimensionrecent_noteRecent Notes
45Dimensionsales_account_idID of the primary account that the contact belongs to
46Dimensionsales_accountsAccounts which contact belong to
47DimensionstateState that the contact belongs tocalifornia
48Dimensionsubscription_statusStatus of subscription that the contact is in.
49DimensiontagsTags[]
50Dimensionteam_user_idsTeam user id
51Dimensionterritory_idID of the territory that the contact belongs to
52Dimensiontime_zoneTimezone that the contact belongs to
53DimensiontwitterTwitter username of the contact
54Dimensionupdated_atContact updated timestamp2019-02-26t05: 20:04-05:00
55Dimensionview_idView Id
56Dimensionview_nameView Name
57Dimensionweb_form_idsWeb Form Id
58Metricwon_deals_amountWon Deals Amount254000
59Metricwon_deals_countWon Deals Count1
60Dimensionwork_numberWork phone number of the contact+91 7042453697
61DimensionzipcodeZipcode of the region that the contact belongs to92660
62Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
63Electrik.AIetl_orgOrganization IdORG000097
64Electrik.AIetl_projectProject IdPR000154
65Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
66Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
67Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
68Electrik.AItl_flow_nmEAI Flow CodeFL001282
69Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910 144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionactive_sales_sequencesActive sales sequences
2Dimensionageage130
3Metricamountamount75000
4Metricbase_currency_amountbase_currency_amount75000
5Dimensioncampaign_idcampaign_id
6Dimensionclosed_dateclosed_date
7Dimensioncollaborationcollaboration{}
8Dimensioncompleted_sales_sequencescompleted_sales_sequences
9Dimensioncreated_atcreated_at2021-02-03t12:29:58-05:00
10Dimensioncurrency_idcurrency_id
11Dimensioncustom_fieldCustom field{“cf_bottleneck”:null, “cf_pricing_model”:null, “cf_how_did_they_find_us” :null,”cf_use_cases”:null, “cf_why_us”:null, “cf_why_now”:null, “cf_description”:null, “cf_lead_source”:null, “cf_next_step”:null, “cf_deal_id”:null}
12Metricdeal_freddy_metricsDeal freddy metrics
13Dimensiondeal_payment_status_idDeal payment status id
14Dimensiondeal_pipeline_idDeal pipeline id36240
15Dimensiondeal_product_idDeal product id
16Dimensiondeal_reason_idDeal reason id
17Dimensiondeal_stage_idDeal stage id2000261063
18Dimensiondeal_tagDeal tag
19Dimensiondeal_type_idDeal type id
20Dimensiondomain_nameDomain nametoranainc.freshsales.io
21Dimensionexpected_closeExpected close13-10-2021
22Metricexpected_deal_valueExpected deal value75000
23Dimensionfc_widget_collaborationFc widget collaboration{“convo_token”: “eyJ0eXAiOiJKV1QiLCJhb GciOiJIUzI1NiJ9.eyJDb 252b0lkIjoiMjAwNDk4MD g1OSIsInR5cGUiOiJkZWFs In0.hmzjSzu9aNujQnpYqt2 jMS2Sy6Qo4k44UahS_VTovRI”, “auth_token”:”eyJ0eXAiOi JKV1QiLCJhbGciOiJIUzI1NiJ9. eyJVc2VyVVVJRCI6IjE4NzU2ODY 4NTI2MzU4ODcwNyJ9.uYrxFEl_7
6HJlgzbyuTiJbSjGB_DoBCJe0F4n C4jp8g”,”encoded_jwt_token” :”eyJ0eXAiOiJKV1QiLCJhbGciO iJIUzI1NiJ9.eyJwcm9kdWN0Ijo iZnJlc2hzYWxlcyIsImNvbnRleHR faWQiOiIyMDA0OTgwODU5IiwiY 29udGV4dF90eXBlIjoiRGVhbCI sInByb2R1Y3RfYWNjb3VudF9pZ CI6IjQ3NjMxIiwicHJvZHVjdF9h
Y2NvdW50X2RvbWFpbiI6InRvcm FuYWluYy5mcmVzaHNhbGVzLmlv IiwidXNlcl9lbWFpbCI6InBlcnJ 5LndAdG9yYW5haW5jLmNvbSIsIm lzX3NlcnZlciI6dHJ1ZSwiZXhwI joxNjIzNTY4NjYyfQ.GmmEoz4G RxiPF42jJM_ZSiDSd0HOc9HYw_ 6ryHQnILI”}
24Dimensionforecast_categoryForecast category2
25Dimensionidid2004980859
26Dimensionis_deletedis_deletedFALSE
27Dimensionlast_assigned_atLast assigned at2021-02-03t12: 29:59-05:00
28Dimensionlast_contacted_sales_activity_modeLast contacted sales activity mode
29Dimensionlast_contacted_via_sales_activityLast contacted via sales activity
30Dimensionlead_source_idLead source id
31Dimensionlinkslinks{“conversations”: “/deals/2004980859/ conversations/all? include=email_ conversation_ recipients%2Cta rgetable%2Cphone_ number%2Cphone_ caller%2Cnote%2 Cuser&per_page=3”, “document_associations” :”/deals/2004980859/ document_associations”,
“notes”:”/deals/2004980859 /notes?include=creater”, “tasks”:”/deals/2004980859 /tasks?include=creater, owner,updater,targetable, users,task_type”, “appointments”:”/deals /2004980859/appointments ?include=creater,owner, updater,targetable,
appointment_attendees, conference,note”}
32Dimensionnamenameon it
33Dimensionowner_idOwner id
34MetricprobabilityProbability100
35Dimensionrecent_noteRecent note
36Dimensionrotten_daysRotten days
37Dimensionsales_account_idSales account id
38Dimensionstage_updated_timeStage updated time2021-02-03t12:29:58-05:00
39Dimensiontagstags[]
40Dimensionteam_user_idsteam_user ids
41Dimensionterritory_idTerritory id
42Dimensionupcoming_activities_timeUpcoming activities time
43Dimensionupdated_atUpdated at2021-02-03t12:29:58-05:00
44Dimensionview_idView id
45Dimensionview_nameView name
46Dimensionweb_form_idWeb form id
47Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
48Electrik.AIetl_orgOrganization IdORG000097
49Electrik.AIetl_projectProject IdPR000154
50Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
51Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
52Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
53Electrik.AItl_flow_nmEAI Flow CodeFL001282
54Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910 144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionactive_sales_sequencesActive sales sequences
2DimensionaddressAddress of the lead
3Dimensioncampaign_idThe campaign that led your lead to your web app.
4DimensioncityCity that the lead belongs to
5DimensioncompanyCompany{“id”:2031219716,”name” :”Deloitte”,”address”: “30 Rockefeller Plaza”, “city”:”New York”,”state”: “New York”,”zipcode”:”10112″, “country”:”United States”, “number_of_employees”:10001, “annual_revenue”:null, “website”:”deloitte.com”, “phone”:”+1
(212) 492-1600″, “industry_type_id”:null, “industry_type”:null, “business_type_id”:null, “business_type”:null}
6Dimensioncompany_addressAddress of the company that the lead belongs to30 rockefeller plaza
7Metriccompany_annual_revenueAnnual revenue of the lead’s company
8Dimensioncompany_business_type_idID of the business that the lead’s company belongs to
9Dimensioncompany_cityCity that the lead’s company belongs tonew york
10Dimensioncompany_countryCountry that the lead’s company belongs tounited states
11Dimensioncompany_idCompany id2031219716
12Dimensioncompany_industry_type_idID of the industry that the lead’s company belongs to
13Dimensioncompany_nameName of the company that the lead belongs todeloitte
14Dimensioncompany_number_of_employeesNumber of employees in the lead’s company10001
15Dimensioncompany_phonePhone number of the lead’s company+1 (212) 492-1600
16Dimensioncompany_stateState that the leads’ company belongs tonew york
17Dimensioncompany_websiteWebsite of the lead’s companydeloitte.com
18Dimensioncompany_zipcodeZipcode of the region that the lead’s company belongs to10112
19Dimensioncompleted_sales_sequencesCompleted sales sequences
20DimensioncountryCountry that the lead belongs to
21Dimensioncreated_atLead creation timestamp2019-03-06t06:49:34-05:00
22Dimensioncustom_fieldCustom field{“cf_alternate_email”:null, “cf_consulting_company”:null, “cf_visitor_id”: “VID48eff1b4-49b9-a3e7-3b03-6d4afd43380f”, “cf_client_id”:null,”cf_alt_address”:null, “cf_alt_city”:null,”cf_alt_state”:null, “cf_alt_zipcode”:null,”cf_alt_country”
:null,”cf_lead_id”:null,”cf_home”:null, “cf_fax”:null,”cf_description”:null}
23DimensiondealDeal
24Metricdeal_amountValue of the lead’s deal
25Metricdeal_base_currency_amountValue of the lead’s deal amount in base currency
26Dimensiondeal_currency_idID of the currency that the lead’s deal belongs to
27Dimensiondeal_expected_closeThe date when the deal is expected to close
28Dimensiondeal_nameName of the lead’s deal
29Dimensiondeal_product_idID of the product that the lead’s deal belongs to (in a multi product company)
30DimensiondepartmentDepartment
31Dimensiondisplay_nameDisplay namevenkatesh goud maadhu
32Dimensiondo_not_disturbDo not disturbFALSE
33Dimensiondomain_nameDomain nametoranainc.freshsales.io
34DimensionemailPrimary email address of the leadvmaadhu@deloitte.com
35Dimensionemail_statusEmail statusactive
36DimensionemailsEmail addresses of the lead[{“id”:2023722322,”value”: “vmaadhu@deloitte.com”, “is_primary”:true,”label”: null,”_destroy”:false}]
37DimensionfacebookFacebook account of the lead
38Dimensionfirst_nameFirst name of the leadvenkatesh
39Dimensionhas_authorityHas authorityFALSE
40DimensionidUnique ID of the lead2031219716
41Dimensionis_deletedFALSE
42Dimensionjob_titleDesignation of the lead in the company he belongs to
43DimensionkeywordThe keywords that the lead used to reach your website/web app
44Dimensionlast_assigned_atLast assigned at2019-03-06t06:49:35-05:00
45Dimensionlast_contactedLast contacted
46Dimensionlast_contacted_modeLast contacted mode
47Dimensionlast_contacted_sales_ activity_modeLast contacted sales activity mode
48Dimensionlast_contacted_via_chatLast contacted via chat
49Dimensionlast_contacted_via_sales_activityLast contacted via sales activity
50Dimensionlast_nameLast name of the leadgoud maadhu
51Dimensionlast_seenLast seen
52Dimensionlead_qualityLead qualitycold
53Dimensionlead_reason_idID of the lead reason – Reason to unqualify the lead
54Dimensionlead_scoreLead score0
55Dimensionlead_source_idID of the source where lead came from
56Dimensionlead_stage_idID of the lead stage that the lead belongs to
57DimensionlinkedinLinkedIn account of the lead
58DimensionlinksLinks{“conversations”: “/leads/2031219716/conversations /all?include=email_conversation_ recipients%2Ctargetable%2Cphone_ number%2Cphone_caller%2Cnote%2Cuser &per_page=3″,”timeline_feeds” :”/leads/2031219716/timeline_feeds”, “document_associations”:”/leads/
2031219716/document_associations”, “notes”:”/leads/2031219716/notes? include=creater”,”tasks”:”/leads/ 2031219716/tasks?include=creater, owner,updater,targetable,users,task _type”,”appointments”:”/leads/ 2031219716/appointments?include
=creater,owner,updater,targetable, appointment_attendees,conference, note”,”reminders”:”/leads/ 2031219716/reminders?include= creater,owner,updater, targetable”,”duplicates”: “/leads/2031219716/duplicates”, “connections”:”/leads/2031219716/
connections”}
59DimensionmediumThe medium that led your lead to your website/ web app
60Dimensionmobile_numberMobile phone number of the lead
61Dimensionowner_idID of the user to whom the lead has been assigned.
62Dimensionphone_numbersPhone numbers[]
63Dimensionrecent_noteRecent noteinterested in: • etl & data warehouse testing • bi report testing • data migration testing • data monitoring & compliance • data lake & big data testing • devops
64Dimensionstage_updated_timeStage updated time2019-03-06t06:49:34-05:00
65DimensionstateState that the lead belongs to
66Dimensionsubscription_statusStatus of subscription that the contact is in
67DimensiontagsTags[]
68Dimensionteam_user_idsTeam user id
69Dimensionterritory_idID of the territory that the lead belongs to
70Dimensiontime_zoneTimezone that the lead belongs to
71DimensiontwitterTwitter account of the lead
72Dimensionupdated_atLead updated timestamp2019-03-06t06: 49:50-05:00
73Dimensionview_idView id
74Dimensionview_nameView name
75Dimensionweb_form_idsWeb form ids
76Dimensionwork_numberWork phone number of the lead9573041300
77DimensionzipcodeZipcode of the region that the lead belongs to
78Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
79Electrik.AIetl_orgOrganization IdORG000097
80Electrik.AIetl_projectProject IdPR000154
81Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
82Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
83Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
84Electrik.AItl_flow_nmEAI Flow CodeFL001282
85Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196