Supermetrics Support Forum

Display Name Field Changes for Salesforce Feb 2020

We are making some changes to the display names of some fields for our Salesforce connector. As we have been testing the connector, we realized that the names of fields were causing confusion with query setup, especially in Data Studio, so we wanted to rename those to clarify what they are.


This change unfortunately will break some existing queries and formulas using the older names, and will require those queries to be edited to use the newer names. We apologize for the disruption this change may cause for users, but this seemed like the best time to do this adjustment while the connector is still Early Access and not as widely used.


This will take effect on February 11th, 2020. Different products may have different changes, so please check the appropriate table.



The following field display name changes affect Google Sheets, Excel, and Supermetrics API ONLY:


Current Display NameNew Display Name After Update
Year of week (Sun-Sat)Closed year of week (Sun-Sat)
Year of week (Mon-Sun)
Closed year of week (Mon-Sun) in ISO format
Year & week (Sun-Sat)Closed year & week (Sun-Sat)
Week (Mon-Sun)Closed week (Mon-Sun)
Day of monthClosed day of month
Day of week (Sun-Sat)
Closed day of week (Sun-Sat)
Day of week (Mon-Sun)Closed day of week (Mon-Sun) in ISO format




The following field display name changes affect Data Studio ONLY - the duplicates in "Current Display Name" are on purpose, they have new specific names for their type:


Current Display NameNew Display Name After Update
YearClosed year
Year of weekClosed year of week
Year of weekClosed year of week in ISO format
Year & monthClosed year & month
Month
Closed month
Year & week
Closed year & week
WeekClosed week
Day of monthClosed day of month
Day of weekClosed day of week
Day of weekClosed day of week in ISO format
DateClosed date
DescriptionCampaign Description
Last activity dateCampaign last activity date
Last viewed dateCampaign last viewed date
TypeCampaign type
NameOpportunity name
TypeOpportunity type
StageOpportunity stage
Close dateOpportunity close date
Next stepOpportunity next step
Lead sourceOpportunity lead source
ClosedIs opportunity closed
Is WonIs opportunity won
Created dateOpportunity created date
Last modified dateOpportunity last modified date
Last viewed dateOpportunity last viewed date
Last referenced dateOpportunity last referenced date
Account name
Opportunity account name
Account sourceOpportunity account source
Account phoneOpportunity account phone
Account industryOpportunity account industry
Account employee countOpportunity account employee count
Account descriptionOpportunity account description
Account nameContact account name
Birthdate
Contact birthdate
Created dateContact created date
DescriptionContact description
EmailContact email
First nameContact first name
Last NameContact last name
Last activity dateContact last activity date
Last modified dateContact last modified date
Last viewed dateContact last viewed date
Mobile phoneContact mobile phone
Full nameContact full name
TitleContact title
First nameLead first name
Last name
Lead last name
TitleLead title
Phone
Lead phone
EmailLead email



When the changes take place on Feb 11th, 2020, please make sure you update your queries and formulas as needed to work with the new field names. For Data Studio, you will need to refresh your data source field list per How do I Refresh Fields/Update a Connector?


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.