AMP Data Pipeline sends sales and wash activity data from the AMP platform to the Snowflake Data Cloud allowing you to consolidate AMP data with point-of-sale activity to automate financial and operational reporting.
Automate Data Delivery
Start syncing AMP data to your Snowflake organization within minutes. No coding required!
Unified View of Your Data
Snowflake allows you to create a single-source-of-the-trooth for all your data sources. Unlock the power of having financial and operational data at your fingertips for better insights and decision support analytics.
Eliminate the need for transferring files and reports via traditional means (e.g. email, FTP, custom development) by leveraging the industry leading security architecture of Snowflake.
What memberships have been sold in AMP last month?
This query returns the memberships that were sold in AMP over the past 30 days.
SELECT product, customer_id, customer_email, purchase_location, payment_date, line_item_total_amount as amount FROM GENERAL.AMP_SALES WHERE payment_date >= dateadd('day', -30, current_date()) AND product_type = 'Unlimited Plan';
How many memberships and washes were purchased at each location last month?
This query returns the number of memberships an individual washes sold in AMP over the past 30 days.
SELECT purchase_location, product_type, COUNT(invoice_line_item_id) as sales FROM GENERAL.AMP_SALES WHERE payment_date >= dateadd('day', -30, current_date()) AND product_type = 'Unlimited Plan' GROUP BY purchase_location, product_type;