Recommended database setup? (9)
Hey STM peeps,
I'm still new and don't have a lot of data so I'm using excel spreadsheets. But thinking long-term and with the aim to avoid growing pains, I'd like to incorporate a database to house the data for quick querying. Could ya'll please advise on a good database setup/configuration? I really value organization and storing data efficiently so I would love to hear what kind of setups you use.
Thanks,
Ferg
What do you plan to store?
Anything and everything that is useful (which I'm still learning what is and isn't useful). Mainly campaign tracking/results analysis, lander tracking (what landers were used with what campaigns), offers (offer IDs, affiliate networks, payout $, GEOs, etc.), targeting details (per GEO: top carriers, top devices, top browsers, most spoken languages, so-on and so forth).
Of course, campaigns can be so short lived and things move so quickly on the internet that I don't want to get bogged down with data admin and accumulating data that can't be analyzed in a way to drive the bottom line so I'd like to hear what kind of data you veterans know is valuable and what isn't.
I imagine the campaign tracking is sufficiently handled by
P.S. I saw caurmen mention a database and importing a CSV for GEOIP data here and that's what got me thinking about a more powerful setup than excel https://stmforum.com/forum/showthrea...anges-for-City
A database will work but then you need to build out the admin section to be able to see and review all that data. For most I think it ends up being overkill and so spreadsheets are what they use.
Right, important to strike a balance and spreadsheets still do that well. As I work on these spreadsheets, I can see where it would be handy to use joins so at some point I imagine I'll naturally progress to a more comprehensive solution.
Yep that makes sense. i think it's worth saying that I don't think any tracking solution currently makes that part of things easy, it could interesting to see what a solution like that would look like.
Certainly. The trackers are sick, but nothing like your own custom views. Hoping to create some discussion on the topic as I was curious if anyone had a pretty robust setup for storing GEO/targeting (or any other data at scale) data to query efficiently. I'm not at a point where I'm limited by excel since it works well for small data sets and can pivot/use vlookups/filters. But given how valuable data analysis is in this industry I know people are crunching data on a big scale and really curious what a basic setup is like to be able to do that.
Originally Posted by poker007
Another interesting thread on tracking and landing pages: https://stmforum.com/forum/showthrea...g-Page-Hosting
Home > Technical & Creative Skills > Programming, Servers & Scripts