sanjeev21/ProductRecv3
0
1SQLite format 3 @ .WJ
� � �##�/tableclickReportclickReportCREATE TABLE clickReport (2 report_date VARCHAR(50),3 publisher_id VARCHAR(10),4 ca�##�KtableclickReportclickReportCREATE TABLE "clickReport" (5"report_date" TEXT,6 "publisher_id" INTEGER,7 "campaign_id" TEXT,8 "placement_id" INTEGER,9 "rid" TEXT,10 "keyword" TEXT,11 "Skus" TEXT,12 "clicks" INTEGER,13 "earnings" REAL,14 "cpc" REAL15) � ���4
�
|
�j�|.16�17�188 � � H��*�r19�^��@��$�f�J��$ � `,!' 9- 2023-03-02�test_campaigngummy_6524087161000170gummy6524087161000170?���Y��}?���Y��}`+!' 9- 2023-03-02�test_campaigngummy_6524087570025830gummy6524087570025830?���Y��}?���Y��}`*!' 9- 2023-03-02�test_campaigngummy_6524087571000170gummy6524087571000170?���Y��}?���Y��}`)!' 9- 2023-03-02�test_campaigngummy_6524087191000170gummy6524087191000170?���Y��}?���Y��}](!' 5%2023-03-02�test_campaigntshirts_item87094834tshirtsitem87094834?���Y��}?���Y��}]'!' 5%2023-03-02�test_campaigntshirts_item95443056tshirtsitem95443056?���Y��}?���Y��}\&!' 5% 2023-03-02�test_campaigntshirts_item92117027tshirtsitem92117027?���Y��}?���Y��}^%!' 7' 2023-03-02�test_campaigntshirts_item133674570tshirtsitem133674570?���Y��}?���Y��}\$!' 5% 2023-03-02�test_campaigntshirts_item84934337tshirtsitem84934337?���Y��}?���Y��}^#!' 7' 2023-03-02�test_campaigntshirts_item123203061tshirtsitem123203061?���Y��}?���Y��}\"!' 5% 2023-03-02�test_campaigntshirts_item86709621tshirtsitem86709621?���Y��}?���Y��}\!!' 5% 2023-03-02�test_campaigntshirts_item53852492tshirtsitem53852492?���Y��}?���Y��}\ !' 5% 2023-03-02�test_campaigntshirts_item90002318tshirtsitem90002318?���Y��}?���Y��}^!' 7' 2023-03-02�test_campaigntshirts_item122606512tshirtsitem122606512?���Y��}?���Y��}^!' 7' 2023-03-02�test_campaigntshirts_item119111665tshirtsitem119111665?���Y��}?���Y��}\!' 5% 2023-03-02�test_campaigntshirts_item78484847tshirtsitem78484847?���Y��}?���Y��}L!' % 2023-03-02�test_campaignchair_9254SVchair9254SV?���Y��}?���Y��}f!' ?1 2023-03-02�test_campaignchairs_XUDG60115GRDWALWGGchairsXUDG60115GRDWALWGG?���Y��}?���Y��}T!' - 2023-03-02�test_campaignchairs_LEL1MAHGGchairsLEL1MAHGG?���Y��}?���Y��}`!' 9- 2023-03-02�test_campaignchair_XUDG6G5BWALMTLGGchairXUDG6G5BWALMTLGG?���Y��}?���Y��}j!' C7 2023-03-02�test_campaignchair_XUDGW0005LADNATBURVGGchairXUDGW0005LADNATBURVGG?���Y��}?���Y��}X!' 1# 2023-03-02�test_campaignchairs_ET3534COPGGchairsET3534COPGG?���Y��}?���Y��}V!' /# 2023-03-02�test_campaignelectronics_TE10RelectronicsTE10R?���Y��}?���Y��}X!' 1) 2023-03-02�test_campaignbed_XUBD1012PSMKGGbedXUBD1012PSMKGG?���Y��}?���Y��}B!' +2023-03-02�test_campaignchair_LEL1MAHGGchairLEL1MAHGGP!' ) 2023-03-02�test_campaigncologne_538082cologne538082?��<64?��<64P!' ) 2023-03-02�test_campaigncologne_427559cologne427559?���Y��}?���Y��}P!' ) 2023-03-02�test_campaigncologne_502850cologne502850?���Y��}?���Y��}P!' ) 2023-03-02�test_campaigncologne_430659cologne430659?���Y��}?���Y��}L!' % 2023-03-02�test_campaigndolce_514350dolce514350?���Y��}?���Y��}P!' ) 2023-03-02�test_campaigncologne_448932cologne448932?���Y��}?���Y��}L
!' % 2023-03-02�test_campaigndolce_435355dolce435355?���Y��}?���Y��}L!' % 2023-03-02�test_campaigndolce_545226dolce545226?���Y��}?���Y��}Z!' 3' 2023-03-01�test_campaignshoes_205917459M5W7shoes205917459M5W7?�L�_�?�L�_�X20!' 1% 2023-03-01�test_campaignshoes_2069934SSC13shoes2069934SSC13?ʽ<64?ʽ<64Z !' 3' 2023-03-01�test_campaignshoes_2078720CUM7W9shoes2078720CUM7W9?��ߤ?�?��ߤ?�\!' 5) 2023-03-01�test_campaignshoes_205917060M8W10shoes205917060M8W10?��s�P?��s�PX!' 1% 2023-03-01�test_campaignshoes_207012001C10shoes207012001C10?�hr� Ĝ?�hr� ĜZ!' 3' 2023-03-01�test_campaignshoes_205917060M6W8shoes205917060M6W8?�L�_�?�L�_�Z!' 3' 2023-03-01�test_campaignshoes_2078412Y4M6W8shoes2078412Y4M6W8?ʽ<64?ʽ<64(! 2023-03-01�?ѷX�e?ѷX�eX!' 1% 2023-03-01�test_campaignshoes_20783783FC13shoes20783783FC13?�xF�]?�xF�]V!' /# 2023-03-01�test_campaignshoes_20783783FJ2shoes20783783FJ2?�xF�]?�xF�]6! 2023-03-01�1click1click1?��ߤ X ,
, c �<�x
�
\
�H��(21�22�236 � � 4��2��(�j24�F��>��?��-�u# � c `X!' 9- 2023-03-03�test_campaigngummy_6524087190025170gummy6524087190025170?���Y��}?���Y��}\W!' 5- 2023-03-03�test_campaignbed_BEDHIROBRQUEESETbedBEDHIROBRQUEESET?���Y��}?���Y��}PV!' ) 2023-03-03�test_campaignversace_555381versace555381?���Y��}?���Y��}PU!' ) 2023-03-03�test_campaignversace_402323versace402323?���Y��}?���Y��}dT!' =3 2023-03-03�test_campaignrugs_YKF968AD9276I5RBKGGrugsYKF968AD9276I5RBKGG?��<64?��<64^S!' 7' 2023-03-03�test_campaigntshirts_item118836568tshirtsitem118836568?���Y��}?���Y��}`R!' 9- 2023-03-03�test_campaigngummy_6524087570025830gummy6524087570025830?���Y��}?���Y��}NQ!' ' 2023-03-03�test_campaignbench_M4BCHBKbenchM4BCHBK?���Y��}?���Y��}GP!' 2023-03-03�test_campaignbench_158bench158?���Y��}?���Y��}\O!' 5- 2023-03-03�test_campaignbed_BEDOLIVWHQUEESETbedBEDOLIVWHQUEESET?���Y��}?���Y��}VN!' /' 2023-03-03�test_campaignbed_BEDMOVIWHQUEEbedBEDMOVIWHQUEE?���Y��}?���Y��}FM!' 2023-03-03�test_campaignbench_159bench159?���Y��}?���Y��}\L!' 5- 2023-03-03�test_campaignbed_BEDWILLGYQUEESETbedBEDWILLGYQUEESET?���Y��}?���Y��}`K!' 9- 2023-03-03�test_campaigngummy_6524087570025818gummy6524087570025818?��<64?��<64`J!' 9- 2023-03-03�test_campaigngummy_6524087561500170gummy6524087561500170?���Y��}?���Y��}`I!' 9- 2023-03-03�test_campaigngummy_6524087160025150gummy6524087160025150?��<64?��<64^H!' 7' 2023-03-03�test_campaigntshirts_item135176297tshirtsitem135176297?���Y��}?���Y��}\G!' 5% 2023-03-03�test_campaigntshirts_item90002318tshirtsitem90002318?���Y��}?���Y��}^F!' 7' 2023-03-03�test_campaigntshirts_item108693132tshirtsitem108693132?���Y��}?���Y��}dE!' =3 2023-03-03�test_campaignrugs_YKF968AD9276I57BKGGrugsYKF968AD9276I57BKGG?��<64?��<64PD!' ) 2023-03-02�test_campaigncologne_536092cologne536092?���Y��}?���Y��}PC!' ) 2023-03-02�test_campaigncologne_539584cologne539584?���Y��}?���Y��}PB!' ) 2023-03-02�test_campaigncologne_416102cologne416102?���Y��}?���Y��}PA!' ) 2023-03-02�test_campaigncologne_518326cologne518326?���Y��}?���Y��}\@!' 5# 2023-03-02�test_campaignelectronics_8852F190electronics8852F190?���Y��}?���Y��}^?!' 7' 2023-03-02�test_campaigntshirts_item108693132tshirtsitem108693132?���Y��}?���Y��}J>!' # 2023-03-02�test_campaigncologne_959cologne959?���Y��}?���Y��}T=!' - 2023-03-02�test_campaignleather_GATERBAGleatherGATERBAG?���Y��}?���Y��}P<!' ) 2023-03-02�test_campaigncologne_491480cologne491480?���Y��}?���Y��}L;!' % 2023-03-02�test_campaigndolce_547135dolce547135?���Y��}?���Y��}P:!' ) 2023-03-02�test_campaigncologne_425149cologne425149?���Y��}?���Y��}^9!' 7' 2023-03-02�test_campaigntshirts_item118836568tshirtsitem118836568?���Y��}?���Y��}`8!' 91 2023-03-02�test_campaignbed_BEDGIORWHQUEEV2SETbedBEDGIORWHQUEEV2SET?���Y��}?���Y��}\7!' 5- 2023-03-02�test_campaignbed_BEDMASSGYQUEESETbedBEDMASSGYQUEESET?���Y��}?���Y��}\6!' 5- 2023-03-02�test_campaignbed_BEDWILLGYQUEESETbedBEDWILLGYQUEESET?���Y��}?���Y��}\5!' 5- 2023-03-02�test_campaignbed_BEDHIROBRQUEESETbedBEDHIROBRQUEESET?���Y��}?���Y��}V4!' /' 2023-03-02�test_campaignbed_BEDMOVIWHQUEEbedBEDMOVIWHQUEE?���Y��}?���Y��}b3!' ;3 2023-03-02�test_campaignbed_BEDCASAGYFABQUEESETbedBEDCASAGYFABQUEESET?���Y��}?���Y��}\2!' 5- 2023-03-02�test_campaignbed_BEDOLIVWHQUEESETbedBEDOLIVWHQUEESET?���Y��}?���Y��}X1!' 1) 2023-03-02�test_campaignbed_BEDENVYQUEESETbedBEDENVYQUEESET?���Y��}?���Y��}`0!' 9- 2023-03-02�test_campaigngummy_6524087570025818gummy6524087570025818?�f�A��?�f�A��`/!' 9- 2023-03-02�test_campaigngummy_6524088510300000gummy6524088510300000?���Y��}?���Y��}`.!' 9- 2023-03-02�test_campaigngummy_6524087561500170gummy6524087561500170?���Y��}?���Y��}`-!' 9- 2023-03-02�test_campaigngummy_6524087160025150gummy6524087160025150?���Y��}?���Y��}
, � �p��4
�
|
�j�|.25�26�278 � � H��*�r28�^��@��$�f�J��$ � `,!' 9- 2023-03-02�test_campaigngummy_6524087161000170gummy6524087161000170?���Y��}?���Y��}`+!' 9- 2023-03-02�test_campaigngummy_6524087570025830gummy6524087570025830?���Y��}?���Y��}`*!' 9- 2023-03-02�test_campaigngummy_6524087571000170gummy6524087571000170?���Y��}?���Y��}`)!' 9- 2023-03-02�test_campaigngummy_6524087191000170gummy6524087191000170?���Y��}?���Y��}](!' 5%2023-03-02�test_campaigntshirts_item87094834tshirtsitem87094834?���Y��}?���Y��}]'!' 5%2023-03-02�test_campaigntshirts_item95443056tshirtsitem95443056?���Y��}?���Y��}\&!' 5% 2023-03-02�test_campaigntshirts_item92117027tshirtsitem92117027?���Y��}?���Y��}^%!' 7' 2023-03-02�test_campaigntshirts_item133674570tshirtsitem133674570?���Y��}?���Y��}\$!' 5% 2023-03-02�test_campaigntshirts_item84934337tshirtsitem84934337?���Y��}?���Y��}^#!' 7' 2023-03-02�test_campaigntshirts_item123203061tshirtsitem123203061?���Y��}?���Y��}\"!' 5% 2023-03-02�test_campaigntshirts_item86709621tshirtsitem86709621?���Y��}?���Y��}\!!' 5% 2023-03-02�test_campaigntshirts_item53852492tshirtsitem53852492?���Y��}?���Y��}\ !' 5% 2023-03-02�test_campaigntshirts_item90002318tshirtsitem90002318?���Y��}?���Y��}^!' 7' 2023-03-02�test_campaigntshirts_item122606512tshirtsitem122606512?���Y��}?���Y��}^!' 7' 2023-03-02�test_campaigntshirts_item119111665tshirtsitem119111665?���Y��}?���Y��}\!' 5% 2023-03-02�test_campaigntshirts_item78484847tshirtsitem78484847?���Y��}?���Y��}L!' % 2023-03-02�test_campaignchair_9254SVchair9254SV?���Y��}?���Y��}f!' ?1 2023-03-02�test_campaignchairs_XUDG60115GRDWALWGGchairsXUDG60115GRDWALWGG?���Y��}?���Y��}T!' - 2023-03-02�test_campaignchairs_LEL1MAHGGchairsLEL1MAHGG?���Y��}?���Y��}`!' 9- 2023-03-02�test_campaignchair_XUDG6G5BWALMTLGGchairXUDG6G5BWALMTLGG?���Y��}?���Y��}j!' C7 2023-03-02�test_campaignchair_XUDGW0005LADNATBURVGGchairXUDGW0005LADNATBURVGG?���Y��}?���Y��}X!' 1# 2023-03-02�test_campaignchairs_ET3534COPGGchairsET3534COPGG?���Y��}?���Y��}V!' /# 2023-03-02�test_campaignelectronics_TE10RelectronicsTE10R?���Y��}?���Y��}X!' 1) 2023-03-02�test_campaignbed_XUBD1012PSMKGGbedXUBD1012PSMKGG?���Y��}?���Y��}B!' +2023-03-02�test_campaignchair_LEL1MAHGGchairLEL1MAHGGP!' ) 2023-03-02�test_campaigncologne_538082cologne538082?��<64?��<64P!' ) 2023-03-02�test_campaigncologne_427559cologne427559?���Y��}?���Y��}P!' ) 2023-03-02�test_campaigncologne_502850cologne502850?���Y��}?���Y��}P!' ) 2023-03-02�test_campaigncologne_430659cologne430659?���Y��}?���Y��}L!' % 2023-03-02�test_campaigndolce_514350dolce514350?���Y��}?���Y��}P!' ) 2023-03-02�test_campaigncologne_448932cologne448932?���Y��}?���Y��}L
!' % 2023-03-02�test_campaigndolce_435355dolce435355?���Y��}?���Y��}L!' % 2023-03-02�test_campaigndolce_545226dolce545226?���Y��}?���Y��}Z!' 3' 2023-03-01�test_campaignshoes_205917459M5W7shoes205917459M5W7?�L�_�?�L�_�X29!' 1% 2023-03-01�test_campaignshoes_2069934SSC13shoes2069934SSC13?ʽ<64?ʽ<64Z !' 3' 2023-03-01�test_campaignshoes_2078720CUM7W9shoes2078720CUM7W9?��ߤ?�?��ߤ?�\!' 5) 2023-03-01�test_campaignshoes_205917060M8W10shoes205917060M8W10?��s�P?��s�PX!' 1% 2023-03-01�test_campaignshoes_207012001C10shoes207012001C10?�hr� Ĝ?�hr� ĜZ!' 3' 2023-03-01�test_campaignshoes_205917060M6W8shoes205917060M6W8?�L�_�?�L�_�Z!' 3' 2023-03-01�test_campaignshoes_2078412Y4M6W8shoes2078412Y4M6W8?ʽ<64?ʽ<64(! 2023-03-01�?ѷX�e?ѷX�eX!' 1% 2023-03-01�test_campaignshoes_20783783FC13shoes20783783FC13?�xF�]?�xF�]V!' /# 2023-03-01�test_campaignshoes_20783783FJ2shoes20783783FJ2?�xF�]?�xF�]6! 2023-03-01�1click1click1?��ߤ?�?��ߤ?�
� �>� P[!' ) 2023-03-03�test_campaignversace_534152versace534152?���Y��}?���Y��}XZ!' 1) 2023-03-03�test_campaignbed_XUBD1012PSMKGGbedXUBD1012PSMKGG?���Y��}?���Y��}fY!' ?5 2023-03-03�test_campaignrugs_YKF968AD9276I810BKGGrugsYKF968AD9276I810BKGG?��<64?��<64