Where are the AQ Rewards?? [updated: 12-07, 2:30pm PT]

Dob1616

Can’t move passed the node choice box. My whole alliance is just stuck have a campfire

[repurposed thread]

Comments

unknown

This content has been removed.

The_man001

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

There are a lot of theories in this thread about what's taking so long and why it should be "so simple" so I wanted to shed some light onto the situation.

It is not as simple as copy+paste as some have suggested. One team has to run data queries to gather all of the placements of players from the previous season to set a "map" of who is getting what ranking of rewards. I don't know the exact intricacies of this process, but it does involve a lot more manual work than you would expect.

After we have this map, the new rewards need to be attached to it, another manual process with margin for error. Time is taken to make sure there are not errors in the process, which unfortunately lengthens the wait. To the best of my knowledge, the snag in the timeline this time around has come in updating the rewards from the previous season to Season 10's reward scale, yet another manual process impacting thousands of players.

After all of this is finished, there's yet another process of setting the rewards live in the game and distributing them to all accounts.

If you've seen our previous post discussing the tools used to manage banning modders, this might seem familiar. It is many more steps than meets the eye and our systems do not automate the process. It is something that is being worked on and we're hoping to grow better equipped as time goes on.

Stop whining and git gud

loader187

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

There are a lot of theories in this thread about what's taking so long and why it should be "so simple" so I wanted to shed some light onto the situation.

It is not as simple as copy+paste as some have suggested. One team has to run data queries to gather all of the placements of players from the previous season to set a "map" of who is getting what ranking of rewards. I don't know the exact intricacies of this process, but it does involve a lot more manual work than you would expect.

After we have this map, the new rewards need to be attached to it, another manual process with margin for error. Time is taken to make sure there are not errors in the process, which unfortunately lengthens the wait. To the best of my knowledge, the snag in the timeline this time around has come in updating the rewards from the previous season to Season 10's reward scale, yet another manual process impacting thousands of players.

After all of this is finished, there's yet another process of setting the rewards live in the game and distributing them to all accounts.

If you've seen our previous post discussing the tools used to manage banning modders, this might seem familiar. It is many more steps than meets the eye and our systems do not automate the process. It is something that is being worked on and we're hoping to grow better equipped as time goes on.

This is what's wrong with the world. Its just a game and just rewards. Can you really not play the game because of the rewards being delayed? Stop your crying and play the game or here is another thought........ just quit(you probably wont be missed).

SirGamesBond

I'll take it. 2 more days you say!! Okay!

Stantona

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

There are a lot of theories in this thread about what's taking so long and why it should be "so simple" so I wanted to shed some light onto the situation.

It is not as simple as copy+paste as some have suggested. One team has to run data queries to gather all of the placements of players from the previous season to set a "map" of who is getting what ranking of rewards. I don't know the exact intricacies of this process, but it does involve a lot more manual work than you would expect.

After we have this map, the new rewards need to be attached to it, another manual process with margin for error. Time is taken to make sure there are not errors in the process, which unfortunately lengthens the wait. To the best of my knowledge, the snag in the timeline this time around has come in updating the rewards from the previous season to Season 10's reward scale, yet another manual process impacting thousands of players.

After all of this is finished, there's yet another process of setting the rewards live in the game and distributing them to all accounts.

If you've seen our previous post discussing the tools used to manage banning modders, this might seem familiar. It is many more steps than meets the eye and our systems do not automate the process. It is something that is being worked on and we're hoping to grow better equipped as time goes on.
So you’re giving out extra rewards too?

Dr. Zola

If you are expecting extra rewards, I would keep those expectations with little optimism as you'll probably receive an additional 45 glory just like our recent pay-out of Elder Marks compensation

bxd

Hi, i don‘t usually post much… but i had to laugh a bit.

… It is something that is being worked on and we're hoping to grow better equipped as time goes on. …

It‘s not like the game has 8th anniversary or something.

Sorry Jax, nothing against you. But come on… it‘s a bit funny.

Greets 😊

luscious_lu6

Damn my boy is cold blooded lol

Ceti_Eel

Maybe they can throw in a few two star crystals to sweeten the pot

Wozzle007

So what we’re essentially saying is that we’ll get rewards Wednesday, so tomorrow?

So You Gotta Hang On 'Til Tomorrow, Come What May
Tomorrow, Tomorrow, I Love You, Tomorrow
You're Always A Day Away
Tomorrow, Tomorrow, I Love You, Tomorrow
You're Always A Day Away

Soumemiakas1926

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

There are a lot of theories in this thread about what's taking so long and why it should be "so simple" so I wanted to shed some light onto the situation.

It is not as simple as copy+paste as some have suggested. One team has to run data queries to gather all of the placements of players from the previous season to set a "map" of who is getting what ranking of rewards. I don't know the exact intricacies of this process, but it does involve a lot more manual work than you would expect.

After we have this map, the new rewards need to be attached to it, another manual process with margin for error. Time is taken to make sure there are not errors in the process, which unfortunately lengthens the wait. To the best of my knowledge, the snag in the timeline this time around has come in updating the rewards from the previous season to Season 10's reward scale, yet another manual process impacting thousands of players.

After all of this is finished, there's yet another process of setting the rewards live in the game and distributing them to all accounts.

If you've seen our previous post discussing the tools used to manage banning modders, this might seem familiar. It is many more steps than meets the eye and our systems do not automate the process. It is something that is being worked on and we're hoping to grow better equipped as time goes on.

Stings, doesn't it?

MrFullStop

honestly, if the decision was in my hand, I'd send everyone the 3rd highest milestone for everyone.
I mean, would that break game economy in anyway shape or form?? ofc not.
in fact, quite the opposite, it will let everyone knows that we care for our customers.

oh well, this is what it is

unknown

This content has been removed.

MasterSmoke

Kabam just please drop a 6* tech doom in my inbox & all will be forgiven

MrFullStop

honestly, if the decision was in my hand, I'd send everyone the 3rd highest milestone for everyone.
I mean, would that break game economy in anyway shape or form?? ofc not.
in fact, quite the opposite, it will let everyone knows that we care for our customers.

oh well, this is what it is
people who normally get 1st and2nd milestone wont be happy though

but this way, they narrowed the data they have to collect from thousands to only 60 players or so, so they can manually send those players manually their correct rewards (1st and 2nd milestones), while the rest gets the 3rd milestone, so no data collection needed

unknown

This content has been removed.

Panchulon21

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

There are a lot of theories in this thread about what's taking so long and why it should be "so simple" so I wanted to shed some light onto the situation.

It is not as simple as copy+paste as some have suggested. One team has to run data queries to gather all of the placements of players from the previous season to set a "map" of who is getting what ranking of rewards. I don't know the exact intricacies of this process, but it does involve a lot more manual work than you would expect.

After we have this map, the new rewards need to be attached to it, another manual process with margin for error. Time is taken to make sure there are not errors in the process, which unfortunately lengthens the wait. To the best of my knowledge, the snag in the timeline this time around has come in updating the rewards from the previous season to Season 10's reward scale, yet another manual process impacting thousands of players.

After all of this is finished, there's yet another process of setting the rewards live in the game and distributing them to all accounts.

If you've seen our previous post discussing the tools used to manage banning modders, this might seem familiar. It is many more steps than meets the eye and our systems do not automate the process. It is something that is being worked on and we're hoping to grow better equipped as time goes on.
You guys move slower then the federal government….and that says something

So what’s your plan now for people who are sitting on max glory?. Cause you are now dumping 2 weeks worth of glory on us at once

Man I wouldn’t know what the solution to this would be… maybe… spend it?

Total_Domin01

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

There are a lot of theories in this thread about what's taking so long and why it should be "so simple" so I wanted to shed some light onto the situation.

It is not as simple as copy+paste as some have suggested. One team has to run data queries to gather all of the placements of players from the previous season to set a "map" of who is getting what ranking of rewards. I don't know the exact intricacies of this process, but it does involve a lot more manual work than you would expect.

After we have this map, the new rewards need to be attached to it, another manual process with margin for error. Time is taken to make sure there are not errors in the process, which unfortunately lengthens the wait. To the best of my knowledge, the snag in the timeline this time around has come in updating the rewards from the previous season to Season 10's reward scale, yet another manual process impacting thousands of players.

After all of this is finished, there's yet another process of setting the rewards live in the game and distributing them to all accounts.

If you've seen our previous post discussing the tools used to manage banning modders, this might seem familiar. It is many more steps than meets the eye and our systems do not automate the process. It is something that is being worked on and we're hoping to grow better equipped as time goes on.
You guys move slower then the federal government….and that says something

So what’s your plan now for people who are sitting on max glory?. Cause you are now dumping 2 weeks worth of glory on us at once

Go buy stuff from the glory store

unknown

This content has been removed.

MrFullStop

honestly, if the decision was in my hand, I'd send everyone the 3rd highest milestone for everyone.
I mean, would that break game economy in anyway shape or form?? ofc not.
in fact, quite the opposite, it will let everyone knows that we care for our customers.

oh well, this is what it is
people who normally get 1st and2nd milestone wont be happy though
but this way, they narrowed the data they have to collect from thousands to only 60 players or so, so they can manually send those players manually their correct rewards (1st and 2nd milestones), while the rest gets the 3rd milestone, so no data collection needed
hmm that does sound like a good idea but we all know that will just never happen sadly
also for players who do like map1,2,3 i think top3 rewards would be a bit too much with the t6b and t3a lol

it's not like that gonna be enough to r4 6* in anyway shape or form! every major sale, game economy shatter in pieces but Kabam don't care about that since they get paid (which is totally fine, and they earn it)

LilMaddogHT

Hey Summoners,

I hate to be the bearer of bad news, but unfortunately the team has hit a snag in the process of getting these rewards out and the timeline has been updated to target Wednesday this week. Apologies from the game team and the community team alike.

At this point, would it be more simple to just send out double AQ rewards for this week when it ends... Day 4 just about to close. Another AQ about to be come and gone and no rewards from prior week. I don't understand why to commit to something that is overly complicated and time consuming on your end if that is really the case to sort out who gets what... After AQ rewards are sent this week on Thursday, just do it again?

Sure placements could have changed (up or down) from 2 weeks ago to the current AQ but no one did last week's AQ so at this point any set of 'regular' rewards is ok w/ me.

Dragoon81

Y'all should calm down. Rewards will come tomorrow
They had almost a week and a half to figure it out but couldn't? Come on man, it's not even a coding nightmare they're just lazy.
Can you explain how it's not a coding nightmare? Can you explain exactly how Kabam could have done it earlier? I can only assume you have insider knowledge in their processes to be able to make a bold statement like you just did.
What do you mean how it's not a coding nightmare all they have to do is look back at the rewards they sent last AQ and send them again it isn't rocket science lmao I don't have insider knowledge but I have something called a brain which gives me the ability to think logically, you don't?
So if it's that simple, why would it take this long? I'm well aware you don't have insider knowledge as that was a rhetorical question. It's never as simple as you think it is.
Because they're lazy, that's why. I praise the devs when they deserve to be praised but almost two weeks just to send out a bunch of rewards when they've literally done other stuff that actually can be a coding nightmare such as changing matchmaking in Battlegrounds in less than a week?
i think if they could've clicked a few buttons and sent out rewards, they would've done it already. don't assume that someone is lazy just because it's not getting done. if you have no idea what they have to do to send out the rewards, don't say that they can just click a few buttons and do it
They can click buttons to change matchmaking in less than a week but they can't do it to send out a bunch of rewards a week and a half after? Oh you poor sweet summer child.
Tell me you know nothing about programming without telling me you know nothing about programming.
Tell me you'll eat whatever nasty food you get served without telling me you'll eat whatever nasty food you get served... Mr. Hacker Programmer, there's a reason you're getting ratioed on every comment.
classy.

anyways FWIW, 11 years as a data analyst/architect tells me I could get these results over lunch IF their data collection is clean and their schema doesn't look like trash. To wit:
query rank table- results-aq -date;
match table new rankings rewards;
run query matching userid to new rank;
rewards should be userid driven based on snapshot of rank at time of last aq, not alliance driven
execute

assuming they have their data tables run right. easy.

11 years my self in various roles and almost 3 years in DevOps, makes me sad that this seems so hard to people.

InfamousMike

Please change color it dazzles me or I have nausea or I have the fear of emptiness with this maps 6

That color really sucks, is not healthy for my eyees..

unknown

This content has been removed.

Suros_moon

Y'all should calm down. Rewards will come tomorrow
They had almost a week and a half to figure it out but couldn't? Come on man, it's not even a coding nightmare they're just lazy.
Can you explain how it's not a coding nightmare? Can you explain exactly how Kabam could have done it earlier? I can only assume you have insider knowledge in their processes to be able to make a bold statement like you just did.
What do you mean how it's not a coding nightmare all they have to do is look back at the rewards they sent last AQ and send them again it isn't rocket science lmao I don't have insider knowledge but I have something called a brain which gives me the ability to think logically, you don't?
So if it's that simple, why would it take this long? I'm well aware you don't have insider knowledge as that was a rhetorical question. It's never as simple as you think it is.
Because they're lazy, that's why. I praise the devs when they deserve to be praised but almost two weeks just to send out a bunch of rewards when they've literally done other stuff that actually can be a coding nightmare such as changing matchmaking in Battlegrounds in less than a week?
i think if they could've clicked a few buttons and sent out rewards, they would've done it already. don't assume that someone is lazy just because it's not getting done. if you have no idea what they have to do to send out the rewards, don't say that they can just click a few buttons and do it
They can click buttons to change matchmaking in less than a week but they can't do it to send out a bunch of rewards a week and a half after? Oh you poor sweet summer child.
Tell me you know nothing about programming without telling me you know nothing about programming.
Tell me you'll eat whatever nasty food you get served without telling me you'll eat whatever nasty food you get served... Mr. Hacker Programmer, there's a reason you're getting ratioed on every comment.
classy.

anyways FWIW, 11 years as a data analyst/architect tells me I could get these results over lunch IF their data collection is clean and their schema doesn't look like trash. To wit:
query rank table- results-aq -date;
match table new rankings rewards;
run query matching userid to new rank;
rewards should be userid driven based on snapshot of rank at time of last aq, not alliance driven
execute

assuming they have their data tables run right. easy.

Masters student in Statistics here (undergraduate was in stat and data science)- also in disbelief that anything they listed could possibly take this long. Their architecture is, at best, a cesspool and thats really the only explanation besides incompetence

SandPounder

At this point they are probably wishing they agreed to just double the rewards for this AQ that’s about to finish

DNA3000

Y'all should calm down. Rewards will come tomorrow
They had almost a week and a half to figure it out but couldn't? Come on man, it's not even a coding nightmare they're just lazy.
Can you explain how it's not a coding nightmare? Can you explain exactly how Kabam could have done it earlier? I can only assume you have insider knowledge in their processes to be able to make a bold statement like you just did.
What do you mean how it's not a coding nightmare all they have to do is look back at the rewards they sent last AQ and send them again it isn't rocket science lmao I don't have insider knowledge but I have something called a brain which gives me the ability to think logically, you don't?
So if it's that simple, why would it take this long? I'm well aware you don't have insider knowledge as that was a rhetorical question. It's never as simple as you think it is.
Because they're lazy, that's why. I praise the devs when they deserve to be praised but almost two weeks just to send out a bunch of rewards when they've literally done other stuff that actually can be a coding nightmare such as changing matchmaking in Battlegrounds in less than a week?
i think if they could've clicked a few buttons and sent out rewards, they would've done it already. don't assume that someone is lazy just because it's not getting done. if you have no idea what they have to do to send out the rewards, don't say that they can just click a few buttons and do it
They can click buttons to change matchmaking in less than a week but they can't do it to send out a bunch of rewards a week and a half after? Oh you poor sweet summer child.
Tell me you know nothing about programming without telling me you know nothing about programming.
Tell me you'll eat whatever nasty food you get served without telling me you'll eat whatever nasty food you get served... Mr. Hacker Programmer, there's a reason you're getting ratioed on every comment.
classy.

anyways FWIW, 11 years as a data analyst/architect tells me I could get these results over lunch IF their data collection is clean and their schema doesn't look like trash. To wit:
query rank table- results-aq -date;
match table new rankings rewards;
run query matching userid to new rank;
rewards should be userid driven based on snapshot of rank at time of last aq, not alliance driven
execute

assuming they have their data tables run right. easy.

Once upon a time in another game I asked a similar question. Then by chance I got to answer my own question. I gained substantial control of the beta servers. And I did something similar, for different reasons. And promptly crashed all the map servers. Because while you could query the live databases in that way, introducing more than a very short delay into the live system would cause blockades in the system and hang stuff. Which is why they never did that: they used procedural collectors to export live information preconditioned into export containers during specific transport windows.

When you say "if their data collection is clean" that hides basically all of the problem. If the data can be queried then I can get the data by query. But that's almost never how these kinds of systems work. In fact, in my experience if the backend isn't specifically designed to spit this data out in real time, it almost never can be queried directly either. Manys the time I've seen people have to fetch this data from the logs, because the logs are static and essentially exported off the live systems. Querying the live system directly is the sort of thing that few people are willing to risk, in real time systems.

In fact I'll bet everyone who's actually worked on game server back ends or even any industrial real time system is currently nodding, and everyone else that's ever picked up SQL for Dummies is wondering what the big deal is.

DrZola

Y'all should calm down. Rewards will come tomorrow
They had almost a week and a half to figure it out but couldn't? Come on man, it's not even a coding nightmare they're just lazy.
Can you explain how it's not a coding nightmare? Can you explain exactly how Kabam could have done it earlier? I can only assume you have insider knowledge in their processes to be able to make a bold statement like you just did.
What do you mean how it's not a coding nightmare all they have to do is look back at the rewards they sent last AQ and send them again it isn't rocket science lmao I don't have insider knowledge but I have something called a brain which gives me the ability to think logically, you don't?
So if it's that simple, why would it take this long? I'm well aware you don't have insider knowledge as that was a rhetorical question. It's never as simple as you think it is.
Because they're lazy, that's why. I praise the devs when they deserve to be praised but almost two weeks just to send out a bunch of rewards when they've literally done other stuff that actually can be a coding nightmare such as changing matchmaking in Battlegrounds in less than a week?
i think if they could've clicked a few buttons and sent out rewards, they would've done it already. don't assume that someone is lazy just because it's not getting done. if you have no idea what they have to do to send out the rewards, don't say that they can just click a few buttons and do it
They can click buttons to change matchmaking in less than a week but they can't do it to send out a bunch of rewards a week and a half after? Oh you poor sweet summer child.
Tell me you know nothing about programming without telling me you know nothing about programming.
Tell me you'll eat whatever nasty food you get served without telling me you'll eat whatever nasty food you get served... Mr. Hacker Programmer, there's a reason you're getting ratioed on every comment.
classy.

anyways FWIW, 11 years as a data analyst/architect tells me I could get these results over lunch IF their data collection is clean and their schema doesn't look like trash. To wit:
query rank table- results-aq -date;
match table new rankings rewards;
run query matching userid to new rank;
rewards should be userid driven based on snapshot of rank at time of last aq, not alliance driven
execute

assuming they have their data tables run right. easy.
Once upon a time in another game I asked a similar question. Then by chance I got to answer my own question. I gained substantial control of the beta servers. And I did something similar, for different reasons. And promptly crashed all the map servers. Because while you could query the live databases in that way, introducing more than a very short delay into the live system would cause blockades in the system and hang stuff. Which is why they never did that: they used procedural collectors to export live information preconditioned into export containers during specific transport windows.

When you say "if their data collection is clean" that hides basically all of the problem. If the data can be queried then I can get the data by query. But that's almost never how these kinds of systems work. In fact, in my experience if the backend isn't specifically designed to spit this data out in real time, it almost never can be queried directly either. Manys the time I've seen people have to fetch this data from the logs, because the logs are static and essentially exported off the live systems. Querying the live system directly is the sort of thing that few people are willing to risk, in real time systems.

In fact I'll bet everyone who's actually worked on game server back ends or even any industrial real time system is currently nodding, and everyone else that's ever picked up SQL for Dummies is wondering what the big deal is.

Friendly wager: which gets fixed first— the snowblind AQ background or the missing AQ rewards?

Dr. Zola

Just_grinding

@Kabam Zibiit so the game is built to be even more of a grind, expecting players to spend 2-3 hours a day between battlegrounds, incursions, arenas, and alliance events. But the team doesn’t have the bandwidth to do a few hours of data pulls? Run some sql queries, create a pivot table and it can be done in an afternoon. Shouldn’t take a week.

DNA3000

Y'all should calm down. Rewards will come tomorrow
They had almost a week and a half to figure it out but couldn't? Come on man, it's not even a coding nightmare they're just lazy.
Can you explain how it's not a coding nightmare? Can you explain exactly how Kabam could have done it earlier? I can only assume you have insider knowledge in their processes to be able to make a bold statement like you just did.
What do you mean how it's not a coding nightmare all they have to do is look back at the rewards they sent last AQ and send them again it isn't rocket science lmao I don't have insider knowledge but I have something called a brain which gives me the ability to think logically, you don't?
So if it's that simple, why would it take this long? I'm well aware you don't have insider knowledge as that was a rhetorical question. It's never as simple as you think it is.
Because they're lazy, that's why. I praise the devs when they deserve to be praised but almost two weeks just to send out a bunch of rewards when they've literally done other stuff that actually can be a coding nightmare such as changing matchmaking in Battlegrounds in less than a week?
i think if they could've clicked a few buttons and sent out rewards, they would've done it already. don't assume that someone is lazy just because it's not getting done. if you have no idea what they have to do to send out the rewards, don't say that they can just click a few buttons and do it
They can click buttons to change matchmaking in less than a week but they can't do it to send out a bunch of rewards a week and a half after? Oh you poor sweet summer child.
Tell me you know nothing about programming without telling me you know nothing about programming.
Tell me you'll eat whatever nasty food you get served without telling me you'll eat whatever nasty food you get served... Mr. Hacker Programmer, there's a reason you're getting ratioed on every comment.
classy.

anyways FWIW, 11 years as a data analyst/architect tells me I could get these results over lunch IF their data collection is clean and their schema doesn't look like trash. To wit:
query rank table- results-aq -date;
match table new rankings rewards;
run query matching userid to new rank;
rewards should be userid driven based on snapshot of rank at time of last aq, not alliance driven
execute

assuming they have their data tables run right. easy.
Once upon a time in another game I asked a similar question. Then by chance I got to answer my own question. I gained substantial control of the beta servers. And I did something similar, for different reasons. And promptly crashed all the map servers. Because while you could query the live databases in that way, introducing more than a very short delay into the live system would cause blockades in the system and hang stuff. Which is why they never did that: they used procedural collectors to export live information preconditioned into export containers during specific transport windows.

When you say "if their data collection is clean" that hides basically all of the problem. If the data can be queried then I can get the data by query. But that's almost never how these kinds of systems work. In fact, in my experience if the backend isn't specifically designed to spit this data out in real time, it almost never can be queried directly either. Manys the time I've seen people have to fetch this data from the logs, because the logs are static and essentially exported off the live systems. Querying the live system directly is the sort of thing that few people are willing to risk, in real time systems.

In fact I'll bet everyone who's actually worked on game server back ends or even any industrial real time system is currently nodding, and everyone else that's ever picked up SQL for Dummies is wondering what the big deal is.
Friendly wager: which gets fixed first— the snowblind AQ background or the missing AQ rewards?

Dr. Zola

I'll take AQ rewards. But we're probably going to have to resolve this bet on the honor system, as my retinas will probably be completely burned out by then.

DNA3000

@Kabam Zibiit so the game is built to be even more of a grind, expecting players to spend 2-3 hours a day between battlegrounds, incursions, arenas, and alliance events. But the team doesn’t have the bandwidth to do a few hours of data pulls? Run some sql queries, create a pivot table and it can be done in an afternoon. Shouldn’t take a week.