)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce exports maintain your org’s timezone rather than providing UTC standardization, creating problems for global teams analyzing campaign performance across time zones.
Here’s how to export campaign data with proper UTC timestamp conversion for consistent global analysis and system integrations.
Get campaign data with proper UTC timestamps using Coefficient
Coefficient handles timezone conversions automatically and provides tools for UTC standardization. Instead of manual timezone conversion after export, you get consistent timestamp handling across all your campaign data refreshes.
How to make it work
Step 1. Import campaign member data with all datetime fields.
Pull Campaign Member data including CreatedDate, LastModifiedDate, and FirstRespondedDate. Salesforce datetime fields automatically convert to your local timezone during import, giving you a baseline for UTC conversion.
Step 2. Add UTC conversion formulas with auto-fill.
Create formula columns immediately to the right of imported data for UTC conversion: =A2 + TIME(OFFSET_HOURS,0,0) where OFFSET_HOURS accounts for your timezone difference from UTC. Enable formula auto-fill down so new rows automatically get UTC conversion formulas.
Step 3. Set up automated refreshes for consistent timestamp handling.
Configure scheduled refreshes to maintain current timestamp data with consistent UTC conversion. The refresh scheduling operates based on your timezone, but the UTC formulas ensure standardized output regardless of when the refresh runs.
Step 4. Preserve original timestamps while providing UTC equivalents.
Keep both original Salesforce timestamps and UTC converted versions for analysis flexibility. This is particularly valuable when integrating with systems that require UTC timestamps or when analyzing global campaign performance across multiple time zones.
Standardize your global campaign analysis
Stop manually converting timestamps and start getting consistent UTC data automatically. Try Coefficient to handle timezone conversions in your campaign exports seamlessly.
