Analyze some Data

We need a detailed report on the clicks to sales rates across all our publications.

We have a series of ebooks available on iBooks and Amazon, 7 in total, plus one up on the App store, you can see them on www.oldmatemedia.com.

Ideally the report would cover the last 6 months (note some books have not been on sale that long so theirs will be shorter).

The report should include the following information:

Monthly:

- clicks to sale site

- sales

- Click to sale %

Overall for past 6 months

- clicks to sale site

- sales

- Click to sale %

Then we want to have this broken down across the publications as follows:

- Each book – iBooks

- Each book – Amazon

- Total for each book

- Total for iBooks for all books

- Total for Amazon for all books

- Total for all books for all portals

For example, looking at the Little Green Boat, this would have 6 lines of data relevant to it:

- iBooks conversion

- Amazon conversion

- Total conversion

- Total ibooks conversion (contribute to this figure)

- Total Amazon conversion (contribute to this figure)

- Total all portals conversion (contribute to this figure)

We use Georiot links for tracking so it should be easy to track the clicks.

Please let me know in your quote what information you will need from me to produce this report.

苹果iBooks作者 数据输入 数据处理 Excel 虚拟助手

项目ID： #10659213

关于项目