- Order Reports: Track completed orders placed through Magic Checkout. Use these reports to calculate conversion rates, identify top-performing products and promotions and analyse payment method preferences.
- Checkout Reports: Analyse both completed orders and abandoned checkouts to understand the complete customer journey. Use these reports for abandoned cart recovery, checkout funnel analysis and identifying customer drop-off points.
Generate Reports
To generate reports:1
Step 1
Log in to the Dashboard and navigate to Reports.
2
Step 2
In the Overview section, click Download Report.
3
Step 3
Configure report settings:
- Select the report from the drop-down list.
- Magic Checkout Orders Report for completed orders only.
- Magic Checkout Checkout Report for completed orders and abandoned checkouts.
- Enter a file name (optional).
-
- Select the file format. Only
CSVformat is supported for Magic Checkout reports.
- Select the file format. Only
- Choose the duration from the drop-down or toggle Custom to set a specific date range.
- To receive the report via email, toggle Yes in the Do you want this report in an email? section and enter email addresses for all recipients.
4
Step 4
Click Start Download.
5
Step 5
Navigate to the Downloads section to track the download status and click the download icon to download the report.
Schedule ReportsYou can also schedule reports to receive them automatically at regular intervals. This ensures you get timely data for consistent decision-making without manual downloads. Know more about how to schedule reports.
Data Fields
The reports contain the following data fields:Order Reports
Order reports contain the following data fields:Field | Description
order_id | Unique identifier for the order in your system.
razorpay_order_id | Unique Razorpay order identifier.
razorpay_payment_id | Unique Razorpay payment identifier.
order_amount | Total order amount in the smallest currency unit - paise for INR (for example: 12000 is ₹120).
order_status | Status of the order. Know more about Order Status.
payment_method | Code of the payment method used. Know more about Razorpay Payment Methods.
payment_amount | Amount paid through the payment method in smallest currency unit.
payment_status | Status of payment. Know more about Payment Status.
payment_currency | Currency code for the payment.
payment_refund_status | Refund status of the payment.
customer_contact | Customer’s contact number.
customer_email | Customer’s email address.
shipping_address | JSON object containing shipping address details including name, contact, address lines, city, state, zipcode, country and landmark.
promotions | Array of applied promotions with details like type, code, description, value and reference id.
utm_parameters | JSON object containing UTM tracking parameters including source, campaign, medium, content, landing page URL and additional tracking ids like gclid.
line_items | Array of product names included in the order.
line_items_total | Total value of all line items in the smallest currency unit.
checkout_created_time | Timestamp when the checkout was initiated.
checkout_closed_time | Timestamp when the checkout was completed.
Checkout Reports
Checkout reports contain all the fields from Order reports plus one additional field:Field | Description
abandoned_checkout_url | URL to recover abandoned checkout. This is only populated for incomplete checkouts.
Handy Tips
- Checkout reports include both completed orders and abandoned checkouts, while order reports only show completed orders.
- The
abandoned_checkout_urlfield is only populated for customers who initiated checkout but did not complete the purchase. - For completed orders, the
abandoned_checkout_urlfield will remain empty.