Filing method that involves placing newer reports on top of older reports

We are looking for a responsible Administrative Assistant to perform a variety of administrative and clerical tasks. Duties of the Administrative Assistant include providing support to our managers and employees, assisting in daily office needs and managing our company’s general administrative activities.

What does an Administrative Assistant do?

Administrative Assistant responsibilities include making travel and meeting arrangements, preparing reports and maintaining appropriate filing systems. The ideal candidate should have excellent oral and written communication skills and be able to organize their work using tools, like MS Excel and office equipment. If you also have previous experience as a Secretary or Executive Administrative Assistant and familiarity within our industry, we’d like to meet you.

Ultimately, a successful Admin Assistant should ensure the efficient and smooth day-to-day operation of our office.

Responsibilities

  • Answer and direct phone calls
  • Organize and schedule appointments
  • Plan meetings and take detailed minutes
  • Write and distribute email, correspondence memos, letters, faxes and forms
  • Assist in the preparation of regularly scheduled reports
  • Develop and maintain a filing system
  • Update and maintain office policies and procedures
  • Order office supplies and research new deals and suppliers
  • Maintain contact lists
  • Book travel arrangements
  • Submit and reconcile expense reports
  • Provide general support to visitors
  • Act as the point of contact for internal and external clients
  • Liaise with executive and senior administrative assistants to handle requests and queries from senior managers

Requirements and skills

  • Proven experience as an Administrative Assistant, Virtual Assistant or Office Admin Assistant
  • Knowledge of office management systems and procedures
  • Working knowledge of office equipment, like printers and fax machines
  • Proficiency in MS Office (MS Excel and MS PowerPoint, in particular)
  • Excellent time management skills and the ability to prioritize work
  • Attention to detail and problem solving skills
  • Excellent written and verbal communication skills
  • Strong organizational skills with the ability to multi-task
  • High School degree; additional qualification as an Administrative assistant or Secretary will be a plus

Frequently asked questions

What does an Administrative Assistant do?

Administrative Assistants are responsible for many clerical tasks to ensure the staff can communicate and work efficiently. Their job involves answering phone calls, greeting visitors, distributing mail, and preparing communications.

What are the duties and responsibilities of an Administrative Assistant?

Administrative Assistants assist with the day-to-day operations of an office by doing tasks such as filing paperwork, answering phone calls, preparing documents for meetings, and managing the calendar of their supervisors.

What makes a good Administrative Assistant

Successful Administrative Assistants are effective communicators who speak clearly and are personable and welcoming when answering incoming calls. They use proper grammar and put people at ease when they're on the phone or speaking one-on-one with other staff members or customers.

Who does Administrative Assistant work with?

Administrative Assistants typically report to a Managing Director unless assigned directly to a CEO or other executive. Most Administrative Assistants support the entire office in smaller companies and work with various department managers and staff.

This page was printed on Jan 06, 2023. For the current version, visit https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/customers-reports.

If your store is on the Shopify, Advanced Shopify, or Shopify Plus plan, then you have access to detailed reports about your customers. With the following reports, you can gain helpful insights about your customers, including their average order count, average order totals, and expected purchase value:

  • Customers over time
  • First-time vs returning customer sales
  • Customers by location
  • Returning customers
  • One-time customers
  • Customer cohort analysis
  • Predicted spend tier

If your store is on the Advanced Shopify or Shopify Plus plan, then you also have access to the following reports:

  • At-risk customers
  • Loyal customers

Because of the way that the customer reports are generated, they might not display all the activity on your store from the past 12 hours. However, when you open the First-time vs returning customer sales report report, the data is up to date, give or take a few seconds. You can reopen or refresh the report to display newer data.

The Customers reports are limited to 250,000 customers. If you need to access customer data for more than 250,000 customers, then you can set up and use Google Analytics. To learn more, go to Working with Google Analytics. However, you can export all your customers from the Customers page in your Shopify admin.

The data in customer reports is based on the entire order history of the new customers in the report, not only the orders that were placed during the selected timeframe. For example, if you access a report for November only, then a new customer from that month still displays as a repeat customer, even if they made their second purchase in December.

Access your customer reports

Steps:

  • Desktop
  • iPhone
  • Android

  1. From your Shopify admin, go to Analytics > Reports.

  1. From the Shopify app, tap Store, and then tap Analytics.
  2. Tap Reports.

  1. From the Shopify app, tap Store, and then tap Analytics.
  2. Tap Reports.

  1. Click Categories.
  2. Click Customers to filter the reports to show only customers reports.

Customers over time

The Customers over time report displays how many customers placed orders with your store.

You can select a unit of time in the Group by drop-down menu to control how the data is grouped.

The report table displays two rows for each time unit when there are both types of customer: one for first-time customers, and one for returning customers. A first-time customer is a customer who placed their first order with your store. A returning customer is a customer who placed an order, and whose order history already includes at least one order.

For each time unit, you can find the following data:

  • The number of new (first-time) customers who placed an order during that time. Such a group of customers is often called a new cohort of customers.
  • The number of returning customers who placed an order during that time.

First-time vs returning customer sales

The First-time vs returning customer sales report displays the value of orders placed by first-time and returning customers.

You can click Group by to select the time unit that you want to display the total sales by in the graph: hour, day, week, month, quarter, year, hour of day, day of week, or month of year. The time unit specifies how the total sales are grouped.

The report table display two rows for each time unit when there are both types of customer: one for first-time customers, and one for returning customers. A first-time customer is a customer who placed their first order with your store. A returning customer is a customer who placed an order, and whose order history already includes at least one order.

For each time unit, you can find the following data:

  • the number of orders placed by each group of customers
  • the value of orders (total sales) placed by each group of customers

Customers by location

The Customers by location report displays data for new customers organized by geographical location. New customers are organized according to the geographical location in their default address in your Shopify admin.

For each geographical region, you can find:

  • the number of new customers who placed their first order during the selected timeframe
  • the total number of orders that those customers have placed since their first order
  • the total amount that they have spent, including taxes, discounts, shipping, and any refunds

The Orders to date and Total spent to date totals are based on the entire order history of the new customers in the report, not only the orders that were placed during the selected timeframe.

Returning customers

The Returning customers report displays data about all your customers whose order history includes two or more orders.

You can find the following details for each customer:

  • their name
  • their email address
  • whether they agreed to accept marketing when they placed their most recent order
  • the date of their first order
  • the date of their most recent order
  • the number of orders that they have placed
  • their average order value
  • the total amount that they have spent, including taxes, discounts, shipping, and any refunds

One-time customers

The One-time customers report displays data about all your customers whose order history includes only one order.

You can find the following details for each customer:

  • their name
  • their email address
  • whether they agreed to accept marketing when they placed their most recent order
  • the date of their first order.
  • the number of orders that they have placed, which is 1
  • the value of their order, including taxes, discounts, shipping, and any refunds

Customer cohort analysis

The Customer cohort analysis report displays data about your customer acquisition and retention. A cohort is defined as a group of customers that have similar characteristics. For the Customer cohort analysis report, customers are grouped into cohorts based on the date that they placed their first order.

You can use this report to find out which customers have made repeat purchases to identify your most valuable customers. You can use this information to help you make decisions about when to retarget customers, which customers to retarget, and which customers are lower value.

The Customer cohort analysis contains the following reports:

  • Cohort analysis table
  • Retention rate chart
  • Cohort analysis details

Cohort analysis table

The cohort analysis table displays data about repeat purchases by customers based on when they made their first purchase. Each row represents a cohort of your customers that made their first purchase in the same time period. The first column displays the name of the cohort, based on the week, month, or quarter of their first purchase. The second column displays the sum of the selected metric for each cohort row. The rest of the columns display the selected metric over weeks, months, or quarters since the acquisition of the original cohort.

For example, your customer John made their first purchase in February 2022. John then made another purchase in June 2022 and in September 2022. In a monthly cohort analysis for 2022, John would be in the February cohort and would be counted as a repeat customer for Month 4 and Month 7.

You can customize the report in the following ways:

  • change the time period that cohorts are grouped by
  • change the time period that the report displays
  • change which metric is displayed, including number of customers, customer retention rate, gross sales, net sales, or average order value

Note

Data for the current time period isn't displayed. For example, if it's August and you choose to display monthly cohorts, then only data from July and earlier is displayed. The data for a time period is available 72 hours after the end of that period.

Retention rate chart

The Retention rate chart displays the retention rate of all first-time customers during the time period that the report displays. You can also display the following comparisons:

  • Comparison to previous period
  • Comparison to previous year
  • Comparison between cohorts

You can also display the retention rate for customers in all cohorts for the selected time period, or select a single cohort to display the retention rate for.

Cohort analysis details

You can access the cohort analysis details by clicking All, or a specific time period in the Cohort column. You can find the following details for each cohort:

  • gross and net sales for the selected cohort
  • average order value and average number of orders per customer in the cohort
  • total new or returning customers and their total number of orders
  • the top products sold to the customers in the selected cohort
  • the top marketing channels responsible for directing the cohort’s customers to your business
  • the top sales channels that processed the cohort’s orders
  • the predicted spend tier overview for the cohort
  • a ratio of sales from one-time versus subscription purchases
  • the top geographic locations of customers in this cohort

Note

Some of the metrics may not be shown for a specific cohort or specific time period. For example, if there were no subscription sales in the selected cohort or time period, then the subscription versus one-time metric won’t be shown.

Using the cohort analysis report for customer segmentation

You can use the data from the Customer cohort analysis report to create customer segments out of high-value customer cohorts.

For example, if the customer cohort for June of 2022 indicates high retention, then you can create a customer segment by using the First_order_date BETWEEN 2022-06-01 AND 2022-06-30 .

Learn more about customer segmentation.

Predicted spend tier

The Predicted spend tier report displays the predicted value of each customer in the selected cohort. This report can help you target customers that are part of the highest value cohorts. You can find the following details for each customer in the cohort:

  • customer name
  • the predicted spend tier
  • email subscription status
  • the date the customer placed their last order
  • the total number of orders placed by that customer
  • the total amount that customer has spent

Learn more about how the predicted spend tier is determined.

At-risk customers

You have access to the At-risk customers report only if your store is on the Advanced Shopify or Shopify Plus plan.

The At-risk customers report displays data about all your returning customers who are at risk.

A customer is at risk if they're estimated to have a medium probability of returning to place another order with your store, but they haven't placed an order in a while.

Shopify uses a machine learning model to determine the likelihood that a customer will return to purchase an item in the next 90 days.

By knowing which of your customers are at risk, you can tailor or target your marketing. For example, you can offer your at-risk customers a discount to encourage them to buy from you again.

In the report, you can find the following details for each customer:

  • their name
  • their email address
  • whether they agreed to accept marketing when they placed their most recent order
  • the date of their first order
  • the date of their most recent order.
  • the number of orders that they have placed
  • their average order value
  • the total amount that they have spent, including taxes, discounts, shipping, and any refunds

Loyal customers

You have access to the Loyal customers report only if your store is on the Advanced Shopify or Shopify Plus plan.

The Loyal customers report displays data about all your returning customers who are loyal.

A customer is loyal if they're estimated to have a high probability of returning to place another order with your store, and they've placed more orders than the average customer. This can be helpful in your marketing efforts. For example, marketing your high-margin products to your loyal customers might be an effective approach.

You can find the following details for each customer:

  • their name
  • their email address
  • whether they agreed to accept marketing when they placed their most recent order
  • the date of their first order
  • the date of their most recent order.
  • the number of orders that they have placed
  • their average order value
  • the total amount that they have spent, including taxes, discounts, shipping, and any refunds

Customize the Customers reports

If your store is on the Advanced Shopify or Shopify Plus plan, then you can use the filtering and editing features to customize the reports about your customers.

The following is a sample of some of the filters and columns that are available, where applicable.

Filters for the Customers reports

Customer

  • Customer email - The email address associated with a customer.
  • Customer name - The first and last names of a customer.

Customer attributes

  • Accepts marketing - Whether customers agreed to accept marketing when they placed their most recent order.
  • Is one-time - Customers whose order history includes only 1 order.
  • Is returning - Customers whose order history includes more than 1 order.

Customer segment

  • Is at risk - Customers who are a repeat customer and estimated to have a medium probability of returning, but who have not placed an order in a while.
  • Is dormant - Customers who have a low probability of returning to make another purchase.
  • Is loyal - Repeat customers who are estimated to have a high probability of returning, and have placed more orders than the average customer.
  • Is promising - Customers who are estimated to have a high probability of returning and becoming a loyal customer.

Location

  • City/Country/Region - The city, country, and region of customers, based on their default address in your Shopify admin.

Columns for the Customers reports

Customer

  • Customer email - The email address associated with a customer.
  • Customer name - The first and last names of a customer.
  • Customers - The total number of first-time and repeat customers who placed their an order during the selected timeframe.

Customer attributes

  • Accepts marketing - Whether customers agreed to accept marketing when they placed their most recent order.
  • Is one-time - Customers whose order history includes only 1 order.
  • Is returning - Customers whose order history includes more than 1 order.

Customer segment

  • Is at risk - Customers who are a repeat customer and estimated to have a medium probability of returning, but who have not placed an order in a while.
  • Is dormant - Customers who have a low probability of returning to make another purchase.
  • Is loyal - Repeat customers who are estimated to have a high probability of returning, and have placed more orders than the average customer.
  • Is promising - Customers who are estimated to have a high probability of returning and becoming a loyal customer.

First order

  • First order (day/month/week/year) - The date of a customer's first order.

Last order

  • Last order (day/month/week/year) - The date of a customer's last order.

Location

  • City/Country/Region - The city, country, and region of customers, based on their default address in your Shopify admin.

Order

  • Average order value - The average value of customers' orders since their first order. It's calculated by dividing the total value of new customers' orders by the total number of new customers' orders. The total order value includes taxes and shipping, and is before refunds. The total number of orders does not include orders that consist only of gift cards.

Orders

  • Total spent to date - The total amount that a customer has spent, including taxes, discounts, shipping, and any refunds. For example, let's suppose a customer ordered two $50 items from your store, paid no tax, received 10% on one of the items, spent $10 in shipping, and received a $7 refund for a shipping delay. In this example, the Total spent to date would calculate 50 + 45 + 10 -7 and display a total of $98.
  • Orders to date - The total number of new customers' orders since their first order.

Time

  • Day/Month/Week - The day, month, and week of the order.

Example customization: Target an email campaign towards returning customers

If you want to use an email campaign to encourage returning customers to make another purchase, then you could customize your Returning customers report so that it displays only the returning customers who agreed to accept marketing.

To create the report for this example:

  • Desktop
  • iPhone
  • Android

  1. From your Shopify admin, go to Analytics > Reports.

  1. From the Shopify app, tap Store, and then tap Analytics.
  2. Tap Reports.

  1. From the Shopify app, tap Store, and then tap Analytics.
  2. Tap Reports.

  1. Click Categories.
  2. Click Customers to filter the reports to show only customers reports.
  3. Click Returning customers.
  4. From the Returning customers report, click Manage filters.
  5. Click Add filter.
  6. Select Accepts marketing, and then in Search, select Yes.
  7. Click Apply filters.

The report is now limited to returning customers who accept marketing.

You can then export the report to a CSV file, and you can use all the email addresses in the file for your email campaign.

What are the three basic filing methods?

Filing in Alphabetical order. Filing by Numbers/Numerical order. Filing by Places/Geographical order.
When filing alphabetically, if two names are identical, the address is used to make the filing decision in which order? When filing records in a new file cabinet, it is recommended that you: Place the files in the bottom drawers first.

Which of the following is the best way to update information in a paper record quizlet?

Which of the following is the best way to update information in a paper record? Draw a single line through the information and add a note, the date, and your initials.

Which of the following terms describes a collection of associated files that function as basis for retrieving information?

What term describes a collection of associated files that functions as a basis for retrieving information? Database. Databases are used in healthcare settings document, track and store pt information.