Area Statistiche: differenze tra le versioni

Da Webmobili Wiki.
← Differenza precedente
 
(332 versioni intermedie di 3 utenti non mostrate)
Riga 1: Riga 1:
{{InfoProgetto|nome=Area Statistiche|URL=http://statistics.designbest.com|testURL=http://statistics.dbdemo47.com ([[Area Statistiche\Ambiente di test|altri dettagli]])|versioning=SVN|versioning_trunkURL=https://svn.office.webmobili.it/svn/WM4/DB_AreaStatistiche|versioning_branchesURL=https://svn.office.webmobili.it/svn/WM4/branches/}}
{{InfoProgetto|nome=Area Statistiche|URL=http://statistics.designbest.com|testURL=http://statistics.dbdemo47.com ([[Area Statistiche\Ambiente di test|altri dettagli]])|versioning=SVN|versioning_trunkURL=https://svn.office.webmobili.it/svn/WM4/DB_AreaStatistiche|versioning_branchesURL=https://svn.office.webmobili.it/svn/WM4/branches/}}


'''Area Statistiche''' è l'interfaccia che permette di controllare l'andamento di produttori e rivenditori all'interno del portale Designbest e Trovaprodotti.<br/>
'''Area Statistiche''' è l'interfaccia che permette di controllare l'andamento di produttori e rivenditori all'interno del portale Designbest e Trovaprodotti.<br/>
== Origine dei dati ==
Il tracciamento dei dati si basa sullo script di '''Google Analytics'''.<br/>
Il tracciamento dei dati si basa sullo script di '''Google Analytics'''.<br/>
Ad ogni tipologia di pagina corrisponde un tracciamento (gaTrack). A loro volta i gaTrack sono divisi per i portali Designbest e Trovaprodotti.<br/>
Ad ogni tipologia di pagina corrisponde un tracciamento (gaTrack). A loro volta i gaTrack sono divisi per i portali Designbest e Trovaprodotti.<br/>
Nella tabella sottostante c'è uno schema riassuntivo. Cliccando sul link ''gaTrack'' si ottiene l'estrazione esatta della metrica richiesta per un campione esemplare.<br/><br/>
Nella tabella sottostante c'è uno schema riassuntivo. Cliccando sul link ''gaTrack'' si ottiene l'estrazione esatta della metrica richiesta per un campione esemplare.<br/><br/>


 
=== Query ad Analytics ===
Per quanto riguarda '''Designbest''':<br/>
Per quanto riguarda '''Designbest''':<br/>
<table class="wikitable sortable">
<table class="wikitable sortable">
Riga 28: Riga 31:
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fbrand%2Fkartell&max-results=10000 DB-brand_channel]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fbrand%2Fkartell&max-results=10000 DB-brand_channel]  </td>
     <td>  Scheda Brand-Channel  </td>
     <td>  Scheda Brand-Channel  </td>
  </tr>
  <tr>
    <td>Pagine dentro all'[[MagazinePosts.xml come generarlo|XML dei post del magazine]]</td>
    <td>  [https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&max-results=10000 DB-magazineposts]  </td>
    <td>  Magazine Post del Produttore  </td>
   </tr>
   </tr>
   <tr>
   <tr>
Riga 46: Riga 54:
   <tr>
   <tr>
     <td>  /{lang}/pro/{showroom(lang)}/{shopname}/{shopid}  </td>
     <td>  /{lang}/pro/{showroom(lang)}/{shopname}/{shopid}  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2Fgalliano_habitat%2F15277%24&max-results=10000 DB-shop]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5B%5Cw%5C-%5D%2B%2F15277%24&max-results=10000 DB-shop]  </td>
     <td>  Schede negozio  </td>
     <td>  Schede negozio  </td>
   </tr>
   </tr>
Riga 82: Riga 90:
     <td>  /{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{catalogo(lang)}  </td>
     <td>  /{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{catalogo(lang)}  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fpro%2Fshowroom%2F%5Cw%2B%2F%5Cd%2B%2Fcatalogo%24&max-results=10000 DB-catalog_shop]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fpro%2Fshowroom%2F%5Cw%2B%2F%5Cd%2B%2Fcatalogo%24&max-results=10000 DB-catalog_shop]  </td>
     <td>  Ricerca negozi generica ''(no filtri)''  </td>
     <td>  Ricerca negozi generica ''(no filtri)'', no catalog  </td>
  </tr>
  <tr>
    <td>  /{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{altro...}  </td>
    <td>  [https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5Cw%2B%2F%5Cd%2B%2F%5Cw%2B&max-results=10000 DB-shop_listing]  </td>
    <td>  Ricerca negozi totale (DB-catalog_shop , DB-catalog_shop_amb , DB-catalog_shop_typ , DB-catalog_shop_man , DB-catalog_shop_man_amb , DB-catalog_shop_man_typ) </td>
   </tr>
   </tr>
   <tr>
   <tr>
Riga 91: Riga 104:
   <tr>
   <tr>
     <td>  /{lang}/outlet/{occasione(lang)}/{occasionename}/{occasioneid}/{shopid}  </td>
     <td>  /{lang}/outlet/{occasione(lang)}/{occasionename}/{occasioneid}/{shopid}  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Foutlet%2Fnegozi%2F%5Cw%2B%2F15410&max-results=10000 DB-offer]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Foutlet%2Foccasione%2F%5Cw%2B%2F%5Cd%2B%2F15410&max-results=10000 DB-offer]  </td>
     <td>  Scheda occasione negozio </td>
     <td>  Scheda occasione negozio </td>
   </tr>
   </tr>
Riga 108: Riga 121:
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5Ewrite_275%24&max-results=10000 DB-catalog_receivedmail]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5Ewrite_275%24&max-results=10000 DB-catalog_receivedmail]  </td>
     <td>  Email ricevute su Designbest dal produttore  </td>
     <td>  Email ricevute su Designbest dal produttore  </td>
  </tr>
  <tr>
    <td>tr: <nowiki>produttore_bottone_impression:</nowiki> </td>
    <td>[https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2018-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5Ebottone_impression_275%24&max-results=10000 DB-catalog_bottoneimpression_]</td>
    <td>Impression ricevute su Designbest dal bottone del produttore</td>
   </tr>
   </tr>
   <tr>
   <tr>
Riga 126: Riga 144:
   <tr>
   <tr>
     <td>  /{lang}/{catalogo(lang)}/{manufacturer} </td>
     <td>  /{lang}/{catalogo(lang)}/{manufacturer} </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2F(katalog%7Ccatalog%7Ccatalogue%7Ccatalogo)%2Fkartell&max-results=10000 DB-catalog_userSessions]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2019-05-01&end-date=2019-05-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2Fkartell(%24%7C%5C%3F%7C%2F)&max-results=10000 DB-catalog_userSessions]  </td>
     <td>  Utenti e sessioni di un produttore su Designbest  </td>
     <td>  Utenti e sessioni di un produttore su Designbest  </td>
  </tr>
  <tr>
    <td>  /{lang}/{pro(lang)}/{showroom(lang)}/{shopname}/{shopid}/{altro...} </td>
    <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A94092734&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5B%5Cw%5C-%5D%2B%2F15314&max-results=10000 DB-shop_userSessions]  </td>
    <td>  Utenti e sessioni di un rivenditore su Designbest  </td>
   </tr>
   </tr>
   <tr>
   <tr>
Riga 143: Riga 166:
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3Aregion%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2F(catalogo%7Ccatalogue%7Ccatalog%7Ckatalog)%2F%5Cw%2B%2F%3F%5Cw*%2F%3F%5Cw*(%24%7C%5C%3F.*)&max-results=10000 DB-catalog_graphGeolocalization]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3Aregion%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2F(catalogo%7Ccatalogue%7Ccatalog%7Ckatalog)%2F%5Cw%2B%2F%3F%5Cw*%2F%3F%5Cw*(%24%7C%5C%3F.*)&max-results=10000 DB-catalog_graphGeolocalization]  </td>
     <td>  Geolocalizzazione del catalogo su Designbest  </td>
     <td>  Geolocalizzazione del catalogo su Designbest  </td>
  </tr>
  <tr>
    <td>  segment =~ /outlet  </td>
    <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2019-03-01&end-date=2019-03-31&metrics=ga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2Foutlet DB-outlet-sessions]  </td>
    <td>  Sessioni totali dell'oultet  </td>
   </tr>
   </tr>
</table>
</table>


Per quanto riguarda '''Trovaprodotti''':
Per quanto riguarda '''Trovaprodotti''':
<table class="wikitable sortable">
<table class="wikitable sortable" style="width:100%">
   <tr>
   <tr>
     <th>URL/Tracciamento</th>
     <th>URL/Tracciamento</th>
Riga 172: Riga 200:
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FProduct%2FShop_30978_Product_88464&max-results=10000 TP-product]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FProduct%2FShop_30978_Product_88464&max-results=10000 TP-product]  </td>
     <td>  Scheda prodotto  </td>
     <td>  Scheda prodotto  </td>
  </tr>
  <tr>
    <td>  it/Product/Selections/Shop_[IDshop]_Product_[IDProduct]  </td>
    <td>  [https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2FProduct%2FSelections%2FShop_%5Cd%2B_Product_%5Cd%2B&max-results=10000 TP-product_selection]  </td>
    <td>  Scheda prodotto da selezione  </td>
   </tr>
   </tr>
   <tr>
   <tr>
Riga 207: Riga 240:
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2FProduct%2FSelections%2FShop_36806_Product_781&max-results=10000 TP-selection]  </td>
     <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2FProduct%2FSelections%2FShop_36806_Product_781&max-results=10000 TP-selection]  </td>
     <td>  Scheda prodotto di selezione  </td>
     <td>  Scheda prodotto di selezione  </td>
  </tr>
  <tr>
    <td>  segment =~ /\w{2}/\w+/Offers  </td>
    <td>  [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2019-03-01&end-date=2019-03-31&metrics=ga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2F%5Cw%2B%2FOffers TP-totoffers-sessions]  </td>
    <td>  Sessioni totali del Trovaoccasioni  </td>
   </tr>
   </tr>
</table><br/>
</table><br/>


I seguenti dati mese per mese vengono recuperati da Analytics ed aggregati nel '''nostro database''' nella seguente struttura
=== Da Analytics al Database tramite Intruder ===
[[File:Statistiche - MainTables.png|left|top]]
I seguenti dati mese per mese vengono recuperati da Analytics ed aggregati nel '''nostro database''' tramite il programma [[Intruder|Designbest Statistics Intruder]].<br/>
'''Intruder''' , mese per mese, permette di eseguire l'inserimento dei dati tramite i seguenti task modulari indipendenti:<br/>
* <span id="intruderA" style="font-size:.6rem;color:green;">A</span> ''visite, impression - manufacturer''
* <span id="intruderB" style="font-size:.6rem;color:green;">B</span> ''utenze, sessioni - manufacturer''
* <span id="intruderC" style="font-size:.6rem;color:green;">C</span> ''grafici genere, età, geoloc - manufacturer''
* <span id="intruderD" style="font-size:.6rem;color:green;">D</span> ''visite ai post magazine - manufacturer''
* <span id="intruderE" style="font-size:.6rem;color:green;">E</span> ''schede negozio - negozi''
* <span id="intruderF" style="font-size:.6rem;color:green;">F</span> ''utenze, sessioni - negozi''
* <span id="intruderG" style="font-size:.6rem;color:green;">G</span> ''schede occasione - occasioni''
* <span id="intruderH" style="font-size:.6rem;color:green;">H</span> ''prodotti, cataloghi visti - trovaprodotti''
* <span id="intruderI" style="font-size:.6rem;color:green;">I</span> ''ambienti visti - trovaprodotti''
* <span id="intruderL" style="font-size:.6rem;color:green;">L</span> ''schede negozio - trovaprodotti''
* <span id="intruderM" style="font-size:.6rem;color:green;">M</span> ''schede occasione - trovaprodotti''
* <span id="intruderN" style="font-size:.6rem;color:green;">N</span> ''schede prodotto - prodotti''
* <span id="intruderO" style="font-size:.6rem;color:green;">O</span> ''schede prodotto da negozio - prodotti''
* <span id="intruderP" style="font-size:.6rem;color:green;">P</span> ''applicazione moltiplicatore''
 
all'interno di questa nostra struttura dati:
 
<div style="display:flex;flex-wrap:wrap;background-color:#806000;justify-content: space-around;align-items:center;">
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ManufacturerByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderB|<span style="font-size:.6rem;color:green;">B</span>]]</td>
    <td id="STS_ManufacturerByDevice_Users">Users</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2F(katalog%7Ccatalog%7Ccatalogue%7Ccatalogo)%2Fkartell&max-results=10000 DB-catalog_userSessions]</td>
  </tr>
  <tr>
    <td>[[#intruderB|<span style="font-size:.6rem;color:green;">B</span>]]</td>
    <td id="STS_ManufacturerByDevice_Sessions">Sessions</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2F(katalog%7Ccatalog%7Ccatalogue%7Ccatalogo)%2Fkartell&max-results=10000 DB-catalog_userSessions]</td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerByDevice_Impressions">Impressions</td>
    <td style="font-size:.7rem;max-width:150px;">fonte: [[DFP (documentazione varia)|DFP]] + [https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-09-01&end-date=2018-09-30&metrics=ga%3AtotalEvents&dimensions=ga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5Eimpression_275%24&max-results=10000 DB-catalog_bottoneimpression]</td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerByDevice_WebsiteVisits">WebsiteVisits</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2018-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5Ebottone_impression__275%24&max-results=10000 DB-catalog_websitevisits] + [[DFP (documentazione varia)|Click al banner DFP]] </td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerByDevice_DownloadedPDFs">DownloadedPDFs</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5EdownloadPDF_367_%5Cd%2B%24&max-results=10000 DB-catalog_downloadedpdfs]</td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerByDevice_ReceivedEmails">ReceivedEmails</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dproduttore%3Bga%3AeventAction%3D~%5Ewrite_275%24&max-results=10000 DB-catalog_receivedmail]</td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerByDevice_CatalogPageViews">CatalogPageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fcatalogo%2Fkartell%2F%5Cw%2B%2F%3F%5Cw*%2F%3F%5Cw*(%24%7C%5C%3F.*)&max-results=10000 DB-catalog] +[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fnovita%2Fazienda%2Fkartell&max-results=10000 DB-catalog-news] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fbrand%2Fkartell&max-results=10000 DB-brand_channel] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2F(negozi%7Cmagasins%7Ceinrichtungshaeuser%7Cstores).*manufacturerFilter%5C%3Dkartell&max-results=10000 DB-res_shop_by_catalog] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5Cw%2B%2F10341%2F%5Cw%2B%24%3Bga%3ApagePath!~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5Cw%2B%2F10341%2Fcatalogo%24&max-results=10000 DB-catalog_shop_man]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ManufacturerOtherImpressions</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Contract</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerOtherImpressions_Impressions">Impressions</td>
    <td style="font-size:.7rem;max-width:150px;">fonte: [[DFP (documentazione varia)|DFP]]</td>
  </tr>
  <tr>
    <td>[[#intruderA|<span style="font-size:.6rem;color:green;">A</span>]]</td>
    <td id="STS_ManufacturerOtherImpressions_WebsiteVisits">WebsiteVisits</td>
    <td style="font-size:.7rem;max-width:150px;">fonte: [[DFP (documentazione varia)|DFP]]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ManufacturerByAgeBracket</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>AgeBracket</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderC|<span style="font-size:.6rem;color:green;">C</span>]]</td>
    <td id="STS_ManufacturerByAgeBracket_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AuserAgeBracket&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fcatalogo%2Fkartell%2F%3F%5Cw*%2F%3F%5Cw*(%24%7C%5C%3F.*)&max-results=10000 DB-catalog_graphAge]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ManufacturerByGender</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Gender</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderC|<span style="font-size:.6rem;color:green;">C</span>]]</td>
    <td id="STS_ManufacturerByGender_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AuserGender&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fcatalogo%2Fkartell%2F%3F%5Cw*%2F%3F%5Cw*(%24%7C%5C%3F.*)&max-results=10000 DB-catalog_graphGender]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ManufacturerByGEO</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Geolocalization</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderC|<span style="font-size:.6rem;color:green;">C</span>]]</td>
    <td id="STS_ManufacturerByGEO_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3Aregion%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2F(catalogo%7Ccatalogue%7Ccatalog%7Ckatalog)%2F%5Cw%2B%2F%3F%5Cw*%2F%3F%5Cw*(%24%7C%5C%3F.*)&max-results=10000 DB-catalog_graphGeolocalization]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_MagazinePostsByManufacturer</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ArticleID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderD|<span style="font-size:.6rem;color:green;">D</span>]]</td>
    <td id="STS_MagazinePostsByManufacturer_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&max-results=10000 DB-magazineposts]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ShopByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td></td>
    <td>Impressions</td>
    <td style="font-size:.7rem;max-width:150px;">non tracciato</td>
  </tr>
  <tr>
    <td>[[#intruderE|<span style="font-size:.6rem;color:green;">E</span>]]</td>
    <td id="STS_ShopByDevice_WebsiteVisits">WebsiteVisits</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dnegozio%3Bga%3AeventAction%3D~%5Evisit_15314%24&max-results=10000 DB-shop_websitevisits]</td>
  </tr>
  <tr>
    <td>[[#intruderE|<span style="font-size:.6rem;color:green;">E</span>]]</td>
    <td id="STS_ShopByDevice_ReceivedEmails">ReceivedEmails</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3AtotalEvents&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath%2Cga%3AeventAction&sort=-ga%3AtotalEvents&filters=ga%3AeventCategory%3D%3Dnegozio%3Bga%3AeventAction%3D~%5Ewrite_15314%24&max-results=10000 DB-shop_receivedmail]</td>
  </tr>
  <tr>
    <td>[[#intruderE|<span style="font-size:.6rem;color:green;">E</span>]]</td>
    <td id="STS_ShopByDevice_CatalogPageViews">CatalogPageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2Fgalliano_habitat%2F15277%24&max-results=10000 DB-shop] + [https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5Cw%2B%2F%5Cd%2B%2F%5Cw%2B&max-results=10000 DB-shop_listing]</td>
  </tr>
  <tr>
    <td>[[#intruderE|<span style="font-size:.6rem;color:green;">E</span>]]</td>
    <td id="STS_ShopByDevice_CatalogOffersPageViews">CatalogOffersPageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Foutlet%2Fnegozi%2F%5Cw%2B%2F15410&max-results=10000 DB-res_offers]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ShopBySessions</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderF|<span style="font-size:.6rem;color:green;">F</span>]]</td>
    <td id="STS_ShopBySessions_Users">Users</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5Cw%2B%2F15314&max-results=10000 DB-shop_userSessions]</td>
  </tr>
  <tr>
    <td><span style="font-size:.6rem;color:green;">F</span></td>
    <td id="STS_ShopBySessions_Sessions">Sessions</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Ausers%2Cga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2Fpro%2Fshowroom%2F%5Cw%2B%2F15314&max-results=10000 DB-shop_userSessions]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_TpOfferByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>OfferID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderG|<span style="font-size:.6rem;color:green;">G</span>]]</td>
    <td id="STS_TpOfferByDevice_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FProduct%2FOffers%2FShop_30978&max-results=10000 TP-offer]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ProductByTpByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ProductID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>TpID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderE|<span style="font-size:.6rem;color:green;">H</span>]]</td>
    <td id="STS_ProductByTpByDevice_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FProduct%2FShop_30978_Product_88464&max-results=10000 TP-product] + [https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2FProduct%2FSelections%2FShop_%5Cd%2B_Product_%5Cd%2B&max-results=10000 TP-product_selection]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ManufacturerByTP</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ManufacturerID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>TpID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderH|<span style="font-size:.6rem;color:green;">H</span>]]</td>
    <td id="STS_ManufacturerByTP_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResult%2FShop_109347_Manufacturer_1788&max-results=10000 TP-catalog]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_TPbyAmbient</th>
  </tr>
  <tr>
    <td>K</td>
    <td>TpID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>AmbientID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderI|<span style="font-size:.6rem;color:green;">I</span>]]</td>
    <td id="STS_TPbyAmbient_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResultAmbient%2FShop_40278_Ambient_21&max-results=10000 TP-amb] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResult%2FShop_30978_Ambient_5&max-results=10000 TP-result]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_TpByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>TpID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderL|<span style="font-size:.6rem;color:green;">L</span>]]</td>
    <td id="STS_TpByDevice_ReceivedEmails">ReceivedEmails</td>
    <td style="font-size:.7rem;max-width:150px;">fonte: tabella STS_Email di designbest</td>
  </tr>
  <tr>
    <td>[[#intruderL|<span style="font-size:.6rem;color:green;">L</span>]]</td>
    <td id="STS_TpByDevice_CatalogPageViews">CatalogPageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FHome%2FIndex%2F42094&max-results=10000 TP-hp] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResultNews%2FShop_40278&max-results=10000 TP-news] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResult%2FManufacturersList%2F109137&max-results=10000 TP-res_catalogs] + [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResultSelection%2FShop_44499_Selection_371&max-results=10000 TP-res_selections]</td>
  </tr>
  <tr>
    <td>[[#intruderL|<span style="font-size:.6rem;color:green;">L</span>]]</td>
    <td id="STS_TpByDevice_CatalogOffersPageViews">CatalogOffersPageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FResult%2FOffers%2FShop_30978&max-results=10000 TP-res_offers]</td>
  </tr>
  <tr>
    <td>[[#intruderL|<span style="font-size:.6rem;color:green;">L</span>]]</td>
    <td id="STS_TpByDevice_Entrances">Entrances</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Aentrances&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Aentrances&filters=ga%3ApagePath%3D~%5E%2F%5Cw%7B2%7D%2F(Home%7CResult)%2F%5Cw%2B%2F15314&max-results=10000 TP-shop_entrances]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_TpOfferByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>OfferID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderM|<span style="font-size:.6rem;color:green;">M</span>]]</td>
    <td id="STS_TpOfferByDevice_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2FProduct%2FOffers%2FShop_30978&max-results=10000 TP-offer]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_OutletOfferByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>OfferID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderM|<span style="font-size:.6rem;color:green;">M</span>]]</td>
    <td id="STS_OutletOfferByDevice_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Foutlet%2Foccasione%2F%5Cw%2B%2F%5Cd%2B%2F15410&max-results=10000 DB-offer]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ProductByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ProductID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderN|<span style="font-size:.6rem;color:green;">N</span>]], [[#intruderP|<span style="font-size:.6rem;color:green;">P</span>]]</td>
    <td id="STS_ProductByDevice_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fcatalogo%2Fkartell%2F%5Cw%2B%2F%5Cw%2B%2F%5Cw%2B%2F%5Cd%2B&max-results=10000 DB-product]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_ProductByShopByDevice</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ProductID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>DeviceType</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderO|<span style="font-size:.6rem;color:green;">O</span>]], [[#intruderP|<span style="font-size:.6rem;color:green;">P</span>]]</td>
    <td id="STS_ProductByShopByDevice_PageViews">PageViews</td>
    <td style="font-size:.7rem;max-width:150px;">[https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2016-08-01&end-date=2016-08-31&metrics=ga%3Apageviews&dimensions=ga%3AdeviceCategory%2Cga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D~%5E%2Fit%2Fcatalogo%2Fkartell%2F%5Cw%2B%2F%5Cw%2B%2F%5Cw%2B%2F%5Cd%2B%2F%5Cw%2B%2F%5Cd%2B&max-results=10000 DB-product_shop]</td>
  </tr>
</table>
 
<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_OutletShopSessions</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderG|<span style="font-size:.6rem;color:green;">G</span>]]</td>
    <td id="STS_OutletShopSessions_Sessions">Sessions</td>
    <td style="font-size:.7rem;max-width:150px;">[[#Sessioni_su_Outlet_Design|<span style="font-size:.6rem;color:green;">algoritmo Cydrolous</span>]]</td>
  </tr>
</table>


<table class="wikitable" style="margin:1em">
  <tr>
    <th colspan="3">STS_TpTotalOffersSessions</th>
  </tr>
  <tr>
    <td>K</td>
    <td>ShopID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>ZoneID</td>
  </tr>
  <tr>
    <td>K</td>
    <td>Data</td>
  </tr>
  <tr>
    <td>[[#intruderM|<span style="font-size:.6rem;color:green;">M</span>]]</td>
    <td id="STS_TpTotalOffersSessions_Sessions">Sessions</td>
    <td style="font-size:.7rem;max-width:150px;">[[#Sessioni_su_Trovaoccasioni|<span style="font-size:.6rem;color:green;">algoritmo Cydrolous</span>]]</td>
  </tr>
</table>
</div>


<div style="clear:both"></div>
<div style="clear:both"></div>
=== Algoritmo Cydrolous ===
Il calcolo delle '''sessioni''' di '''Trovaoccasioni''' e di '''Outlet Design''' avviene tramite un algoritmo detto '''Cydrolous'''.<br/>
In breve i passaggi
==== Sessioni su Outlet Design ====
* <code>outletTotalSessions</code> = <code>SOMMA [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A126098721&start-date=2019-03-01&end-date=2019-03-31&metrics=ga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2Foutlet DB-outlet-sessions]</code>
<span style="font-size:.8em">La somma dei valori restituiti dalla query analytics fatta su tutto l'outlet (e tutti i negozi) nel periodo specificato</span><br/><br/>
* <code>outletTotalPageViews</code> = <code>SOMMA Pagine Viste Totali Outlet</code>
<span style="font-size:.8em">Un'estrazione del tipo <code>SELECT SUM(PageViews) FROM ...</code> su tutto l'outlet (e tutti i negozi) nel periodo specificato</span><br/><br/>
* <code>totalPageViewsPerSession</code> = <code>outletTotalPageViews</code> / <code>outletTotalSessions</code>
<span style="font-size:.8em">Parziale intermedio</span><br/><br/>
* <code>shopOutletSessions</code> = <code>shopOutletTotalPageViews</code> / <code>totalPageViewsPerSession</code>
<span style="font-size:.8em">Le sessioni di un singolo negozio sono le sue pagine viste totali diviso il parziale</span><br/>
==== Sessioni su Trovaoccasioni ====
* <code>offersTotalSessions</code> = <code>SOMMA [https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A66262932&start-date=2019-03-01&end-date=2019-03-31&metrics=ga%3Asessions&dimensions=ga%3AdeviceCategory&sort=-ga%3Asessions&segment=sessions%3A%3Acondition%3A%3Aga%3ApagePath%3D~%2F%5Cw%7B2%7D%2F%5Cw%2B%2FOffers TP-totoffers-sessions]</code>
<span style="font-size:.8em">La somma dei valori restituiti dalla query analytics fatta su tutto il Trovaprodotti (e tutti i negozi) nel periodo specificato</span><br/><br/>
* <code>offersTotalPageViews</code> = <code>SOMMA Pagine Viste Totali Occasioni Trovaprodotti</code>
<span style="font-size:.8em">Un'estrazione del tipo <code>SELECT SUM(PageViews) FROM ...</code> su tutto il Trovaprodotti (e tutti i negozi) nel periodo specificato</span><br/><br/>
* <code>totalPageViewsPerSession</code> = <code>offersTotalPageViews</code> / <code>offersTotalSessions</code>
<span style="font-size:.8em">Parziale intermedio</span><br/><br/>
* <code>shopOffersSessions</code> = <code>shopOffersTotalPageViews</code> / <code>totalPageViewsPerSession</code>
<span style="font-size:.8em">Le sessioni di un singolo negozio sono le sue pagine viste totali diviso il parziale</span><br/><br/>


== Area Produttori ==
== Area Produttori ==
=== Sintesi ===
==== Tabellino riassuntivo ====
I dati vengono recuperati tramite la stored procedure ''MAN_Recap''
<table class="wikitable">
  <tr>
    <td>Utenti unici</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_Users|STS_ManufacturerByDevice.Users]]</td>
  </tr>
  <tr>
    <td>Visite</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_Sessions|STS_ManufacturerByDevice.Sessions]]</td>
  </tr>
  <tr>
    <td>Pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_CatalogPageViews|STS_ManufacturerByDevice.CatalogPageViews]] + [[#STS_ManufacturerByTP_PageViews|STS_ManufacturerByTP.PageViews]] + [[#STS_ProductByDevice_PageViews|STS_ProductByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]]</td>
  </tr>
  <tr>
    <td>Impression ADV</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_Impressions|STS_ManufacturerByDevice.Impressions]]</td>
  </tr>
  <tr>
    <td>Visite al sito</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_WebsiteVisits|STS_ManufacturerByDevice.WebsiteVisits]]</td>
  </tr>
  <tr>
    <td>Download cataloghi pdf</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_DownloadedPDFs|STS_ManufacturerByDevice.DownloadedPDFs]]</td>
  </tr>
  <tr>
    <td>Email ricevute</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_ReceivedEmails|STS_ManufacturerByDevice.ReceivedEmails]]</td>
  </tr>
</table>


==== Grafici ====
<table class="wikitable">
  <tr>
    <td>Fasce d'età</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByAgeBracket_PageViews|STS_ManufacturerByAgeBracket.PageViews]]</td>
  </tr>
  <tr>
    <td>Sesso</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByGender_PageViews|STS_ManufacturerByGender.PageViews]]</td>
  </tr>
  <tr>
    <td>Dispositivi</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_CatalogPageViews|STS_ManufacturerByDevice.CatalogPageViews]]</td>
  </tr>
  <tr>
    <td>Geolocalizzazione (nascosto)</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByGEO_PageViews|STS_ManufacturerByGEO.PageViews]]</td>
  </tr>
</table>
=== Prodotti ===
==== Tabellino riassuntivo ====
I dati sono restituiti dalla stored procedure ''MAN_TOTs''
<table class="wikitable">
  <tr>
    <td>Pagine catalogo viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_CatalogPageViews|STS_ManufacturerByDevice.CatalogPageViews]] + [[#STS_ManufacturerByTP_PageViews|STS_ManufacturerByTP.PageViews]]</td>
  </tr>
  <tr>
    <td>Schede prodotto viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ProductByDevice_PageViews|STS_ProductByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]]</td>
  </tr>
</table>
==== Elenco top 50 prodotti ====
I dati sono restituiti dalla stored procedure ''MAN_Products''
<table class="wikitable">
  <tr>
    <td>Prodotto pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ProductByDevice_PageViews|STS_ProductByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]]</td>
  </tr>
</table>
=== Distribuzione ===
Si tratta dell'elenco dei rivenditori in ordine alfabetico associati alla rete di produttori.
=== Advertising ===
==== Impression da contratto ====
<table class="wikitable">
  <tr>
    <td>Impression Banner</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_Impressions|STS_ManufacturerByDevice.Impressions]]</td>
  </tr>
  <tr>
    <td>Visite al sito</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerByDevice_WebsiteVisits|STS_ManufacturerByDevice.WebsiteVisits]]</td>
  </tr>
</table>
==== Impression extra contratto ====
<table class="wikitable">
  <tr>
    <td>Impression Banner</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerOtherImpressions_Impressions|STS_ManufacturerOtherImpressions.Impressions]]</td>
  </tr>
  <tr>
    <td>Visite al sito</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ManufacturerOtherImpressions_WebsiteVisits|STS_ManufacturerOtherImpressions.WebsiteVisits]]</td>
  </tr>
</table>
=== Magazine (step 2) ===
I dati vengono recuperati tramite la stored procedure ''MAN_MagazinePosts''
<table class="wikitable">
  <tr>
    <td>Articolo pageViews</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_MagazinePostsByManufacturer_PageViews|STS_MagazinePostsByManufacturer.PageViews]]</td>
  </tr>
</table>
=== Social (step 2) ===
Elenco totale dei post su Facebook in ordine dal più recente del produttore.
=== Newsletter (step 2) ===
Area in disuso.


== Area Negozi ==
== Area Negozi ==
=== Sintesi ===
==== Tabellino riassuntivo ====
I dati vengono recuperati tramite la stored procedure ''SHOP_Recap''
<table class="wikitable">
  <tr>
    <td>Visite</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopBySessions_Sessions|STS_ShopBySessions.Sessions]] + [[#STS_TpByDevice_Entrances|STS_TpByDevice.Entrances]]</td>
  </tr>
  <tr>
    <td>Pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopByDevice_CatalogPageViews|STS_ShopByDevice.CatalogPageViews]] + [[#STS_ShopByDevice_CatalogOffersPageViews|STS_ShopByDevice.CatalogOffersPageViews]] + [[#STS_TpByDevice_CatalogPageViews|STS_TpByDevice.CatalogPageViews]] + [[#STS_TpByDevice_CatalogOffersPageViews|STS_TpByDevice.CatalogOffersPageViews]] + [[#STS_TPbyAmbient_PageViews|STS_TPbyAmbient.PageViews]] + [[#STS_ManufacturerByTP_PageViews|STS_ManufacturerByTP.PageViews]] + [[#STS_ProductByShopByDevice_PageViews|STS_ProductByShopByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]] + [[#STS_OutletOfferByDevice_PageViews|STS_OutletOfferByDevice.PageViews]] + [[#STS_TpOfferByDevice_PageViews|STS_TpOfferByDevice.PageViews]]</td>
  </tr>
  <tr>
    <td>Click al tuo sito</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopByDevice_WebsiteVisits|STS_ShopByDevice.WebsiteVisits]]</td>
  </tr>
  <tr>
    <td>Email ricevute</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopByDevice_ReceivedEmails|STS_ShopByDevice.ReceivedEmails]] + [[#STS_TpByDevice_ReceivedEmails|STS_TpByDevice.ReceivedEmails]]</td>
  </tr>
</table>
==== Traffico per canale ====
<table class="wikitable">
  <tr>
    <th></th>
    <th>Store channel</th>
    <th>Occasioni</th>
    <th>Trovaprodotti</th>
    <th>Totale</th>
  </tr>
  <tr>
    <td>Visite</td>
    <td style="font-family:monospace;color:#806000;max-width:20%;">[[#STS_ShopBySessions_Sessions|STS_ShopBySessions.Sessions]]</td>
    <td style="font-family:monospace;color:#806000;max-width:20%;">[[#STS_OutletShopSessions_Sessions|STS_OutletShopSessions.Sessions]] + [[#STS_TpTotalOffersSessions_Sessions|STS_TpTotalOffersSessions.Sessions]]</td>
    <td style="font-family:monospace;color:#806000;max-width:20%;">[[#STS_TpByDevice_Entrances|STS_TpByDevice.Entrances]]</td>
    <td></td>
  </tr>
  <tr>
    <td>Pagine viste</td>
    <td style="font-family:monospace;color:#806000;max-width:20%;">[[#STS_ShopByDevice_CatalogPageViews|STS_ShopByDevice.CatalogPageViews]] + [[#STS_ProductByShopByDevice_PageViews|STS_ProductByShopByDevice.PageViews]]</td>
    <td style="font-family:monospace;color:#806000;max-width:20%;">[[#STS_ShopByDevice_CatalogOffersPageViews|STS_ShopByDevice.CatalogOffersPageViews]] + [[#STS_OutletOfferByDevice_PageViews|STS_OutletOfferByDevice.PageViews]] +[[#STS_TpByDevice_CatalogOffersPageViews|STS_TpByDevice.CatalogOffersPageViews]] + [[#STS_TpOfferByDevice_PageViews|STS_TpOfferByDevice.PageViews]]</td>
    <td style="font-family:monospace;color:#806000;max-width:20%;">[[#STS_TpByDevice_CatalogPageViews|STS_TpByDevice.CatalogPageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]] + [[#STS_TPbyAmbient_PageViews|STS_TPbyAmbient.PageViews]] + [[#STS_ManufacturerByTP_PageViews|STS_ManufacturerByTP.PageViews]]</td>
    <td></td>
  </tr>
</table>
==== Grafico ====
<table class="wikitable">
  <tr>
    <td>Dispositivi</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopByDevice_CatalogPageViews|STS_ShopByDevice.CatalogPageViews]] + [[#STS_ShopByDevice_CatalogOffersPageViews|STS_ShopByDevice.CatalogOffersPageViews]] + [[#STS_TpByDevice_CatalogPageViews|STS_TpByDevice.CatalogPageViews]] + [[#STS_TpByDevice_CatalogOffersPageViews|STS_TpByDevice.CatalogOffersPageViews]]</td>
  </tr>
</table>
=== Prodotti ===
==== Tabellino riassuntivo [[#warningRefuso|<span style="color:red;font-weight:bold;font-size:2em;" title="ATTENZIONE">*</span>]] ====
<table class="wikitable">
  <tr>
    <td>Pagine catalogo viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopByDevice_CatalogPageViews|STS_ShopByDevice.CatalogPageViews]] + [[#STS_TpByDevice_CatalogPageViews|STS_TpByDevice.CatalogPageViews]]</td>
  </tr>
  <tr>
    <td>Schede prodotto viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ProductByShopByDevice_PageViews|STS_ProductByShopByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]] + [[#STS_TPbyAmbient_PageViews|STS_TPbyAmbient.PageViews]] + [[#STS_ManufacturerByTP_PageViews|STS_ManufacturerByTP.PageViews]]</td>
  </tr>
</table>
<div id="warningRefuso">
  <span style="font-weight:bold;color:red;">* ATTENZIONE</span><br/>
  Il valore '''Totale pagine viste''' è privo di Outlet Design e di Trovaoccasioni.<br/>
  In pratica mancano [[#STS_ShopByDevice_CatalogOffersPageViews|STS_ShopByDevice.CatalogOffersPageViews]] + [[#STS_OutletOfferByDevice_PageViews|STS_OutletOfferByDevice.PageViews]] + [[#STS_TpByDevice_CatalogOffersPageViews|STS_TpByDevice.CatalogOffersPageViews]] + [[#STS_TpOfferByDevice_PageViews|STS_TpOfferByDevice.PageViews]]
</div>
==== Prodotti ====
I dati sono restituiti dalla stored procedure ''SHOP_NET_Products''
<table class="wikitable">
  <tr>
    <td>Prodotto pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ProductByShopByDevice_PageViews|STS_ProductByShopByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]]</td>
  </tr>
</table>
=== Marche ===
I dati sono restituiti dalla stored procedure ''SHOP_NET_Manufacturers''
<table class="wikitable">
  <tr>
    <td>Produttore pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ProductByShopByDevice_PageViews|STS_ProductByShopByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]]</td>
  </tr>
</table>
=== Aree Casa ===
I dati sono restituiti dalla stored procedure ''SHO_NET_Ambients''
<table class="wikitable">
  <tr>
    <td>Ambiente pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ProductByShopByDevice_PageViews|STS_ProductByShopByDevice.PageViews]] + [[#STS_ProductByTpByDevice_PageViews|STS_ProductByTpByDevice.PageViews]]</td>
  </tr>
</table>
=== Outlet design (step 2) ===
==== Tabellino riassuntivo ====
<table class="wikitable">
  <tr>
    <td>Pagine catalogo viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_ShopByDevice_CatalogOffersPageViews|STS_ShopByDevice.CatalogOffersPageViews]] + [[#STS_TpByDevice_CatalogOffersPageViews|STS_TpByDevice.CatalogOffersPageViews]]</td>
  </tr>
  <tr>
    <td>Schede prodotto viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_OutletOfferByDevice_PageViews|STS_OutletOfferByDevice.PageViews]] + [[#STS_TpOfferByDevice_PageViews|STS_TpOfferByDevice.PageViews]]</td>
  </tr>
</table>
==== Occasioni ====
I dati sono restituiti dalla stored procedure ''SHOP_NET_Offers''
<table class="wikitable">
  <tr>
    <td>Occasione pagine viste</td>
    <td style="font-family:monospace;color:#806000;">[[#STS_OutletOfferByDevice_PageViews|STS_OutletOfferByDevice.PageViews]] + [[#STS_TpOfferByDevice_PageViews|STS_TpOfferByDevice.PageViews]]</td>
  </tr>
</table>


=== Contatti (step 2) ===
Elenco di tutte le email ricevute (query al database alla ''STS_Email'')


== Sottoprogetti ==
== Sottoprogetti ==
Riga 273: Riga 1 212:
| 1.4
| 1.4
|-
|-
|..
| Agosto 2017
|..
| 1.4
|-
| Settembre 2017
| 1.6
|-
| Ottobre 2017
| 1.6
|-
| Novembre 2017
| 1.8
|-
| Dicembre 2017
| 1.6
|-
| Gennaio 2018
| 1.8
|-
| Febbraio 2018
| 1.8
|-
| Marzo 2018
| 1.9
|-
| Aprile 2018
| 2.1
|-
| Maggio 2018
| 1.9
|-
| Giugno 2018
| 1.4
|-
| Luglio 2018
| 1.4
|-
| Agosto 2018
| 1.4
|-
| Settembre 2018
| 1.6
|-
| Ottobre 2018
| 1.6
|-
| Novembre 2018
| 1.5
|-
| Dicembre 2018
| 1.7
|-
| Gennaio 2019
| 1.6
|-
| Febbraio 2019
| 1.6
|-
| Marzo 2019
| 1.6
|-
| Aprile 2019
| 1.9
|-
| Maggio 2019
| 1.8
|-
| Giugno 2019
| 1.7
|-
| Luglio 2019
| 1.5
|-
| Agosto 2019
| 1.6
|-
| Settembre 2019
| 1.6
|-
| Ottobre 2019
| 1.8
|-
| Novembre 2019
| 1.8
|-
| Dicembre 2019
| 1.9
|-
| Gennaio 2020
| 1.9
|-
| Febbraio 2020
| 1.8
|-
| Marzo 2020
| 1.6
|-
| Aprile 2020
| 1.9
|-
| Maggio 2020
| 1.6
|-
| Giugno 2020
| /
|-
| Luglio 2020
| 1.3
|-
| Agosto 2020
| 1.3
|-
| Settembre 2020
| 1.5
|-
| Ottobre 2020
| 1.3
|-
| Novembre 2020
| 1.3
|-
| Dicembre 2020
| 1.5
|-
| Gennaio 2021
| 1.7
|-
| Febbraio 2021
| 1.7
|-
| Marzo 2021
| 1.5
|-
| Aprile 2021
| 1.6
|-
| Maggio 2021
| 1.7
|-
| Giugno 2021
| 1.4
|-
| Luglio 2021
| 1.6
|-
| Agosto 2021
| 1.5
|-
| Settembre 2021
| 1.8
|-
| Ottobre 2021
| 1.8
|-
| Novembre 2021
| 1.7
|-
| Dicembre 2021
| 1.9
|-
| Gennaio 2022
| 1.8
|-
| Febbraio 2022
| 2.0
|-
| Marzo 2022
| 1.7
|-
| Aprile 2022
| 1.8
|-
| Maggio 2022
| 1.8
|-
| Giugno 2022
| 1.7
|-
| Luglio 2022
| 1.9
|-
| Agosto 2022
| 1.7
|-
| Settembre 2022
| 1.9
|-
| Ottobre 2022
| 1.9
|-
| Novembre 2022
| 1.8
|-
| Dicembre 2022
| 2.0
|-
| Gennaio 2023
| 1.8
|-
| Febbraio 2023
| 2.0
|-
|}
|}
<br/>
<br/>


Nella parte del Trovaprodotti i valori etichettati come ''sessioni'' in realtà sono gli ''accessi''.
Nella parte del Trovaprodotti i valori etichettati come ''sessioni'' in realtà sono gli ''accessi''.
=== Porcherie varie ===
<div class="mw-collapsible mw-collapsed" style="border:solid 1px;padding:2rem;">


Sono stati alterati manualmente manualmente i mesi di ''ottobre'', ''novembre'', ''dicembre 2016'' in ''zona 1'' e ''device: desktop''
Sono stati alterati manualmente manualmente i mesi di ''ottobre'', ''novembre'', ''dicembre 2016'' in ''zona 1'' e ''device: desktop''
Riga 287: Riga 1 428:
<syntaxhighlight lang="sql">UPDATE STS_ManufacturerByDevice
<syntaxhighlight lang="sql">UPDATE STS_ManufacturerByDevice
SET Impressions = 3201, WebsiteVisits = 13
SET Impressions = 3201, WebsiteVisits = 13
WHERE ManufacturerID = 4095 AND MONTH(Data) = 4 AND ZoneID = 1 AND DeviceType = 'mobile'</syntaxhighlight><br/><br/>
WHERE ManufacturerID = 4095 AND MONTH(Data) = 4 AND YEAR(Data) = 2017 AND ZoneID = 1 AND DeviceType = 'mobile'</syntaxhighlight><br/><br/>


Nel mese di Giugno 2017 sono stati fatti casini con DFP dei produttori Eclisse, Geberit e Oluce. Sono stati inseriti manualmente i seguenti click al sito:
Nel mese di Giugno 2017 sono stati fatti casini con DFP dei produttori Eclisse, Geberit e Oluce. Sono stati inseriti manualmente i seguenti click al sito:
Riga 320: Riga 1 461:
AND ZoneID = 1 AND Data = '2017-06-01'</syntaxhighlight>
AND ZoneID = 1 AND Data = '2017-06-01'</syntaxhighlight>


Nel mese di luglio 2017 sono state fatte delle campagne non integrate nell'area stats, ecco le query di incremento:ù
<syntaxhighlight lang="sql">-- Desktop
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 142 WHERE ManufacturerID = 202 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 186 WHERE ManufacturerID = 265 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 84 WHERE ManufacturerID = 119 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 96 WHERE ManufacturerID = 137 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID = 112 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 246 WHERE ManufacturerID = 351 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 58 WHERE ManufacturerID = 82 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID = 80 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID = 80 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 178 WHERE ManufacturerID = 254 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 80 WHERE ManufacturerID = 113 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID = 112 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID = 79 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 108 WHERE ManufacturerID = 154 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 81 WHERE ManufacturerID = 115 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 174 WHERE ManufacturerID = 248 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 66 WHERE ManufacturerID = 93 AND Data = '2017-07-01' AND DeviceType = 'desktop' AND ZoneID = 1
-- Mobile
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 61 WHERE ManufacturerID = 142 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 80 WHERE ManufacturerID = 186 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 36 WHERE ManufacturerID = 84 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 42 WHERE ManufacturerID = 96 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 34 WHERE ManufacturerID = 79 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 106 WHERE ManufacturerID = 246 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 25 WHERE ManufacturerID = 58 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID = 56 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID = 56 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 77 WHERE ManufacturerID = 178 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 34 WHERE ManufacturerID = 80 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 34 WHERE ManufacturerID = 79 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID = 56 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 47 WHERE ManufacturerID = 108 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 35 WHERE ManufacturerID = 81 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 75 WHERE ManufacturerID = 174 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 28 WHERE ManufacturerID = 66 AND Data = '2017-07-01' AND DeviceType = 'mobile' AND ZoneID = 1</syntaxhighlight>




Nel mese di febbraio 2018 ci siamo resi conto che la parte commerciale in passato ha spedito dei report ulteriormente alterati a 2 aziende in particolare: ''Unopiù'' e ''Martinelli Luce''. E' emerso che se per caso le aziende entrassero nella propria area statistiche vedrebbero l'incoerenza dei dati fornita precedentemente e di conseguenza potrebbero disdire il contratto.
Per rimediare non ci resta che alterare i dati di tutti i loro prodotti calcolando un coefficiente moltiplicativo
<syntaxhighlight lang="sql">/**
Moltiplichiamo per un certo coefficiente tutti i dati delle statistiche di uno sponsor per far
quadrare i conti con i report "gonfiati" che precedentemente sono stati consegnati a loro.
*/
USE [_Test_DBStats]
--  UNOPIU
DECLARE @ProdMultiplier DECIMAL(5,3) = 1.51
DECLARE @CatMultiplier DECIMAL(5,3) = 1.2
DECLARE @ManufacturerID INT = 4114 -- Unopiù
DECLARE @StartDate DATE = '2016-12-01'
DECLARE @EndDate DATE = '2018-01-01'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION
-- MARTINELLI LUCE
SET @ProdMultiplier = 1.28
SET @CatMultiplier = 1
SET @ManufacturerID = 1456 -- Martinelli Luce
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = CEILING(CatalogPageViews*@CatMultiplier)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = CEILING(PageViews*@CatMultiplier)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION</syntaxhighlight>
Per lo stesso problema del mese scorso anche ''Agape'' ha dovuto subire il taroccamento perché i report fossero coerenti. Questo nel mese di Marzo 2018
<syntaxhighlight lang="sql">/**
Moltiplichiamo per un certo coefficiente tutti i dati delle statistiche di uno sponsor per far
quadrare i conti con i report "gonfiati" che precedentemente sono stati consegnati a loro.
*/
USE [_Test_DBStats]
--  AGAPE
DECLARE @ProdMultiplier DECIMAL(5,3) = 1.65
DECLARE @CatMultiplier DECIMAL(5,3) = 1.65
DECLARE @ManufacturerID INT = 28 -- Agape
DECLARE @StartDate DATE = '2016-01-01'
DECLARE @EndDate DATE = '2018-02-01'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION</syntaxhighlight>
Per lo stesso problema del mese scorso anche ''Alias'' e ''Magis'' hanno dovuto subire il taroccamento perché i report fossero coerenti. Questo nel mese di Aprile 2018
<syntaxhighlight lang="sql">/**
Moltiplichiamo per un certo coefficiente tutti i dati delle statistiche di uno sponsor per far
quadrare i conti con i report "gonfiati" che precedentemente sono stati consegnati a loro.
*/
USE [_Test_DBStats]
--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 1.8
DECLARE @CatMultiplier DECIMAL(5,3) = 1.8
DECLARE @ManufacturerID INT = 34 -- ALIAS
DECLARE @StartDate DATE = '2010-01-01'
DECLARE @EndDate DATE = '2018-03-31'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION
-- MAGIS
SET @ProdMultiplier = 2.1
SET @CatMultiplier = 2.1
SET @ManufacturerID = 313 -- MAGIS
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = CEILING(CatalogPageViews*@CatMultiplier)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = CEILING(PageViews*@CatMultiplier)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION
</syntaxhighlight>
Nell'ottobre del 2018 è stato deciso di raddoppiare i valori di ''Candy''
<syntaxhighlight lang="sql">
USE [_Test_DBStats]
--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 2
DECLARE @CatMultiplier DECIMAL(5,3) = 2
DECLARE @ManufacturerID INT = 4119 -- CANDY
DECLARE @StartDate DATE = '2018-01-01'
DECLARE @EndDate DATE = '2018-09-30'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION
</syntaxhighlight>
''Candy'' non era ancora abbastanza pompato. Nuovo moltiplicatore di 3,5 che sommandosi all'altro praticamente fa un 7x . Moltiplicate anche le impression per 2,2
<syntaxhighlight lang="sql">
USE [_Test_DBStats]
--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 3.5
DECLARE @CatMultiplier DECIMAL(5,3) = 3.5
DECLARE @ImpMultiplier DECIMAL(5,3) = 2.2 -- Moltiplico anche le impression
DECLARE @ManufacturerID INT = 4119 -- CANDY
DECLARE @StartDate DATE = '2018-01-01'
DECLARE @EndDate DATE = '2018-09-30'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
, Impressions = ROUND(Impressions*@ImpMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION
</syntaxhighlight>
''Faber'' x2 (ottobre 2018)
<syntaxhighlight lang="sql">
USE [_Test_DBStats]
--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 2
DECLARE @CatMultiplier DECIMAL(5,3) = 2
--DECLARE @ImpMultiplier DECIMAL(5,3) = 2.2 -- Moltiplico anche le impression
DECLARE @ManufacturerID INT = 207 -- FABER
DECLARE @StartDate DATE = '2017-09-01'
DECLARE @EndDate DATE = '2018-09-30'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByDevice
INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByShopByDevice
INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
-- , Impressions = ROUND(Impressions*@ImpMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
--------------------------------------------------------------------------------------------------------------
---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
FROM STS_ProductByTpByDevice
INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate
UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByTP
WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
COMMIT TRANSACTION
</syntaxhighlight>
Nel novembre del 2018 sono state fatte altre 19 operazioni per moltiplicare i valori statistici di altri produttori.
[[File:201811-query_moltiplicatore_PROD.zip]]
Nel dicembre del 2018 sono state fatte altre operazioni per moltiplicare i valori statistici di altri produttori.
[[File:201812-query_moltiplicatore_PROD.zip]]
Nel dicembre del 2018 abbiamo dovuto ''abbassare'' le impression di Valcucine per far coincidere calcoli vari
<syntaxhighlight lang="sql">
USE [DBStats]
--  VALCUCINE
-- Primo caso in cui vengono ABBASSATE le stas (solo IMPRESSION)
DECLARE @ImpMultiplier DECIMAL(5,3) = 0.8 -- Moltiplico le impression
DECLARE @ManufacturerID INT = 510 -- VALCUCINE
-- primo giorno del mese iniziale
DECLARE @StartDate DATE = '2018-01-01'
-- ultimo giorno del mese finale
DECLARE @EndDate DATE = '2018-11-30'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ManufacturerByDevice SET Impressions = ROUND(Impressions*@ImpMultiplier,0)
--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
ROLLBACK TRANSACTION
</syntaxhighlight>
</div>
=== "Aggiustamenti" mensili sponsor ===
Nel gennaio del 2019 sono state fatte altre operazioni per moltiplicare i valori statistici di altri produttori.
[[File:201901-query moltiplicatore_PROD.zip]]
E ancora queste:
[[File:20190116-query moltiplicatore_PROD.zip]]
Nel febbraio del 2019 abbiamo moltiplicato questi: [[File:20190205-query moltiplicatore_PROD.zip]]
Nel marzo del 2019 abbiamo moltiplicato questi: [[File:20190305-query moltiplicatore_PROD.zip]]
Nell'aprile del 2019 abbiamo moltiplicato questi: [[File:20190402-query moltiplicatore PROD.zip]]
Nel maggio del 2019 abbiamo moltiplicato questi: [[File:20190507-query_moltiplicatore_PROD.zip]]
Nel giugno del 2019 abbiamo moltiplicato questi: [[File:20190611_query_moltiplicatore_PROD.zip]]
Nel luglio del 2019 abbiamo moltiplicato questi: [[File:20190703_query_moltiplicatore_PROD.zip]]
Nel settembre del 2019 abbiamo moltiplicato questi: [[File:20190903_query_moltiplicatore_PROD.zip]] per i dati di LUGLIO
Nel settembre del 2019 abbiamo moltiplicato questi: [[File:20190920_query_moltiplicatore_PROD.zip]] per i dati di AGOSTO
Nell'ottobre del 2019 abbiamo moltiplicato questi: [[File:2011010_query_moltiplicatore_PROD.zip]] per i dati di SETTEMBRE
Nel novembre del 2019 abbiamo moltiplicato questi: [[File:20191106_query_moltiplicatore_PROD.zip]] per i dati di OTTOBRE
<div class="mw-collapsible mw-collapsed" style="border:solid 1px;padding:2rem;">
Nel novembre del 2019 abbiamo diminuito le impression di Fantini perché nel 2018 risultano esagerate
<syntaxhighlight lang="sql">
USE Statistiche
-- Moltiplicatore di impression
DECLARE @ImpMultiplier DECIMAL(5,3) = 0.744
-- Manufacturer ID
DECLARE @ManufacturerID INT = 1286 -- FANTINI
-- primo giorno del mese iniziale
DECLARE @StartDate DATE = '2018-01-01'
-- ultimo giorno del mese finale
DECLARE @EndDate DATE = '2018-12-31'
BEGIN TRANSACTION
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
UPDATE STS_ManufacturerByDevice SET Impressions = ROUND(Impressions*@ImpMultiplier,0)
FROM STS_ManufacturerByDevice
WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate
EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
ROLLBACK TRANSACTION
</syntaxhighlight>
</div>
Nel dicembre del 2019 abbiamo moltiplicato questi: [[File:20191203_query_moltiplicatore_PROD.zip]] per i dati di NOVEMBRE
Nel dicembre del 2019 abbiamo sistemato ancora questi: [[File:20191218_query_moltiplicatore_PROD.zip]]
Nel gennaio del 2020 abbiamo moltiplicato questi: [[File:20200109_query_moltiplicatore_PROD.zip]]
Nel febbraio del 2020 abbiamo moltiplicato questi: [[File:20200210_query_moltiplicatore_PROD.zip]]
Nel marzo del 2020 abbiamo moltiplicato questi: [[File:20200305_query_moltiplicatore_PROD.zip]]
Nell'aprile del 2020 abbiamo moltiplicato questi: [[File:20200403_query_moltiplicatore_PROD.zip]]
Nel maggio del 2020 abbiamo moltiplicato questi: [[File:20200507_query_moltiplicatore_PROD.zip]]
Nel giugno del 2020 abbiamo moltiplicato questi: [[File:20200611_query_moltiplicatore_PROD.zip]]
Nel luglio del 2020 abbiamo moltiplicato questi: [[File:20200702_query_moltiplicatore_PROD.zip]]
Nell'agosto del 2020 abbiamo moltiplicato questi: [[File:20200825_query_moltiplicatore_PROD.zip]]
Nel settembre del 2020 abbiamo moltiplicato questi: [[File:20200902_query_moltiplicatore_PROD.zip]]
Nell'ottobre del 2020 abbiamo moltiplicato questi: [[File:20201002_query_moltiplicatore_PROD.zip]]
Nel novembre del 2020 abbiamo moltiplicato questi: [[File:20201103_query_moltiplicatore_PROD.zip]]
Nel dicembre del 2020 abbiamo moltiplicato questi: [[File:20201216_query_moltiplicatore_PROD.zip]]
Nel gennaio del 2021 abbiamo moltiplicato questi: [[File:20200108_query_moltiplicatore_PROD.zip]]
Nel febbraio del 2021 abbiamo moltiplicato questi: [[File:20200203_query_moltiplicatore_PROD.zip]]
Nel marzo del 2021 abbiamo moltiplicato questi: [[File:20200304_query_moltiplicatore_PROD.zip]]
Nell'aprile del 2021 abbiamo moltiplicato questi: [[File:20200409_query_moltiplicatore_PROD.zip]]
Nel maggio del 2021 abbiamo moltiplicato questi: [[File:20200506_query_moltiplicatore_PROD.zip]]
Nel giugno del 2021 abbiamo moltiplicato questi: [[File:20210609_query_moltiplicatore_PROD.zip]]
Nel luglio del 2021 abbiamo moltiplicato questi: [[File:20210720_query_moltiplicatore_PROD.zip]]
Nell'agosto del 2021 abbiamo moltiplicato questi: [[File:20200804_query_moltiplicatore_PROD.zip]]
Nel settembre del 2021 abbiamo moltiplicato questi: [[File:20210901_query_moltiplicatore_PROD.zip]]
Nell'ottobre del 2021 abbiamo moltiplicato questi: [[File:20211011_query_moltiplicatore_PROD.zip]]
Nel novembre del 2021 abbiamo moltiplicato questi: [[File:20211111_query_moltiplicatore_PROD.zip]]
Nel dicembre del 2021 abbiamo moltiplicato questi: [[File:20211201_query_moltiplicatore_PROD.zip]]
Nel gennaio del 2022 abbiamo moltiplicato questi: [[File:20220110_query_moltiplicatore_PROD.zip]]
Nel febbraio del 2022 abbiamo moltiplicato questi: [[File:20220207_query_moltiplicatore_PROD.zip]]
Nel marzo del 2022 abbiamo moltiplicato questi: [[File:20220303_query_moltiplicatore_PROD.zip]]
Nell'aprile del 2022 abbiamo moltiplicato questi: [[File:20220408_query_moltiplicatore_PROD.zip]]
Nel maggio del 2022 abbiamo moltiplicato questi: [[File:20220503_query_moltiplicatore_PROD.zip]]
Nel giugno del 2022 abbiamo moltiplicato questi: [[File:20220614_query_moltiplicatore_PROD.zip]]
Nel luglio del 2022 abbiamo moltiplicato questi: [[File:20220712_query_moltiplicatore_PROD.zip]]
Nell'agosto del 2022 abbiamo moltiplicato qualcosa
Nel settembre del 2022 abbiamo moltiplicato questi: [[File:20220902_query_moltiplicatore_PROD.zip]]
Nell'ottobre del 2022 abbiamo moltiplicato questi: [[File:20221019_query_moltiplicatore_PROD.zip]]
Nel novembre del 2022 abbiamo moltiplicato questi: [[File:20221129_query_moltiplicatore_PROD.zip]]
Nel dicembre del 2022 abbiamo moltiplicato questi: [[File:20221201_query_moltiplicatore_PROD.zip]]
Nel gennaio del 2023 abbiamo moltiplicato questi: [[File:20230111_query_moltiplicatore_PROD.zip]]
== Campagne ==
Questo paragrafo riassume tutte le campagne Facebook che sono state fatte nei mesi.
I numeri sono stati inseriti manualmente nel database mese per mese.
LUGLIO 2017 - Campagna Facebook
<syntaxhighlight lang="sql">UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 142 WHERE
ManufacturerID = 313 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 186 WHERE
ManufacturerID = 4108 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 84 WHERE ManufacturerID
= 4107 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 96 WHERE ManufacturerID
= 1322 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID
= 1938 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 246 WHERE
ManufacturerID = 308 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 58 WHERE ManufacturerID
= 4114 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID
= 3981 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID
= 2070 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 178 WHERE
ManufacturerID = 373 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 80 WHERE ManufacturerID
= 207 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID
= 3940 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID
= 4021 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 108 WHERE
ManufacturerID = 4117 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 81 WHERE ManufacturerID
= 2216 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 174 WHERE
ManufacturerID = 1481 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 66 WHERE ManufacturerID
= 4095 AND Data = '2017-07-01' AND DeviceType = 'desktop'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 60 WHERE ManufacturerID
= 313 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID
= 4108 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 35 WHERE ManufacturerID
= 4107 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 41 WHERE ManufacturerID
= 1322 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 33 WHERE ManufacturerID
= 1938 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 105 WHERE
ManufacturerID = 308 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID
= 4114 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID
= 3981 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID
= 2070 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 76 WHERE ManufacturerID
= 373 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 33 WHERE ManufacturerID
= 207 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 33 WHERE ManufacturerID
= 3940 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 23 WHERE ManufacturerID
= 4021 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 46 WHERE ManufacturerID
= 4117 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 34 WHERE ManufacturerID
= 2216 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 74 WHERE ManufacturerID
= 1481 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 27 WHERE ManufacturerID
= 4095 AND Data = '2017-07-01' AND DeviceType = 'mobile'
AND ZoneID = 1</syntaxhighlight>
SETTEMBRE 2017 - Campagna Facebook
<syntaxhighlight lang="sql">-- Campagna Facebook settembre 2017 desktop
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 53 WHERE ManufacturerID = 4095 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 57 WHERE ManufacturerID = 1481 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 221 WHERE ManufacturerID = 3940 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 501 WHERE ManufacturerID = 2216 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 41 WHERE ManufacturerID = 207 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 49 WHERE ManufacturerID = 4021 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 185 WHERE ManufacturerID = 4117 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 74 WHERE ManufacturerID = 308 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 23 WHERE ManufacturerID = 1322 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 144 WHERE ManufacturerID = 3981 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 123 WHERE ManufacturerID = 4114 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
-- Campagna Facebook settembre 2017 mobile
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 21 WHERE ManufacturerID = 4095 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 31 WHERE ManufacturerID = 1481 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 157 WHERE ManufacturerID = 3940 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 268 WHERE ManufacturerID = 2216 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 22 WHERE ManufacturerID = 207 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 21 WHERE ManufacturerID = 4021 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 146 WHERE ManufacturerID = 4117 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 42 WHERE ManufacturerID = 308 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 34 WHERE ManufacturerID = 1322 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 104 WHERE ManufacturerID = 3981 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 129 WHERE ManufacturerID = 4114 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
</syntaxhighlight>
OTTOBRE 2017 - Campagna Facebook
<syntaxhighlight lang="sql">-- Campagna Facebook ottobre 2017 mobile
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 31 WHERE ManufacturerID = 4095 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 4 WHERE ManufacturerID = 1481 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 21 WHERE ManufacturerID = 3940 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 59 WHERE ManufacturerID = 2216 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 26 WHERE ManufacturerID = 207 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 22 WHERE ManufacturerID = 4021 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 56 WHERE ManufacturerID = 4117 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 23 WHERE ManufacturerID = 3981 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 12 WHERE ManufacturerID = 4114 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
-- Campagna Facebook ottobre 2017 tablet
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 16 WHERE ManufacturerID = 4095 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 2 WHERE ManufacturerID = 1481 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 11 WHERE ManufacturerID = 3940 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 27 WHERE ManufacturerID = 2216 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 13 WHERE ManufacturerID = 207 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 11 WHERE ManufacturerID = 4021 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 28 WHERE ManufacturerID = 4117 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 12 WHERE ManufacturerID = 3981 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 6 WHERE ManufacturerID = 4114 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
-- Campagna Facebook ottobre 2017 desktop
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 108 WHERE ManufacturerID = 4095 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 15 WHERE ManufacturerID = 1481 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 74 WHERE ManufacturerID = 3940 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 188 WHERE ManufacturerID = 2216 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 90 WHERE ManufacturerID = 207 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 76 WHERE ManufacturerID = 4021 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 197 WHERE ManufacturerID = 4117 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 81 WHERE ManufacturerID = 3981 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 41 WHERE ManufacturerID = 4114 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
</syntaxhighlight>
OTTOBRE 2018 - Campagna Facebook
<syntaxhighlight lang="sql">
USE DBStats
BEGIN TRANSACTION
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 279 WHERE ManufacturerID = 4145 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 122 WHERE ManufacturerID = 1481 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 129 WHERE ManufacturerID = 1286 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 263 WHERE ManufacturerID = 1322 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 1 WHERE ManufacturerID = 4119 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01'
COMMIT TRANSACTION
</syntaxhighlight>




[[Category:AreaStatistiche]]
[[Category:AreaStatistiche]]
[[Category:Progetti]]
[[Category:Progetti]]

Versione attuale delle 10:20, 16 mar 2023

Informazioni sul progetto
Area Statistiche
http://statistics.designbest.com
Ambiente di test http://statistics.dbdemo47.com (altri dettagli)
Sistema di versionamento
Tipo SVN
URL del trunk https://svn.office.webmobili.it/svn/WM4/DB_AreaStatistiche
URL base dei branch https://svn.office.webmobili.it/svn/WM4/branches/


Area Statistiche è l'interfaccia che permette di controllare l'andamento di produttori e rivenditori all'interno del portale Designbest e Trovaprodotti.

Origine dei dati

[modifica]

Il tracciamento dei dati si basa sullo script di Google Analytics.
Ad ogni tipologia di pagina corrisponde un tracciamento (gaTrack). A loro volta i gaTrack sono divisi per i portali Designbest e Trovaprodotti.
Nella tabella sottostante c'è uno schema riassuntivo. Cliccando sul link gaTrack si ottiene l'estrazione esatta della metrica richiesta per un campione esemplare.

Query ad Analytics

[modifica]

Per quanto riguarda Designbest:

URL/Tracciamento gaTrack Descrizione
/{lang}/{catalogo(lang)}/{manufacturer} DB-catalog Schede catalogo
/{lang}/{novita(lang)}/{azienda(lang)}/{manufacturer} DB-catalog-news Listing novità
/{lang}/brand/{manufacturer} DB-brand_channel Scheda Brand-Channel
Pagine dentro all'XML dei post del magazine DB-magazineposts Magazine Post del Produttore
/{lang}/{catalogo(lang)}/{manufacturer}/{ambient}/{type}/{productname}/{productid} DB-product Schede prodotto - Comprensive delle schede prodotto da negozio (DB-product_shop)
/{lang}/{catalogo(lang)}/{manufacturer}/{ambient}/{type}/{productname}/{productid}/{shopname}/{shopid} DB-product_shop Schede prodotto da negozio - Sottoinsieme di DB-product
/{lang}/{pro}/{negozi(lang)}...manufacturerFilter=... DB-res_shop_by_catalog Listing negozi da catalogo
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid} DB-shop Schede negozio
/{lang}/pro/showroom/{shopname}/{shopid}/{manufacturer}/{ambient}/{type}/{productname}/{productid} DB-shop_from_product Scheda negozio da prodotto
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{catalogo(lang)}/{ambient} DB-catalog_shop_amb Ricerca negozi per ambiente
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{catalogo(lang)}/{ambient}/{type} DB-catalog_shop_typ Ricerca negozi per ambiente/tipologia
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{manufacturer} DB-catalog_shop_man Ricerca negozi per manufacturer
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{manufacturer}/{ambient} DB-catalog_shop_man_amb Ricerca negozi per manufacturer/ambiente
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{manufacturer}/{ambient}/{type} DB-catalog_shop_man_typ Ricerca negozi per manufacturer/ambiente/tipologia
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{catalogo(lang)} DB-catalog_shop Ricerca negozi generica (no filtri), no catalog
/{lang}/pro/{showroom(lang)}/{shopname}/{shopid}/{altro...} DB-shop_listing Ricerca negozi totale (DB-catalog_shop , DB-catalog_shop_amb , DB-catalog_shop_typ , DB-catalog_shop_man , DB-catalog_shop_man_amb , DB-catalog_shop_man_typ)
/{lang}/outlet/{negozi(lang)}/{shopname}/{shopid} DB-res_offers Ricerca Occasioni Negozio
/{lang}/outlet/{occasione(lang)}/{occasionename}/{occasioneid}/{shopid} DB-offer Scheda occasione negozio
/{lang}/{prodotti(lang)}/{ambient}/{type} DB-result Ricerca prodotti per ambiente/tipologia in questo momento non è usata dall'applicazione
tr: http://sitoesternoproduttore... DB-catalog_websitevisits Visite al sito del produttore tramite i pulsanti su Designbest
tr: mailtoproduttore: DB-catalog_receivedmail Email ricevute su Designbest dal produttore
tr: produttore_bottone_impression: DB-catalog_bottoneimpression_ Impression ricevute su Designbest dal bottone del produttore
tr: http://sitoesternorivenditore... DB-shop_websitevisits Visite al sito del rivenditore tramite i pulsanti su Designbest
tr: mailtonegozio: DB-shop_receivedmail Email ricevute su Designbest dal rivenditore
tr: pdfdownload: DB-catalog_downloadedpdfs Download dei PDF del produttore da Designbest
/{lang}/{catalogo(lang)}/{manufacturer} DB-catalog_userSessions Utenti e sessioni di un produttore su Designbest
/{lang}/{pro(lang)}/{showroom(lang)}/{shopname}/{shopid}/{altro...} DB-shop_userSessions Utenti e sessioni di un rivenditore su Designbest
/{lang}/{catalogo(lang)}/{manufacturer} DB-catalog_graphAge Età media del visitatore della scheda catalogo su Designbest
/{lang}/{catalogo(lang)}/{manufacturer} DB-catalog_graphGender Sesso medio del visitatore della scheda catalogo su Designbest
tr: geolocalization: DB-catalog_graphGeolocalization Geolocalizzazione del catalogo su Designbest
segment =~ /outlet DB-outlet-sessions Sessioni totali dell'oultet

Per quanto riguarda Trovaprodotti:

URL/Tracciamento gaTrack Descrizione
it/Home/Index/[IDshop] TP-hp Homepage
it/ResultAmbient/Shop_[IDshop]_Ambient_[IDAmbient]/… TP-amb Ricerca per ambiente
it/Result/Shop_[IDshop]_Ambient_[IDAmbient]_... TP-result Ricerca per tipologia
it/Product/Shop_[IDshop]_Product_[IDProduct] TP-product Scheda prodotto
it/Product/Selections/Shop_[IDshop]_Product_[IDProduct] TP-product_selection Scheda prodotto da selezione
it/ResultNews/Shop_[IDshop]_... TP-news Ricerca novità
it/Result/Offers/Shop_[IDshop]_... TP-res_offers Ricerca occasioni
it/Product/Offers/Shop_[IDshop]_Offer_[IDOffer] TP-offer Scheda occasione
it/Result/ManufacturersList/[IDshop] TP-res_catalogs Ricerca cataloghi
it/Result/Shop_[IDshop]_Manufacturer_[Idmanufacturer]/… TP-catalog Scheda catalogo
it/ResultSelection/Shop_[IDshop]_Selection_[IDSelection]/… TP-res_selections Ricerca selezioni
it/Product/Selections/Shop_[IDshop]_Product_[IDOffer] TP-selection Scheda prodotto di selezione
segment =~ /\w{2}/\w+/Offers TP-totoffers-sessions Sessioni totali del Trovaoccasioni


Da Analytics al Database tramite Intruder

[modifica]

I seguenti dati mese per mese vengono recuperati da Analytics ed aggregati nel nostro database tramite il programma Designbest Statistics Intruder.
Intruder , mese per mese, permette di eseguire l'inserimento dei dati tramite i seguenti task modulari indipendenti:

  • A visite, impression - manufacturer
  • B utenze, sessioni - manufacturer
  • C grafici genere, età, geoloc - manufacturer
  • D visite ai post magazine - manufacturer
  • E schede negozio - negozi
  • F utenze, sessioni - negozi
  • G schede occasione - occasioni
  • H prodotti, cataloghi visti - trovaprodotti
  • I ambienti visti - trovaprodotti
  • L schede negozio - trovaprodotti
  • M schede occasione - trovaprodotti
  • N schede prodotto - prodotti
  • O schede prodotto da negozio - prodotti
  • P applicazione moltiplicatore

all'interno di questa nostra struttura dati:

STS_ManufacturerByDevice
K ManufacturerID
K ZoneID
K DeviceType
K Data
B Users DB-catalog_userSessions
B Sessions DB-catalog_userSessions
A Impressions fonte: DFP + DB-catalog_bottoneimpression
A WebsiteVisits DB-catalog_websitevisits + Click al banner DFP
A DownloadedPDFs DB-catalog_downloadedpdfs
A ReceivedEmails DB-catalog_receivedmail
A CatalogPageViews DB-catalog +DB-catalog-news + DB-brand_channel + DB-res_shop_by_catalog + DB-catalog_shop_man
STS_ManufacturerOtherImpressions
K ManufacturerID
K ZoneID
K DeviceType
K Contract
K Data
A Impressions fonte: DFP
A WebsiteVisits fonte: DFP
STS_ManufacturerByAgeBracket
K ManufacturerID
K AgeBracket
K Data
C PageViews DB-catalog_graphAge
STS_ManufacturerByGender
K ManufacturerID
K Gender
K Data
C PageViews DB-catalog_graphGender
STS_ManufacturerByGEO
K ManufacturerID
K Geolocalization
K Data
C PageViews DB-catalog_graphGeolocalization
STS_MagazinePostsByManufacturer
K ArticleID
K ManufacturerID
K ZoneID
K DeviceType
K Data
D PageViews DB-magazineposts
STS_ShopByDevice
K ShopID
K ZoneID
K DeviceType
K Data
Impressions non tracciato
E WebsiteVisits DB-shop_websitevisits
E ReceivedEmails DB-shop_receivedmail
E CatalogPageViews DB-shop + DB-shop_listing
E CatalogOffersPageViews DB-res_offers
STS_ShopBySessions
K ShopID
K DeviceType
K Data
F Users DB-shop_userSessions
F Sessions DB-shop_userSessions
STS_TpOfferByDevice
K OfferID
K ShopID
K ZoneID
K DeviceType
K Data
G PageViews TP-offer
STS_ProductByTpByDevice
K ProductID
K TpID
K ZoneID
K DeviceType
K Data
H PageViews TP-product + TP-product_selection
STS_ManufacturerByTP
K ManufacturerID
K TpID
K ZoneID
K DeviceType
K Data
H PageViews TP-catalog
STS_TPbyAmbient
K TpID
K AmbientID
K ZoneID
K DeviceType
K Data
I PageViews TP-amb + TP-result
STS_TpByDevice
K TpID
K ZoneID
K DeviceType
K Data
L ReceivedEmails fonte: tabella STS_Email di designbest
L CatalogPageViews TP-hp + TP-news + TP-res_catalogs + TP-res_selections
L CatalogOffersPageViews TP-res_offers
L Entrances TP-shop_entrances
STS_TpOfferByDevice
K OfferID
K ShopID
K DeviceType
K Data
M PageViews TP-offer
STS_OutletOfferByDevice
K OfferID
K ShopID
K ZoneID
K DeviceType
K Data
M PageViews DB-offer
STS_ProductByDevice
K ProductID
K ZoneID
K DeviceType
K Data
N, P PageViews DB-product
STS_ProductByShopByDevice
K ProductID
K ShopID
K ZoneID
K DeviceType
K Data
O, P PageViews DB-product_shop
STS_OutletShopSessions
K ShopID
K ZoneID
K Data
G Sessions algoritmo Cydrolous


STS_TpTotalOffersSessions
K ShopID
K ZoneID
K Data
M Sessions algoritmo Cydrolous

Algoritmo Cydrolous

[modifica]

Il calcolo delle sessioni di Trovaoccasioni e di Outlet Design avviene tramite un algoritmo detto Cydrolous.
In breve i passaggi

Sessioni su Outlet Design

[modifica]

La somma dei valori restituiti dalla query analytics fatta su tutto l'outlet (e tutti i negozi) nel periodo specificato

  • outletTotalPageViews = SOMMA Pagine Viste Totali Outlet

Un'estrazione del tipo SELECT SUM(PageViews) FROM ... su tutto l'outlet (e tutti i negozi) nel periodo specificato

  • totalPageViewsPerSession = outletTotalPageViews / outletTotalSessions

Parziale intermedio

  • shopOutletSessions = shopOutletTotalPageViews / totalPageViewsPerSession

Le sessioni di un singolo negozio sono le sue pagine viste totali diviso il parziale


Sessioni su Trovaoccasioni

[modifica]

La somma dei valori restituiti dalla query analytics fatta su tutto il Trovaprodotti (e tutti i negozi) nel periodo specificato

  • offersTotalPageViews = SOMMA Pagine Viste Totali Occasioni Trovaprodotti

Un'estrazione del tipo SELECT SUM(PageViews) FROM ... su tutto il Trovaprodotti (e tutti i negozi) nel periodo specificato

  • totalPageViewsPerSession = offersTotalPageViews / offersTotalSessions

Parziale intermedio

  • shopOffersSessions = shopOffersTotalPageViews / totalPageViewsPerSession

Le sessioni di un singolo negozio sono le sue pagine viste totali diviso il parziale

Area Produttori

[modifica]

Sintesi

[modifica]

Tabellino riassuntivo

[modifica]

I dati vengono recuperati tramite la stored procedure MAN_Recap

Utenti unici STS_ManufacturerByDevice.Users
Visite STS_ManufacturerByDevice.Sessions
Pagine viste STS_ManufacturerByDevice.CatalogPageViews + STS_ManufacturerByTP.PageViews + STS_ProductByDevice.PageViews + STS_ProductByTpByDevice.PageViews
Impression ADV STS_ManufacturerByDevice.Impressions
Visite al sito STS_ManufacturerByDevice.WebsiteVisits
Download cataloghi pdf STS_ManufacturerByDevice.DownloadedPDFs
Email ricevute STS_ManufacturerByDevice.ReceivedEmails

Grafici

[modifica]
Fasce d'età STS_ManufacturerByAgeBracket.PageViews
Sesso STS_ManufacturerByGender.PageViews
Dispositivi STS_ManufacturerByDevice.CatalogPageViews
Geolocalizzazione (nascosto) STS_ManufacturerByGEO.PageViews


Prodotti

[modifica]

Tabellino riassuntivo

[modifica]

I dati sono restituiti dalla stored procedure MAN_TOTs

Pagine catalogo viste STS_ManufacturerByDevice.CatalogPageViews + STS_ManufacturerByTP.PageViews
Schede prodotto viste STS_ProductByDevice.PageViews + STS_ProductByTpByDevice.PageViews

Elenco top 50 prodotti

[modifica]

I dati sono restituiti dalla stored procedure MAN_Products

Prodotto pagine viste STS_ProductByDevice.PageViews + STS_ProductByTpByDevice.PageViews


Distribuzione

[modifica]

Si tratta dell'elenco dei rivenditori in ordine alfabetico associati alla rete di produttori.


Advertising

[modifica]

Impression da contratto

[modifica]
Impression Banner STS_ManufacturerByDevice.Impressions
Visite al sito STS_ManufacturerByDevice.WebsiteVisits

Impression extra contratto

[modifica]
Impression Banner STS_ManufacturerOtherImpressions.Impressions
Visite al sito STS_ManufacturerOtherImpressions.WebsiteVisits


Magazine (step 2)

[modifica]

I dati vengono recuperati tramite la stored procedure MAN_MagazinePosts

Articolo pageViews STS_MagazinePostsByManufacturer.PageViews


Social (step 2)

[modifica]

Elenco totale dei post su Facebook in ordine dal più recente del produttore.


Newsletter (step 2)

[modifica]

Area in disuso.

Area Negozi

[modifica]

Sintesi

[modifica]

Tabellino riassuntivo

[modifica]

I dati vengono recuperati tramite la stored procedure SHOP_Recap

Visite STS_ShopBySessions.Sessions + STS_TpByDevice.Entrances
Pagine viste STS_ShopByDevice.CatalogPageViews + STS_ShopByDevice.CatalogOffersPageViews + STS_TpByDevice.CatalogPageViews + STS_TpByDevice.CatalogOffersPageViews + STS_TPbyAmbient.PageViews + STS_ManufacturerByTP.PageViews + STS_ProductByShopByDevice.PageViews + STS_ProductByTpByDevice.PageViews + STS_OutletOfferByDevice.PageViews + STS_TpOfferByDevice.PageViews
Click al tuo sito STS_ShopByDevice.WebsiteVisits
Email ricevute STS_ShopByDevice.ReceivedEmails + STS_TpByDevice.ReceivedEmails

Traffico per canale

[modifica]
Store channel Occasioni Trovaprodotti Totale
Visite STS_ShopBySessions.Sessions STS_OutletShopSessions.Sessions + STS_TpTotalOffersSessions.Sessions STS_TpByDevice.Entrances
Pagine viste STS_ShopByDevice.CatalogPageViews + STS_ProductByShopByDevice.PageViews STS_ShopByDevice.CatalogOffersPageViews + STS_OutletOfferByDevice.PageViews +STS_TpByDevice.CatalogOffersPageViews + STS_TpOfferByDevice.PageViews STS_TpByDevice.CatalogPageViews + STS_ProductByTpByDevice.PageViews + STS_TPbyAmbient.PageViews + STS_ManufacturerByTP.PageViews

Grafico

[modifica]
Dispositivi STS_ShopByDevice.CatalogPageViews + STS_ShopByDevice.CatalogOffersPageViews + STS_TpByDevice.CatalogPageViews + STS_TpByDevice.CatalogOffersPageViews


Prodotti

[modifica]

Tabellino riassuntivo *

[modifica]
Pagine catalogo viste STS_ShopByDevice.CatalogPageViews + STS_TpByDevice.CatalogPageViews
Schede prodotto viste STS_ProductByShopByDevice.PageViews + STS_ProductByTpByDevice.PageViews + STS_TPbyAmbient.PageViews + STS_ManufacturerByTP.PageViews 
 * ATTENZIONE

 Il valore Totale pagine viste è privo di Outlet Design e di Trovaoccasioni.

 In pratica mancano STS_ShopByDevice.CatalogOffersPageViews + STS_OutletOfferByDevice.PageViews + STS_TpByDevice.CatalogOffersPageViews + STS_TpOfferByDevice.PageViews

Prodotti

[modifica]

I dati sono restituiti dalla stored procedure SHOP_NET_Products

Prodotto pagine viste STS_ProductByShopByDevice.PageViews + STS_ProductByTpByDevice.PageViews

Marche

[modifica]

I dati sono restituiti dalla stored procedure SHOP_NET_Manufacturers

Produttore pagine viste STS_ProductByShopByDevice.PageViews + STS_ProductByTpByDevice.PageViews


Aree Casa

[modifica]

I dati sono restituiti dalla stored procedure SHO_NET_Ambients

Ambiente pagine viste STS_ProductByShopByDevice.PageViews + STS_ProductByTpByDevice.PageViews


Outlet design (step 2)

[modifica]

Tabellino riassuntivo

[modifica]
Pagine catalogo viste STS_ShopByDevice.CatalogOffersPageViews + STS_TpByDevice.CatalogOffersPageViews
Schede prodotto viste STS_OutletOfferByDevice.PageViews + STS_TpOfferByDevice.PageViews

Occasioni

[modifica]

I dati sono restituiti dalla stored procedure SHOP_NET_Offers

Occasione pagine viste STS_OutletOfferByDevice.PageViews + STS_TpOfferByDevice.PageViews


Contatti (step 2)

[modifica]

Elenco di tutte le email ricevute (query al database alla STS_Email)

Sottoprogetti

[modifica]


Maialate

[modifica]

I numeri a partire da agosto 2016 sono alterati da moltiplicatori definiti nella tabella STS_AlterStats che vanno ad applicarsi, durante la generazione, a tutti i numeri riferiti alle schede prodotto viste sul portale Designbest (no Trovaprodotti) mese per mese.
I campi coinvolti da questa alterazione sono STS_ProductByDevice.PageViews e STS_ProductByShopByDevice.PageViews.
L'unico sistema per aggiungere nuovi moltiplicatori è l'inserimento manuale del valore all'interno del database nella suddetta tabella.
Qui un riassunto dei valori presenti ad oggi:

MESE MOLTIPLICATORE
Agosto 2016 2.4
Settembre 2016 3.0
Ottobre 2016 2.0
Novembre 2016 1.8
Dicembre 2016 1.8
Gennaio 2017 2.1
Febbraio 2017 1.6
Marzo 2017 1.6
Aprile 2017 1.4
Maggio 2017 1.4
Giugno 2017 1.4
Luglio 2017 1.4
Agosto 2017 1.4
Settembre 2017 1.6
Ottobre 2017 1.6
Novembre 2017 1.8
Dicembre 2017 1.6
Gennaio 2018 1.8
Febbraio 2018 1.8
Marzo 2018 1.9
Aprile 2018 2.1
Maggio 2018 1.9
Giugno 2018 1.4
Luglio 2018 1.4
Agosto 2018 1.4
Settembre 2018 1.6
Ottobre 2018 1.6
Novembre 2018 1.5
Dicembre 2018 1.7
Gennaio 2019 1.6
Febbraio 2019 1.6
Marzo 2019 1.6
Aprile 2019 1.9
Maggio 2019 1.8
Giugno 2019 1.7
Luglio 2019 1.5
Agosto 2019 1.6
Settembre 2019 1.6
Ottobre 2019 1.8
Novembre 2019 1.8
Dicembre 2019 1.9
Gennaio 2020 1.9
Febbraio 2020 1.8
Marzo 2020 1.6
Aprile 2020 1.9
Maggio 2020 1.6
Giugno 2020 /
Luglio 2020 1.3
Agosto 2020 1.3
Settembre 2020 1.5
Ottobre 2020 1.3
Novembre 2020 1.3
Dicembre 2020 1.5
Gennaio 2021 1.7
Febbraio 2021 1.7
Marzo 2021 1.5
Aprile 2021 1.6
Maggio 2021 1.7
Giugno 2021 1.4
Luglio 2021 1.6
Agosto 2021 1.5
Settembre 2021 1.8
Ottobre 2021 1.8
Novembre 2021 1.7
Dicembre 2021 1.9
Gennaio 2022 1.8
Febbraio 2022 2.0
Marzo 2022 1.7
Aprile 2022 1.8
Maggio 2022 1.8
Giugno 2022 1.7
Luglio 2022 1.9
Agosto 2022 1.7
Settembre 2022 1.9
Ottobre 2022 1.9
Novembre 2022 1.8
Dicembre 2022 2.0
Gennaio 2023 1.8
Febbraio 2023 2.0


Nella parte del Trovaprodotti i valori etichettati come sessioni in realtà sono gli accessi.

Porcherie varie

[modifica]

Sono stati alterati manualmente manualmente i mesi di ottobre, novembre, dicembre 2016 in zona 1 e device: desktop incrementando il campo STS_ManufacturerByDevice.WebsiteVisits di alcuni produttori elitari a seguito di una campagna Facebook. Lo storico si trova qui https://cloud.designbest.com/index.php/s/kAyRQh8R7iDFfDW

Nel mese di Aprile 2017 sono stati fatti casini con DFP mobile del produttore Geberit. Le Impression a zero non si potevano lasciare, così sono stati inseriti manualmente dei valori di media con questa query: 

UPDATE STS_ManufacturerByDevice
SET Impressions = 3201, WebsiteVisits = 13
WHERE ManufacturerID = 4095 AND MONTH(Data) = 4 AND YEAR(Data) = 2017 AND ZoneID = 1 AND DeviceType = 'mobile'


Nel mese di Giugno 2017 sono stati fatti casini con DFP dei produttori Eclisse, Geberit e Oluce. Sono stati inseriti manualmente i seguenti click al sito: 

-- Eclisse
UPDATE STS_ManufacturerByDevice
SET WebsiteVisits += 317
WHERE ManufacturerID = 2216 AND DeviceType = 'desktop'
	AND ZoneID = 1 AND Data = '2017-06-01'
UPDATE STS_ManufacturerByDevice
  SET WebsiteVisits += 205
  WHERE ManufacturerID = 2216 AND DeviceType = 'mobile'
	AND ZoneID = 1 AND Data = '2017-06-01'

-- Geberit
UPDATE STS_ManufacturerByDevice
SET WebsiteVisits += 177
WHERE ManufacturerID = 4095 AND DeviceType = 'desktop'
	AND ZoneID = 1 AND Data = '2017-06-01'
UPDATE STS_ManufacturerByDevice
  SET WebsiteVisits += 78
  WHERE ManufacturerID = 4095 AND DeviceType = 'mobile'
	AND ZoneID = 1 AND Data = '2017-06-01'

-- Oluce
UPDATE STS_ManufacturerByDevice
SET WebsiteVisits += 59
WHERE ManufacturerID = 1481 AND DeviceType = 'desktop'
	AND ZoneID = 1 AND Data = '2017-06-01'
UPDATE STS_ManufacturerByDevice
  SET WebsiteVisits += 32
  WHERE ManufacturerID = 1481 AND DeviceType = 'mobile'
	AND ZoneID = 1 AND Data = '2017-06-01'


Nel mese di febbraio 2018 ci siamo resi conto che la parte commerciale in passato ha spedito dei report ulteriormente alterati a 2 aziende in particolare: Unopiù e Martinelli Luce. E' emerso che se per caso le aziende entrassero nella propria area statistiche vedrebbero l'incoerenza dei dati fornita precedentemente e di conseguenza potrebbero disdire il contratto. Per rimediare non ci resta che alterare i dati di tutti i loro prodotti calcolando un coefficiente moltiplicativo 

/**
Moltiplichiamo per un certo coefficiente tutti i dati delle statistiche di uno sponsor per far
quadrare i conti con i report "gonfiati" che precedentemente sono stati consegnati a loro.
*/


USE [_Test_DBStats]

--  UNOPIU
DECLARE @ProdMultiplier DECIMAL(5,3) = 1.51
DECLARE @CatMultiplier DECIMAL(5,3) = 1.2
DECLARE @ManufacturerID INT = 4114	-- Unopiù

DECLARE @StartDate DATE = '2016-12-01'
DECLARE @EndDate DATE = '2018-01-01'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION



-- MARTINELLI LUCE
SET @ProdMultiplier = 1.28
SET @CatMultiplier = 1
SET @ManufacturerID = 1456	-- Martinelli Luce



BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = CEILING(CatalogPageViews*@CatMultiplier)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = CEILING(PageViews*@CatMultiplier)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION


Per lo stesso problema del mese scorso anche Agape ha dovuto subire il taroccamento perché i report fossero coerenti. Questo nel mese di Marzo 2018 

/**
Moltiplichiamo per un certo coefficiente tutti i dati delle statistiche di uno sponsor per far
quadrare i conti con i report "gonfiati" che precedentemente sono stati consegnati a loro.
*/


USE [_Test_DBStats]

--  AGAPE
DECLARE @ProdMultiplier DECIMAL(5,3) = 1.65
DECLARE @CatMultiplier DECIMAL(5,3) = 1.65
DECLARE @ManufacturerID INT = 28	-- Agape

DECLARE @StartDate DATE = '2016-01-01'
DECLARE @EndDate DATE = '2018-02-01'



BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION


Per lo stesso problema del mese scorso anche Alias e Magis hanno dovuto subire il taroccamento perché i report fossero coerenti. Questo nel mese di Aprile 2018 

/**
Moltiplichiamo per un certo coefficiente tutti i dati delle statistiche di uno sponsor per far
quadrare i conti con i report "gonfiati" che precedentemente sono stati consegnati a loro.
*/


USE [_Test_DBStats]

--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 1.8
DECLARE @CatMultiplier DECIMAL(5,3) = 1.8
DECLARE @ManufacturerID INT = 34	-- ALIAS

DECLARE @StartDate DATE = '2010-01-01'
DECLARE @EndDate DATE = '2018-03-31'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION



-- MAGIS
SET @ProdMultiplier = 2.1
SET @CatMultiplier = 2.1
SET @ManufacturerID = 313	-- MAGIS



BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = CEILING(CatalogPageViews*@CatMultiplier)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = CEILING(PageViews*@CatMultiplier)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION

Nell'ottobre del 2018 è stato deciso di raddoppiare i valori di Candy 

USE [_Test_DBStats]

--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 2
DECLARE @CatMultiplier DECIMAL(5,3) = 2
DECLARE @ManufacturerID INT = 4119	-- CANDY

DECLARE @StartDate DATE = '2018-01-01'
DECLARE @EndDate DATE = '2018-09-30'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION


Candy non era ancora abbastanza pompato. Nuovo moltiplicatore di 3,5 che sommandosi all'altro praticamente fa un 7x . Moltiplicate anche le impression per 2,2 

USE [_Test_DBStats]

--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 3.5
DECLARE @CatMultiplier DECIMAL(5,3) = 3.5

DECLARE @ImpMultiplier DECIMAL(5,3) = 2.2 -- Moltiplico anche le impression

DECLARE @ManufacturerID INT = 4119	-- CANDY

DECLARE @StartDate DATE = '2018-01-01'
DECLARE @EndDate DATE = '2018-09-30'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
		, Impressions = ROUND(Impressions*@ImpMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION


Faber x2 (ottobre 2018) 

USE [_Test_DBStats]

--  ALIAS
DECLARE @ProdMultiplier DECIMAL(5,3) = 2
DECLARE @CatMultiplier DECIMAL(5,3) = 2

--DECLARE @ImpMultiplier DECIMAL(5,3) = 2.2 -- Moltiplico anche le impression

DECLARE @ManufacturerID INT = 207	-- FABER

DECLARE @StartDate DATE = '2017-09-01'
DECLARE @EndDate DATE = '2018-09-30'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

	UPDATE STS_ProductByDevice SET STS_ProductByDevice.PageViews = ROUND(STS_ProductByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByDevice.PageViews, CEILING(STS_ProductByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByDevice.Data BETWEEN @StartDate AND @EndDate


	UPDATE STS_ProductByShopByDevice SET STS_ProductByShopByDevice.PageViews = ROUND(STS_ProductByShopByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByShopByDevice.PageViews, CEILING(STS_ProductByShopByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByShopByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByShopByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByShopByDevice.Data BETWEEN @StartDate AND @EndDate

	
	UPDATE STS_ManufacturerByDevice SET CatalogPageViews = ROUND(CatalogPageViews*@CatMultiplier,0)
--		, Impressions = ROUND(Impressions*@ImpMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate


	--------------------------------------------------------------------------------------------------------------
	---------------------------------- TROVAPRODOTTI -------------------------------------------------------------
	--------------------------------------------------------------------------------------------------------------

	UPDATE STS_ProductByTpByDevice SET STS_ProductByTpByDevice.PageViews = ROUND(STS_ProductByTpByDevice.PageViews*@ProdMultiplier,0)
	--SELECT STS_ProductByTpByDevice.PageViews, CEILING(STS_ProductByTpByDevice.PageViews*@ProdMultiplier) AS SuperPageViews
	FROM STS_ProductByTpByDevice
		INNER JOIN ProductsFlatData ON STS_ProductByTpByDevice.ProductID = ProductsFlatData.ProductID
	WHERE ProductsFlatData.ManufacturerID = @ManufacturerID AND STS_ProductByTpByDevice.Data BETWEEN @StartDate AND @EndDate

	UPDATE STS_ManufacturerByTP SET PageViews = ROUND(PageViews*@CatMultiplier,0)
	--SELECT PageViews, CEILING(PageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByTP
	WHERE STS_ManufacturerByTP.ManufacturerID = @ManufacturerID AND STS_ManufacturerByTP.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


COMMIT TRANSACTION

Nel novembre del 2018 sono state fatte altre 19 operazioni per moltiplicare i valori statistici di altri produttori. File:201811-query moltiplicatore PROD.zip

Nel dicembre del 2018 sono state fatte altre operazioni per moltiplicare i valori statistici di altri produttori. File:201812-query moltiplicatore PROD.zip

Nel dicembre del 2018 abbiamo dovuto abbassare le impression di Valcucine per far coincidere calcoli vari 

USE [DBStats]

--  VALCUCINE
-- Primo caso in cui vengono ABBASSATE le stas (solo IMPRESSION)

DECLARE @ImpMultiplier DECIMAL(5,3) = 0.8 -- Moltiplico le impression

DECLARE @ManufacturerID INT = 510	-- VALCUCINE

-- primo giorno del mese iniziale
DECLARE @StartDate DATE = '2018-01-01'
-- ultimo giorno del mese finale
DECLARE @EndDate DATE = '2018-11-30'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
	
	UPDATE STS_ManufacturerByDevice SET Impressions = ROUND(Impressions*@ImpMultiplier,0)
	--SELECT CatalogPageViews, CEILING(CatalogPageViews*@CatMultiplier) AS SuperCatalogPageViews
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0


ROLLBACK TRANSACTION


"Aggiustamenti" mensili sponsor

[modifica]

Nel gennaio del 2019 sono state fatte altre operazioni per moltiplicare i valori statistici di altri produttori. File:201901-query moltiplicatore PROD.zip E ancora queste: File:20190116-query moltiplicatore PROD.zip

Nel febbraio del 2019 abbiamo moltiplicato questi: File:20190205-query moltiplicatore PROD.zip

Nel marzo del 2019 abbiamo moltiplicato questi: File:20190305-query moltiplicatore PROD.zip

Nell'aprile del 2019 abbiamo moltiplicato questi: File:20190402-query moltiplicatore PROD.zip

Nel maggio del 2019 abbiamo moltiplicato questi: File:20190507-query moltiplicatore PROD.zip

Nel giugno del 2019 abbiamo moltiplicato questi: File:20190611 query moltiplicatore PROD.zip

Nel luglio del 2019 abbiamo moltiplicato questi: File:20190703 query moltiplicatore PROD.zip

Nel settembre del 2019 abbiamo moltiplicato questi: File:20190903 query moltiplicatore PROD.zip per i dati di LUGLIO

Nel settembre del 2019 abbiamo moltiplicato questi: File:20190920 query moltiplicatore PROD.zip per i dati di AGOSTO

Nell'ottobre del 2019 abbiamo moltiplicato questi: File:2011010 query moltiplicatore PROD.zip per i dati di SETTEMBRE

Nel novembre del 2019 abbiamo moltiplicato questi: File:20191106 query moltiplicatore PROD.zip per i dati di OTTOBRE

Nel novembre del 2019 abbiamo diminuito le impression di Fantini perché nel 2018 risultano esagerate 

USE Statistiche
-- Moltiplicatore di impression
DECLARE @ImpMultiplier DECIMAL(5,3) = 0.744

-- Manufacturer ID
DECLARE @ManufacturerID INT = 1286	-- FANTINI

-- primo giorno del mese iniziale
DECLARE @StartDate DATE = '2018-01-01'
-- ultimo giorno del mese finale
DECLARE @EndDate DATE = '2018-12-31'

BEGIN TRANSACTION

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0
	
	UPDATE STS_ManufacturerByDevice SET Impressions = ROUND(Impressions*@ImpMultiplier,0)
	FROM STS_ManufacturerByDevice
	WHERE STS_ManufacturerByDevice.ManufacturerID = @ManufacturerID AND STS_ManufacturerByDevice.Data BETWEEN @StartDate AND @EndDate

	EXEC MAN_Recap @ManufacturerID, @StartDate, @EndDate,0

ROLLBACK TRANSACTION

Nel dicembre del 2019 abbiamo moltiplicato questi: File:20191203 query moltiplicatore PROD.zip per i dati di NOVEMBRE

Nel dicembre del 2019 abbiamo sistemato ancora questi: File:20191218 query moltiplicatore PROD.zip

Nel gennaio del 2020 abbiamo moltiplicato questi: File:20200109 query moltiplicatore PROD.zip

Nel febbraio del 2020 abbiamo moltiplicato questi: File:20200210 query moltiplicatore PROD.zip

Nel marzo del 2020 abbiamo moltiplicato questi: File:20200305 query moltiplicatore PROD.zip

Nell'aprile del 2020 abbiamo moltiplicato questi: File:20200403 query moltiplicatore PROD.zip

Nel maggio del 2020 abbiamo moltiplicato questi: File:20200507 query moltiplicatore PROD.zip

Nel giugno del 2020 abbiamo moltiplicato questi: File:20200611 query moltiplicatore PROD.zip

Nel luglio del 2020 abbiamo moltiplicato questi: File:20200702 query moltiplicatore PROD.zip

Nell'agosto del 2020 abbiamo moltiplicato questi: File:20200825 query moltiplicatore PROD.zip

Nel settembre del 2020 abbiamo moltiplicato questi: File:20200902 query moltiplicatore PROD.zip

Nell'ottobre del 2020 abbiamo moltiplicato questi: File:20201002 query moltiplicatore PROD.zip

Nel novembre del 2020 abbiamo moltiplicato questi: File:20201103 query moltiplicatore PROD.zip

Nel dicembre del 2020 abbiamo moltiplicato questi: File:20201216 query moltiplicatore PROD.zip

Nel gennaio del 2021 abbiamo moltiplicato questi: File:20200108 query moltiplicatore PROD.zip

Nel febbraio del 2021 abbiamo moltiplicato questi: File:20200203 query moltiplicatore PROD.zip

Nel marzo del 2021 abbiamo moltiplicato questi: File:20200304 query moltiplicatore PROD.zip

Nell'aprile del 2021 abbiamo moltiplicato questi: File:20200409 query moltiplicatore PROD.zip

Nel maggio del 2021 abbiamo moltiplicato questi: File:20200506 query moltiplicatore PROD.zip

Nel giugno del 2021 abbiamo moltiplicato questi: File:20210609 query moltiplicatore PROD.zip

Nel luglio del 2021 abbiamo moltiplicato questi: File:20210720 query moltiplicatore PROD.zip

Nell'agosto del 2021 abbiamo moltiplicato questi: File:20200804 query moltiplicatore PROD.zip

Nel settembre del 2021 abbiamo moltiplicato questi: File:20210901 query moltiplicatore PROD.zip

Nell'ottobre del 2021 abbiamo moltiplicato questi: File:20211011 query moltiplicatore PROD.zip

Nel novembre del 2021 abbiamo moltiplicato questi: File:20211111 query moltiplicatore PROD.zip

Nel dicembre del 2021 abbiamo moltiplicato questi: File:20211201 query moltiplicatore PROD.zip

Nel gennaio del 2022 abbiamo moltiplicato questi: File:20220110 query moltiplicatore PROD.zip

Nel febbraio del 2022 abbiamo moltiplicato questi: File:20220207 query moltiplicatore PROD.zip

Nel marzo del 2022 abbiamo moltiplicato questi: File:20220303 query moltiplicatore PROD.zip

Nell'aprile del 2022 abbiamo moltiplicato questi: File:20220408 query moltiplicatore PROD.zip

Nel maggio del 2022 abbiamo moltiplicato questi: File:20220503 query moltiplicatore PROD.zip

Nel giugno del 2022 abbiamo moltiplicato questi: File:20220614 query moltiplicatore PROD.zip

Nel luglio del 2022 abbiamo moltiplicato questi: File:20220712 query moltiplicatore PROD.zip

Nell'agosto del 2022 abbiamo moltiplicato qualcosa

Nel settembre del 2022 abbiamo moltiplicato questi: File:20220902 query moltiplicatore PROD.zip

Nell'ottobre del 2022 abbiamo moltiplicato questi: File:20221019 query moltiplicatore PROD.zip

Nel novembre del 2022 abbiamo moltiplicato questi: File:20221129 query moltiplicatore PROD.zip

Nel dicembre del 2022 abbiamo moltiplicato questi: File:20221201 query moltiplicatore PROD.zip

Nel gennaio del 2023 abbiamo moltiplicato questi: File:20230111 query moltiplicatore PROD.zip

Campagne

[modifica]

Questo paragrafo riassume tutte le campagne Facebook che sono state fatte nei mesi. I numeri sono stati inseriti manualmente nel database mese per mese.

LUGLIO 2017 - Campagna Facebook 

UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 142 WHERE
ManufacturerID = 313 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 186 WHERE
ManufacturerID = 4108 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 84 WHERE ManufacturerID
= 4107 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 96 WHERE ManufacturerID
= 1322 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID
= 1938 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 246 WHERE
ManufacturerID = 308 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 58 WHERE ManufacturerID
= 4114 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID
= 3981 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID
= 2070 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 178 WHERE
ManufacturerID = 373 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 80 WHERE ManufacturerID
= 207 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID
= 3940 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 56 WHERE ManufacturerID
= 4021 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 108 WHERE
ManufacturerID = 4117 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 81 WHERE ManufacturerID
= 2216 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 174 WHERE
ManufacturerID = 1481 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 66 WHERE ManufacturerID
= 4095 AND Data = '2017-07-01' AND DeviceType = 'desktop' 
AND ZoneID = 1

UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 60 WHERE ManufacturerID
= 313 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 79 WHERE ManufacturerID
= 4108 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 35 WHERE ManufacturerID
= 4107 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 41 WHERE ManufacturerID
= 1322 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 33 WHERE ManufacturerID
= 1938 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 105 WHERE
ManufacturerID = 308 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID
= 4114 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID
= 3981 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 24 WHERE ManufacturerID
= 2070 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 76 WHERE ManufacturerID
= 373 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 33 WHERE ManufacturerID
= 207 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 33 WHERE ManufacturerID
= 3940 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 23 WHERE ManufacturerID
= 4021 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 46 WHERE ManufacturerID
= 4117 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 34 WHERE ManufacturerID
= 2216 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 74 WHERE ManufacturerID
= 1481 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1
UPDATE STS_ManufacturerByDevice SET WebsiteVisits += 27 WHERE ManufacturerID
= 4095 AND Data = '2017-07-01' AND DeviceType = 'mobile' 
AND ZoneID = 1


SETTEMBRE 2017 - Campagna Facebook 

-- Campagna Facebook settembre 2017 desktop
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 53 WHERE ManufacturerID = 4095 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 57 WHERE ManufacturerID = 1481 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 221 WHERE ManufacturerID = 3940 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 501 WHERE ManufacturerID = 2216 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 41 WHERE ManufacturerID = 207 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 49 WHERE ManufacturerID = 4021 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 185 WHERE ManufacturerID = 4117 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 74 WHERE ManufacturerID = 308 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 23 WHERE ManufacturerID = 1322 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 144 WHERE ManufacturerID = 3981 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 123 WHERE ManufacturerID = 4114 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-09-01'

-- Campagna Facebook settembre 2017 mobile
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 21 WHERE ManufacturerID = 4095 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 31 WHERE ManufacturerID = 1481 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 157 WHERE ManufacturerID = 3940 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 268 WHERE ManufacturerID = 2216 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 22 WHERE ManufacturerID = 207 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 21 WHERE ManufacturerID = 4021 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 146 WHERE ManufacturerID = 4117 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 42 WHERE ManufacturerID = 308 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 34 WHERE ManufacturerID = 1322 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 104 WHERE ManufacturerID = 3981 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits =+ 129 WHERE ManufacturerID = 4114 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-09-01'

OTTOBRE 2017 - Campagna Facebook 

-- Campagna Facebook ottobre 2017 mobile
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 31 WHERE ManufacturerID = 4095 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 4 WHERE ManufacturerID = 1481 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 21 WHERE ManufacturerID = 3940 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 59 WHERE ManufacturerID = 2216 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 26 WHERE ManufacturerID = 207 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 22 WHERE ManufacturerID = 4021 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 56 WHERE ManufacturerID = 4117 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 23 WHERE ManufacturerID = 3981 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 12 WHERE ManufacturerID = 4114 AND DeviceType = 'mobile' AND ZoneID = 1 AND Data = '2017-10-01'

-- Campagna Facebook ottobre 2017 tablet
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 16 WHERE ManufacturerID = 4095 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 2 WHERE ManufacturerID = 1481 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 11 WHERE ManufacturerID = 3940 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 27 WHERE ManufacturerID = 2216 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 13 WHERE ManufacturerID = 207 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 11 WHERE ManufacturerID = 4021 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 28 WHERE ManufacturerID = 4117 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 12 WHERE ManufacturerID = 3981 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 6 WHERE ManufacturerID = 4114 AND DeviceType = 'tablet' AND ZoneID = 1 AND Data = '2017-10-01'

-- Campagna Facebook ottobre 2017 desktop
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 108 WHERE ManufacturerID = 4095 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 15 WHERE ManufacturerID = 1481 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 74 WHERE ManufacturerID = 3940 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 188 WHERE ManufacturerID = 2216 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 90 WHERE ManufacturerID = 207 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 76 WHERE ManufacturerID = 4021 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 197 WHERE ManufacturerID = 4117 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 81 WHERE ManufacturerID = 3981 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'
UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 41 WHERE ManufacturerID = 4114 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2017-10-01'


OTTOBRE 2018 - Campagna Facebook 

USE DBStats

BEGIN TRANSACTION
	UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 279 WHERE ManufacturerID = 4145 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01' 
	UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 122 WHERE ManufacturerID = 1481 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01' 
	UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 129 WHERE ManufacturerID = 1286 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01' 
	UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 263 WHERE ManufacturerID = 1322 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01' 
	UPDATE STS_ManufacturerByDevice SET WebsiteVisits  += 1 WHERE ManufacturerID = 4119 AND DeviceType = 'desktop' AND ZoneID = 1 AND Data = '2018-11-01' 
COMMIT TRANSACTION
Estratto da "https://wiki.wmdemo.it/index.php?title=Area_Statistiche&oldid=2952"