campaign

Hi I have this table Query1 below. I want to return the distinct count of companies where the company is in the list of companies where the filter context of campaign = a and the date is greater than the minimum date of the filter context, which in this case would be 4/1/2019 because the...

Hi, I have a column with data that contains campaign id, content id and name id. I would like to have a macro which will paste only the campaign ID in the column next to the information below, which macro can I use to do so?: <colgroup><col><col></colgroup><tbody> Data Campaign ID...

Hello, I wonder if anyone can help with a pivot table issue I'm having. I've created a pivot table and am trying to group the rows on the far left column such that the numbers between 1-1,9 are grouped together, 2-2.9 are grouped together, 3-3.9 are grouped together etc. (Ideally I would...

Hi, I have a named range: "Campaign" in N2 with capaign names in O4:O10 I also have a named range: "Campaign_List" =OFFSET(Campaign,2,1,COUNTA(Settings!$O:$O)-1) How can I replace Settings!$O:$O to something relative to Campaign? This is to be used for Data validation as a list formula. I...

H I'm working with Excel 2010 have a lookup table for a report I'm trying to build that looks like this: <tbody> Campaign Channel Cell Sub Cell A #1 A A A #2 B B A #3 C C B #1 A A B #2 B A C #1 A A C #2 A B C #3 C C C #4 D D C #5 E E </tbody> My aim is to make 4 drop...

Hey guys! I am doing an assignment and I have troubles with one of the questions. The question is asking to use this table: https://imgur.com/7JjrQ5H And then to find which quarter matches the campaign number, using a formula https://imgur.com/ZDUCN0b I have tried to make a new table and use...

Hi. Can anyone help please. This is doing my head in, I was up till 3 am this morning trying all kinds to get this to work, and yes I have checked similar already answers, so apologies for possible re-posting a same question/issue, but the resolutions posted are not appearing to work in my...

Hi Everyone, I am trying to create a tool for an email marketing campaign. I was able to make codes that will send an email to a distro based on the customer type with an opt in option. Everything was working fine until my boss asked to add objects depending on the email campaign that has...

Hi I am a newbie at excel and just joined an advertising firm. I have been a given a project to complete in excel and it's a bit difficult for me given my experience with excel and based on whatever I know I am pretty sure the task I am trying to automate using excel formulas is not easy. I have...

Hi there! Was wondering if anyone out there is able to share some guidance on my problem ahead.. I am hoping to create a dynamic calendar (that shows a daily view across different months of the year) to summarize the events happening daily. But this needs to be auto-fetched from a 2nd sheet in...

Hello I am trying to write a macro that joins strings of text together whilst also transposing. I'll try provide an example of what I'm after: So here is table 1, where we write the campaign name, the ad group name and its associated keyword(s). A B...