not able to fetch complete data from Google content API for shpping
70 views
Skip to first unread message
archana gautam
Jun 5, 2024, 7:45:58 AMJun 5
to Google Content API for Shopping
I am able to fetch the data of brand, title and its metics like click, impression, CTR now I want to fetch the country and link it is showing that segment of country is invalid.
this is code for fetching the data now I want to add these two column i.e Contry and link. can you guide me how I can fetch these
this is code for fetching the data now I want to add these two column i.e Contry and link. can you guide me how I can fetch these
import logging
from googleapiclient.discovery import build
from google.oauth2 import service_account
import pandas as pd
import datetime
# Setup logging
logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')
# Define the scope and credentials
SCOPES = ['https://www.googleapis.com/auth/content']
SERVICE_ACCOUNT_FILE = 'path/to/your/service_account.json'
credentials = service_account.Credentials.from_service_account_file(SERVICE_ACCOUNT_FILE, scopes=SCOPES)
# Define the merchant ID and build the service
MERCHANT_ID = ''
service = build('content', 'v2.1', credentials=credentials)
# Define the date range
start_date = datetime.date(2024, 4, 1)
end_date = datetime.date(2024, 4, 30)
all_data = pd.DataFrame()
# Function to fetch data
def fetch_data_for_date(query_date):
global all_data
nextPageToken = None
total_records = 0
while True:
query = f"""
SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions
FROM MerchantPerformanceView
WHERE segments.program = "FREE_PRODUCT_LISTING" AND segments.date = '{query_date}'
"""
request_body = {
"query": query,
"pageSize": 5000,
"pageToken": nextPageToken
}
response = service.reports().search(merchantId=MERCHANT_ID, body=request_body).execute()
records = response.get('results', [])
total_records += len(records)
logging.info(f'Date: {query_date}, Records fetched: {len(records)}, Total so far: {total_records}')
if not records:
break
data = [{
'Date': query_date,
'Title': r['segments'].get('title', ''),
'Brand': r['segments'].get('brand', ''),
'Clicks': r['metrics'].get('clicks', 0),
'Impressions': r['metrics'].get('impressions', 0),
'CTR': r['metrics'].get('ctr', 0.0),
'Conversions': r['metrics'].get('conversions', 0.0),
} for r in records]
all_data = pd.concat([all_data, pd.DataFrame(data)], ignore_index=True)
nextPageToken = response.get('nextPageToken')
if not nextPageToken:
break
return total_records
# Loop through each date and fetch data
for current_date in pd.date_range(start_date, end_date):
date_str = current_date.strftime('%Y-%m-%d')
records_fetched = fetch_data_for_date(date_str)
logging.info(f'Total records fetched for {date_str}: {records_fetched}')
# Save the DataFrame
all_data.to_csv("performance_metrics_apr.csv", index=False)
archana gautam
Jun 5, 2024, 7:53:55 AMJun 5
to Google Content API for Shopping
---------------------------------------------------------------------------
HttpError Traceback (most recent call last)
Cell In[26], line 103
100 return df
102 # Fetch the data and print the DataFrame
--> 103 df = fetch_combined_data()
104 print(df)
Cell In[26], line 96, in fetch_combined_data()
94 def fetch_combined_data():
95 products = fetch_product_data()
---> 96 performance_data = fetch_performance_data()
97 combined_data = combine_data(products, performance_data)
99 df = pd.DataFrame(combined_data)
Cell In[26], line 68, in fetch_performance_data()
60 def fetch_performance_data():
61 performance_request = service.reports().search(
62 merchantId=MERCHANT_ID,
63 body={
(...)
66 }
67 )
---> 68 performance_response = performance_request.execute()
69 return performance_response.get('results', [])
File ~\anaconda3\Lib\site-packages\googleapiclient\_helpers.py:130, in positional.<locals>.positional_decorator.<locals>.positional_wrapper(*args, **kwargs)
128 elif positional_parameters_enforcement == POSITIONAL_WARNING:
129 logger.warning(message)
--> 130 return wrapped(*args, **kwargs)
File ~\anaconda3\Lib\site-packages\googleapiclient\http.py:938, in HttpRequest.execute(self, http, num_retries)
936 callback(resp)
937 if resp.status >= 300:
--> 938 raise HttpError(resp, content, uri=self.uri)
939 return self.postproc(resp, content)
HttpError: <HttpError 400 when requesting https://shoppingcontent.googleapis.com/content/v2.1/125366935/reports/search?alt=json returned "[query] Error in query: invalid field name 'segments.customerCountryCode' in SELECT clause". Details: "[{'@type': 'type.googleapis.com/google.rpc.ErrorInfo', 'reason': 'invalid', 'domain': 'global'}]">
showing this error
Shopping API Forum Advisor
Jun 5, 2024, 1:19:47 PMJun 5
to archanag...@gmail.com, google-content-...@googlegroups.com
Hi,
Thank you for reaching out to the Content API support team.
Upon reviewing your query, I understand that you are encountering an issue where
You can send the details via Reply privately to the author option, or direct private reply to this email.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdl:ref" (ADR-00238461)
Thanks,
Thank you for reaching out to the Content API support team.
Upon reviewing your query, I understand that you are encountering an issue where
segments.customerCountryCode is not valid in the SELECT clause of your query. Could you please provide the complete JSON request and response logs that you have performed from your end for further investigation.You can send the details via Reply privately to the author option, or direct private reply to this email.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdl:ref" (ADR-00238461)
Thanks,
 |
Content API for Shopping Team |
Shopping API Forum Advisor
Jun 5, 2024, 1:26:17 PMJun 5
to archanag...@gmail.com, google-content-...@googlegroups.com
Hi,
Thank you for reaching out to the Content API support team.
Thank you for reaching out to the Content API support team.
I see that you have already raised this concern on another thread with the subject 'not able to fetch complete data from Google content API for shpping', and we have already responded to the user for this issue. To avoid multiple threads on the same issue, please take a look at that thread and continue the discussion on the same for further updates on the issue.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdg:ref" (ADR-00238460)
Thanks,
|
Content API for Shopping Team |
archana gautam
Jun 6, 2024, 12:31:44 AMJun 6
to Google Content API for Shopping
import logging
from googleapiclient.discovery import build
from google.oauth2 import service_account
import pandas as pd
import datetime
import jsonfrom googleapiclient.discovery import build
from google.oauth2 import service_account
import pandas as pd
import datetime
# Setup logging
logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')
# Define the scope and credentials
SCOPES = ['https://www.googleapis.com/auth/content']
SERVICE_ACCOUNT_FILE = 'path/to/your/service_account.json'
credentials = service_account.Credentials.from_service_account_file(SERVICE_ACCOUNT_FILE, scopes=SCOPES)
# Define the merchant ID and build the service
service = build('content', 'v2.1', credentials=credentials)
# Define the date range
start_date = datetime.date(2024, 4, 1)
end_date = datetime.date(2024, 4, 30)
all_data = pd.DataFrame()
# Function to fetch data
def fetch_data_for_date(query_date):
global all_data
nextPageToken = None
total_records = 0
while True:
query = f"""
SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions
FROM MerchantPerformanceView
WHERE segments.program = "FREE_PRODUCT_LISTING" AND segments.date = '{query_date}'
"""
request_body = {
"query": query,
"pageSize": 5000,
"pageToken": nextPageToken
}
response = service.reports().search(merchantId=MERCHANT_ID, body=request_body).execute()
log.info(f"Response: {json.dumps(response, indent=2)}")
archana gautam
Jun 6, 2024, 12:36:02 AMJun 6
to Google Content API for Shopping
this is the
Captured the JSON Request and Response Logs:
i just want to include the country colunm
2024-06-06 10:03:08,746 - INFO - file_cache is only supported with oauth2client<4.0.0
2024-06-06 10:03:08,805 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-01'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:14,024 - INFO - Response: {
"results": [
{
"segments": {
"title": "Blickle Bsd-gspo 100k Dual Wheel Rigid Caster 4840 Lb 4 Inch Diameter Nyl",
"brand": "blickle"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Fibergrate 874010 Grating Moltruded 1 1/2 Inch 2 X 4 Feet Light Gry",
"brand": "fibergrate"
},
"metrics": {
"clicks": "0",
"impressions": "39",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Miller Electric 251066 Welding Gloves M 5 Inch White/blue/black Pr",
"brand": "miller electric"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Safety Speed Wbatable Power Lift Table",
"brand": "safety speed"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:14,024 - INFO - Date: 2024-04-01, Records fetched: 4, Total so far: 4
2024-06-06 10:03:14,037 - INFO - Total records fetched for 2024-04-01: 4
2024-06-06 10:03:14,038 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-02'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:14,780 - INFO - Response: {
"results": [
{
"segments": {
"title": "Apollo Valves 76-505-01a Stainless Steel Ball Valve Fnpt 1 In",
"brand": "apollo"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dutton-lainson Dlb800a Spur Gear Hand Winch, 800 Lb Brake Capacity, Steel",
"brand": "dutton-lainson"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Fibergrate 874010 Grating Moltruded 1 1/2 Inch 2 X 4 Feet Light Gry",
"brand": "fibergrate"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Fillrite Frh10020gr Hose 20 Feet 1 Inch",
"brand": "fillrite"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ge Lighting Hr400a33 Mercury Vapor Lamp Ed37 400w",
"brand": "ge lighting"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Helicoil 7571-04b Hand Installation Tool, Gage Style, Unc, 4-40 Thread Size",
"brand": "helicoil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Lovejoy 68514411512 Jaw Coupling Hub, L100 Coupling, 3/4 Inch Bore, 2.54 Inch O.d.",
"brand": "lovejoy"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Lovejoy 68514412001 Jaw Coupling Spider, Sox/nbr Rubber, L150 Coupling Size",
"brand": "lovejoy"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Parker Nvh081k Needle Valve, 10 Gpm, Steel",
"brand": "parker"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ramfan Ub20 Blower/exhauster Kit 8 Inch 1/3 Hp 230v",
"brand": "ramfan"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Pm4-2748-lp Low Profile Pallet Truck, 4000 Lb. Capacity, 27 X 48 Inch Size",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Wesco 260150 Hydraulic Lite-lift, 500 Lbs Capacity, 54\" Lift, 20\" X 20\" Platform",
"brand": "wesco"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Zurn Zs880-32 Shower Drain Linear Stainless Steel 32 Inch Length",
"brand": "zurn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:14,780 - INFO - Date: 2024-04-02, Records fetched: 13, Total so far: 13
2024-06-06 10:03:14,780 - INFO - Total records fetched for 2024-04-02: 13
2024-06-06 10:03:14,792 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-03'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:15,487 - INFO - Response: {
"results": [
{
"segments": {
"title": "Air Systems International Aqt-347lp High Pressure Breathing Air Cylinder Adapter",
"brand": "air systems international"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dwyer Instruments Adps-03-2-n Differential Pressure Switch, Compact",
"brand": "dwyer instruments"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Miller - Weldcraft Wp-26v-25-2 Tig Torch Kit A-200v 25 Feet 2pc Rubber",
"brand": "miller - weldcraft"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Mueller Industries 1wju5 Wye 4 Inch Hub Pvc",
"brand": "mueller industries"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Straub Str35651 Open Flex Coupling, 114.3mm Pipe Outside Dia., 4 Inch Ips, Galvanized Steel",
"brand": "straub"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Victor Thermal Dynamics 0781-9134 Regulator Cylinder Argon Helium Nitrogen Cga-580",
"brand": "victor thermal dynamics"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Weiler 12306 Knot Wire Cup Brush Threaded Arbor 4 Inch",
"brand": "weiler"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Wesco 260003 2-wheel Hydraulic Pedalift, 750 Lbs Capacity, 54\" Lift, 22\" X 30\" Platform",
"brand": "wesco"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Zurn Z5344.520.1.07.00.0 Bathroom Sink Kit 18-1/4 Inch Width 10 Inch Height",
"brand": "zurn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:15,487 - INFO - Date: 2024-04-03, Records fetched: 9, Total so far: 9
2024-06-06 10:03:15,494 - INFO - Total records fetched for 2024-04-03: 9
2024-06-06 10:03:15,495 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-04'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:16,216 - INFO - Response: {
"results": [
{
"segments": {
"title": "Aquasol Welding Sgp-1.0 Socket Weld Spacer Ring, Width 1/16 Inch, Diameter 1 Inch",
"brand": "aquasol"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Bell & Gossett Nrf-25 Hot Water Circulator Pump Nrf Series",
"brand": "bell & gossett"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Hyde 13000 Razor Scraper Carbon Steel Silver",
"brand": "hyde"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Lovejoy 68514411073 Jaw Coupling Spider, L090, L095, Al090, Al095 Coupling Size",
"brand": "lovejoy"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Morse Drum 42 Heavy Duty Lifting Hook, Alloy, Self-color, 907 Kg Capacity",
"brand": "morse drum"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Yellow Jacket 42004 Manifold, 60 Inch Hose",
"brand": "yellow jacket"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:16,219 - INFO - Date: 2024-04-04, Records fetched: 6, Total so far: 6
2024-06-06 10:03:16,219 - INFO - Total records fetched for 2024-04-04: 6
2024-06-06 10:03:16,219 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-05'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:17,029 - INFO - Response: {
"results": [
{
"segments": {
"title": "Benchmark Scientific Bsh5001-e Digital Dry Bath, Single Chamber, 230v",
"brand": "benchmark scientific"
},
"metrics": {
"clicks": "0",
"impressions": "127",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Greenlee 7238sb Knockout Kit, With Ratchet And Punch, 1/2 To 2 Inch Conduit Size, 15 Pieces",
"brand": "greenlee"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Parker 8-8 Mcn-ss Close Nipple 1/2 Inch Threaded 316 Stainless Steel",
"brand": "parker"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Siemens 243-00211 Threaded Globe Valve 1/2 Inch 24vac No",
"brand": "siemens"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Lpro-48-16-2 Low Profile Rack Guard, 50.5 X 4 X 16 Inch Size",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Swr-24-6-48 Steel Wheel Riser, 48 Inch Length X 24 Inch Width X 6.25 Inch Height",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Winters Instruments Tim103alf. Thermometer Analog 0 - 160 Degree 3/4 Inch Npt",
"brand": "winters"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Yellow Jacket 42004 Manifold, 60 Inch Hose",
"brand": "yellow jacket"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:17,029 - INFO - Date: 2024-04-05, Records fetched: 8, Total so far: 8
2024-06-06 10:03:17,044 - INFO - Total records fetched for 2024-04-05: 8
2024-06-06 10:03:17,045 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-06'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:17,744 - INFO - Response: {
"results": [
{
"segments": {
"title": "Akro-mils 10164 Plastic Storage Cabinet, 64 Drawers",
"brand": "akro-mils"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Aquasol Welding Asw-60/r-31 Water Soluble Paper Roll, Width 31 Inch, Length 165 Feet",
"brand": "aquasol"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Jb Industries Dvo-12 Vacuum Pump Oil 1 Quart 15 Sae Grade",
"brand": "jb industries"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Krytox Gpl 225 Anti Corrosion Grease Syringe, 1 Oz.",
"brand": "krytox"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ramfan Ub20 Confined Space Fan 8 In 1/4 Hp 230v",
"brand": "ramfan"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Zurn Fd2-pv3-st-cc Pvc Adjustable Floor Drain, 5 Inch Nickel Bronze Head With Deck Plate",
"brand": "zurn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:17,744 - INFO - Date: 2024-04-06, Records fetched: 6, Total so far: 6
2024-06-06 10:03:17,754 - INFO - Total records fetched for 2024-04-06: 6
2024-06-06 10:03:17,757 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-07'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:19,180 - INFO - Response: {
"results": [
{
"segments": {
"title": "E James & Co 8501-1/4a Recycled Rubber 1/4 Inch Thick 12 X 12 In",
"brand": "e james & co"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Little Giant Pumps 554530 Condensate Pump, 115v, 1.5 Amp, Safety Switch",
"brand": "little giant pumps"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Otc Tools 5071 Pulley Remover/installer",
"brand": "otc"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Stanley Stht72179 Rivet Gun Toolkit Manual Steel",
"brand": "stanley"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:19,180 - INFO - Date: 2024-04-07, Records fetched: 4, Total so far: 4
2024-06-06 10:03:19,180 - INFO - Total records fetched for 2024-04-07: 4
2024-06-06 10:03:19,191 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-08'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:19,902 - INFO - Response: {}
2024-06-06 10:03:19,902 - INFO - Date: 2024-04-08, Records fetched: 0, Total so far: 0
2024-06-06 10:03:19,902 - INFO - Total records fetched for 2024-04-08: 0
2024-06-06 10:03:19,902 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-09'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:20,610 - INFO - Response: {
"results": [
{
"segments": {
"title": "Jessup Manufacturing Nst190 Stair Tread Black Aluminium 3-3/4 Inch Width",
"brand": "jessup manufacturing"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Kern And Sohn Ct 10000-3p1 Load Cell, 10000kg Max. Weighing, -35 To 65 Deg. C Ambient Temp. Range",
"brand": "kern and sohn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Low Height Hydraulic Cylinder, 22.1 Tons, 1.75 Inch Stroke",
"brand": "enerpac"
},
"metrics": {
"clicks": "4",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:20,610 - INFO - Date: 2024-04-09, Records fetched: 3, Total so far: 3
2024-06-06 10:03:20,610 - INFO - Total records fetched for 2024-04-09: 3
2024-06-06 10:03:20,623 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-10'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:21,337 - INFO - Response: {
"results": [
{
"segments": {
"title": "Chemglass Cg-1546-05 Erlenmeyer Flask, 50 Ml Labware Capacity - Metric, Type I Borosilicate Glass",
"brand": "chemglass"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Helicoil R1084-4 Free Running Helical Insert, M4 X 0.7 Thread Size, 12pk",
"brand": "helicoil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2696-26,2663-20,48-11-1850 Cordless Combination Kit, 18vdc Volt, 7 Tools, Impact Driver, Work Light",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:21,337 - INFO - Date: 2024-04-10, Records fetched: 3, Total so far: 3
2024-06-06 10:03:21,337 - INFO - Total records fetched for 2024-04-10: 3
2024-06-06 10:03:21,345 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-11'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:22,067 - INFO - Response: {
"results": [
{
"segments": {
"title": "3m 6119100 Cable Vertical System, Trailing, Auto, 100 Ft Lifeline Length",
"brand": "3m"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "4slt-1836-1.2k-95 Truck, 1200 Lb Load Capacity, Flat, Tread On Core Polyurethane",
"brand": "durham manufacturing"
},
"metrics": {
"clicks": "0",
"impressions": "86",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "80/20 65-2240-yel Storage Bins, 187.3 X 104.8 X 76.2 Mm Yellow",
"brand": "80/20"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "A.r. North America Mv925-w R North Meric Spray Gun, 6 Inch Length, 4500 Psi Max. Pressure, 8 Gpm Max. Flow",
"brand": "a.r. north america"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ability One 3920-00-nib-0001 Steel General Purpose Hand Truck, 600 Lb Load Capacity, 14 Inch X 7 Inch, Flat-free",
"brand": "ability one"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ability One 7930-01-373-8845 Cleaner, Citrus-based Solvent, Bucket, 5 Gallon Container Size, Concentrated",
"brand": "ability one"
},
"metrics": {
"clicks": "0",
"impressions": "60",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ability One 7930-01-373-8848 Cleaner, Citrus-based Solvent, Jug, 1 Gallon Container Size, Concentrated, 6 Pack",
"brand": "ability one"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Accurate Manufactured Products Group Z9409 Surface Plate Cleaner, 1 Gal Container Size, Liquid",
"brand": "accurate manufactured products group"
},
"metrics": {
"clicks": "0",
"impressions": "49",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Adam Equipment Lab 84e Analytical Balance, 80 G Capacity, 0.0001 G Scale Graduations",
"brand": "adam equipment"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Agri-fab 45-0533 Trailer Cart, 650 Lb Load Capacity - Hoppers And Cube Trucks, 10 Cu Ft Cubic Foot Capacity",
"brand": "agri-fab"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Agri-fab 45-0554 Cart, 250 Lb Load Capacity - Hoppers And Cube Trucks, Black/orange",
"brand": "agri-fab"
},
"metrics": {
"clicks": "0",
"impressions": "68",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Agri-fab 45-0579 Cart, 1000 Lb Load Capacity - Hoppers And Cube Trucks, Black/orange",
"brand": "agri-fab"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Air Systems International Wl033ns Flowmeter",
"brand": "air systems international"
},
"metrics": {
"clicks": "0",
"impressions": "63",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Akro-mils 77510grey Akro-tilt Truck, 66x33x42, Gray",
"brand": "akro-mils"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Allegro Safety 9937-wadf Air Flex Grinding, Air Flex Shield",
"brand": "allegro safety"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Alto Shaam Ce-28892 Cleaner",
"brand": "alto shaam"
},
"metrics": {
"clicks": "0",
"impressions": "38",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Amana Ptc073g35cxxx Packaged Terminal Air Conditioner, 7, 700 Btuh, 250 To 300 Sq Ft, 208/230vac, 6-20p",
"brand": "amana"
},
"metrics": {
"clicks": "0",
"impressions": "58",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Amana Ptc123g50cxxx Packaged Terminal Air Conditioner, 11, 500/11, 700 Btuh, 400 To 450 Sq Ft, 208/230vac",
"brand": "amana"
},
"metrics": {
"clicks": "0",
"impressions": "96",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "American Standard 2396202.020 Recess Bath With Luxury Ledge Above Floor Rough Installation, Left Drain Location",
"brand": "american standard"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "American Standard 9504999.020 Service Sink, Clinic, Floor Mount, White",
"brand": "american standard"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "American Standard M922887-0020a Aerated Outlet, American Std, 15/16 Inch Thread Size, 1.5 Gpm Flow Rate",
"brand": "american standard"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ampco Metal M-2fg Non-sparking Mallet, Fiberglass Handle, 4 Lb Head Weight, 2 Inch Dia, 4 Inch Head Length",
"brand": "ampco metal"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ams 209.33 Soil Auger Kit, 2-1/4 Inch Dia., 4 Ft. Length",
"brand": "ams"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ams 209.36 Soil Auger Kit, 3-1/4 Inch Dia., 4 Ft. Length",
"brand": "ams"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Apw Wyott 2e-1305610 Switch, Lighted Red",
"brand": "apw wyott"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Apw Wyott 2e-1342500 Pressure Switch",
"brand": "apw wyott"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Apw Wyott 56440 Warming Pan With Drain",
"brand": "apw wyott"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Apw Wyott Cw-2ai Cooker/warmer, 22 Qt Capacity, 1, 200 W Watt, 10 5/8 Inch Overall Ht",
"brand": "apw wyott"
},
"metrics": {
"clicks": "0",
"impressions": "49",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Apw Wyott W-3vi Countertop Warmer, 22 Qt Capacity, 1, 200 W Watt, 9 3/4 Inch Overall Ht",
"brand": "apw wyott"
},
"metrics": {
"clicks": "0",
"impressions": "64",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Argos Technologies Ev601 Bottle",
"brand": "argos technologies"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Armstrong World Industries 763d Ceiling Tile, 763d, 24 Inch X 48 Inch Size Lay-in, 15/16 Inch Grid Size, 0.55 Nrc, 12 Pack",
"brand": "armstrong world industries"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Armstrong World Industries 817025-001 Circulating Pump Motor, Armstrong/bell And Gossett, 817025-001, 1/6 Hp, Single Phase",
"brand": "armstrong world industries"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Arrow Fastener Clg65bg Shed, 76.3 Inch X 59.5 Inch X 72.9 Inch Size, 153 Cu Ft Capacity, Blue Gray",
"brand": "arrow fastener"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Arrow Fastener Clg65sg Shed, 76.3 Inch X 59.5 Inch X 72.9 Inch Size, 153 Cu Ft Capacity, Sage Green",
"brand": "arrow fastener"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Arrow Fastener Clp64sg Shed, 76.5 Inch X 47 Inch X 70.8 Inch Size, 118 Cu Ft Capacity, Sage Green",
"brand": "arrow fastener"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Arrow Fastener Ys47-a Shed, 49 Inch X 79.8 Inch X 82 Inch Size, 154 Cu Ft Capacity, Eggshell",
"brand": "arrow fastener"
},
"metrics": {
"clicks": "0",
"impressions": "76",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Arrow Mixing Products Ase-750c Stand And Clamp, 28 Inch Size Lg, Ase-750c",
"brand": "arrow mixing products"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Atrix International Vacbpai400 Backpack Aviation Hepa Vacuum, 106 Cfm Vacuum Air Flow, 10.3 Lb Wt, 72 Db Sound Level",
"brand": "atrix international"
},
"metrics": {
"clicks": "0",
"impressions": "36",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Avon Protection Systems 70501-162 Front Module Cover, 5 Pk",
"brand": "avon protection systems"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "B & P Manufacturing 2002-e1e Stairclimber, Ergo",
"brand": "b & p manufacturing"
},
"metrics": {
"clicks": "0",
"impressions": "56",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "B & P Manufacturing 2006-108 Disc Rake Wheel Assembly",
"brand": "b & p manufacturing"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "B & P Manufacturing B70-c6-d5 Convertible Hand Truck",
"brand": "b & p manufacturing"
},
"metrics": {
"clicks": "0",
"impressions": "43",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ballymore Tl418p Folding Rolling Ladder, 40 Inch Platform Height, 10 Inch Platform Depth",
"brand": "ballymore"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Barska Ax11780 Gun Safe, 139 Lb Net Wt, 9.4 Cu Ft Capacity, Biometric/key Lock, 57 Inch Outside Height",
"brand": "barska"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Barska Ax12880 Wall Safe, Beige, 48 Lb Net Wt, 0.82 Cu Ft Capacity, 0, 4 Inch Size Outside Height",
"brand": "barska"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bayhead 1/3 Cu-l Tilt Truck, 8.1 Cu Ft Cubic Foot Capacity",
"brand": "bayhead"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bea 10bollardbrz Bollard, Surface Mount, Plastic, Bronze",
"brand": "bea"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Berkel 01-403175-00945 Overlay",
"brand": "berkel"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Big Beam N71f Replacement Battery, Nickel Cadmium, 7.2 V Volt, 600 Mah Battery Capacity",
"brand": "big beam"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Binks 29-866 Construction Film, Light Duty, 3 Mil Thick, 300 Ft Lg, 6 Ft Width, White, Nfpa 33/osha",
"brand": "binks"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bio Ex F05.05.0515 Firefighting Foam, Ecopol A, Airport Fire Protection, 5 Gal Container Size, Pail",
"brand": "bio ex"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bio Ex F05.10.0015 Firefighting Foam, Ecopol F, Class A Wildfires, 5 Gal Container Size, Pail",
"brand": "bio ex"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Black & Decker Lgc120b Max Liion Cultivator/tiller, 20v",
"brand": "black & decker"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5527-1-30 Elasto-kool 700 4.75-gallon White Elastomeric Reflective Roof Coating, Acrylic Polymer",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5576-1-30 White Silicone Reflective Roof Coating, Silicone Roof Coatings, Silicone/rubber, White",
"brand": "black jack"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 6453-9-30 Drive-maxx 700 4.75-gallon Asphalt Sealer, 5 Gal Container Size, Pail",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bn Products Usa Bn7356 Hydraulic Oil, Petroleum, 1 Qt, Jug, Iso Viscosity Grade 68",
"brand": "bn products usa"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bn Products Usa Bnms-sb Portable Mixing Station",
"brand": "bn products usa"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bodine Eli-s-100 Emergency Lighting Inverter, 120/277vac, 100 W",
"brand": "bodine"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bodine Eli-s-250 Cec Emergency Lighting Inverter, 120/277vac, 250 W",
"brand": "bodine"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bodyfilter 4028-l Hooded Disposable Coveralls, Laminated Nonwoven, Serged Seam, White, L, 25 Pk",
"brand": "bodyfilter"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch 2609199281 Motor",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "39",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch 2609199298 Gearbox, Ps30",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch 2609199548 Motor",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Gbh18v-26dk24 + Gds18v-221n Cordless Tool Combination Kit, 18v Volt, 2 Tools, 2 In. Rotary Hammer",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Gks18v-25gcb14/gba18v80 Circular Saw Kit, 7 1/4 Inch Blade Dia, Righeight, 2 1/2 Inch",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Gll 30 Cross Line Laser, 2 Beams, 0 Dots, 2 Lines, Red, 30 Ft Range W/o Detector",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "51",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Glm165-27c Laser Distance Meter, 165 Ft Max Measuring Distance, \u00b11/16 In, Aa, Indoor",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Grl2000-40hk Rotary Laser, 1 Beams, 0 Lines, Red, 100 Ft Range Without Detector",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Brady M210 Portable Printer, No Wireless Connectivity, 3/4 Inch Size, 203 Dpi Printhead Resolution",
"brand": "brady"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Brady M211-power Battery, Rechargeable Battery Pack, M211, Li-ion",
"brand": "brady"
},
"metrics": {
"clicks": "0",
"impressions": "49",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Broan Nutone 97017063 Heater Assembly, Hfl695",
"brand": "broan nutone"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Broan Nutone 98005586 Bird Screen",
"brand": "broan nutone"
},
"metrics": {
"clicks": "0",
"impressions": "38",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Buyers Products Smc50a Hydraulic Reservoir Kit, 50 Gal..lon",
"brand": "buyers products"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Buyers Products Smr25s Hydraulic Reservoir, 25 Gal, Temp Sight",
"brand": "buyers products"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bw Technologies Mcxl-fc1 Replacement Cover",
"brand": "bw technologies"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cadco Ov-003 Convection Oven, Quarter Size Oven Size, 3 Shelves, Wire Shelves, 1, 450 W Watt",
"brand": "cadco"
},
"metrics": {
"clicks": "0",
"impressions": "55",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cadet Cgw Com-pak Grill, White",
"brand": "cadet"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Caldwell 419-2-4 Fixed Spread Lifting Beam, 4000 Lb Working Load Limit, 48 Inch Max. Spread",
"brand": "caldwell"
},
"metrics": {
"clicks": "0",
"impressions": "77",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Caldwell 430-.25-3 Fixed Spread Lifting Beam, 500 Lb Working Load Limit, 36 Inch Max. Spread",
"brand": "caldwell"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Caldwell 430-1-6 Fixed Spread Lifting Beam, 2000 Lb Working Load Limit, 72 Inch Max. Spread",
"brand": "caldwell"
},
"metrics": {
"clicks": "0",
"impressions": "85",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Caldwell Rl-3 Reel Lifter, 6000 Lb Load Capacity, 3 Inch Arbor Hole Min, 5 Inch Arbor Hole Max",
"brand": "caldwell"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cambro Manufacturing Ca182612cw135 Food Box, 68 Qt Capacity, 18 Inch Overall Length, 26 Inch Overall Width, Clear",
"brand": "cambro manufacturing"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cambro Manufacturing Eaics125l131 Ice Caddy, 125.7 Lb Capacity, Top Sliding, Brown",
"brand": "cambro manufacturing"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Canarm P16-1vhe Panel Fan, Direct Drive, 16 Inch Size Blade, 1/15 Hp, 1, 850 Cfm, 115vac, 1 Ph",
"brand": "canarm"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Carrier Hk06wc070 Pressure Switch, Spdt",
"brand": "carrier"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91274 Safety Footwear, Electrical Hazard, M, 14 Size, 1 Pair",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Celltreat 229692 Petri Dish, 300 Pack",
"brand": "celltreat"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cellucap 5740xxxx Collared Disposable Coverall, Polypropylene, Heavy Duty, Serged Seam, White, Cellucap",
"brand": "cellucap"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Century 9433a Model Em Soil Test Kit, 4.0 To 8.0 Ph",
"brand": "century"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Champion Power Equipment 100379 Front Tine Tiller, 22 Inch, Gas Powered, 13 4/5 Inch Length Of Tines, 212cc",
"brand": "champion power equipment"
},
"metrics": {
"clicks": "0",
"impressions": "71",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Chemglass Cg-1512-09 Recovery Flask, 1000 Ml Labware Capacity To Metric, Type I Borosilicate Glass, Distilling",
"brand": "chemglass"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Chemglass Cg-1546-05 Erlenmeyer Flask, 50 Ml Labware Capacity - Metric, Type I Borosilicate Glass",
"brand": "chemglass"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Chemglass Cg-1546-07 Erlenmeyer Flask, 125 Ml Labware Capacity - Metric, Type I Borosilicate Glass, 50 To 125ml",
"brand": "chemglass"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 4hz61 Motor Psc 1/2 Hp 1100 115/230v 48y Oao",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 5wxr9 Pump Centrifugal Stainless Steel 1/3 Hp 1 Ph",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dewalt Dck206p1/dcb205 Combo Kit, 18vdc/20v Volt, 2 Tools, Impact Wrench, 20v",
"brand": "dewalt"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Extech Wth600-kit Wireless Weather Station, Extech Wth Weather Station, 2 Pieces, Lcd, 450 Ft Range",
"brand": "extech"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Fairbanks Mhs-111-8pn Hand Truck Capacity 500 Lb Continous Handle",
"brand": "fairbanks"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 1253-150 Vernier Height Gauge, 0 Inch To 6 In/0 Mm To 150 Mm Range, +/-0.0012 Inch Accuracy, Steel",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kimble Chase 26650-125 Erlenmeyer Flask 125ml Wide Mouth Pk48",
"brand": "kimble chase"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kimble Chase 26650-250 Erlenmeyer Flask 250ml Wide Mouth Pk48",
"brand": "kimble chase"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2691-22, 2621-20 Tool Combo Kit, 18v Dc Volt, 3 Tools, 1/2 Inch Drill Compact, 1800 Rpm, Contractors Bag",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2980-22, 2719-20 Grinder Kit, 18 Vdc Volt, 2 Tools, Angle Grinder/reciprocating Saw",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee Valve 2885-m 4 Gate Valve Class 125 4 Inch Cast Iron",
"brand": "milwaukee valve"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4057-55 Lubricant Additive, Liquid, 4 Oz",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:22,067 - INFO - Date: 2024-04-11, Records fetched: 106, Total so far: 106
2024-06-06 10:03:22,076 - INFO - Total records fetched for 2024-04-11: 106
2024-06-06 10:03:22,076 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-12'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:22,767 - INFO - Response: {
"results": [
{
"segments": {
"title": "Ability One 3920-00-nib-0001 Steel General Purpose Hand Truck, 600 Lb Load Capacity, 14 Inch X 7 Inch, Flat-free",
"brand": "ability one"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Amana Ptc073g35cxxx Packaged Terminal Air Conditioner, 7, 700 Btuh, 250 To 300 Sq Ft, 208/230vac, 6-20p",
"brand": "amana"
},
"metrics": {
"clicks": "0",
"impressions": "46",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "American Standard 2395202.020 Recess Bath With Luxury Ledge, Right Drain Location, American Std, Princeton",
"brand": "american standard"
},
"metrics": {
"clicks": "0",
"impressions": "38",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Archon Industries Akgf030-c19a000 Single Wall Sight Flow Indicator, 3 Inch Pipe Size, Flange, 3 1/2 Inch Sight Length",
"brand": "archon industries"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Arrow Fastener Ys47-a Shed, 49 Inch X 79.8 Inch X 82 Inch Size, 154 Cu Ft Capacity, Eggshell",
"brand": "arrow fastener"
},
"metrics": {
"clicks": "0",
"impressions": "50",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 6455-9-30 Drive-maxx 1000 4.75-gallon Asphalt Sealer, 5 Gal Container Size, Pail",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Broan Nutone 98005586 Bird Screen",
"brand": "broan nutone"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cadco Ov-003 Convection Oven, Quarter Size Oven Size, 3 Shelves, Wire Shelves, 1, 450 W Watt",
"brand": "cadco"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P89162 Work Boot, W, 126 Inch Widthork Boot Footwear, Men's, Wheat, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P90935 Work Boot, M, 86 Inch Widthork Boot Footwear, Men's, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Corbin K437 Combination Padlock, Long Shackle",
"brand": "corbin"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Council Tool 38pe136 Pulaski Axe, Pulaski Axe, Pulaski, Wood, 3 Ft Length",
"brand": "council tool"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Goodman Gm9s800804bx Upflow/horizontal Furnace, 80000 Btuh Heating Capacity Input, 1, 600 Cfm",
"brand": "goodman"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Pac Strapping Products 2cxk3 Strapping Polyester Smooth 7200 Feet Length",
"brand": "pac strapping products"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Renewable Lubricants 84104 Bio Vacuum Pump Oil, Pail 5 Gallon Capacity",
"brand": "renewable lubricants"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Single-Acting, Low-Height Hydraulic Cylinder, 30 Tons",
"brand": "enerpac"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:22,767 - INFO - Date: 2024-04-12, Records fetched: 16, Total so far: 16
2024-06-06 10:03:22,767 - INFO - Total records fetched for 2024-04-12: 16
2024-06-06 10:03:22,777 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-13'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:23,486 - INFO - Response: {
"results": [
{
"segments": {
"title": "Bea 10box45rndsm Round Mount Box, Surface Mount, Plastic",
"brand": "bea"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Beck Products 0331249409 Pipe, Galvanized Steel, 3 Inch Nominal Pipe Size, 16 Inch Overall Length",
"brand": "beck products"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91274 Safety Footwear, Electrical Hazard, W, 7 Size, 1 Pair",
"brand": "cat"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dewalt Dfd270mk Powder Actuated Gun, 2 7/8 Inch Max. P Inch Length With Washer",
"brand": "dewalt"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Electrolux 240561502 Shelf Trim",
"brand": "electrolux"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Electrolux 241503901 Hose Connector",
"brand": "electrolux"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Greenlee 150q Wire Pulling Grip, 1/4 X 1/2 Inch Size, 100 Lbs. Pulling Force",
"brand": "greenlee"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Hi-tech Duravent 2035-0500-2050 Industrial Ducting Hose, 5 Inch Hose Inside Dia, 10 Psi",
"brand": "hi-tech duravent"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Hobart 500573 Welder, Handler 125, Mig Pack",
"brand": "hobart"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Tempco Csf00500 Heater 120v 10-1/2 Inch Length 1200 Degree F",
"brand": "tempco"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Rol-95 Galvanised Nestable Roller Container, 26.375 Inch X 59 Inch Size",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:23,487 - INFO - Date: 2024-04-13, Records fetched: 11, Total so far: 11
2024-06-06 10:03:23,487 - INFO - Total records fetched for 2024-04-13: 11
2024-06-06 10:03:23,494 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-14'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:24,310 - INFO - Response: {
"results": [
{
"segments": {
"title": "40-s-30-u Water Heater Stand, Floor Mount, 100 Gal Max. Tank Capacity, 1200 Lb Max. Weight Capacity",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ability One 7930-01-373-8845 Cleaner, Citrus-based Solvent, Bucket, 5 Gallon Container Size, Concentrated",
"brand": "ability one"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "American Louver Alummil2448-5pk Return Air Grilles, Egg Crate Grille, Silver, Mill, Aluminum, 47 3/4 Inch Height",
"brand": "american louver"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Apw Wyott 2a-85037 Gear, Motor 16 Tooth, 1/2 Bore",
"brand": "apw wyott"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Cm8s Miter Saw, Sliding, 12 Inch Max. Cut Wd At 0 Deg. Miter, 52 Deg. Left To 60 Deg. Right",
"brand": "bosch"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Carrier 48ss660006 Heat Exchanger, 48ss-024060320",
"brand": "carrier"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Eagle 1656mb Poly Drum Open Head 55 Gallon Height 36-3/8 In",
"brand": "eagle"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Eptd24485pu95 Steel-deck Platform Truck, 1400 Lb Load Capacity, 48 Inch X 24 Inch X 7-3/4 Inch",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "General Electric Ab49b Panelboard Enclosure, 42 Spaces, 225 A Amps, 49.5 Inch Length, 32fv48/32fv69, 1",
"brand": "general electric"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 03-550-h Traffic Cone Sign, Plastic, 10 1/2 Inch Height, Blue/white, Handicap",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 06q051n04114 Reduced Port 3-way Ball Valve T Port, 1 1/4 Inch Pipe, 1 1/4 Inch Tube, Full",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 1/3cu-l Black General Purpose Plastic Tilt Truck, 9 Cu Ft Cubic Foot Capacity, Black",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 10611_8_8 Aluminum Sheet, T6, 8 Inch Overall Length, 150 Brinell Hardness",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 12629_48_48 Grade 2 Titanium Sheet, 4 Ft Overall Length, 4 Ft Overall Width, 0.05 Inch Thick",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 24188s100-trd3 Bar Grating Stair Tread, Stainless Steel, 1.19 Inch Bearing Bar Spacing",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 31ng36 Lock Box, Surface, Push Button, 2 Key Capacity, Zinc Alloy, Silver",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 3vu62 Water Heater Stand, Floor Mount, 50 Gal Max. Tank Cap, 21 Inch Length, 21 Inch Width",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "45",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 40-s-22-u Water Heater Stand, Floor Mount, 52 Gal Max. Tank Cap, 650 Lb Max. Wt Cap",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 45mz89 Push Button Lockout",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 4nze6 Packing Peanuts, 20 Cu Ft Bag Size, White, S-shaped, 49 Inch Size Bag Height",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 5101-24-00 Extra Flex Flexible Metal Conduit, 3/8 Inch Trade Size, 50 Ft Overall Length, Steel",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 56jz89 Disposable Respirators, Dual, Non-adj, Metal Nose Clip, Std, White, 40 Pk",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 56la10 Mailer Envelopes, 11 Inch Size X 15 In, 10 1/2 Inch Size X 14 3/4 In, #5, 50 Pk",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 56lv36 Sneeze Guard, 36 1/8 Inch Height, 3 Inch Thickness, 24 1/4 Inch Width",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 7475-5 Post-removal Surface Sealant",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Bulk-ijmp-9 Plastic Pellets, Off-white, 5 Lb Container Size, Bag, 140 Deg F Max Temp",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Bulk-ps-pe-109 Rectangle Stock, 0.75 Inch Thick, 1 Inch Width X 48 Inch L, White, Opaque",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Bulk-rs-v75-408 Viton Sheet, 36 Inch X 6 Ft, 0.125 Inch Thickness, 75a, Plain Backing, Black, Smooth",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Cvl-sms-e-med Collared Disposable Coverall, Sms, Serged Seam, White, Elastic Cuff, Elastic Ankle, Sms",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger E-tug-mm Electric Powered Tugger Multi Mover, 30 1/2 Inch Overall Ht, 9 3/4 Inch Overall Wd",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Hammertone 304#4-22gx24x24 Silver Stainless Steel Sheet, 24 Inch X 24 Inch Size, 0.028 Inch Thicktextured Finish, #4",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Hs-hduf Gas Welding Outfit, Acetylene, Acetylene, Cga 510",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Peco 1075 Folding Gate, Double, Gray, Powder Coated, 8 To 10 Ft Opening Width, 7 Ft Folded Wide",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "36",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Peco 1265 Folding Gate, Double, Gray, Powder Coated, 10 To 12 Ft Opening Width, 11 Inch Folded Wide",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Peco 1475 Folding Gate, Double, Gray, Powder Coated, 12 To 14 Ft Opening Width, 7 Ft Folded Wide",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Sl127bwh2x001200 Hooded Disposable Coveralls, Saranex 23-p Film Laminated Tyvek, Bound Seam, White, 12 Pk",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Ti350 Medium/heavy Duty Portable Welding/cutting/brazing Outfit, Acetylene, Cga 200",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "52",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Tt4xma6tcg Top Cover",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Ttytl3154529g Pneumatic Tire, Pneumatic Tire, 10f633",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Xleco 1265 Folding Gate, Portable Double, Gray, Powder Coated, 1 To 12 Ft Opening Wide",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Zusansr-453 Neoprene Sheet, 36 X 12 Inch Size, 3/8 Inch Thick, Black, Closed Cell, 1-sided Adhesive",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Graphic Controls Clh Hksv0070s239 Circular Paper Chart, 10 Inch Chart Dia, 0 To 35, 100 Pack",
"brand": "graphic controls"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Graphic Controls La125452 Chart Recorder Pen, Red, Eurotherm Chessel Recorders, 3 Pack",
"brand": "graphic controls"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Graymills Imv25-f Machine Tool Pump, 1/4 Hp, 230/460v Ac, 500 Sus Max Visc, 20 Gpm Max Flow, Npt Connection",
"brand": "graymills"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grindmaster Cecilware Corp Gml539al Relay",
"brand": "grindmaster cecilware corp"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hardline Products Gblkki200 Letter And Number Labels, 3 Inch Character Height, Black, Vinyl, Die Cut",
"brand": "hardline products"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Harris Industries Ssbf60 Soldering Flux, 960 Oz, Tin Pail",
"brand": "harris industries"
},
"metrics": {
"clicks": "0",
"impressions": "59",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Harris Industries Sswf25 Soldering Flux, 400 Oz, Tin Pail",
"brand": "harris industries"
},
"metrics": {
"clicks": "0",
"impressions": "46",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Harting 09120052733 Industrial Rectangular Connector Insert, Q, Spring-clamp, Female, 16 A Current Rating",
"brand": "harting"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Heil Quaker 1070639 Blower Assembly, Less Motor",
"brand": "heil quaker"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hessaire 36dl750ts Cabinet Exhaust Fan With Shutter, Direct Drive, 36 Inch Blade, 1 Hp, 12, 811 Cfm, 3 Ph",
"brand": "hessaire"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hessaire Mc18v Portable Evaporative Cooler, 12 Inch Blade Dia, 500 Sq Ft, 1300 Cfm",
"brand": "hessaire"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hi-tech Duravent 2002-0800-1725 Industrial Duct Hose",
"brand": "hi-tech duravent"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hobart 00-103881-00047 Lubricant, Container Assembly, A200",
"brand": "hobart"
},
"metrics": {
"clicks": "0",
"impressions": "46",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hobart 500573 Welder, Handler 125, Mig Pack",
"brand": "hobart"
},
"metrics": {
"clicks": "0",
"impressions": "46",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hobart S119851-g35 Stick Electrode, Carbon Steel, E7018 H8, 5/32 Inch X 14 Inch, 50 Lb",
"brand": "hobart"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hobart S526806-g25 Welding Wire, Stainless Steel, Er308si/308lsi, 0.03 Inch, 30 Lb",
"brand": "hobart"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell 320005130000 Saline Refill, 180 Oz Cap",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell 5205 Security Safe, Compact And Portable, Combo/override Key Lock, 8 19/64 Inch Outside Height",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell Df300n95b Disposable Flatfold Respirator, Dual, Non-adj, Molded Nose Bridge, 50 Pk",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell Df300n95bx Disposable Flatfold Respirator, Dual, Non-adj, Metal Nose Clip, 20 Pk",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell Sgs18/30ft Miller System 30 Ft For 2 Workers, Reusable, Steel, Bolt-on, Steel",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "43",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell V8043e1020 Motorized Zone Valve, Sweat 1",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hubbell Lubt2 Conduit, Thread Lubricant Lubt2",
"brand": "hubbell"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hunter 76031 Commercial Ceiling Fan, 60 Inch Blade Dia, 8 Speeds, 7, 493 Cfm, 240 Vac, 21 Ft, 1 Phase",
"brand": "hunter"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Hunter 76042 Commercial Ceiling Fan, 60 Inch Blade Dia, 8 Speeds, 7, 493 Cfm, 240 Vac, 21 Ft, 1 Phase",
"brand": "hunter"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Pac Strapping Products 68h.10.2145 Strapping Polypropylene 4500 Feet Length",
"brand": "pac strapping products"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:24,310 - INFO - Date: 2024-04-14, Records fetched: 67, Total so far: 67
2024-06-06 10:03:24,310 - INFO - Total records fetched for 2024-04-14: 67
2024-06-06 10:03:24,310 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-15'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:25,426 - INFO - Response: {
"results": [
{
"segments": {
"title": "Ability One 7930-01-373-8845 Cleaner, Citrus-based Solvent, Bucket, 5 Gallon Container Size, Concentrated",
"brand": "ability one"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Accuform Signs Pst318 Safety Poster 24 X 18 Inch Flex Plastic Eng",
"brand": "accuform signs"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Adam Equipment Ebl 12001e Precision Balance Scale 12000g Metal",
"brand": "adam equipment"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Anvil 0560501124 Pipe Roll Cast Iron, 6 Inch Size",
"brand": "anvil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Atrix International Vacochg Charger",
"brand": "atrix international"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Big Ass Fans F-ae1-3001l13s34v56 Standard-duty Industrial Fan, Std-duty Industrial Fan, 30 Inch Size Blade Dia, 120 Vac",
"brand": "big ass fans"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Chicago-latrobe 53660 Reduced Shank Drill Bit, 15/16 Inch Drill Bit Size, 6 Inch Overall Length",
"brand": "chicago-latrobe"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dewalt Dwa1189 Jobber Length Drill Set, 1/16 Inch Smallest Drill Bit Size",
"brand": "dewalt"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Elkay Vrc8s Water Cooler Vandal Resistant 20 7/16h",
"brand": "elkay"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Elkhart Brass B-98-a Ball Valve (2) 2-1/2 Inch Fnst 2-1/2 Fnst",
"brand": "elkhart brass"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Gleason W5s-060902 Jib Crane",
"brand": "gleason"
},
"metrics": {
"clicks": "0",
"impressions": "38",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 17687_36_0 Stainless Steel Flat Bar, 303, 0.1875 Inch Thick, 1/2 Inch X 36 Inch Size, Cold Finished",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 18043_6_0 Aluminum Rod 6061, 1 3/4 Inch Outside Dia, 6 Inch Overall Length",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Bulk-rs-e60fr-32 Epdm Roll, Flame-resistant, 36 Inch X 40 Ft, 60a",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Fs-201ss Pg 36.00 Strut Channel, Slotted Back-to-back, Steel, Pre-galvanized, 3 Ft Overall Length, Silver",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger P-dl21-16 Caster Directional-lock Kit, Steel, Directional Lock, Directional Lock",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Zusavb75455 O-ring, 455, 13 Inch Inside Dia, 13 1/2 Inch Outside Dia, 75 Shore A, Brown",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Honeywell Th1110dh1003 Thermostat Low Voltage Non Programmable",
"brand": "honeywell"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kern And Sohn Ozb-a4804 Halogen Bulb, 12v, 10w",
"brand": "kern and sohn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Low Height Hydraulic Cylinder, 22.1 Tons, 1.75 Inch Stroke",
"brand": "enerpac"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee Valve 2882-m 4\" Gate Valve Class 125 4 Inch",
"brand": "milwaukee valve"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Pac Strapping Products 28m.20.2218 Strapping 18000 Feet Length Polypropylene",
"brand": "pac strapping products"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Proto J86b Cold Chisel Set, S2 Steel, 1-piece Design, Tool Roll Pouch - 7 Pc",
"brand": "proto"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:25,427 - INFO - Date: 2024-04-15, Records fetched: 23, Total so far: 23
2024-06-06 10:03:25,427 - INFO - Total records fetched for 2024-04-15: 23
2024-06-06 10:03:25,435 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-16'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:26,152 - INFO - Response: {
"results": [
{
"segments": {
"title": "Advance Products & Systems Pe10150 Flange Spray Shield L 53-1/4 Inch",
"brand": "advance products & systems"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Allied Tube & Conduit 583211 Emt Conduit - Standard, Steel, Galvanized, 1 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Aquasol Welding Ezp-16 Pre-formed Purge Dam, Diameter 16 Inch",
"brand": "aquasol welding"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5527-1-30 Elasto-kool 700 4.75-gallon White Elastomeric Reflective Roof Coating, Acrylic Polymer",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Brady 150852 Floor Marking Applicator, 3 Inch Max Tape Core Size, 3 Inch Min Tape Core Size",
"brand": "brady"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Council Tool 180pp Pinch Point Crowbar Steel 1-1/4 X 60 In",
"brand": "council tool"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Davis Instruments 6152 Wireless Weather Station, Vantage, Lcd Transflective, 1000 Ft Range",
"brand": "davis instruments"
},
"metrics": {
"clicks": "0",
"impressions": "36",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 11g236 Engine Driven Semi-trash Pump 7.1 Hp",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Extech Wth600-kit Wireless Weather Station, Extech Wth Weather Station, 2 Pieces, Lcd, 450 Ft Range",
"brand": "extech"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ge Lighting Hr400dx33 Mercury Vapor Lamp Ed37 400w",
"brand": "ge lighting"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Goodman Gsxn402410 Air Conditioner Condensing Unit, 2 T, R-410a, 3/4 Inch Suction Line Size",
"brand": "goodman"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 2956-00008 Expandable Barricade, 132 Inch Overall Lg, 37 Inch Overall Ht, Black/yellow",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Vap6000lmfstmdmvoltgz1050k80cri Led Parking Garage Light 4822 Lm 5000k",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Zoeller D293 Submersible Sewage Pump 1hp 230v 50 Feet",
"brand": "zoeller"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Zurn Q4pc300x Pex Tubing White 3/4in 300ft 100psi",
"brand": "zurn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:26,152 - INFO - Date: 2024-04-16, Records fetched: 15, Total so far: 15
2024-06-06 10:03:26,160 - INFO - Total records fetched for 2024-04-16: 15
2024-06-06 10:03:26,168 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-17'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:26,967 - INFO - Response: {
"results": [
{
"segments": {
"title": "Allegro 9404-04 Sludge Dewatering Pump",
"brand": "allegro safety"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91350 Athletic Work Shoe, Better Slip-resist/composite Toe/electrical Hazard /non-metallic",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Continental Pth075-10ce-g Petroleum Transfer Hose, 3/4 Inch Heightose Inside Dia, 10 Ft Hose Length",
"brand": "continental"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Danfoss 018f7663 Coil, 120v, 60 Hz, 14w",
"brand": "danfoss"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Davis Instruments 6152 Wireless Weather Station, Vantage, Lcd Transflective, 1000 Ft Range",
"brand": "davis instruments"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "E James & Co 4050-1/4btape Rubber Buna-nitrile 1/4 Inch Thick 12 X 24 Inch",
"brand": "e james & co"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Flexaust Co Inc 3641020050 Industrial Duct Hose, 2 Inch Size Hose Id, 50 Ft Hose Length, 50 Psi",
"brand": "flexaust co inc"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Gleason W5s-060902 Jib Crane",
"brand": "gleason"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Goodman Gsxn402410 Air Conditioner Condensing Unit, 2 T, R-410a, 3/4 Inch Suction Line Size",
"brand": "goodman"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 5pgt1 Bogus Paper, 50 Lb Basis Wt, 30 Inch Roll Width, 720 Ft Roll Length",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 5rlj5 90 Deg. Elbow, Carbon Steel, 1 Inch X 1 Inch Fitting Pipe Size, 2 Pk",
"brand": "grainger"
},
"metrics": {
"clicks": "3",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marson Hp-2 Riveter Deluxe, 3/32-1/8 5/32-3/16, Inch Size",
"brand": "marson"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Zoeller Wd295 Submersible Sewage Pump 2hp 230v 39 Feet",
"brand": "zoeller"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:26,967 - INFO - Date: 2024-04-17, Records fetched: 13, Total so far: 13
2024-06-06 10:03:26,975 - INFO - Total records fetched for 2024-04-17: 13
2024-06-06 10:03:26,977 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-18'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:27,688 - INFO - Response: {
"results": [
{
"segments": {
"title": "Allied Tube & Conduit 583195 Emt Conduit - Standard, Steel, Galvanized, 1/2 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Amana Pth153g50cxxx Packaged Terminal Heat Pump, 14, 500 Btuh, 550 To 700 Sq Ft, 208/230vac, 6-30p",
"brand": "amana"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 11g236 Engine Driven Semi-trash Pump 7.1 Hp",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Edge 48-706vp Cut Resistant Glove, Vndpk, 10, Greyhppe, Pr",
"brand": "edge"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Gardner 7345-ga Pro Flashing Asphalt Roof Coating Cement, Asphalt Roof Coatings, Asphalt, Reflective",
"brand": "gardner"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Gleason W5s-060902 Jib Crane",
"brand": "gleason"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 06q021n06020 Full Port Ball Valve, 2 Inch Pipe, 2 Inch Tube, 2000 Psi, 32 Deg To 320 Deg F",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 310-010-000 Pipe Flange, Carbon Steel, Slip-on Flange, 1 Inch Size Pipe Size, Class 300",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Bw2ybk200-200 Barrier Tape, Yellow/black, 2 Inch Roll Width, 200 Ft Roll Length, Polyethylene",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ham-let 764l Ss 3/8 Union Tee Stainless Steel 3/8 Inch Unions",
"brand": "ham-let"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ps Doors Ezd-600-052036 Flood Barrier , 52 Inch X 36 Inch Size, 28 Pounds Capacity, Almunium",
"brand": "ps doors"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Southwire Company 11598005 Building Wire, 10 Awg Wire Size, 1 Conductors, 2, 500 Ft Length, Solid, Nylon, Pvc",
"brand": "southwire company"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D 8903sqg11v02 Light Contactor Mech 120v 100a Nema1 3p",
"brand": "square d"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Super-strut Ap 232sq Eg Strut Post Base Square 6 Length X 6 W In",
"brand": "super-strut"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Zurn Ag-5 Wilkins Air Gap Fitting, Npt Connection, Cast Iron",
"brand": "zurn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:27,690 - INFO - Date: 2024-04-18, Records fetched: 15, Total so far: 15
2024-06-06 10:03:27,691 - INFO - Total records fetched for 2024-04-18: 15
2024-06-06 10:03:27,691 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-19'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:28,506 - INFO - Response: {
"results": [
{
"segments": {
"title": "Allied Tube & Conduit 583195 Emt Conduit - Standard, Steel, Galvanized, 1/2 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Armstrong World Industries 7800rwh Wall Molding, 144 Inch Overall Length, 7/8 Inch Overall Height",
"brand": "armstrong world industries"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Ra1171 Cabinet Style Table, 15 1/2 Inch Table Length, 25 Inch Table Width, 35 Lb Wt",
"brand": "bosch"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P89703 Work Boots, M, 7 1/2, Oxford Shoe Footwear, Men's, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cotterman 5tr26a6e10b8d3c2p6 Tilt And Roll Ladder, 50 Inch Platform Height, 10 Inch Platform Dp, 24 Inch Platform Width",
"brand": "cotterman"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Danfoss Mtz36-3vi Compressor, 230v, 3-phase",
"brand": "danfoss"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton Ve10e048pg Propeller, 24 Inch Propeller Dia, 5/8 Inch Bore Dia, 31.5 Deg. Pitch, 3 Blades, Intake",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dwyer Instruments 16b-33 Temp Process Controller",
"brand": "dwyer instruments"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Extech Wth600-kit Wireless Weather Station, Extech Wth Weather Station, 2 Pieces, Lcd, 450 Ft Range",
"brand": "extech"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Fibergrate 873320 Stair Tread Isofr 1 1/2x10 1/2 Inch 2 1/2 Feet",
"brand": "fibergrate"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Gleason W5s-060902 Jib Crane",
"brand": "gleason"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 542_36_0 Stainless Steel Square Tube 304, 36 Inch Length, 4 Inch Width, 4 Inch Height, Welded, Mill",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 6sh22x12-48 Carbon Steel Sheet, 0.032 Inch Thick, 12 Inch X 4 Feet Nominal Size",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ideal 31-611 Fish Stick 12 Feet Fiberglass",
"brand": "ideal"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Louisville L-3016-04 Stepladder Fiberglass 4 Feet 300 Lb.",
"brand": "louisville"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ps Doors Ezd-600-052036 Flood Barrier , 52 Inch X 36 Inch Size, 28 Pounds Capacity, Almunium",
"brand": "ps doors"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:28,506 - INFO - Date: 2024-04-19, Records fetched: 16, Total so far: 16
2024-06-06 10:03:28,506 - INFO - Total records fetched for 2024-04-19: 16
2024-06-06 10:03:28,515 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-20'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:29,316 - INFO - Response: {
"results": [
{
"segments": {
"title": "Acurite 75077a3m Wireless Weather Station, Acurite, 2 Pieces, Color Lcd, 330 Ft Range, Temp",
"brand": "acurite"
},
"metrics": {
"clicks": "0",
"impressions": "93",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bayco Products Lbc-600sdlbd Light Bulb Changer Kit, Light Bulb Changer Kit, Telescopic Pole With Attachments",
"brand": "bayco products"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5527-1-30 Elasto-kool 700 4.75-gallon White Elastomeric Reflective Roof Coating, Acrylic Polymer",
"brand": "black jack"
},
"metrics": {
"clicks": "1",
"impressions": "20",
"ctr": 0.05,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91350 Athletic Work Shoe, Better Slip-resist/composite Toe/electrical Hazard /non-metallic",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Crosby 1019533 Shackle, Bolt Pin, 13000 Lb Working Load Limit, 1 29/64 Inch Width Between Eyes",
"brand": "crosby"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 11g236 Engine Driven Semi-trash Pump 7.1 Hp",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 60yp69 Portable Air Conditioner, 5, 300 Btuh, 100 To 150 Sq Ft, 115v Ac, 5-15p, 55 Dba",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Gast Af633 Vibration Isolator 185 Lb Max 5/16-18",
"brand": "gast"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Gleason W5s-060902 Jib Crane",
"brand": "gleason"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "M. K. Morse Dgm03c Diamond Grit Hole Saw 3/16 In",
"brand": "m. k. morse"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Tamper-pruf Screw 91655 Machine Screw Flat 10-32 X 1-1/2 Size, 10pk",
"brand": "tamper-pruf screw"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Lad-3-y Commercial Spring Loaded Ladder, 3 Step, Yellow, Steel",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:29,324 - INFO - Date: 2024-04-20, Records fetched: 12, Total so far: 12
2024-06-06 10:03:29,336 - INFO - Total records fetched for 2024-04-20: 12
2024-06-06 10:03:29,339 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-21'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:30,043 - INFO - Response: {
"results": [
{
"segments": {
"title": "Acrovyn Kp60t3024373n Door Protection Plate, Kick/stretcher, Acrovyn, Acrovyn, 24 Inch Ht, 30 Inch Wd",
"brand": "acrovyn"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Acurite 75077a3m Wireless Weather Station, Acurite, 2 Pieces, Color Lcd, 330 Ft Range, Temp",
"brand": "acurite"
},
"metrics": {
"clicks": "0",
"impressions": "158",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Allegro 9404-04 Sludge Dewatering Pump",
"brand": "allegro safety"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "American Louver Alummil2448-5pk Return Air Grilles, Egg Crate Grille, Silver, Mill, Aluminum, 47 3/4 Inch Height",
"brand": "american louver"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 24. Oct 4336 Shoulder Screw Stainless Steel 10-24 1 1/2l, 5pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 45189 Anchor Bolt L Hook 5/8-11 X 3-3/4 Inch",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg551000100012 Keystock Undersized 12 Inch Length 1 X 1 In",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bell & Gossett Pl-36 Hot Water Circulator Pump Pl Series",
"brand": "bell & gossett"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5527-1-30 Elasto-kool 700 4.75-gallon White Elastomeric Reflective Roof Coating, Acrylic Polymer",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Carlisle Foodservice Products 5501-207 Tumbler, 5 1/5 Fl Oz Capacity, 3.56 Inch Height, 2.09 Inch Depth, Clear, San Plastic",
"brand": "carlisle foodservice products"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Carrier T1070 Thermostat Non-progra Mmable, 2 Or 4 Pipe",
"brand": "carrier"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P90935 Work Boot, W, 116 Inch Widthork Boot Footwear, Men's, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91350 Athletic Work Shoe, Better Slip-resist/composite Toe/electrical Hazard /non-metallic",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "36",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Continental Rsg400-25mf-g Water Suction And Discharge Hose, 4 Inch Heightose Inside Dia, 150 Psi, Black",
"brand": "continental"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 35kt63 Scissor Lift Table 23-3/16 Inch Length X 22-3/16 Inch Width",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Extech Wth600-kit Wireless Weather Station, Extech Wth Weather Station, 2 Pieces, Lcd, 450 Ft Range",
"brand": "extech"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kmc Co1009z1 Clamp, 5/8, Inch Dia., Galvanised, 50pk",
"brand": "kmc"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056t11o5302 X502 Hvac Motor 50-60 Hertz",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nes Nesrk3 Rk3 Replacement Blade For Af2kvj",
"brand": "nes"
},
"metrics": {
"clicks": "0",
"impressions": "80",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Ssa-1-y Aluminium Step Stand, 1 Step, Welded, Yellow",
"brand": "vestil"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:30,043 - INFO - Date: 2024-04-21, Records fetched: 20, Total so far: 20
2024-06-06 10:03:30,051 - INFO - Total records fetched for 2024-04-21: 20
2024-06-06 10:03:30,054 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-22'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:30,753 - INFO - Response: {
"results": [
{
"segments": {
"title": "Acurite 75077a3m Wireless Weather Station, Acurite, 2 Pieces, Color Lcd, 330 Ft Range, Temp",
"brand": "acurite"
},
"metrics": {
"clicks": "0",
"impressions": "131",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 1-der-02-m7- Wing Screw Iron 5/16-18 X 2 Inch, 25pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 1xa98 Square Nut 1/2-13, 50pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 20204 Threaded Rod Zinc 3/8-24 X 2 Feet",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 2dml6 Shoulder Screw 3/8\" Diameter X 5 Length 188 Stainless Steel, 2pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 3dyz6 Taper Pin #2/0 1 1/2 Overall Length, 50pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 4new8 Box Nail Galvanised Flat 8d, 4200pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 4ney8 Roofing Nail Flat 1 1/2 Inch Length, 935pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 4nez9 Truss Nail Flat 1 1/2 Inch Length, 615pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 5dy40 Spring Pin Coiled 302ss 1/8 X 2 L, 50pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor 5mb18 Bind Barrel External, 50pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "41",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor M16000.420.0001 Eye Bolt Lift With Shoulder Steel M42 X 4.5mm",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "47",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg-tp088 Taper Pin #4, 25pk",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg3010101000 Keystock Undersized 1m L 10 X 10mm",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "57",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg360750100012 Keystock Oversized 12 Inch Length 3/4 X 1 In",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg361000125012 Keystock Oversized 12 Inch Length 1 X 1 1/4",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg551000100012 Keystock Undersized 12 Inch Length 1 X 1 In",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg700437043736 Keystock Undersized 36 Inch Length 7/16 X 7/16",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "235",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg700500075012 Keystock Undersized 12 Inch Length 1/2 X 3/4",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg700750100012 Keystock Undersized 12 Inch Length 3/4 X 1 In",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Approved Vendor Wwg8003031000 Keystock Undersized 1m L 3 X 3mm",
"brand": "approved vendor"
},
"metrics": {
"clicks": "0",
"impressions": "54",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Armstrong World Industries 2767d Ceiling Tile, 2767d, 24 Inch X 48 In, Angled Tegular, 15/16 Inch Grid Size, 0.55 Nrc",
"brand": "armstrong world industries"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5527-1-30 Elasto-kool 700 4.75-gallon White Elastomeric Reflective Roof Coating, Acrylic Polymer",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Calbond Pv1010ct00 Metal Conduit - Pvc Coated, 1 Inch Trade Size, 10 Ft Nominal Length",
"brand": "calbond"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P90935 Work Boot, W, 116 Inch Widthork Boot Footwear, Men's, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91350 Athletic Work Shoe, Better Slip-resist/composite Toe/electrical Hazard /non-metallic",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Chrislynn 82205 Precision Professional Kit, Giant, Metric, 1 9/16 Drill, 4 Peices",
"brand": "chrislynn"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cotterman St06al C1 Storage Tank Ladder, 6 Ft Lengthadder Height, 15 Inch Overall Width, Round, 29 Lb Net Wt",
"brand": "cotterman"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Danfoss Mtz22-4vi Compressor, 460v, 3 Phase, 2 Tons, Maneurop",
"brand": "danfoss"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "E James & Co 8501-1/8-10 Recycled Rubber 1/8 Inch Thick 48 In X 120 In",
"brand": "e james & co"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Flex Seal Fslfsclrr01 Flex Seal Liquid 1 Gallon Clear, Rubber, Clear, 1 Gal Container",
"brand": "flex seal"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ge Lighting Hr250dx37 Mercury Vapor Lamp Ed28 250w",
"brand": "ge lighting"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "General Electric 2810435 Silicone Sealant, Advanced Silicone, Clear, 2.8 Oz, Tube, 301% To 500% Elongation Range",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "General Electric 2811092 Silicone Sealant, Advanced Silicone, Clear, 10 Oz, Cartridge",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 1/2 50-72 Strapping, 500 Lb Break Strength, Black",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 1192_72_0 Aluminum Square Tube 6063, 6 Ft Overall Length",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 26241_12_0 Round Tube, Aluminum, 3.625 Inch Id, 4 Inch Od, 12 Inch Overall Length",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Bulk-rs-h50-316 Buna-n Roll, 36 Inch X 10 Ft, 0.0625 Inch Thickness, 50a",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Ssg 808 Rivet Tool Thread 1/2-13 1/2-20 M12",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger U70525.025.0400 Concrete Screws Flat Phil 3-1/4 Inch, 100pk",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Xhd 600 Coupling, 6 Inch X 6 Inch Fitting Pipe Size, Coupling, 4 Inch Overall Length",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grating Fasteners Ssgm X 5 Grating Clip, Mount, 1 To 2 Inch Bar Height, 20pk",
"brand": "grating fasteners"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lovejoy 68514412265 Jaw Coupling Spider, Hytrel, L190 Coupling Size, 4680 In. Lbs. Torque",
"brand": "lovejoy"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056t11o5302 X502 Hvac Motor 50-60 Hertz",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Marson 39031 Riveting Tool",
"brand": "marson"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mkt Fastening 131200l Drop-in Anchor, 5/8 Inch Anchor Dia., 25pk",
"brand": "mkt fastening"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mkt Fastening 1334ss0 Drop-in Anchor, 1 Inch Anchor Dia., 5pk",
"brand": "mkt fastening"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mkt Fastening 1721ss0 Sleeve Anchor, 3/4 Inch Anchor Dia., 2-1/2 Inch Anchor Length, 5pk",
"brand": "mkt fastening"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mkt Fastening 1774000 Sleeve Anchor, 3/8 Inch Anchor Dia., 5 Inch Anchor Length, 10pk",
"brand": "mkt fastening"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Morse Drum 86 Below Hook Drum Lifter, 1000 Lb Holding Capacity, Carbon Steel, No Tilt",
"brand": "morse drum"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Nes Nesrk3 Rk3 Replacement Blade For Af2kvj",
"brand": "nes"
},
"metrics": {
"clicks": "0",
"impressions": "73",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Powercoil 3532-wk1 Helical Thread Repair Assortment, Unc Thread Type, 95 Pieces",
"brand": "powercoil"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Precision Brand 21026 Music Wire Steel Alloy 11 0.026 In",
"brand": "precision brand"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Proto J6212 Torque Multiplier, Planetary Gear System, 1:6 Torque Ratio",
"brand": "proto"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Richard Manno Co. Hmf113-256-ss Hex Standoff, 18-8 Stainless Steel, #2-56 X 1size, 10pk",
"brand": "richard manno co."
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Richard Manno Co. Hmf303-632-ss Hex Standoff, Stainless Steel, #6-32 X 7/16 Size, 10pk",
"brand": "richard manno co."
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Qo320l125grb Load Center 125a 208y/120vac 3ph",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Strong-tie Et-hp22-g Structural Anchoring Adhesive, 22 Ounce",
"brand": "strong-tie"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Teks 1023000 Drilling Screw, #12-14 Thread Size, 3/4 Inch Length, 500pk",
"brand": "teks"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Mpr-2310-g Multi-purpose Ramp, 23 X 10.5 Inch Size, High Impact",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:30,753 - INFO - Date: 2024-04-22, Records fetched: 60, Total so far: 60
2024-06-06 10:03:30,753 - INFO - Total records fetched for 2024-04-22: 60
2024-06-06 10:03:30,767 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-23'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:31,430 - INFO - Response: {
"results": [
{
"segments": {
"title": "Acurite 75077a3m Wireless Weather Station, Acurite, 2 Pieces, Color Lcd, 330 Ft Range, Temp",
"brand": "acurite"
},
"metrics": {
"clicks": "0",
"impressions": "120",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Allied Tube & Conduit 583195 Emt Conduit - Standard, Steel, Galvanized, 1/2 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "1",
"impressions": "20",
"ctr": 0.05,
"conversions": 0
}
},
{
"segments": {
"title": "Aurand Mp6 Air Powered Scarifier, 8 Inch Cleaning Area, 3/4 Inch Inlet Size, D Handle",
"brand": "aurand"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91350 Athletic Work Shoe, Better Slip-resist/composite Toe/electrical Hazard /non-metallic",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "46",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Condor 52ld13 Hard Hat, Full Brim Head Protection",
"brand": "condor"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 5k676 General Purpose Motor Carbon Steel Odp 5 Hp 1725 Rpm 213t",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 60yp69 Portable Air Conditioner, 5, 300 Btuh, 100 To 150 Sq Ft, 115v Ac, 5-15p, 55 Dba",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dds 406007tcn Rotary Shaft Oil Seal, 2 Lip With Spring, Tcn, Nitrile, 40 Mm Id, 60 Mm Od, 7 Mm Width",
"brand": "dds"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Esab 0558012701 Mig Welder, Rebel, Mig Pack W/running Gear",
"brand": "esab"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Falltech 772100 Temporary Horizontal Lifeline, 100 Ft Lengthifeline Length, Reusable, Anchor Lifeline",
"brand": "falltech"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "General Electric Wr51x443 Defrost Heater",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Gleason W5s-060902 Jib Crane",
"brand": "gleason"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Goodman Gsxn402410 Air Conditioner Condensing Unit, 2 T, R-410a, 3/4 Inch Suction Line Size",
"brand": "goodman"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 1pjz3 Printed Moving Box, 16 X 12-1/2 X 12-1/2 Inch Size, 200#, Single Wall",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 2229_24_0 Stainless Steel Square Tube 316, 24 Inch Length, 2 Inch Width, 2 Inch Height, Welded, Mill",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 23013_96_0 Aluminum U-channel, 8 Ft Overall Length, T6",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Treadtex 304#4-16gx48x120 Silver Stainless Steel Sheet, 4 Ft X 10 Ft Size, 0.058 Inch Thick, Textured Finish, B92",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger Treadtex 304#4-20gx48x120 Silver Stainless Steel Sheet, 4 Ft X 10 Ft Size, 0.035 Inch Thick, Textured Finish, B92",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Jet Tools 707400 Planer/jointer Combination 9000 Rpm 13a",
"brand": "jet tools"
},
"metrics": {
"clicks": "0",
"impressions": "44",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln 4489 Grease Pump 25 To 50 Lb. Containers 40 1",
"brand": "lincoln"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056t11o5302 X502 Hvac Motor 50-60 Hertz",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Parker Hnvs8ff 6000 Psi Needle Valve, Female Inlet, Stainless Steel",
"brand": "parker"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Schneider Electric 783xcxc-120a General Purpose Relay, Socket Mounted, 15 A Current Rating, 120 Vac, 11 Pins/terminals",
"brand": "schneider electric"
},
"metrics": {
"clicks": "0",
"impressions": "36",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh38 Panelboard Enclosure 20 Width X 38 Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Qo1816m200ftrb Load Center Cb 200a 120/240vac 1-phase",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Mmj-10 Mechanical Machinery Jack With 5 Ton Capacity",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Rwc-8 Wheel Chock With Eye Bolt, 8 X 9-1/2 X 6 Inch Size, Black, Molded Rubber",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Zurn P1900-semi-dome Drain Dome Height 2-11/16 In",
"brand": "zurn"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:31,430 - INFO - Date: 2024-04-23, Records fetched: 29, Total so far: 29
2024-06-06 10:03:31,438 - INFO - Total records fetched for 2024-04-23: 29
2024-06-06 10:03:31,443 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-24'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:32,193 - INFO - Response: {
"results": [
{
"segments": {
"title": "Acurite 75077a3m Wireless Weather Station, Acurite, 2 Pieces, Color Lcd, 330 Ft Range, Temp",
"brand": "acurite"
},
"metrics": {
"clicks": "0",
"impressions": "71",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Armstrong World Industries 7800rwh Wall Molding, 144 Inch Overall Length, 7/8 Inch Overall Height",
"brand": "armstrong world industries"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bosch Ra1141 Portable Router Table, 16 1/2 Inch Table Working Length, 26 Inch Table Working Width",
"brand": "bosch"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Bussmann Fwh-800a High Speed Fuse, 700 Vac, Non Indicating, Blade End X Blade End",
"brand": "bussmann"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P89955 Work Shoe, M, 11 1/2, Athletic Shoe Footwear, Men's, Black, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Cat P91350 Athletic Work Shoe, Better Slip-resist/composite Toe/electrical Hazard /non-metallic",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Council Tool 180pp Pinch Point Crowbar Steel 1-1/4 X 60 In",
"brand": "council tool"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Danfoss 104l1853hs Compressor, 115v",
"brand": "danfoss"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 1mdb1 Pressure Washer Pump 2200 Psi",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 60yp69 Portable Air Conditioner, 5, 300 Btuh, 100 To 150 Sq Ft, 115v Ac, 5-15p, 55 Dba",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dbi-sala 1113374 Fall Protection Climbing Vest Harness, Revolver, Size 2xl, Seat Sling",
"brand": "dbi-sala"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Eaton 928gr-r Rodent Station, Rodent Station, Rodent Control, Bait Box Trap, 12 Inch Length",
"brand": "eaton"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Edwards Signaling 302-et-194 Heat Detector, 125v, 1 Inch Dia.",
"brand": "edwards signaling"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Flexaust Co Inc 2901000012 Industrial Duct Hose, 10 Inch Size Hose Id, 12 Ft Hose Length, 8 Psi",
"brand": "flexaust co inc"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "General Electric 2816710 Sealant, Metal Silicone 2, Silicone, Gray, 10 Oz Container Size, Cartridge",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "General Electric Wr51x443 Defrost Heater",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "58",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Gleason G-394 Gleason Reel/ Power Reel",
"brand": "gleason"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Goodman Gsx140251 Air Conditioner Condensing Unit, 2 T, R-410a, 3/4 Inch Suction Line Size",
"brand": "goodman"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 20183_24_36 Carbon Steel Sheet, 0.105 Inch Thick, 24 Inch X 36 Inch Nominal Size",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 4uaa5 Recycling Collection Box, 4.5 Gal Capacity, 12 Inch Width/dia, 8 Inch Depth",
"brand": "grainger"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 50788 Pallet, 48 Inch Length, 48 Inch Width, 5 1/4 Inch Height, 20000 Lb Static Load Capacity",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 793n77 Nipple, Black Steel, 5 Inch Nominal Pipe Size",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grohe 27492000 Showerhead, Grohe, Euphoria, 2.5 Gpm Fixed Showerhead Flow Rate, Chrome Finish",
"brand": "grohe"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Hamilton W-1220-ra-1 Caster Wheel, 12 Inch Wheel Dia, 2 Inch Wheel Width, 720 Lb Load Rating, 1 Inch",
"brand": "hamilton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Hi-tech Duravent 2002-0800-1725 Industrial Duct Hose",
"brand": "hi-tech duravent"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Leeson 108052.00 C4d17fk8 Dc Motor",
"brand": "leeson"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln 82230 Drum Pump Air Operated",
"brand": "lincoln"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ps Doors Ezd-600-052036 Flood Barrier , 52 Inch X 36 Inch Size, 28 Pounds Capacity, Almunium",
"brand": "ps doors"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Siemens 6gk1901-1bb10-2aa0 Connector, Black, 4 Contacts, 8 Positions",
"brand": "siemens"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Qo312l125grb Load Center 125a 120/240vac 3ph",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Hg-3f Multi-purpose Barricade, 3 Panel, 111 Inch Size",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:32,194 - INFO - Date: 2024-04-24, Records fetched: 32, Total so far: 32
2024-06-06 10:03:32,199 - INFO - Total records fetched for 2024-04-24: 32
2024-06-06 10:03:32,207 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-25'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:32,904 - INFO - Response: {
"results": [
{
"segments": {
"title": "Acurite 75077a3m Wireless Weather Station, Acurite, 2 Pieces, Color Lcd, 330 Ft Range, Temp",
"brand": "acurite"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Advantech 4\"ss8h Sieve 4 S/s 8 Inch Half Height",
"brand": "advantech"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Aeroquip Nh1650c300b0650 Coupling, Zinc-plated Steel, Vibration, 3 Inch Coupling Connection",
"brand": "aeroquip"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Cat P89955 Work Shoe, M, 11 1/2, Athletic Shoe Footwear, Men's, Black, 1 Pr",
"brand": "cat"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 2zwp2 Centrifugal Pump 1/2 Hp 3-phase 208-230/460",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 4rnn8 Ducted Evaporative Cooler 2800 Cfm 1/3hp",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 60yp70 Portable Air Conditioner, 7000 Btuh, 250 To 300 Sq Ft, 115v Ac, 5-15p, 55 Dba",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Frigidaire Ffre053wa1 Window Air Conditioner, 5000 Btuh, 100 To 150 Sq Ft, 115vac \u20ac\u201c Lcdi, 5-15p, Cooling Only",
"brand": "frigidaire"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 4381013850 45 Deg. Elbow, 316 Ss, 2 Inch X 2 Inch Fitting Pipe Size",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056t34d15652 General Purpose Motors, Open Dripproof, Universal Mount, 3 Hp, 3450 Nameplate Rpm",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 49-16-2485 Protective Boot",
"brand": "milwaukee"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh38 Panelboard Enclosure 20 Width X 38 Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Wiha Tools 32874 Insulated Tool Set 48-pieces",
"brand": "wiha tools"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:32,904 - INFO - Date: 2024-04-25, Records fetched: 14, Total so far: 14
2024-06-06 10:03:32,904 - INFO - Total records fetched for 2024-04-25: 14
2024-06-06 10:03:32,914 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-26'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:33,623 - INFO - Response: {
"results": [
{
"segments": {
"title": "Eaton R2-12-48f Hose Assembly 3/4 Id X 48 Inch 1 1/16 Jic",
"brand": "eaton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 8094_36_96 Aluminum Sheet, H14, 8 Ft Overall Length, +/-0.0045 In",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Harris Industries Ecdf1/2 Flux, 0.5 Lb, Jar, Powder, Fb1-a, Al-braze",
"brand": "harris industries"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Jet Tools Iafs-1700 Dust Collector, Two Filter System, 1, 700 Cfm",
"brand": "jet tools"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 215ttdbd6008 Close-coupled Pump Motor 3-phase 15 Hp",
"brand": "marathon motors"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 5k49pn4088x K1415 Hvac Motor",
"brand": "marathon motors"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Schneider Electric 783xcxc-24a General Purpose Relay, Socket Mounted, 15 A Current Rating, 24 Vac, 11 Pins/terminals",
"brand": "schneider electric"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Siemens Fs140 Surge Protection Device, Single Phase, 120/240vac, Audible Alarm/led Light, 2 Poles",
"brand": "siemens"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Siemens Lgb3b125b Bolt On Circuit Breaker Lgb 100 Amp 480vac 3p",
"brand": "siemens"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh38 Panelboard Enclosure 20 Width X 38 Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Qo324l125g Load Center Lug 125a 208y/120vac 3-phase",
"brand": "square d"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:33,623 - INFO - Date: 2024-04-26, Records fetched: 12, Total so far: 12
2024-06-06 10:03:33,623 - INFO - Total records fetched for 2024-04-26: 12
2024-06-06 10:03:33,633 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-27'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:34,336 - INFO - Response: {
"results": [
{
"segments": {
"title": "Baldor Motor 110463-9 Motor, 1.5hp 3ph For The Above Cooler",
"brand": "baldor motor"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Bussmann Gdb-500ma Fuse 500ma Gdb 250vac - Pack Of 5",
"brand": "bussmann"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Flex Seal Fslfsclrr01 Flex Seal Liquid 1 Gallon Clear, Rubber, Clear, 1 Gal Container",
"brand": "flex seal"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Frigidaire Ffre053wa1 Window Air Conditioner, 5000 Btuh, 100 To 150 Sq Ft, 115vac \u20ac\u201c Lcdi, 5-15p, Cooling Only",
"brand": "frigidaire"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Harper Pgdyk1935p Hand Truck, Nylon, Two-wheeled, 700 Lb",
"brand": "harper"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Itw 684712 Insulated Pipe Jacket",
"brand": "itw"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 270637 Gasket Maker, Si 5900, 5 Oz, Cartridge, Black, Oil Resistant",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "45",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Msa 10208272 Fall Protection Harness, Climbing/confined Spaces/positioning, Mating, Size Xl",
"brand": "msa"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Red Head Cl-12 Drop-in Anchor, Carbon Steel, 1/2 X 2 Inch Size, 50pk",
"brand": "red head"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Schneider Electric 783xcxc-24a General Purpose Relay, Socket Mounted, 15 A Current Rating, 24 Vac, 11 Pins/terminals",
"brand": "schneider electric"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Schneider Electric 9001kyk116 Complete Control Station, Momentary, 1no/1nc, To Stop Break Glass, Push Button",
"brand": "schneider electric"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh38 Panelboard Enclosure 20 Width X 38 Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "44",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:34,336 - INFO - Date: 2024-04-27, Records fetched: 13, Total so far: 13
2024-06-06 10:03:34,344 - INFO - Total records fetched for 2024-04-27: 13
2024-06-06 10:03:34,345 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-28'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:35,064 - INFO - Response: {
"results": [
{
"segments": {
"title": "Allied Tube & Conduit 583195 Emt Conduit - Standard, Steel, Galvanized, 1/2 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "1",
"impressions": "29",
"ctr": 0.034482758620689655,
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5530-1-30 Elasto-kool 1000 5-gallon White Elastomeric Reflective Roof Coating, Reflective",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 1mdb1 Pressure Washer Pump 2200 Psi",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 4rnn8 Ducted Evaporative Cooler 2800 Cfm 1/3hp",
"brand": "dayton"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dbi-sala 1108128 Bosn Chair Harness Front And Back D-ring",
"brand": "dbi-sala"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Ge Lighting Lu250/h/eco High Pressure Sodium Lamp Ed18 250w",
"brand": "ge lighting"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "General Electric 2795576 Silicone Sealant, All Purpose Silicone, Clear, 10 Oz, Cartridge",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 12g309 Portable Barrier Railing, 101 Inch Length, 42.25 Inch Height, Silver",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Grainger 22611_48_0 Stainless Steel Round Tube 304, 5 Inch Dia, 4 Ft Length, 0.065 Inch Wall Thick, Mill",
"brand": "grainger"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Greenlee 53390 Wheel, Rubber 12x3",
"brand": "greenlee"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Husqvarna 522hd60s Hedge Tri Mmer, Double-sided Hedge Tri Mmer, 24 Inch Bar Length, 2 Stroke, 21.7 Cu Cm",
"brand": "husqvarna"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Husqvarna 522hdr60s Hedge Tri Mmer, Double-sided Hedge Tri Mmer, 24 Inch Bar Length, 2 Stroke",
"brand": "husqvarna"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Husqvarna 525deps Madsaw, Dielectric Gas Powered Pole Saw, 1.55 Cu Inch, Recoil, 12 Inch Bar Length, 150 Inch Overall Length",
"brand": "husqvarna"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Husqvarna 525p5s Detach Pole Saw Gas Powered Pole Saw, 1.55 Cu Inch, Recoil, 12 Inch Bar Length",
"brand": "husqvarna"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Husqvarna 535lk Combi Tri Mmer, Gas, 19.7 In, 58.386 Inch Shaft Length, Straight, 50 Cc, 2 Stroke",
"brand": "husqvarna"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ice-o-matic 9041097-01 Thermostat Bin Control",
"brand": "ice-o-matic"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Icm Sc1600l Low Voltage Thermostat, Remote Sensor",
"brand": "icm"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ideal 31-278 Cable And Wire Pulling Lubricants, 40 Deg To 100 Deg F, No Additives, 5 Gallon, Pail",
"brand": "ideal"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ideal 61-557 Voltage Tester, Audible/visual, Dial/push Button/slide, 61-557 Cat Iv 600v, Digital",
"brand": "ideal"
},
"metrics": {
"clicks": "0",
"impressions": "72",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ideal 61-757 Clamp Meter, Clamp-jaw Jaw, Cat Iii 1000v/cat Iv 600v, Trms, 600 A",
"brand": "ideal"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ina Axk2035 Needle Roller Thrust Bearing, 2035, 20 Mm Bore Dia, 35 Mm Outside Dia, 2 Mm Overall Width",
"brand": "ina"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ingersoll-rand 2175max Impact Wrench, Pistol Grip, Std, Full-size, Gen Duty, 1 Inch Square Drive Size",
"brand": "ingersoll-rand"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 1312-200a Metric Dial Caliper, 0 To 200 Mm Range, +/-0.03 Mm Accuracy, 0.02 Mm Dial Graduation",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 2372-360 Bevel Protractor, 0 Deg To 360 Deg Range, 5 Min Graduations, +/-5 Min Accuracy",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 4700-50 Straight Edge, Inch, 2 Inch, 2 Inch Length In, 50 Mm Length Mm, Stainless Steel",
"brand": "insize"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Insize 4797-100 Manual-reading Protractor, 10 Deg To 170 Deg. Range, 1 Deg. Graduations",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 4797-200 Manual-reading Protractor, 10 Deg To 170 Deg. Range, 1 Deg. Graduations",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 4799-1200 Manual-reading Protractor, 0 Deg To 180 Deg. Range, 1 Deg. Graduations",
"brand": "insize"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Insize 4906-b150 Frame Level, Electronic Digital, 6 Inch Length, 1.66 Inch Wide, 1 Vials, 0.0057 Degrees",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 4912-100 Portable Level, Shockproof Vial, 4 Inch Length, 2 Inch Width, 1 Vials",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 7142-5 Tape Measure, 16 Ft 5 M Blade Length, 19 Mm Blade Width, Mm, Closed, Steel",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Insize 9223-120 Non-contact Digital Tachometer, Noncontact 50 To 99, 999, 100 Measurement, Digital",
"brand": "insize"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ipg Pm2...75 Pressure Sensitive Paper Tape, Kraft Paper, Rubber, 6 Mil Tape Thick, 36 Mm Tape Width",
"brand": "ipg"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jameson Tp-14f Telescoping Pole, 14 Ft Length, Fiberglass, Multipurpose, Ps-3fp",
"brand": "jameson"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jay R. Smith Mfg. Co A08nbg Floor Drain Grid, Nickel Bronze, Bronze, Screw",
"brand": "jay r. smith mfg. co"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jb Industries Dm4-z Digital Manifold Gauge, Digital Manifold Gauge, 4 Valves, Multiple Refrigerants",
"brand": "jb industries"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jb Industries Dv-142n 5 Cfm Vacuum Pump",
"brand": "jb industries"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jb Industries Dv-6e-250sp Refrigerant Evacuation Pump, 6 Cfm Displacement, 1/2 Hp Hp, 15 Micron",
"brand": "jb industries"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jet Tools 708734 Afs-1b-cf, Charcoal Filter",
"brand": "jet tools"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jet Tools Jat-700 Pneumatic R6 High Speed Sander",
"brand": "jet tools"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jet Tools S90-100-20 Hand Chain Hoist With 20ft Lift, 1-ton",
"brand": "jet tools"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jet Tools S90-200-10 Hand Chain Hoist With 10ft Lift, 2-ton",
"brand": "jet tools"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Johnson 1253-4800 I-beam Level, 48 Inch Length, 4 Vials, Orange, Top Read, Aluminum, Nonmagnetic",
"brand": "johnson"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Johnson 1717-7200 Box Level, 72 Inch Length, 3 Vials, Yellow, Top Read, Aluminum, Nonmagnetic",
"brand": "johnson"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Jones Stephens J40018 Tub Drain Removal Tool",
"brand": "jones stephens"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kason 11248000028 Cam-rise Spring Assisted Hinge Flush, Rh",
"brand": "kason"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kent Safety 152200-200-030-13 Ring Buoy, Orange, 30 Inch Depthia, Polyethylene, Uscg Approved, 30 Inch Dia",
"brand": "kent safety"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kent Safety 154000-200-004-13 I Mmersion Suit, Uscg, Universal, Universal, Orange, Zipper",
"brand": "kent safety"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kidde Fx-10r Alarm Control Panel, 10 2 Awg Class B Circuit Input, 4 2 Awg Class B Circuit Output, Red",
"brand": "kidde"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kohler 25 757 01-s Carburetor Repair Kit, Carburetor Repair Kit",
"brand": "kohler"
},
"metrics": {
"clicks": "0",
"impressions": "52",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kohler 32 853 67-s Engine Carburetor Complete Kit, Carburetor Complete Kit, Gaskets",
"brand": "kohler"
},
"metrics": {
"clicks": "0",
"impressions": "70",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kool Seal Ks0034600-20 Roof Primer, Acrylic, Gray, 4.75 Gal Container Size, Kool-lastick",
"brand": "kool seal"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kool Seal Ks0034800-20 Primer, Acrylic, White, 5 Gal Container Size, Storm Patch",
"brand": "kool seal"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kool Seal Ks0063600-20 Elastomeric Roof Coating, Acrylic Roof Coatings, Acrylic, Reflective, White, Pail",
"brand": "kool seal"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kool Seal Ks0073600-20 Asphalt Sealer, 73-600, 5 Gallon Container Size, Pail, Asphalt-emulsion",
"brand": "kool seal"
},
"metrics": {
"clicks": "0",
"impressions": "51",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kool Seal Ks0075100-16 Joint And Crack Filler, Crack Filler, Black, Asphalt, 1 Gal Container Size, Jug, No Voc",
"brand": "kool seal"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Koyo Nta-2031 Needle Roller Thrust Bearing, 2031, 1 1/4 Inch Bore Dia, 1 15/16 Inch Outside Dia, Nta/tc",
"brand": "koyo"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kuriyama 45du69 Water Suction And Discharge Hose, 1 1/2 Inch Heightose Inside Dia, 90 Psi, Blue/clear",
"brand": "kuriyama"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Labelmaster Zt4-1791 Corrosive Placard, Un 1791, 25 Pk",
"brand": "labelmaster"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lamotte 2994 Test Strip, Iron, 0 To 5 Ppm, 0 To 3 Ppm, 25 Pk",
"brand": "lamotte"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lamotte 3308-01 Water Quality Testing Kit, Chlorine, 0.2 To 3.0 Ppm",
"brand": "lamotte"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lamotte 4447-01 Water Quality Testing Kit, Iron, 0.5 To 10.0 Ppm",
"brand": "lamotte"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lasco 436102bc Adapter, 3/4 Inch X 1 Inch Fitting Pipe Size",
"brand": "lasco"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lavi 50-3016m/yl/18/bk Warehouse Quick Mount Retractable Belt Barrier, Black, Powidther Coated, 18 Ft Belt Length",
"brand": "lavi"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lcn 4000t-72 Al Standard Cover, Aluminum, Silver, 12 1/4 Inch Lg",
"brand": "lcn"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Legris 0121 34 27 Reducing Adapter, Brass, 1 Inch X 3/4 Inch Fitting Pipe Size, Male Bspt X Male Bspt",
"brand": "legris"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lenox Tools 1600d2c1464 Band Saw Blade Coil Stock, 1/4 Inch Blade Width, 14/18, 0.025 Inch Blade Thickness",
"brand": "lenox tools"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Liftmaster 387lm Universal Keyless Entry",
"brand": "liftmaster"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Liftmaster T501l5g-18 Industrial Door Opener, Trolley, 18 Max. Door Ht, 22 Max. Door Wd",
"brand": "liftmaster"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln 1875a Battery Charger, 4 39/64 In/6 19/64 In",
"brand": "lincoln"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln 369231 Caster",
"brand": "lincoln"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln Electric Ed031117 Hardfacing Flux-cored Wire, Lincore 33, 1/16 Inch, 25 Lb, Dcep, 42 Hrc",
"brand": "lincoln electric"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln Electric Eds30778 Mig Welding Wire, Low-alloy Steel, 0.035 In, 44 Lb",
"brand": "lincoln electric"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln Electric K5257-1 Multiprocess Welder, Weld Pak 180i Mp, Dc, Mig/stick Pack",
"brand": "lincoln electric"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln Electric Kp2744-030t Tapered Contact Tip, Magnum Pro 350a, 0.03 Inch, Std Duty",
"brand": "lincoln electric"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Linear Dnt00002a Visor Transmitter, 310.000 Mhz, 200 Ft Transmission Range",
"brand": "linear"
},
"metrics": {
"clicks": "0",
"impressions": "63",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Linear Nappir01 Motion Detector Transmitter, 500 Ft Transmission Range, Napco Receivers",
"brand": "linear"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Liquatite Lnm-p 16 Liquid Tight Conduit, 2 Inch Trade Size, Orange, 50 Ft Nominal Length, Lnmp",
"brand": "liquatite"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Clx L96 10000lmsefrdlmvoltgz1050k80criwh Led Linear Strip Light, 66.5 W Max. Fixture Watt, 5000k, 9, 627 Lm",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Elb 1p201n Battery, Nickel Cadmium, 1.2 V Volt, 1 Ah Battery Capacity, 1 3/4 Inch Overall Height",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Hgx Led 3rh Alo Sww2 120 Pe Ddb M2 Security Floodlight, 3 Lightheads, 750 Lm/2, 750 Lm/4, 100 Lm, 36 W Fixture Watt",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Ibg48000lmsefaflgndmvoltgz1050k80cridwh Led High Bay, Di Mmable, 120 To 277v, Bulb Type Integrated Led",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Lem04 A M6 Led Emergency Driver, 120 To 277v Ac, 1 Bulbs Supported, 4 W Max. Bulb Watts",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Little Giant 13122-001 Multipurpose Ladder, 5 To 9 Ft, 300 Lb Load Capacity, 40 Lb Net Wt",
"brand": "little giant"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Little Giant 15395-001 Platform Stepladder, 5 Ft Lengthadder Height, 5 Ft Platform Height, 300 Lb",
"brand": "little giant"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Little Giant Nbb-2436-8pybk Platform Truck, 3600 Lb, 24 X 36 Inch Size",
"brand": "little giant"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 2025120 Antispatter, 1 Gal, Bottle",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 234340 High Performance Lubricant, 2 Oz Size, White",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 261797 Urethane Adhesive, U-05fl, Ambient Cure, 50 Ml, Dual-cartridge, Off-white, Thick Liquid",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "49",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 269078 Pipe Repair Kit, Fiberglass, 4 Inch W X 12 Ft Length Wrap Size, 3 Inch Pipe Size",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "39",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 720228 Multiple Ratio Two-part Applicator",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lovibond 147490 Water Quality Test Kit, Chlorine, 2-18% Nahcl Sodium Hypochlorite/bleach Range",
"brand": "lovibond"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Luminaire Led Vpf8 4ft Min10 50w 35k Mvolt Op Brz Vandal And Ligature Resistant Fixture, Di Mmable, 120 To 277vac, 5, 317 Lm, Integrated Led",
"brand": "luminaire led"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lux P111 Low Voltage Thermostat, Heat And Cool, Manual, 1 Heating Stages - Conventional System",
"brand": "lux"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lux P722u Low Voltage Thermostat, Heat Pump With Aux/hydronic Systems/millivolt",
"brand": "lux"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mag Mag00820 Gear Oil, Mineral, Sae Grade 80w-90, 1 Qt, Bottle",
"brand": "mag"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Magliner Gmk81uab Convertible Hand Truck",
"brand": "magliner"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Magliner Gmk81uae Convertible Hand Truck",
"brand": "magliner"
},
"metrics": {
"clicks": "0",
"impressions": "62",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Magliner Hmk53cua45 Corrosion-resistant Modular Aluminum General Purpose Hand Truck, 500 Lb Load Capacity",
"brand": "magliner"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Makita 4100nhx1 Masonry Saw, 4 3/8 Inch Blade Dia, Dry, 1 3/8 Inch Max. Cutting Dp, 120v Ac, 15 A Current",
"brand": "makita"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Makita Hm1317cb Breaker Hammer Kit, Corded, Chipper, 1 1/8 Inch Hex, 25.7 Ft-lb, 1, 450 Bpm, 41.9 Lb Wt",
"brand": "makita"
},
"metrics": {
"clicks": "0",
"impressions": "32",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Makita Xru15pt String Tri Mmer Kit, Battery, 15 Inch, Straight",
"brand": "makita"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Makita Xrv02z Cordless Concrete Vibrator, Handheld, 18vdc, 96 Inch Lg, 1 Inch Dia, Bare Tool",
"brand": "makita"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Manitowoc 000013508 Fan Cycling Control",
"brand": "manitowoc"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056b17d11018 General Purpose Motor, Open Dripproof, Rigid Base Mount, 1/2 Hp, 1725 Nameplate Rpm",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056c17f5321 General Purpose Motor Capacitor-start 1/2 Hp 115/208-230v",
"brand": "marathon motors"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056t11o5302 X502 Hvac Motor 50-60 Hertz",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 182ttfcd6026 General Purpose Motor, Totally Enclosed Fan-cooled, Rigid Base Mount, 3 Hp, Ball",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Markel Products 26158006 Motor, Wall Heater 3320, 277v, 3-4.8kw",
"brand": "markel products"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Master 6271kaw700a Padlock, 1 9/32 Inch Vertical Shackle Clearance, 1 23/32 Inch Horizontal Shackle Clearance",
"brand": "master"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Master Appliance Hg-501t Professional Heat Gun 1200?f, Pistol-grip, 120v Ac, Three-prong, 0 Deg F To 1, 200 Deg F",
"brand": "master appliance"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Maxlite L25t5de450-cg Linear Led Bulb, T5, Miniature Bi-pin, 4 Ft Nominal Length, 5000k, 54 W Lfl",
"brand": "maxlite"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Maxx Air Hvff 20s Redups High Velocity Shrouded Floor Fan 3 Speed, High Velocity Shrouded Floor Fan 3 Speed",
"brand": "maxx air"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Maxx Air Icf72ups Industrial Ceiling Fan, 6 Speed, 72in",
"brand": "maxx air"
},
"metrics": {
"clicks": "0",
"impressions": "56",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mckinney 4 1/2x4 1/2 Mpb99 32d Butt Hinge, 4 Holes Per Leaf, 4 1/2 Inch Door Leaf Height, 2 1/4 Inch Door Leaf Width",
"brand": "mckinney"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Mechanix Lmg-75-010 Mechanics Gloves, Size L, Mechanics Glove, Full Finger, Pigskin, Brown, Brown, 1 Pair",
"brand": "mechanix"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mechanix S5cp-08-011 Knit Gloves, Size 2xl, Ansi Cut Level A4, Ansi Impact Level 1, Palm, Dipped, 1 Pair",
"brand": "mechanix"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mechanix S5dp-05-010 Knit Gloves, Size Xl, Full, Dipped, Nitrile, Acrylic, Sandy, Black, 1 Pair",
"brand": "mechanix"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Medify Air Ma-15-s1 Air Purification Ma-15 Silver, Child Lock, Timer, On/off, Fan Speed, Di Mmer",
"brand": "medify air"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Medify Air Ma-25r-1 Replacement Filter",
"brand": "medify air"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Metaltech I-caisc Scaffold, 2 Ft 2 Inch To 6 Ft Platform Height, 6 Ft 3 Inch Height, 29 Inch Depth",
"brand": "metaltech"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mi-t-m Cm-1400-1meh-m Pressure Washer Mister Combination, 400 Psi Op Pressure, Cold, 1.5 Hp Hp",
"brand": "mi-t-m"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Miles Lubricants M0010020103 Hydraulic Oil, Mineral, 5 Gal, Pail, Iso Viscosity Grade 32, Sae Grade 10w, Ro",
"brand": "miles lubricants"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Miles Lubricants M00701703 Way Oils, Iso Grade 68, Way Oils, Petroleum, 5 Gal Container Size, Pail",
"brand": "miles lubricants"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Miles Lubricants Msf2006603 Gear Oil, Synthetic, Sae Grade 75w-90, 5 Gal, Pail",
"brand": "miles lubricants"
},
"metrics": {
"clicks": "0",
"impressions": "39",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Miller Electric 770496 Plasma Cutter Tip And Electrode Kit, 60 A",
"brand": "miller electric"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Miller Electric Lm1a-15 Liner, 0.03 Inch Size X 15 Ft, Steel, Acculock Mdx",
"brand": "miller electric"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 22-64-3000 Cord Set",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2407-20 Drill, 12vdc, Subcompact, 3/8 Inch Chuck, 1, 500 Rpm",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2531-20 Cordless Detail Sander, M12, Bare Tool, Pointed Detail, Hook And Loop, Pistol Grip, 12 V",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2674-22c, 2625-20 Press Tool Kit And Hackzall, 18v Dc Volt, 2 Tools, Carrying Case, Press Tool, M18 Fuel",
"brand": "milwaukee"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2817a-21 Drain Cleaning Machine, Cordless, M18 3/8 Inch Cable Dia",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2841-21ct Nail Gun Kit, Finish, Sequential For 0.062 Inch Nail Shank Dia",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "50",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 3600 Hammer Cart, 19 3/8 Inch Overall Length, 21 5/8 Inch Overall Width",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "49",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 48-73-4004 Disposable Respirator, Dual, Adj, Molded Nose Bridge, Comfort, White, 10 Pk",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 48-73-4011 Disposable Respirator, Dual, Adj, Molded Nose Bridge, White, M Mask Size, Milwaukee, N95",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee Dc30087 Hand Trucks Convertible Truck, With Solid Platform",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "24",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee Mlbxcm78 Milwaukee Masters Set-mag",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mitutoyo 103-129 Micrometer 0-25 Mm/0.001 Mm",
"brand": "mitutoyo"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mobil 103866 Way Oils, Sae Grade Not Specified, Spindle Oils, Mineral, 5 Gal Container Size",
"brand": "mobil"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mobil 104743 Hydraulic Oil, Mineral, 5 Gal, Pail, Iso Viscosity Grade 32, Sae Grade 10, Dte Oil Named",
"brand": "mobil"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mobil 121325 Gear Oil, Synthetic, 5 Gal, Pail",
"brand": "mobil"
},
"metrics": {
"clicks": "0",
"impressions": "29",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Moldex 2200n95 Disposable Respirator, Dual, Non-adj, Molded Nose Bridge, Comfort, 20 Pk",
"brand": "moldex"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Moldex 2200n95hv Disposable Respirator, Dual, Non-adj, Molded Nose Bridge, Comfort, 20 Pk",
"brand": "moldex"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Moldex 7802 Half Mask Respirator, 7800, 0 Cartridges Included, Silicone, M Mask Size",
"brand": "moldex"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Moldex 8112n Half Mask Respirator Kit, 8000, 4 Cartridges Included, Thermoplastic Elastomer",
"brand": "moldex"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Moldex 8940 Filter, P100, Magenta Color, Moldex 8000, 10 Pk",
"brand": "moldex"
},
"metrics": {
"clicks": "0",
"impressions": "31",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Mr. Chain 71103-6 Barrier Post Kit, Outdoor Or Indoor, 2 1/2 Inch Post Dia, 40 Inch Height, Black, Plastic",
"brand": "mr. chain"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Msa 10208273 Fall Protection Harness, Climbing/confined Spaces/positioning, Mating, Size 2xl",
"brand": "msa"
},
"metrics": {
"clicks": "0",
"impressions": "42",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Msa 30917-00 Vertical Ladder Lifeline Kit, Trailing, Steel, Auto, 60 Ft Lengthifeline Length",
"brand": "msa"
},
"metrics": {
"clicks": "0",
"impressions": "60",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Msa 30918-00 Vertical Ladder Lifeline Kit, Trailing, Steel, Auto, 80 Ft Lengthifeline Length",
"brand": "msa"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Msa 818413 Nfl Hard Hat, Front Brim Head Protection, Ansi Classification Type 1, Class E, White",
"brand": "msa"
},
"metrics": {
"clicks": "0",
"impressions": "40",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Napco Gem-p1664 Control Panel",
"brand": "napco"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "National Guard 199na-36 Door Sweep, Single Fin, Anodized Aluminum, 1 1/4 Inch Flange Ht, 1 3/16 Inch Insert Size",
"brand": "national guard"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "National Guard L-wg-diamond-5x26 Fire Rated Wired Glass, 5 Inch Glass Length, 26 Inch Height",
"brand": "national guard"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Newborn 189d Dripless Caulk Gun, Cartridge, 10 Oz For Container Size, 6, 1, Half Barrel Frame",
"brand": "newborn"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ngk 130-115 Spark Plug",
"brand": "ngk"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nordfab 8040206803 Rigid Duct, Stainless Steel, 58 3/4 Inch Length, 22 Ga Material Thick",
"brand": "nordfab"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nordyne 621919 Motor, 208/230v, 1 Phase, 1/10 Hp, 1100 Rpm",
"brand": "nordyne"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nordyne 903404 M1 Combustion Blower Assembly",
"brand": "nordyne"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4190-08 Condenser Cleaner, Liquid, 1 Gal Size, Straw",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4304-05 Refrigeration Lubricant, 5 Gal Container Size, Mineral Oil",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4308-07 Refrigeration Lubricant, 1 Gal Container Size, Alkylbenzene",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4314-44 Refrigeration Lubricant, 1 Qt Container Size, Polyol Ester",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4316-45 Refrigeration Lubricant, 5 Gal Container Size, Polyol Ester",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Nu-calgon 4371-32 Heat Sink Compound, 1 Qt Size, Gray, Gel",
"brand": "nu-calgon"
},
"metrics": {
"clicks": "0",
"impressions": "41",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Oatey 11871 Roof Vent Pipe Flashing, Rectangular Base, 12 Roof Pitch",
"brand": "oatey"
},
"metrics": {
"clicks": "0",
"impressions": "39",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Oatey 42751 Floor Sink Top Grate, Pvc, White, Drop Inch, 9 3/16 Inch Length",
"brand": "oatey"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Oregon 240rndd025 Power Match Bar, Power Match Bar",
"brand": "oregon"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Oregon 83-402 Oil Filter Shop, 12 Pack",
"brand": "oregon"
},
"metrics": {
"clicks": "0",
"impressions": "76",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Orion 1/2 Schedule 80 Pipe Pipe, Blueline, Polypropylene, 1/2 Inch Nominal Pipe Size, 10 Ft Overall Length",
"brand": "orion"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Orion 2 Schedule 80 Pipe Pipe, Blueline, Polypropylene, 2 Inch Nominal Pipe Size, 10 Ft Overall Length",
"brand": "orion"
},
"metrics": {
"clicks": "0",
"impressions": "57",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Sharpe Valves Sv50114m020 Carbon Steel Ball Valve Inline Flanged 2 In",
"brand": "sharpe valves"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "37",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Starrett H124a/b Mechanical Micrometer Headch To 1/2 Inch Range, 0.001 Inch Resolution, Plain Thimble",
"brand": "starrett"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
}
]
}
2024-06-06 10:03:35,072 - INFO - Date: 2024-04-28, Records fetched: 175, Total so far: 175
2024-06-06 10:03:35,080 - INFO - Total records fetched for 2024-04-28: 175
2024-06-06 10:03:35,080 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-29'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:35,877 - INFO - Response: {
"results": [
{
"segments": {
"title": "786451 Invertible Pipe Stand, Roller V Head, 4500 Lb Max Load Capacity",
"brand": "sumner"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Allied Tube & Conduit 583195 Emt Conduit - Standard, Steel, Galvanized, 1/2 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Armstrong World Industries 769a Ceiling Tile, 769a, 24 Inch X 48 Inch Size Lay-in, 15/16 Inch Grid Size, 0.55 Nrc, 12 Pack",
"brand": "armstrong world industries"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Aro Pd10p-aps-paa Diaphragm Pump Air Operatd 1 Inch 120 Psi",
"brand": "aro"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5530-1-30 Elasto-kool 1000 5-gallon White Elastomeric Reflective Roof Coating, Reflective",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "25",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Dayton 3bb80 Sump Pump 3/4 Hp 1-1/2 Npt 15 Feet",
"brand": "dayton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Destaco 6015 Straight Line Action Clamp, 560 Lb Holding Capacity, Steel",
"brand": "destaco"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Flex Seal Fslfsclrr01 Flex Seal Liquid 1 Gallon Clear, Rubber, Clear, 1 Gal Container",
"brand": "flex seal"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "General Electric 2795576 Silicone Sealant, All Purpose Silicone, Clear, 10 Oz, Cartridge",
"brand": "general electric"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Kool Seal Ks0073600-20 Asphalt Sealer, 73-600, 5 Gallon Container Size, Pail, Asphalt-emulsion",
"brand": "kool seal"
},
"metrics": {
"clicks": "0",
"impressions": "34",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln Electric Ed032940 Flux Cored Welding Wire, Carbon Steel, E70t-5c, 3/32 Inch, 50 Lb, Ultracore 75c",
"brand": "lincoln electric"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lincoln Electric Ed033104 Stick Electrodes, Stainless Steel, E316/316l-16, 3/32 Inch X 12 Inch, 24 Lb",
"brand": "lincoln electric"
},
"metrics": {
"clicks": "0",
"impressions": "21",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Lithonia Lighting Clx L96 10000lmsefrdlmvoltgz1050k80criwh Led Linear Strip Light, 66.5 W Max. Fixture Watt, 5000k, 9, 627 Lm",
"brand": "lithonia lighting"
},
"metrics": {
"clicks": "0",
"impressions": "26",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 2046040 Cleaner/degreaser, Water Based, Jug, 1 Gallon Container Size, Concentrated, 1% Voc Content",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "35",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 720228 Multiple Ratio Two-part Applicator",
"brand": "loctite"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Marathon Motors 056t11o5302 X502 Hvac Motor 50-60 Hertz",
"brand": "marathon motors"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 2841-21ct Nail Gun Kit, Finish, Sequential For 0.062 Inch Nail Shank Dia",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Milwaukee 3600 Hammer Cart, 19 3/8 Inch Overall Length, 21 5/8 Inch Overall Width",
"brand": "milwaukee"
},
"metrics": {
"clicks": "0",
"impressions": "20",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "National Guard L-tg-1/4\"-fra-gt118 24\"x30\" Lite Kit With Glass, Steel, 30 Inch Size Opening Ht, 24 Inch Size Opening Width",
"brand": "national guard"
},
"metrics": {
"clicks": "0",
"impressions": "33",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Orion 1/2 Schedule 80 Pipe Pipe, Blueline, Polypropylene, 1/2 Inch Nominal Pipe Size, 10 Ft Overall Length",
"brand": "orion"
},
"metrics": {
"clicks": "0",
"impressions": "30",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Orion 2 Schedule 80 Pipe Pipe, Blueline, Polypropylene, 2 Inch Nominal Pipe Size, 10 Ft Overall Length",
"brand": "orion"
},
"metrics": {
"clicks": "0",
"impressions": "23",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Rain Bird Sw20/10ps Spot Watering Emitters, Spot Watering Emitters, 1/4 Inch And 1/2 Inch Tubing, Red/black",
"brand": "rain bird"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Schneider Electric 92s7d22d-12d Enclosed Power Relay, Din-rail & Surface Mounted, 30 A Current Rating, 12vdc, Dpst-no",
"brand": "schneider electric"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D 9070t1000d13 Transformer In 120v Out12/24v 1000va",
"brand": "square d"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh62 Panelboard Enclosure, 62 Inch Length, 1 54 Spaces",
"brand": "square d"
},
"metrics": {
"clicks": "2",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Pk4fl Panelboard Lock Kit",
"brand": "square d"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Qo124m100p Load Center Cb 100a 120/240vac 1-phase",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Wiha Tools 32874 Insulated Tool Set 48-pieces",
"brand": "wiha tools"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:35,877 - INFO - Date: 2024-04-29, Records fetched: 29, Total so far: 29
2024-06-06 10:03:35,877 - INFO - Total records fetched for 2024-04-29: 29
2024-06-06 10:03:35,888 - INFO - Request Body: {
"query": "\n SELECT segments.title, segments.brand, metrics.clicks, metrics.impressions, metrics.ctr, metrics.conversions\n FROM MerchantPerformanceView\n WHERE segments.program = \"FREE_PRODUCT_LISTING\" AND segments.date = '2024-04-30'\n ",
"pageSize": 5000,
"pageToken": null
}
2024-06-06 10:03:36,692 - INFO - Response: {
"results": [
{
"segments": {
"title": "Allied Tube & Conduit 583195 Emt Conduit - Standard, Steel, Galvanized, 1/2 Inch Trade Size, 10 Ft Nominal Length",
"brand": "allied tube & conduit"
},
"metrics": {
"clicks": "0",
"impressions": "39",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Ashcroft 251009swl02lv/30# Industrial Compound Gauge, 30 To 0 To 30 Inch Hg/psi, 2 1/2 Inch Dial, Liquid-filled",
"brand": "ashcroft"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Black Jack 5530-1-30 Elasto-kool 1000 5-gallon White Elastomeric Reflective Roof Coating, Reflective",
"brand": "black jack"
},
"metrics": {
"clicks": "0",
"impressions": "36",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Carrier La22ra100 Blower Wheel, 9-15/16 Inch X 7-1/8 Inch",
"brand": "carrier"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Eaton 928gr-r Rodent Station, Rodent Station, Rodent Control, Bait Box Trap, 12 Inch Length",
"brand": "eaton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Eaton Z-ihk-na Breaker, Auxiliary Contact Module, Faz-na Or Faz-rt Breakers",
"brand": "eaton"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Flex Seal Fslfsclrr01 Flex Seal Liquid 1 Gallon Clear, Rubber, Clear, 1 Gal Container",
"brand": "flex seal"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Justrite 28624 Drum Spill Containment Pallet, 2 Drum, Yellow",
"brand": "justrite"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 1562042 Polymer Sealant, Teroson Ms 5510, White, 10 Oz Container Size, Cartridge",
"brand": "loctite"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Loctite 261797 Urethane Adhesive, U-05fl, Ambient Cure, 50 Ml, Dual-cartridge, Off-white, Thick Liquid",
"brand": "loctite"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Orion 2 Schedule 80 Pipe Pipe, Blueline, Polypropylene, 2 Inch Nominal Pipe Size, 10 Ft Overall Length",
"brand": "orion"
},
"metrics": {
"clicks": "0",
"impressions": "27",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Romold Tt65 Drip Tray, General Purpose, 65 Litre Sump Capacity",
"brand": "romold"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D H321n Safety Switch, Fusible, 30 A, Three Phase, 240 Vac, Galvanized Steel, Indoor",
"brand": "square d"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh38 Panelboard Enclosure 20 Width X 38 Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "22",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Square D Mh50 Panelboard Enclosure 20 Inch Width X 50 Inch Length",
"brand": "square d"
},
"metrics": {
"clicks": "0",
"impressions": "28",
"ctr": 0,
"conversions": 0
}
},
{
"segments": {
"title": "Vestil Phch-1-10 Professional Chain Hoist, 1000 Lb Capacity, 10 Feet Lift Height",
"brand": "vestil"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
},
{
"segments": {
"title": "Wiha Tools 32874 Insulated Tool Set 48-pieces",
"brand": "wiha tools"
},
"metrics": {
"clicks": "1",
"impressions": "0",
"ctr": "NaN",
"conversions": 0
}
}
]
}
2024-06-06 10:03:36,700 - INFO - Date: 2024-04-30, Records fetched: 17, Total so far: 17
2024-06-06 10:03:36,701 - INFO - Total records fetched for 2024-04-30: 17
In [ ]:
Shopping API Forum Advisor
Jun 6, 2024, 5:54:50 AMJun 6
to archanag...@gmail.com, google-content-...@googlegroups.com
Hello,
Thank you for getting back to us.
I would like to inform you that the failed logs for the segments.customerCountryCode is not available in the shared logs. Can you please provide the complete JSON request and response logs where you have failed to generate the report.
Thank you for getting back to us.
I would like to inform you that the failed logs for the segments.customerCountryCode is not available in the shared logs. Can you please provide the complete JSON request and response logs where you have failed to generate the report.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdl:ref" (ADR-00238461)
Thanks,
|
Content API for Shopping Team |
Shopping API Forum Advisor
Jun 6, 2024, 5:56:09 AMJun 6
to archanag...@gmail.com, google-content-...@googlegroups.com
Hello,
Thank you for getting back to us.
Thank you for getting back to us.
As informed earlier, we have already replied on another thread with the subject "not able to fetch complete data from Google content API for shpping". To avoid multiple threads on the same issue, please refer to that thread and continue the discussion there for further updates.
Reply all
Reply to author
Forward
0 new messages