About the AIQ <> MJFreeway Pennsylvania Integration

Review our Integration Grid for supported features.

This article covers connection for AIQ Marketing + Loyalty.

How to Connect AIQ to MJFreeway Pennsylvania

Prepare your data

Prepare your data in a CSV file (Comma Seperated Values) using the following headers.
Place the data in a folder in OneDrive. This folder should be at the top level; it should not be inside any other folders.

Header	Notes
TransactionID	Required. Unique transaction ID
Patient Number	Required. Unique patient ID
LocationID	Unique location ID
Item ID
Product Name
Product Category Name
VendorName
InventoryQuantity
Agg - Product Sales (subtotal)
AllocatedTax
Product Discount
TransactionDate	YYYY-MM-DD (ex. 2006-01-02)
Completed Time	HH:MM:SS (ex. 15:04:05)
Patient Postal Code
Patient Address
Patient Name
Patient email
Patient Phone Default
Patient Gender
Patient Age	YYYY-MM-DD (ex. 1990-01-02)
Facility Name	Store name

AIQ Steps

Navigate to Settings > Integrations, search for MJFreeway - Pennsylvania and click on it to open the integration card.
Select "Connect Account via Oauth2" and follow the onscreen prompts.
Enter the OneDrive folder name in the field labeled "Folder"
Scroll down to the Loyalty section and check off the box next to Required All users from this source have passed an age gate compliant with my industry.
Lastly, click the purple Connect button in the top right.

How to Map a Store

Navigate to Settings -> Company Account > Retail Store
Click Edit on the store you wish you map
Under Store Mappings you'll see the MJ Freeway Pennsylvania symbol
Click on the empty field to the right of the symbol and a dropdown will appear to "map" the key
Click Save settings and you are done mapping the store. Keep in mind this must be repeated for any additional stores that you add to the account.

Additional AIQ Settings

The following additional settings are available on the MJFreeway Pennsylvania integration card in AIQ. To access them, navigate to Settings > Integrations, locate MJFreeway - Pennsylvania and click on it to open the integration card.

Use AIQ's last backup

Freezes data from this source at the last audience run and stops AIQ from hitting the MJFreeway Pennsylvania API for new data.

⚠️ Warning: Do not turn this on unless you are switching POS systems and want to retain existing data.

Send SMS double opt-ins to Personas who purchased after

Sends an SMS double opt-in request to shoppers with a phone number who had a sale on or after the date you specify. Takes 24 hours to trigger.

⚠️ Warning: If this setting is removed after it has been set, it can cause loyalty Personas to be lost if they only became a member through this setting and did not use a signup form. We do not recommend changing this after it is set.

Enroll Personas in loyalty program who purchased after

Automatically enrolls shoppers in the loyalty program if they had a sale on or after the date you specify. Enrolled shoppers earn points for sales on or after that date. Takes 24 hours to reflect.

FAQs

How long does it take before I start to see my POS data in AIQ?

Within 24 hours, you should see data populating in AIQ

How can I confirm that the integration is active and signups are being sent?

Look under your Personas page in AIQ. The integration is functioning properly if you see "mjfreeway" under the Sourced from column

I am getting an account notification that I have unmapped stores, how can I fix this?

Once you see data coming through AIQ, you must "map" the API key to the store(s) to assign a "favorite store" to the shopper. See How to Map a Store above for directions on how to accomplish this.