Excel Whizz Required: I need a line order report reformatted for AWeber CSV import
- or -
Post a project like this2256
$$
- Posted:
- Proposals: 11
- Remote
- #1856813
- Awarded
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Business Planner, Excel Guru, Database Professional, UI designer, Content Writer, Research Professional
Prague
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
1838570506661148965487001192798119942313875941449433153654719384661946714
Description
Experience Level: Intermediate
General information for the business: Mens Hair Products
Description of excel work: I have a line report in Excel (From Woocommerce) with 7340 orders with date of order, first name, surname, country, item purchased, total value of order. The report contains orders from customers that have ordered multiple times and sometimes with 1 or more items in the order.
I want to import this into AWeber email platform so I can target by date of order (for lapsed customers), items purchased (to market other products in the range) and order value (i.e high spenders).
- I need help combining all products ordered and spend data into one row.
- I would like the total spend for that customer to appear in the total spend column
- I would like all items purchased to appear in one cell separated by a comma (These would act as tags in AWeber.
For example:
M Smith m.smith@gmail.com product 1, product 2, product 3 £150.50
I hope this makes sense. This should be a quick and easy job for an Excel whizz.
I look forward to your quotes.
Please let me know if you have any questions.
Many thanks
Matt
Extra notes:
Description of excel work: I have a line report in Excel (From Woocommerce) with 7340 orders with date of order, first name, surname, country, item purchased, total value of order. The report contains orders from customers that have ordered multiple times and sometimes with 1 or more items in the order.
I want to import this into AWeber email platform so I can target by date of order (for lapsed customers), items purchased (to market other products in the range) and order value (i.e high spenders).
- I need help combining all products ordered and spend data into one row.
- I would like the total spend for that customer to appear in the total spend column
- I would like all items purchased to appear in one cell separated by a comma (These would act as tags in AWeber.
For example:
M Smith m.smith@gmail.com product 1, product 2, product 3 £150.50
I hope this makes sense. This should be a quick and easy job for an Excel whizz.
I look forward to your quotes.
Please let me know if you have any questions.
Many thanks
Matt
Extra notes:
Matt T.
100% (42)Projects Completed
40
Freelancers worked with
29
Projects awarded
26%
Last project
2 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Matt,
Your requirements appear to be straight forward. Can you please send sample data and i will have a working solution sent by the top of the hour.
Thanks,
Nyasha -
HI,
My name is Mufaddal would you mid providing sample file to have a look at ?? -
Hi,
I am not able to send proposal.. so kindly invite again. Andi got your point.. I am ready to do samples..
Please Advise,
Jee.
572273571293571236
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies