I have all of the data from our third-party analytics tool - all in CSV files. The format comes out as this:
Excel 2013/2016
<tbody>
</tbody>
Excel 2013/2016
<tbody>
</tbody>
Considering that there are hundreds of such CSV files, manually copying and pasting takes too long. An automated solution would be perfect for this, but I'm not sure how to proceed.
Any help would be appreciated.
Excel 2013/2016
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Media Impact Origin Market Breakdown | |||||||||||
| 2 | Advertiser | Visit Britain | ||||||||||
| 3 | Date Range | Jan 1, 2018 - Apr 30, 2019 | ||||||||||
| 4 | ||||||||||||
| 5 | Pixel Group | CN_Email_Dec2018 | ||||||||||
| 6 | Pixel | All Analytics Pixels and Click URLs | ||||||||||
| 7 | ||||||||||||
| 8 | ||||||||||||
| 9 | Hotel | |||||||||||
| 10 | # Searches | # Bookings | # Total Travelers | # Total Nights | Total Revenue | Avg. Search To Book | Avg. AP | AVG. Length of Stay | Avg. # Travelers | Avg. Daily Rate(ADR) | ||
| 11 | All Markets - TOTALS / AVERAGES | 28 | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| 12 | China | 28 | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| 13 | ||||||||||||
| 14 | ||||||||||||
| 15 | Air | |||||||||||
| 16 | # Searches | # Bookings | # Total Travelers | # Total Nights | Avg. Search to Book | Avg. AP | Avg. Length of Stay | Avg. # Travelers | ||||
| 17 | All Markets - TOTALS / AVERAGES | -- | -- | -- | -- | -- | -- | -- | -- | |||
| 18 | China | -- | -- | -- | -- | -- | -- | -- | -- |
<tbody>
</tbody>
Impact_Reports_Origin_Market_Br
And I need the data to be copied over to the following table template:Excel 2013/2016
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | DATA | AIR | HOTEL | |||||||||||||||||||||||||
| 2 | Advertiser (Visit Britain, Visit England, Australia) | Date range | Type of pixel (web, impressions, click) | Pixel group name | Pixel name | Data / country | # Unique Site Visitors | # Unique Site Visits | # of Page Views | Avg # Site Visits per Visitor | Avg # Page Views per Visitor | # Searches | # Bookings | # Total Travelers | # Total Nights | Avg. Search to Book | Avg. AP | Avg. Length of Stay | Avg. # Travelers | # Searches | # Bookings | # Total Travelers | # Total Nights | Avg. Search to Book | Avg. AP | Avg. Length of Stay | Avg. # Travelers | Avg. Daily Rate(ADR) |
| 3 | 1 | Partner_Test_Feb2019 | UK_partnership_test web pixel_Feb2019 | All markets - TOTALS / AVERAGES | 1 | 1 | 2 | |||||||||||||||||||||
| 4 | 1 | Partner_Test_Feb2019 | UK_lastminute.com partnership_test web pixel_March2019 | Italy | 1 | 1 | 2 |
<tbody>
</tbody>
Sheet2
Considering that there are hundreds of such CSV files, manually copying and pasting takes too long. An automated solution would be perfect for this, but I'm not sure how to proceed.
Any help would be appreciated.
