Vendor banners - Administration and Configuration

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

7/31/2006 2:17 PM

ritter

www.insidedsp.com
Joined: 7/31/2006

Posts: 3

Vendor banners

Any ideas on how to reset the # of views and clicks on a vendor banner without deleting it and starting over?
During the process of creating and testing the banner ad, we generated 50 views and 2 clicks and it hasn't even gone live yet. This seems like a logical feature of the module, but I can't find any such option.

7/31/2006 3:25 PM

John Mitchell

www.snapsis.com
Joined: 4/18/2003

Posts: 3987

Re: Vendor banners Modified By John Mitchell on 7/31/2006 3:26:38 PM

You can reset them in the Banners table in the DB.

If you want to reset ALL views and impressions for ALL vendors and all their ads you can use this

UPDATE Banners SET Impressions=0, Views=0, ClickThroughs=0

***Caution: If you don't want to reset them for all then you need to put criteria on this query to limit it to a specific vendorid and/or bannerid.

I agree, it would be nice to have a reset feature in the UI. Please add the request to Gemini at http://support.dotnetnuke.com

All that being said, are you really worried about those few impressions and clicks throwing the numbers off? :)

7/31/2006 4:07 PM

ritter

www.insidedsp.com
Joined: 7/31/2006

Posts: 3

Re: Vendor banners

Thanks for the quick response.
Where is the DB? Is that an area I, the Administrator, have access to?

As for the # of view, this is our first month of paid advertising with a vendor who has paid for only 5000 impressions, we want to be certain we are able to track the info correctly and provide accurate reports. As a work around, we just increased the limit on the number of impressions.

7/31/2006 4:30 PM

John Mitchell

www.snapsis.com
Joined: 4/18/2003

Posts: 3987

Re: Vendor banners

No, you can't get to it as an admin of the site. You'll have to talk to the person hosting it for you.

7/31/2006 7:03 PM

Rodney Joyce

www.pokerdiy.com
Joined: 4/28/2004

Posts: 2796

Re: Vendor banners

ritter wrote

we want to be certain we are able to track the info correctly and provide accurate reports.

You may be aware of this, but I wrote an article on Vendor Affiliate Reporting here... some people are not aware this functionality even exists!

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

Page 1 of 2

1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)