ARHG, Need help with excel - My head hurts! :(

by Matthew Miele 10 replies
Im having one of those momment when everything is in my head and its blocking my logical thinking!

I dont know if im doing it right, if i doing it the best way, im just stuck!

Ok, here is where I need help...

im going to be promoting cpa via PPC. So, i need to track every keyword. All that is taken care of....i will be using tracking code for sub IDs

so it will read...subid=a2b2

which means



So my sale (subid=a2b8) came from
Google>Camera Website>Camera Lens 1>Camera lens 1 info

- The keyword -in this case camera lens 1 info - is the keyword ill be bidding on.

Ok...so thats sorted.

THIS IS MY PROBLEM.

Im trying to make an excel sheet....(excel? or access? or something else?) to organise all my codes and keywords

Ive attached the excel file....which is what im trying to acomplish....again, Is this the best way to do what im trying to do?

- Obvioulsy each drop down list will determin the choices in the next drop down list

I have no idea how to code this thing or the formulas need.....and im quite good at excel


again, Is this the best way to do what im trying to do? haha


Thank you

Matthew
#main internet marketing discussion forum #arhg #excel #head #hurts #ppc #subids #tracking
Avatar of Unregistered
  • Profile picture of the author chriswight
    Instead of doing anything fancy with dropdowns, try going with a nice low-tech matrix.

    List your keywords in a column and the source, campaign, sub campaigns and keyword number as headings. You should be able to copy down most cells to fill in the blanks, and then make a simple formula like 1&2&3&4= to get your subid.
    Signature

    Chris Wight
    www.ChrisWight.com

    {{ DiscussionBoard.errors[42346].message }}
    • Profile picture of the author chriswight
      See the attached for an example.

      Just move each value up incrementally to cover each source, campaign, etc.
      Signature

      Chris Wight
      www.ChrisWight.com

      {{ DiscussionBoard.errors[42365].message }}
      • Profile picture of the author Chipt
        Can't you just download all your stats as a CSV file?

        Chip Tarver
        Signature

        Improve your online success permanently right now. Joint Venture Masters tell you the real insider info. Save $450 right now by checking out my *limited time* FCS WSO and change your JV success in a radical way permanently at http://www.warriorforum.com/forum/to...OPIC_ID=264511... and for less than $20 you can really save up to half your gasoline costs at www.CutYourGasCostsNow.com.

        {{ DiscussionBoard.errors[42695].message }}
        • Profile picture of the author Matthew Miele
          thats what im going to do. but then i need to excel sheet so I can match the IDs up to the keyword and source etc.
          {{ DiscussionBoard.errors[42706].message }}
          • Profile picture of the author debra
            actually Microsoft Access does all that better because it can update your forms striaght off the net.
            {{ DiscussionBoard.errors[42763].message }}
            • Profile picture of the author Matthew Miele
              hmm ah ok

              could any help me with an access database then please
              {{ DiscussionBoard.errors[42844].message }}
              • Profile picture of the author debra
                Originally Posted by Matthew Miele View Post

                hmm ah ok

                could any help me with an access database then please
                Well...yes.

                My daughter already has a skeleton data base written for this that she put together for the carpet mill she works at. They do adwords.

                She will be here on Saturday and then I can upload it onto my hard drive from her USB. Which...I was going to do anyway.

                There you go...but you have to wait til this weekend for it, if that's ok.
                {{ DiscussionBoard.errors[42952].message }}
                • Profile picture of the author Matthew Miele
                  Ah wow, that would be great debra! Thanks

                  Looking forward to it!

                  Matthew
                  {{ DiscussionBoard.errors[44381].message }}
                  • Profile picture of the author Matthew Miele
                    Hey Debra,

                    Just reminding you about the excel sheet hhehe

                    Thanks

                    Matthew
                    {{ DiscussionBoard.errors[49321].message }}
                    • Profile picture of the author debra
                      Originally Posted by Matthew Miele View Post

                      Hey Debra,

                      Just reminding you about the excel sheet hhehe

                      Thanks

                      Matthew
                      Matthew -

                      Sent you a PM
                      {{ DiscussionBoard.errors[54460].message }}
Avatar of Unregistered

Trending Topics