loader

HOW TO IMPORT YOUR DATA

 

Please only use one of the following internet browsers
Mozilla Firefox, Google Chrome or Apple Safari.

 

Pensaki-Mailing-process.png

 

Pensaki provides you with two ways to transfer your data.

  • → MANUALLY - by using the Pensaki Excel spreadsheet templates (these might vary by product)
  • → AUTOMATED  - via the Pensaki API (for recurring projects)

Pensaki is an online service, i.e. your total order experience is online. Therefore please do NOT send us any of your data by email.

 

Import file requirements: mandatory stuff

  1. → The Pensaki App exclusively accepts the provided .xls import templates - no other files will be accepted during the import process.
  2. → Please carefully ready the "READ ME" page within the provided import template and DO NOT ERASE the first sheet.
  3. → Don't use any fancy file names when re-naming the import file. The Pensaki App doesn't like special characters within the file names. e.g. this file will not be possible to import  - e.g. this file will never be accepted: Österreich-Kunden-Übungen®-V1.xlsx

 

Data requirements: mandatory stuff (how to avoid bad data)

  1. → You need to eliminate all the very fancy special characters such as º ©Ω‡ ¶ ¿®
  2. → Make sure that field maximum field length The Pensaki App will automatically cuts-off any excess data.
  3. → Make sure that all data excludes non-printing characters

 

Try your best to avoid words with CONSECUTIVE CAPITAL LETTERS - also in names - it's simply looks bad when "handwritten".

  

 

 

 

Structure of the standard Pensaki import file

The Pensaki import files are organized by columns. The maximum number of characters per column written in (). 

Column A (max 40) Column B (max 40) Column C (max 40) Column D (max 10) Column F (max 30) Column G (max 40) Column H (max 58)
Müller & Meier GmbH Peter Meier (persönlich) Musterstrasse 123 68124 Musterhausen Deutschland Dear Peter,
Stefano Brambilla Brambilla & C. Via Bramante 8 20154 Milano Italia Dear Stefano,
Tim Cook (personal) Apple Inc. 1 Infinite Loop 95014 Cupertino, CA USA Dear Tim,
Paul Stewart c/o Number Sixteen 16 Sumner Pl, Kensington SW7 3EG London United Kingdom Dear Paul,
Alphabet Inc. Sergey Brin (private) 1600 Amphitheatre Pkwy 94043 Mountain View, CA USA Dear Sergey,
The White House Barack Obama 1600 Pennsylvania Avenue NW 20500 Washington, DC USA Dear Barack,
             
Envelope> Address_Line1 Envelope> Address_Line2 Envelope> Address_Street Envelope> Address_ZIP Envelope> Address_City Envelope> Address_Country Message > Personal salutation

 

This is how the data will be written on the envelopes, depending on the country:

Result on envelope: Result on envelope: Result on envelope: Result on envelope:
Müller & Meier GmbH
Peter Meier (persönlich)
Musterstrasse 123
68124 Musterhausen
Deutschland
Stefano Brambilla
Brambilla & C.
Via Bramante 8
20154 Milano
Italia
Tim Cook (personal)
Apple Inc.
1 Infinite Loop
Cupertino, CA 95014
USA
Paul Stewart
c/o Number Sixteen
16 Sumner Pl, Kensington
London SW7 3EG
United Kingdom
→ German Case → Italian Case → USA Case → UK Case

Data quality is one of the key success factors of your "handwritten" direct mail campaign. In this context basic SPREADSHEET experiences are of pivotal importance. The usefulness of spreadsheet applications such as Microsoft© Excel, OpenOffice Calc© or Spreadsheet by Google actually extend beyond large databases; they can do a lot of great things with text, too.

 

Personalization Drastically Improves Response Rates

 

You are using Pensaki because you know how important personalization is for your marketing campaigns. Personalization can drastically improve response rates and there are many studies available to prove the increased results personalization generates. "Handwritten" documents are certainly the most personal way of communication, especially in our digital age.

The personalization of the content is for sure the most important success factor. As a standard you can personalize the salutation lines. With Pensaki it's easy to include additional personalization segments within your "handwritten" documents.

e.g. simply put {{url}} into the text as a placeholder and import the data via the provided Xls template. You only need to make sure that the total maximum field length per text line is not exceeded. By using the preview function you will be able to check that your data is correct.. 

Certainly you can change the names within the import template accordingly. It's only important that you use words that are written in lower case without spacings.

e.g.

  • field H3 => url and within the text {{url}}
  • field I3 => city and within the text {{city}}

pensaki-personalization-segments.png

 

 personalization segments.png

 

1. Preparing the data

The physical borders of the “hand written” lettering are defined by the desired format (letter in envelope, A6 postcard, etc) as well as by the writing utensil. The following spreadsheet shows the maximum amount of characters that are possible per field, including spaces. Anything exceeding these lengths will be automatically cut off by the system!

 

2.1 Standard format for letters and compliment cards in envelopes and DIN Long postcards (biro)

Column Reference Example Max characters
A 1. Line Envelope Turner & Turner Ltd. 40
B 2. Line Envelope Jane Doe (personal) 40 
C Street 16 Sumner Place 40 
D Postal Code SW7 3EG 10 
E City London 30 
F Country United Kingdom 40
G Personal Salutation Dear Jane, 58

2.3 Format for addressed DIN Long postcards, written with ink rollerball (210 x 110 mm)

Column Reference Example Max characters
A 1. Line Envelope Turner & Turner Ltd. 30
B 2. Line Envelope Jane Doe (personal) 30 
C Street 16 Sumner Place 30 
D Postal Code SW7 3EG 10 
E City London 20 
F Country United Kingdom 30
G Personal Salutation Dear Jane, 48

 

2.4  Format for addressed DIN A6 postcards (148 x 105 mm) with roller pen/ball pen/biro

Column Reference Example Max characters
A 1. Line Envelope Turner & Turner Ltd. 30
B 2. Line Envelope Jane Doe (personal) 30 
C Street 16 Sumner Place 30 
D Postal Code SW7 3EG 10 
E City London 20 
F Country United Kingdom 30
G Personal Salutation Dear Jane, 32

2. Importing data

After you have created the draft of your text, you can continue with the data import right away. You can correct the text later as often as needed.

step1-import-process.png step2-import-process.png

 

3. Alright, time for a little coffee break ... while Pensaki does the work.

Depending on the size of the file, the import might take 10 minutes at times because of different analysis concerning special characters, field lengths and so on.

You don't need to wait for that to happen. Instead, an email notification will be send to you once the import analysis report is ready.

Please make sure that you have access to your registered email address.

 

4. Automatic error analysis & import of corrected data sets

EN-Explain-Import-Process-new-small.jpg

Now you can conveniently export the error analysis, correct the errors in the spreadsheet and simply import again. The Pensaki system automatically replaces faulty data sets. It couldn't be easier.

Possible error messages:

  • Yellow = Warning & suggestion (for example to refrain from using strung together capital letters)

  • Red = The error needs to be corrected, otherwise the mailing can't be created (for example if non authorized Latin1 characters are used (ƒå „„=•∑√ )

 

step4-import-process.png

step5-import-process.png

 

Yeah! You made it.... Now you only need to check the mailing in the preview function and commission it.

 


"Possibly the coolest #marketing service I've seen... On demand, handwritten, direct mail via @PensakiTweets" 
— Charlie Hutton (@Charliehutton) September 25, 2015

 

"Good old handwriting boosts leads for DIGITAL Oracle Eloqua CAMPAIGN. Lead conversion rate of around 40%. Like it."
— Michaela Seika (@michaela_seika) 22. Juni 2016

 

Das Start-up #Pensaki setzt auf die Renaissance von Handgeschriebenem. Mit Roboterhilfe."
— brand eins (@brandeins) April 7, 2015