Data and integrations FAQs

Does Ascent360 share data across clients?

No. Ascent360 does not share data across client databases without express written permission from the client. For more information, view Ascent360's Privacy Policy.

Can Ascent360 pull customer information from a credit card at point-of-sale?

No. It is not currently possible to pull customer information from a credit card at point-of-sale. Although there are some vendors and website that suggest that they are able to do this, none of the reputable Point of Sale vendors are selling this service.

Does Ascent360 store credit card information in the database?

Ascent360 will not store unsecured credit card information in the database. However, Ascent360 can store an encrypted version of a credit card such as a token or a seeded and hashed credit card. The encrypted version of the credit card can be very useful for matching.

How do I access the Ascent360 SFTP?

This article is for clients who have an existing FTP (file transfer protocol) folder set up by Ascent360.

When transferring Personally Identifiable Information (PII) to Ascent360, please do so via SFTP. Looking for information regarding the in-Platform File Management system? Please see Dropping and Picking Up Files with File Management.

Option 1: Access via an FTP Client

Access your FTP folder through a dedicated FTP client like FileZilla.

  • Hostname: ftp.ascentcrm.com
  • Connect using your FTP username and password, provided securely by the Ascent360 Team.

Option 2: Access through a Web Browser

Alternatively, access your FTP folder through an online browser.

  • Web Transfer Login Page: https://webupload.ascent360.com/ThinClient/
  •  Login using your FTP username and password, provided securely by the Ascent360 Team.
  • Should you wish to reset your FTP account password, please do so through the Web Transfer Portal.

Note: Web Transfer is not optimal for files 2GB or larger. If the file fails to upload, try transferring the file through a dedicated client (Option 1)

How do I configure a dynamic date in an export?

If you are setting up an automated campaign and need the name of the file or contact list to display a dynamic date, insert the following into the file name: [[yyyyMMdd]]

This means that your file or list name will include the date on which the export was run.

For example, if a daily recurring file export needs the title "Purchasers" along with the date the file was generated, the name would be entered like this:


If the campaign runs on June 1st, 2021, the file name will be: Purchasers 20210601.

What is a RFM Score?

Ascent360 has an aggregate called RFM -- “Recency, Frequency and Monetary”. At its core, the RFM score is a tool to understand customer value by comparing individuals against one another. RFM has been used in database marketing for 20+ years.

  • Recency - How recently did the customer purchase?
  • Frequency - How often does the customer purchase?
  • Monetary Value - How much does the customer spend?

How RFM is calculated

To calculate RFM, Ascent360 looks at all customers, records and transactions in the customer database, and divides the customer list into equal groups of 20% (known as Quintiles) for each dimension.   

Recency:

The idea behind ‘Recency’ is that customers who have purchased from your business recently are much more likely to respond to a new offer than someone who had made a purchase in the distant past.

Recency quintiles are based on the date of most recent purchase at your business and are organized by the Min / Max number of days since last purchase. As a result, the more recent a record’s last transaction date is, the higher the quintile score will be assigned to that record. Thus, customers with the top 20% most recent transactions (in terms of Recency) are given a code of "5". The next 20% in terms of recent purchases is coded as "4", and so on until all records in your database are now assigned either a 5, 4, 3, 2, or 1 in terms of Recency.

Example of Recency quintile breakdown:

  • #5: 7 days – 60 days
  • #4: 60 days – 120 days
  • #3: 120 days – 240 days
  • #2: 240 days – 300 days
  • #1: 300 days – Oldest transaction date associated with a record in your database

Frequency

Frequency quintiles are based on the sum quantity of total lifetime transactions each customer has made at your business.  

Customers are sorted in your the database by this number – from the most to least frequent, coding the top 20% as "5", and the less frequent quintiles as 4, 3, 2, and 1.  Note: brand new customers will have a Recency code of "5", but a frequency code of "1", resulting in the lowest frequency quintile containing your newest customers.

Example of Frequency quintile breakdown:

  • #5: 5 transactions – Maximum number of transactions associated with a record in your database
  • #4: 4 transactions
  • #3: 3 transactions
  • #2: 2 transactions
  • #1: 1 transaction
  • #0: 0 transactions

Monetary

Monetary scores are organized into quintiles based on the sum of an individual's total lifetime spend. Your biggest spenders will be assigned a “5”, and the others, 4, 3, 2, and 1.  Customers are organized into your database by min / max amount of total dollars spent with your business.

Example of Monetary quintile breakdown:

  • #5: $400.00 – Highest lifetime total dollar sales associated with a record in your database
  • #4: $200.00 - $400.00
  • #3: $100.00 - $200.00
  • #2: $50.00 - $100.00
  • #1: $1.00 - $50.00
  • #0: $0.00

Putting The Three Scores Together

RFM analysis depends on Recency, Frequency, and Monetary measures, but the real power of the technique comes from combining them into a three digit RFM "cell code".

Using the quintile system explained above, all customers end up with three digits in their database records. They are either 555, 554, 553, 552, 551, 545,...down to 111. There are 125 different "cells" in all, with all cells containing approximately the same number of customers. 

You may notice that not all RFM buckets are utilized AND that you don’t actually have an even 20% in each bucket. Your RFM may only have customers assigned a 4 or 5 and not 1, 2, 3. This is because the frequency of known purchasers is not large enough to create a complete segment. If 80% of your customers have only purchased once, than it's impossible to break this 80% into different frequency buckets. The entire 80% will be assigned a frequency of 4. The other 20% that have more than one transaction will be assigned a 5.

Updating Audiences with Year-Specific Source Name

At the start of each new calendar year, it's a good idea to audit your audiences to ensure they are all set up correctly. Something important to check for is if any of your audiences incorporate a year-specific source name. 

Here is what that might look like:

Let's say my Newsletter List audience incorporated this criteria above ^ of source name = 23 Website Signup. When we enter into 2024, there will be a new value of 24 Website Signup that will need to be added/updated to keep this audience current.

Note that the new year's value won't be available to select in the drop-down list under Source Name until a record comes through with that value. So in 99% of cases, this won't be until after January 1st or 2nd of the new year. (i.e. you can't make this update in late December).

In some cases, you might be able to use the Source Type instead (i.e. Source Type = Webforms), but this may pull more records that intended if you have multiple forms labelled with source type of Webforms.

Please reach out to your CSM or the Help Desk if you want to chat through how to correctly set up audience criteria, especially if you're using year-specific Source Name values.