Offline Events Part 2: Loading Your Events Manually
Unit Resources And Notes
- Manual Upload Excel Sheet Example (remember to convert to csv before uploading): OfflineEvents_ManualUploadFileExample
- Facebook Developer Documentation on Offline Events (pretty good info here)
- “You should upload transactions within 62 days of the conversion.” – Facebook
- Excel Formula for Splitting First Name from a full name field (remember to replace D12 with your cell reference): =TRIM(LEFT(D12, SEARCH(” “,D12)))
- “” Last Name from full name field (kudos to Excel Tactics, you can read how this Rubik’s Cube of a formula works over there if you’re really bored):
=IF(
ISERROR(
FIND(” “,D12)
),D12,RIGHT(D12,
LEN(D12)-FIND(“~”,
SUBSTITUTE(D12,” “,”~”,
LEN(D12)-LEN(SUBSTITUTE(D12,” “,””))
)
)
)
)